MSSQL MCP Server

Name: MSSQL MCP Server
Author: daobataotie

@daobataotie

リポジトリ

MSSQL MCP Server について

mssql mcp server

#ai #mcp #mssql #sqlserver #model-context-protocol #mssqlmcp

基本情報

カテゴリ

データベース

ライセンス

MIT

ランタイム

python

トランスポート

stdio

公開者

daobataotie

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "mssql-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/inspector",
        "python",
        "C:\\mssql-mcp\\src\\server.py"
      ]
    }
  }
}

ツール

ツールは検出されませんでした

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is MSSQL MCP Server?

MSSQL MCP Server provides database interaction and business intelligence capabilities for Microsoft SQL Server. It enables running SQL queries, analyzing business data, and automatically generating business insight memos. It is designed for AI agents (e.g., Claude Desktop) to interact with MSSQL databases via the Model Context Protocol.

How to use MSSQL MCP Server?

Install Python packages with pip install -r requirements.txt, then create a config.json file with database connection details (driver, server, database, username, password). Configure the server as an MCP tool in Claude Desktop, Windsurf, or Cursor by pointing to server.py with the Python command. Supported tools include read_query, write_query, create_table, list_tables, describe-table, and append_insight.

Key features of MSSQL MCP Server

Execute SELECT, INSERT, UPDATE, and DELETE queries
Create new tables in the database
List all tables and describe table schemas
Append business insights to a memo resource
Self-correct SQL execution errors

Use cases of MSSQL MCP Server

Querying and analyzing business data using natural language via AI
Performing CRUD operations on MSSQL databases
Generating automated business insight memos from database content
Exploring database schema and table structures

FAQ from MSSQL MCP Server

What dependencies are required?

Python 3.x, the packages pyodbc>=4.0.39, pydantic>=2.0.0, mcp>=0.1.0, and ODBC Driver 17 for SQL Server.

How do I configure the database connection?

Create a config.json file in the same folder as server.py with fields: driver (e.g., "ODBC Driver 17 for SQL Server"), server, database, username, password, and trusted_connection (false).

How do I integrate with Claude Desktop?

Add an entry to claude_desktop_config.json with "command": "python" and "args": ["path/to/server.py"].

What operations does the server support?

It supports read_query, write_query, create_table, list_tables, describe-table, and append_insight tools.

Does the server require an internet connection?

No, it connects directly to a local or network-accessible MSSQL database instance via ODBC.

「データベース」の他のコンテンツ

Meilisearch MCP Server

meilisearch

A Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces.

193

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

mcp_mysql_server

wenb1n-dev

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

245