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.

Источник