MSSQL MCP Server
Enables AI assistants to interact with both local SQL Server and Azure SQL Database through natural language, supporting queries, data manipulation, and schema operations with built-in security features.
Install
npx -y mssql-mcp-server
Paste the configuration above into your MCP client config (claude_desktop_config.json for Claude Desktop) and restart the client.
{
"mcpServers": {
"mssql-mcp": {
"command": "npx",
"args": [
"-y",
"mssql-mcp-server"
],
"env": {
"READONLY": "<READONLY>",
"SQL_USER": "<SQL_USER>",
"SERVER_NAME": "<SERVER_NAME>",
"SQL_PASSWORD": "<SQL_PASSWORD>",
"DATABASE_NAME": "<DATABASE_NAME>",
"TRUST_SERVER_CERTIFICATE": "<TRUST_SERVER_CERTIFICATE>"
}
}
}
}Paste the configuration above into your MCP client config (claude_desktop_config.json for Claude Desktop) and restart the client.
Sources: public MCP Server directories. This is an independent third-party directory with no affiliation to or endorsement from the maintainers of the listed servers.