A Model Context Protocol (MCP) server that enables secure interaction with Microsoft SQL Server databases.
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-ishaan","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.
# Microsoft SQL Server MCP Server (Ishaan's Version) [](https://pypi.org/project/mssql_mcp_server_ishaan/) [](https://opensource.org/licenses/MIT) [](https://pypi.org/project/mssql_mcp_server_ishaan/) A Model Context Protocol (MCP) server for secure SQL Server database access through Claude Desktop. ## 🚀 Quick Start ### Prerequisites - **Python 3.11 or higher** (Python 3.12 recommended) - **FreeTDS** (for SQL Server connectivity) ### Install FreeTDS ```bash # macOS brew install freetds # Ubuntu/Debian sudo apt-get install freetds-dev # RHEL/CentOS sudo yum install freetds-devel ``` ### Install the Package ```bash pip install mssql-mcp-server-ishaan ``` ### Configure Claude Desktop Add to your `claude_desktop_config.json`: ```json { "mcpServers": { "mssql": { "command": "python", "args": ["-m", "mssql_mcp_server_ishaan"], "env": { "MSSQL_CONNECTION_STRING": "server=your-server;database=your-db;uid=your-user;pwd=your-password;encrypt=true;trustServerCertificate=true" } } } } ``` ## 📋 Features - **Secure SQL Server connectivity** with encrypted connections - **Read-only operations** for safety (SELECT queries only) - **Table schema inspection** and metadata retrieval - **SQL injection protection** with parameterized queries - **Connection validation** and error handling - **Comprehensive logging** for debugging ## 🔧 Configuration Options ### Environment Variables ```bash # Basic connection (choose one method) MSSQL_CONNECTION_STRING="server=localhost;database=mydb;uid=user;pwd=pass" # OR individual components: MSSQL_SERVER=localhost MSSQL_DATABASE=mydb MSSQL_USERNAME=your_user MSSQL_PASSWORD=your_password # Optional settings MSSQL_PORT=1433 # Custom port (default: 1433) MSSQL_ENCRYPT=true …
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.