A Model Context Protocol (MCP) server that enables secure interaction with MSSQL databases. This server allows AI assistants to list tables, read data, and execute SQL queries through a controlled interface, making database exploration and analysis safer and more structured.
Wellknown found it in public sources; nobody has proven control of it yet. Claiming takes one click if the repository is under your GitHub account, or a small file on your domain otherwise. Verified owners get the badge, 15-minute checks, status alerts, edits that outrank crawled data, and a ranking boost.
Agents can do it too: POST https://wellknown.network/api/v1/claims with {"agent":"mssql-mcp-server-2","method":"well_known_file"} — machine-readable steps at claim.json, guide at /docs/claim.
Everything here was measured by our prober or read from a registry. Nothing is self-reported.
Attributed to the source that supplied each field. Treated as claims, not facts.
 # MSSQL MCP Server MSSQL MCP Server is a **Model Context Protocol (MCP) server** that enables secure and structured interaction with **Microsoft SQL Server (MSSQL)** databases. It allows AI assistants to: - List available tables - Read table contents - Execute SQL queries with controlled access Built on **MCP SDK v2** (2026-07-28 spec) with support for both **stdio** and **Streamable HTTP** transports. ## Features - **Secure MSSQL Database Access** through environment variables - **SQL Injection Protection** with identifier validation - **Read-Only & Write Tools** with appropriate MCP annotations - **Windows Authentication** support via Trusted Connection - **Dual Transport** — stdio (default) and HTTP - **Docker Support** with pre-configured ODBC drivers - **Comprehensive Logging** for monitoring queries and operations ## Installation ```bash pip install mssql-mcp-server ``` ## Configuration Set the following environment variables to configure database access: ```bash # Required MSSQL_DATABASE=your_database # Authentication (choose one): # Option 1: SQL Server Authentication MSSQL_USER=your_username MSSQL_PASSWORD=your_password # Option 2: Windows / Kerberos Authentication Trusted_Connection=yes # Optional MSSQL_HOST=localhost # or use MSSQL_SERVER MSSQL_DRIVER=SQL Server # default driver TrustServerCertificate=no # default: no (set to yes for self-signed certs) MCP_TRANSPORT=stdio # or "streamable-http" for Streamable HTTP ``` ## Available Tools | Tool | Description | Annotations | |------|-------------|-------------| | `list_tables` | List all tables in the database | Read-only, Idempotent | | `query_sql` | Execute read-only SELECT queries | Read-only, Idempotent | | `execute_sql` | Execute any SQL statement (SELECT, INSERT, UPDATE, DELETE, DDL) | Destructive | ## Usage ### With Claude Desktop Add this configuration to `c…
Mapped onto the structured taxonomy from declared text and observed tool names. Confidence shown for derived entries.
Every source is kept verbatim. Field changes are logged as events.