Microsoft SQL Server MCP Server

@vuutla

代码仓库

基本信息

分类

数据库

许可证

MIT license

传输方式

stdio

作者

vuutla

关于 Microsoft SQL Server MCP Server

暂无概览

#mssql #sql-server #database #mcp-server

Microsoft SQL Server MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mssql-mcp-server-vuutla": {
      "command": "python",
      "args": [
        "-m",
        "mssql_mcp_server"
      ]
    }
  }
}

Microsoft SQL Server MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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

常见问题

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.