mcp-sql-optimizer
Verified Safeby uddin-rajaul
Overview
Analyzes, optimizes, and suggests indexes for SQL queries across multiple dialects.
Installation
docker run -i --rm mcp-sql-optimizerSecurity Notes
The server primarily performs static analysis and transformation of SQL queries using the `sqlglot` library. It does not execute arbitrary SQL against a database, nor does it make external network requests from its core logic. User-provided `sql` and `explain_plan` inputs are parsed and processed internally without dangerous execution. No 'eval' or direct shell commands are used. The generated DDL for indexes is returned as a string, not executed.
Similar Servers
code-index-mcp
Intelligent code indexing and analysis for Large Language Models, enabling tasks such as code review, refactoring, documentation generation, debugging assistance, and architectural analysis.
CodeGraphContext
This MCP Server acts as an expert AI pair programmer's backend, providing real-time, accurate code analysis, indexing, and relationship information from a local codebase to assist with understanding, writing, and refactoring code.
DBchat
Transforms a database into an intelligent conversational partner, enabling natural language queries, instant answers, and data visualizations via MCP clients.
postgres-mcp
A PostgreSQL database management and optimization expert system, offering interactive workflows for query analysis, index tuning, health monitoring, backup strategies, and advanced functionalities like vector search and geospatial data management. It helps users understand and improve their PostgreSQL database performance and health.