MCP MSSQL Server
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
C:\Projects\mcp-mssql
├── src
│ └── mcp_mssql
│ ├── init.py
│ ├── server.py
│ ├── config.py
│ ├── database
│ │ ├── init.py
│ │ ├── connection.py
│ │ ├── executor.py
│ │ ├── schema_cache.py
│ │ └── validator.py
│ └── tools
│ ├── init.py
│ └── query_tools.py
├── requirements.txt
├── .env
└── run.py
https://claude.ai/share/1d5b820c-c063-4c9b-bfda-5ae852f438fa
Rebuild
Full clean rebuild
docker compose down docker compose build --no-cache docker compose up -d docker compose logs -f mcp-mssql
local mcp client config
"mssql": {
"command": "D:\\Projects\\AI\\mcp_mssql_py-main\\mcp_mssql_py-main\\.venv\\Scripts\\python.exe",
"args": [
"D:\\Projects\\AI\\mcp_mssql_py-main\\mcp_mssql_py-main\\run.py"
],
"env": {
"MSSQL_SERVER": "127.0.0.1",
"MSSQL_DATABASE": "demo_db",
"MSSQL_USERNAME": "sa",
"MSSQL_PASSWORD": "YourStrong!Passw0rd"
},
"url":"http://localhost:8000/sse"
}docker mcp client config
"mssql": {
"command": "docker",
"args": [
"run",
"--rm",
"-i",
"--network", "host",
"--env-file", "D:\\Projects\\AI\\mcp_mssql_py-main\\mcp_mssql_py-main\\.env",
"-e", "TRANSPORT=stdio",
"mcp-mssql-mcp-mssql:latest"
]
}Claude local MCP configuration
{ "mcpServers": { "filesystem": { "command": "npx", "args": [ "-y", "@modelcontextprotocol/server-filesystem", "C:\Users\User\Desktop", "C:\Users\User\Downloads" ] }, "MCP_DOCKER": { "command": "docker", "args": [ "mcp", "gateway", "run" ], "env": { "LOCALAPPDATA": "C:\Users\User\AppData\Local", "ProgramData": "C:\ProgramData", "ProgramFiles": "C:\Program Files" } }, "duckduckgo": { "command": "docker", "args": [ "run", "-i", "--rm", "mcp/duckduckgo" ] }, "mssql": { "command": "docker", "args": [ "run", "--rm", "-i", "--network", "host", "--env-file", "D:\Projects\AI\mcp_mssql_py-main\mcp_mssql_py-main\.env", "-e", "TRANSPORT=stdio", "mcp-mssql-mcp-mssql:latest" ] } }, "preferences": { "sidebarMode": "chat", "coworkScheduledTasksEnabled": false } }
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
This server cannot be deployed
Maintenance
Related MCP Connectors
Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Governed data discovery, exact queries, decisions, simulations, and runtime utilities over MCP.
Cloud-hosted MCP server for secure AI access to enterprise data sources via CData Connect AI.
Draxlr's remote MCP server connects AI assistants to your SQL databases and dashboards. Explore schemas, run read-only queries, manage saved queries and dashboards, and export results, all with row-level security so each user sees only their own data.
Related MCP Servers
- FlicenseAqualityDmaintenanceAn MCP server for Microsoft SQL Server that enables executing read-only queries, listing tables, and describing database schemas. It offers specialized support for custom ports and multiple authentication methods including SQL credentials, NTLM, and Windows Integrated Auth.3-
- AlicenseNot gradedqualityDmaintenanceEnables SQL query execution and database structure browsing via MCP tools and resources.MIT
- AlicenseNot gradedqualityDmaintenanceProvides tools to connect, query, and manage Microsoft SQL Server databases through the MCP protocol, including support for stored procedures, transactions, and schema inspection.81 PyPIMIT
- AlicenseNot gradedqualityDmaintenanceProvides secure, API-key authenticated access to on-premise MSSQL databases, enabling SQL query execution, schema exploration, and stored procedure management through MCP.MIT