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

说明与用途

DBA 自动化：deepsql 监控查询、重写慢查询、回答 BI 问题并验证迁移，减少手动工作。

问题

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

结果

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.

工作流

• 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

证据

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.

来源

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

来源