広告掲載
MCP.so
ログイン

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

よくある質問

1

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.

2

What dependencies are required?

The package automatically installs system dependencies like FreeTDS. You need Python and pip to install the server.

3

How do I configure the database connection?

Set four environment variables: `MSSQL_SERVER`, `MSSQL_USER`, `MSSQL_PASSWORD`, and `MSSQL_DATABASE`. Never commit these credentials.

4

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.

5

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.

コメント

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

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K
広告掲載