sql-mcp-server

# SQL Assistant MCP Server Connects Claude to a Microsoft SQL Server database over stdio. Ask Claude to query your database, inspect table structures, or preview execution plans — without leaving the chat. --- ## Installation ```bash pip install sql-mcp-server ``` You also need the **ODBC Driver for SQL Server**: https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server --- ## Tools **list_tables** : Lists all user-created tables, grouped by schema. **describe_table** : Shows columns, data types, nullability, and defaults for a table. **run_query** : Runs a SELECT query and returns results. Write operations (INSERT, UPDATE, DELETE, DROP, etc.) are blocked. **explain_query** : Returns SQL Server's estimated execution plan via `SET SHOWPLAN_TEXT`. Good to run before a slow or unfamiliar query. **get_table_sample** : Returns the first N rows from a table (max 20, default 5). Pass `rows=10` for more. --- ## Project Structure ``` sql-mcp-server/ ├── server.py # MCP server and tool definitions ├── db.py # SQL Server connection helper (loads .env) ├── pyproject.toml # Project metadata and dependencies ├── uv.lock # Locked dependency versions (uv) ├── .env # Connection config (not committed) └── README.md ``` --- ## Setup ### 1. Configure the database connection Create a `.env` file in the project root: **Windows Authentication:** ```env DB_DRIVER=ODBC Driver 17 for SQL Server DB_SERVER=YOUR_SERVER_NAME\SQLEXPRESS DB_NAME=your_database_name ``` **SQL Server Authentication:** ```env DB_DRIVER=ODBC Driver 17 for SQL Server DB_SERVER=YOUR_SERVER_NAME\SQLEXPRESS DB_NAME=your_database_name DB_USER=your_username DB_PASSWORD=your_password ``` If you're using the Claude Desktop config below, put credentials in the `env` block — no `.env` file needed. --- ### 2. Register with Claude Desktop Add this to `claude_desktop_config.json` — usually at `%APPDATA%\Claude\claude_desktop_…