MSSQL Read-Only MCP

What it does

This MCP server provides a secure, read-only bridge to Microsoft SQL Server (MSSQL). It is designed specifically for safety, ensuring that the AI can explore database structures and retrieve data without the risk of modifying or deleting any records.

Tools

• list_table: Lists all available tables in the database, with support for schema filtering.
• describe_table: Returns the detailed structure of a specific table, including columns and data types.
• read_data: Executes SELECT queries to retrieve data from the database.

Installation

Add the following to your claude_desktop_config.json:

{
  "mcpServers": {
    "mssql-read-only": {
      "type": "stdio",
      "command": "npx",
      "args": ["-y", "mssql-read-only-mcp"],
      "env": {
        "SERVER_NAME": "your-server.database.windows.net",
        "DATABASE_NAME": "YourDatabase",
        "SQL_USER": "username",
        "SQL_PASSWORD": "password",
        "SQL_PORT": "1433",
        "TRUST_SERVER_CERTIFICATE": "false"
      }
    }
  }
}

Supported hosts

• Claude Desktop
• Claude Code CLI