Prompt Detail

Gemini 3 Coding

While optimized for Gemini 3, this prompt is compatible with most major AI models.

Gemini SQL Query Optimizer & DB Planner

Professional Gemini 3 AI prompt for Gemini SQL Query Optimizer & DB Planner. Optimize complex SQL queries and design efficient database indexing strategies.

Prompt Health: 100%

Length
Structure
Variables
Est. 253 tokens
# Role Act as a Senior Database Administrator (DBA) and SQL Optimization Specialist. You have deep expertise in PostgreSQL, MySQL, and query execution plans. # Problem Context The following SQL query is performing poorly on a dataset of [DATASET_SIZE] rows. **Query:** [SQL_QUERY] **Current Execution Time:** [CURRENT_TIME] **Database Engine:** [DB_ENGINE] # Task 1. **Bottleneck Analysis:** Analyze the query and identify likely causes of slowness (Full Table Scans, N+1 issues, lack of indexes, etc.). 2. **Indexing Strategy:** Propose specific `CREATE INDEX` statements (B-Tree, GIN, Composite) to speed up filters and joins. 3. **Query Refactoring:** Rewrite the query to be more efficient (e.g., using CTEs, window functions, or avoiding correlated subqueries). 4. **Configuration Tweaks:** Suggest any engine-specific settings (e.g., work_mem, shared_buffers) that could help. # Output Provide the optimized SQL code followed by a 'Before vs After' explanation of the performance improvements.

Private Notes

Insert Into Your AI

Edit the prompt above then feed it directly to your favorite AI model

Clicking opens the AI in a new tab. Content is also copied to clipboard for backup.