MSSQL MCP Server
# MSSQL MCP Server [](https://smithery.ai/server/@c0h1b4/mssql-mcp-server) A
What is the MSSQL MCP Server?
MSSQL MCP Server A Model Context
More MCP options
Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.
Configuration
| Variable | Description | Required |
|---|---|---|
| MSSQL_CONNECTION_STRING | Configuration value read at startup. | Optional |
| MSSQL_HOST | Endpoint or connection string the server talks to. | Optional |
| MSSQL_PORT | Configuration value read at startup. | Optional |
| MSSQL_DATABASE | Configuration value read at startup. | Optional |
| MSSQL_USER | Configuration value read at startup. | Optional |
| MSSQL_PASSWORD | Configuration value read at startup. | Optional |
| MSSQL_ENCRYPT | Configuration value read at startup. | Optional |
| MSSQL_TRUST_SERVER_CERTIFICATE | Configuration value read at startup. | Optional |
Example prompts to try
- “Use MSSQL to query.”
- “Use MSSQL to Parameters.”
- “Use MSSQL to Example.”
Frequently asked questions
Alternatives to the MSSQL MCP Server
PostgreSQL
Inspect PostgreSQL schemas and run read-only queries with the archived MCP reference server. Review its maintenance status before choosing it.
Notion
OfficialConnect the Notion MCP server to search workspace content and work with pages and databases through Notion’s hosted OAuth service.
Supabase
OfficialUse the Supabase MCP server to inspect database schemas, query project data and retrieve docs through a project-scoped connection.
SQLite
OfficialQuery, modify and analyse local SQLite databases in conversation — the fastest way to chat with a data file.
Metabase
OfficialMetabase ships its own MCP endpoint — search your BI content, build and run queries, and save questions and dashboards without leaving the chat.
MongoDB
OfficialOfficial MongoDB server covering data, schemas and Atlas management — from find queries to spinning up clusters.