Show HN: DeepSQL – A self-hostable AI DBA agent for Postgres and MySQL
DeepSQL is a self-hostable AI DBA agent designed for Postgres and MySQL databases. It allows users to add database connections, teach it their company's knowledge, and feed it slow query logs to improve performance. DeepSQL indexes the schema and starts learning the workload immediately, providing recommendations for improvement.
- ▪DeepSQL supports both Postgres and MySQL databases, including read replicas and VPC-peered connections.
- ▪The agent learns the company's knowledge through plain English business rules, such as MRR and active hotel definitions.
- ▪DeepSQL analyzes slow query logs from pg_stat_statements or MySQL slow log, clustering and ranking queries to provide recommendations.
Opening excerpt (first ~120 words) tap to expand
Add database connections, teach it your company's knowledge, and feed it your slow query logs. DeepSQL indexes your schema and starts learning your workload immediately.Database connectionsPostgres or MySQL — read replica, VPC-peered. Read-only credentials, no data leaves your infra.host: aws-rds-replica.internalrole: deepsql_rossl: requireCompany knowledgeTeach DeepSQL your business rules in plain English — MRR, active-hotel, currency conventions.// MRR = SUM(subscription.mrr)// WHERE status = 'active'// Active hotel = check-ins ≥ 1 / 30dSlow query logsPoint at pg_stat_statements or MySQL slow log. DeepSQL clusters, ranks, and starts recommending.source: pg_stat_statementswindow: 30d rollinggrouped: 1,284 → 96 fingerprints
Excerpt limited to ~120 words for fair-use compliance. The full article is at DeepSQL.
Discussion
0 commentsMore from DeepSQL
