Best overallChecked 5h agoLink OKFree plan available
Why it wins
Explains slow query plans, suggests indexes, rewrites N+1 queries, and generates optimised SQL for Postgres, MySQL, or SQLite, just paste your schema and query.
When not to use
No direct DB connection. you must paste queries manually and apply changes yourself.
AI understands your ORM models and migration files, suggests query optimisations and schema changes inline as you write code, with diff preview before applying.
When not to use
Best for code-adjacent DB work (ORM, migrations). less useful for raw DBA tasks in a DB console.
Copy and paste these prompts into your chosen tool to get started.
Fill in placeholders (optional):
Analyze this slow SQL query and suggest optimizations. Explain each suggestion: [paste query + explain plan if available]
My database is running slow under load. Diagnose the issue based on these symptoms: [describe symptoms]. Suggest: index improvements, query rewrites, and configuration changes.
Write the indexes I should add to this database schema to support these common query patterns: [paste schema and queries]
I need to optimize this PostgreSQL database that has grown to [X] million rows. Suggest: partitioning strategy, archiving approach, connection pooling, and vacuum settings.
Review this ORM-generated query and rewrite it as optimized raw SQL: [paste ORM query]
Design a caching strategy for [application]. Which queries should be cached, what TTL, what invalidation rules, and what caching layer (Redis/Memcached) makes sense?