Microsoft SQL Server MCP Server

Name: Microsoft SQL Server MCP Server
Author: vuutla

@vuutla

代码仓库

关于 Microsoft SQL Server MCP Server

暂无概览

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

基本信息

分类

数据库

许可证

MIT license

运行时

python

传输方式

stdio

发布者

vuutla

配置

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

{
  "mcpServers": {
    "mssql-mcp-server-vuutla": {
      "command": "python",
      "args": [
        "-m",
        "mssql_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

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.

数据库分类下的更多 MCP 服务器

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245

MCP Server for MySQL based on NodeJS

benborla

A 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.

1.9K