Microsoft SQL MCP Server

@aaaaalexander

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT license

トランスポート

stdio

作者

aaaaalexander

Microsoft SQL MCP Server について

概要はまだありません

Microsoft SQL MCP Server の設定

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

{
  "mcpServers": {
    "MS_SQL_MCP_server": {
      "command": "python",
      "args": [
        "-m",
        "venv",
        ".venv"
      ]
    }
  }
}

Microsoft SQL MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

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

概要

What is Microsoft SQL MCP Server?

A robust SQL Server interface using the Model Context Protocol (MCP) standard, providing AI assistants with a controlled way to interact with SQL databases. It offers tools for schema exploration, query execution, and data analysis, with safety mechanisms to prevent harmful operations. Designed primarily for integration with Claude Desktop.

How to use Microsoft SQL MCP Server?

Install prerequisites (Python 3.8+, SQL Server 2016+, Microsoft ODBC Driver 17+), clone the repository, create a virtual environment, install dependencies, then configure via claude_config.json for Claude Desktop (using DB_ environment variables) or via .env for standalone mode. Restart Claude Desktop to activate; ask natural language prompts like "Show me the structure of the Customers table."

Key features of Microsoft SQL MCP Server

🔒 Secure database access with configurable security restrictions
🛠️ Rich tool set for queries, schema exploration, and analysis
📊 Data visualization support through export and analysis
🧠 AI‑ready interface implementing the Model Context Protocol
⚡ Connection pooling and efficiency optimizations for high throughput
📦 Export query results to CSV, JSON, Excel and more

Use cases of Microsoft SQL MCP Server

🗂️ Explore database schemas and table structures interactively
⚡ Execute safe read‑only SQL queries with parameter binding
📈 Generate statistical analyses and data summaries from tables
🔍 Discover foreign keys, related tables, and relationship maps
💾 Export query results to various formats for reporting

よくある質問

What are the runtime requirements?

Python 3.8+, SQL Server 2016+, and Microsoft ODBC Driver for SQL Server 17+ are required.

How does the server prevent harmful operations?

It validates and sanitizes SQL queries, enforces read-only mode by default, restricts schema access via `DB_ALLOWED_SCHEMAS`, and recommends using a dedicated read‑only SQL user instead of admin accounts.

Where does configuration data live?

Configuration is stored in `claude_config.json` (for Claude Desktop) or `.env` file (standalone), with connection variables like `DB_SERVER`, `DB_NAME`, `DB_USERNAME`, `DB_PASSWORD`, and `DB_ALLOWED_SCHEMAS`.

What transport does the server use?

The server uses the Model Context Protocol (MCP) standard, invoked via stdio when connected to Claude Desktop or run as a standalone process.

Are there any known limitations?

The server is designed for read‑only access by default; it does not support write operations like INSERT/UPDATE/DELETE unless explicitly overridden. Schema and object access can be further limited using environment variables.

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

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.