Microsoft SQL Server MCP Server
@vuutla
About Microsoft SQL Server MCP Server
No overview available yet
Basic information
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"mssql-mcp-server-vuutla": {
"command": "python",
"args": [
"-m",
"mssql_mcp_server"
]
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is Microsoft SQL Server MCP Server?
A Model Context Protocol (MCP) server that enables secure interaction with Microsoft SQL Server databases. It 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 for developers.
How to use Microsoft SQL Server MCP Server?
Install via pip install mssql-mcp-server. Set the environment variables MSSQL_SERVER, MSSQL_USER, MSSQL_PASSWORD, and MSSQL_DATABASE. Use with Claude Desktop by adding a configuration entry to claude_desktop_config.json using uv, or run as a standalone server with python -m mssql_mcp_server.
Key features of Microsoft SQL Server MCP Server
- List available SQL Server tables as resources
- Read table contents
- Execute SQL queries with proper error handling
- Secure database access through environment variables
- Comprehensive logging
- Automatic system dependency installation (FreeTDS)
Use cases of Microsoft SQL Server MCP Server
- AI assistant explores database schema and table contents
- Safe execution of read-only SQL queries from a chatbot
- Automated database analysis without manual querying
- Secure, audited database interaction for AI workflows
FAQ from Microsoft SQL Server MCP Server
What does this MCP server do?
It enables AI assistants to list tables, read data, and execute SQL queries on Microsoft SQL Server databases through a controlled interface.
What dependencies are required?
The package automatically installs system dependencies like FreeTDS. You need Python and pip to install the server.
How do I configure the database connection?
Set four environment variables: MSSQL_SERVER, MSSQL_USER, MSSQL_PASSWORD, and MSSQL_DATABASE. Never commit these credentials.
Is it safe to use with production databases?
Use a dedicated SQL Server login with minimal permissions, never use sa credentials, and follow the principle of least privilege. Enable logging for audit purposes.
How do I run the server?
Install via pip, then either add it to Claude Desktop’s config (using uv) or run python -m mssql_mcp_server standalone.
More Databases MCP servers
MCP MongoDB Server
kiliczshA Model Context Protocol Server for MongoDB
PostgreSQL Model Context Protocol (PG-MCP) Server
stuzero
ClickHouse MCP Server
ClickHouseConnect ClickHouse to your AI assistants.
Neon MCP Server
neondatabaseMCP server for interacting with Neon Management API and databases
MCP Server for MySQL based on NodeJS
benborlaA Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
Comments