mcp-server-sql-inspector 0.1.1

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)

When using uv no installation is necessary. You can run the server directly:

uvx mcp-server-sql-inspector

Configuration with Claude Desktop

Add this to your claude_desktop_config.json:

{
  "mcpServers": {
    "sql-inspector": {
      "command": "uvx",
      "args": ["mcp-server-sql-inspector"],
      "env": {
        "DATABASE_URL": "postgresql://user:password@localhost:5432/dbname"
      }
    }
  }
}

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