SQL Query Optimization

Analyze and optimize SQL queries. Identifies missing indexes, inefficient joins, subquery issues, and suggests rewrites. Supports PostgreSQL, MySQL, BigQuery, Snowflake with dialect-specific optimization rules.. Input: SQL query + schema. Output: Optimized query + explain plan. Python 3.11+. 89% reliable. Use programmatically via API or CLI.

Install via Dejavu

1 Install the Dejavu MCP package:

pip install dejavu-mcp

2 Subscribe at keepingtrack.biz/skills-landing ($6.67/month)

3 Install this skill:

dejavu skill install sql-query-optimization

4 Your AI agent can now use it:

dejavu skill execute sql-query-optimization --input '...'

Pricing

$6.67/month subscription includes 1,000 free credits. This skill uses credits per execution. Subscribe now →

Get Dejavu — $6.67/month