I automated most of my DB Admin job — then open-sourced it!

Description and use

DBA automation: deepsql monitors queries, rewrites slow ones, answers BI questions, and validates migrations, freeing manual effort.

Problem

Database administrators spent excessive time manually optimizing queries, answering BI questions, and reviewing migrations, creating a single point of failure and consuming valuable time.

Outcome

The DBA’s pager stopped, nights were reclaimed, and the system was open‑source, allowing others to deploy it in their own VPCs and avoid repetitive manual work.

Workflow

• Clone deepsql repository
• Copy .env.example to .env and configure credentials
• Run docker compose up -d to start services
• Configure OpenAI or compatible endpoint
• Use deepsql to monitor queries, rewrite slow ones, answer BI questions, and validate migrations

Evidence

I built something to carry it instead — watches the workload, rewrites the slow queries, answers the BI questions, and checks every AI‑written migration before it nukes a 41M-row table.

Source

Everything runs in your own infra — your VPC, your credentials, connects read-only to a replica.

Source