mcp-server-sql-inspector 0.1.0

A Model Context Protocol server that enables AI to inspect SQL databases and analyze query performance.

MCP Server SQL Inspector

A Model Context Protocol (MCP) server that enables AI to inspect SQL databases and analyze query performance.

Features

• List Tables: See all available tables in your database.
• Get Schema: detailed schema information including columns, types, primary keys, foreign keys, and indexes.
• Table Statistics: specific row counts to understand table size.
• Explain Analyze: Run EXPLAIN ANALYZE (or equivalent) on queries to get performance insights and execution plans.

Installation

Using uv (Recommended)

uvx mcp-server-sql-inspector

From Source

git clone <repository-url>
cd mcp-server-sql-inspector
poetry install --extras all

Docker

docker run -e DATABASE_URL="postgresql://user:password@host:port/dbname" mcp-server-sql-inspector

Configuration

The server requires a DATABASE_URL environment variable to connect to your database.

Supported database protocols (requires appropriate drivers):

• PostgreSQL: postgresql://...
• MySQL: mysql://...
• MSSQL: mssql+pyodbc://...
• SQLite: sqlite:///...

Development

1. Install dependencies:

   poetry install --extras all
   

2. Run the server:

   export DATABASE_URL="sqlite:///test.db"
   poetry run mcp-server-sql-inspector
   

License

MIT