timps_sql_optimizer
Analyze slow SQL queries to receive optimized rewrites, index recommendations, and estimated speedup. Supports PostgreSQL, MySQL, SQLite, and MSSQL.
Instructions
Analyse a slow SQL query and return: the optimised rewrite, index recommendations with CREATE INDEX SQL, and an estimated speedup. Supports PostgreSQL, MySQL, SQLite, MSSQL.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | The slow SQL query | |
| db_engine | No | 'postgresql'|'mysql'|'sqlite'|'mssql' | postgresql |
| explain_output | No | Optional: output of EXPLAIN or EXPLAIN ANALYZE |