mssql-mcp

概述

mssql-mcp服务器通过定义完善的工具提供数据库交互功能，包括数据读写、表创建和模式信息检索。它还包含独特的商业智能功能，可根据数据分析自动生成洞察备忘录。该实现使用pyodbc进行数据库连接，并为不同的MCP客户端提供了适当的配置选项。

试试问 AI

装完之后，这里有 5 个你可以让 AI 做的事：

• read_query

  Execute SELECT queries to read data from the database

  试试:Show me all customers from the database试试:What are the top 10 products by sales?试试:Find all orders placed in the last month
• write_query

  Execute INSERT, UPDATE, or DELETE queries

  试试:Add a new customer to the customers table试试:Update the price of product X试试:Delete all orders older than a year
• create_table

  Create new tables in the database

  试试:Create a new inventory table with columns for product_id and quantity试试:Set up a user activity tracking table试试:Make a new sales summary table
• list_tables

  Get a list of all tables in the database

  试试:What tables are available in this database?试试:Show me all the tables试试:List all database tables
• describe-table

  View schema information for a specific table

  试试:Describe the structure of the customers table试试:What columns are in the products table?试试:Show me the schema of the orders table
• append_insight

  Add new business insights to the memo resource

  试试:Add insights about Q3 sales performance试试:Record findings about customer churn试试:Add observations about market trends

可对比工具

安装

{
  "mcpServers": {
    "mssql": {
      "command": "python",
      "args": ["/path/to/mssql-mcp/src/server.py"]
    }
  }
}```

FAQ

支持哪些SQL Server版本？

该服务器使用SQL Server的ODBC驱动程序17，支持SQL Server 2008及更高版本。

此服务器可用于其他数据库系统吗？

此实现专门针对MSSQL设计。README中提到它是从SQLite示例修改而来的。

mssql-mcp 对比