mcp-sql-optimizer

uddin-rajaul/mcp-sql-optimizer

3.2

If you are the rightful owner of mcp-sql-optimizer and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.

The SQL Query Optimizer MCP Server is a powerful tool designed to analyze, optimize, and suggest indexes for SQL queries across various dialects using Python and sqlglot.

Tools

Functions exposed to the LLM to take actions

analyze_query

Analyzes a SQL query for performance issues, complexity, and anti-patterns.

optimize_query

Rewrites the query to be more performant and provides alternative suggestions.

suggest_indexes

Suggests indexes to improve query performance, including DDL statements.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources