THE SQL & DATABASES COLLECTION

SQL & databases automation.

Database health, backups & reporting. Practical scripts from my engineering workbench.

Browse all collections

THE SCRIPT LIBRARY

Find your next shortcut.

8 scripts to explore

8 scripts

Automation scripts and examples from Joseph Nakhle
TechnologyCollectionScript / toolWhat it does
SQL & databasesMySQL – Consistency Check (Bash)BashRun MySQL consistency checks.
SQL & databasesMySQL – Slow Log Analyzer (Python)PythonAnalyze MySQL slow-query logs with Python.
SQL & databasesPostgres – Backup & Rotate (Bash)BashBack up PostgreSQL databases and rotate saved copies.
SQL & databasesPostgres – Index Bloat Report (SQL)SQLInspect PostgreSQL index bloat.
SQL & databasesSend Alerts for Offline DBsBashScript to send an alert when a DB is offline.
SQL & databasesSend Alerts for Recovery Pending DBsBashScript to send an alert when a DB is in recovery pending mode.
SQL & databasesSend Alerts for Restoring DBsBashScript to send an alert when a DB is in restoring mode.
SQL & databasesSQL Server – DB Space Report (T-SQL)SQLReport SQL Server database space usage.
Showing all 8 scripts