dreez-mssql-mcp

A Model Context Protocol (MCP) server for SQL Server — built with read-only safety, pyodbc, and full compatibility with uvx.

✨ Features

• 🔍 Execute read-only SQL queries (SELECT / WITH)
• 🛡️ READ_ONLY mode — blocks any mutating SQL by default (INSERT, UPDATE, DELETE, DROP, TRUNCATE, ALTER, CREATE, EXEC, MERGE, GRANT, REVOKE)
• 📋 List tables in any schema
• 🔎 Describe table columns (types, nullability, defaults)
• 🗂️ List schemas in the database
• 📦 List stored procedures
• ⚡ Compatible with uvx — no global install needed

📦 Installation

Using uvx (recommended — no install required)

uvx dreez-mssql-mcp

Using pip

pip install dreez-mssql-mcp

⚙️ Environment Variables

🔧 Client Configuration

Claude Desktop

Edit claude_desktop_config.json:

{
  "mcpServers": {
    "dreez-mssql": {
      "command": "uvx",
      "args": ["dreez-mssql-mcp"],
      "env": {
        "MSSQL_SERVER": "localhost",
        "MSSQL_PORT": "1433",
        "MSSQL_DB": "your_database",
        "MSSQL_USER": "your_user",
        "MSSQL_PWD": "your_password",
        "READ_ONLY": "true"
      }
    }
  }
}

Cursor / VS Code

Edit .cursor/mcp.json or .vscode/mcp.json:

{
  "servers": {
    "dreez-mssql": {
      "type": "stdio",
      "command": "uvx",
      "args": ["dreez-mssql-mcp"],
      "env": {
        "MSSQL_SERVER": "localhost",
        "MSSQL_PORT": "1433",
        "MSSQL_DB": "your_database",
        "MSSQL_USER": "your_user",
        "MSSQL_PWD": "your_password",
        "READ_ONLY": "true"
      }
    }
  }
}

🛠️ Available Tools

🛡️ READ_ONLY Mode

By default, READ_ONLY=true. Any query containing write keywords will be blocked immediately before reaching the database:

{
  "error": "Operación bloqueada: el servidor está en modo solo lectura (READ_ONLY=true).",
  "keywords_detectadas": ["DELETE"]
}

Blocked keywords: INSERT, UPDATE, DELETE, DROP, TRUNCATE, ALTER, CREATE, EXEC, EXECUTE, MERGE, REPLACE, GRANT, REVOKE

⚠️ Set READ_ONLY=false only in controlled environments. It is strongly recommended to also use a SQL Server user with read-only database permissions as an extra safety layer.

🚀 Development

# Clone the repo
git clone https://github.com/dreezdev/dreez-mssql-mcp.git
cd dreez-mssql-mcp

# Install with uv
uv sync

# Run locally
uv run dreez-mssql-mcp

📋 Requirements

• Python >= 3.11
• ODBC Driver 18 for SQL Server
• pyodbc >= 5.0.0
• mcp[cli] >= 1.0.0

📄 License

MIT © dreezdev

👤 Author

Made with ❤️ by dreezdev

• 🌐 Website: dreez.dev
• 🐙 GitHub: @dreezdev