広告掲載
MCP.so
ログイン

SQL Server MCP Client

@aadversteeg

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT

トランスポート

stdio

作者

aadversteeg

SQL Server MCP Client について

A Microsoft SQL Server client implementing the Model Context Protocol (MCP). This server provides SQL query capabilities through a simple MCP interface.

SQL Server MCP Client の設定

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

{
  "mcpServers": {
    "mssqlclient-mcp-server": {
      "command": "docker",
      "args": [
        "pull",
        "aadversteeg/mssqlclient-mcp-server:latest"
      ]
    }
  }
}

SQL Server MCP Client のツール

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

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

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

概要

What is SQL Server MCP Client?

A comprehensive Microsoft SQL Server client implementing the Model Context Protocol (MCP). It provides tools for executing SQL queries, managing stored procedures, listing tables, and retrieving schema information from SQL Server databases. Built with .NET Core using the MCP C# SDK, it can be deployed directly or as a Docker container. The server operates in two modes: Database Mode (when a specific database is specified in the connection string) and Server Mode (when no database is specified, allowing server-wide operations across all databases).

How to use SQL Server MCP Client?

Install as a .NET global tool (dotnet tool install --global Ave.McpServer.MsSqlClient) or run as a Docker container. Configure it as an MCP server in Claude Desktop/Claude Code by adding the mssql entry to the mcpServers configuration with the MSSQL_CONNECTIONSTRING environment variable. By default, only read-only tools are enabled; to enable query and stored procedure execution, set the corresponding DatabaseConfiguration__Enable* environment variables to "true".

Key features of SQL Server MCP Client

  • Execute SQL queries and stored procedures with type-safe automatic JSON-to-SQL conversion
  • List all tables with schema and row count information
  • Retrieve detailed schema information for specific tables
  • Discover stored procedure parameters in table or JSON Schema format
  • Configurable timeouts and background session management for long-running operations
  • Automatic execution timing and optional query profiling with IO statistics and XML plans
  • Two-mode architecture optimized for single-database or multi-database scenarios

Use cases of SQL Server MCP Client

  • Enable AI assistants to query and interact with SQL Server databases through natural language
  • Automate schema discovery and documentation generation across multiple databases
  • Debug and analyze SQL Server performance with execution timing and profiling tools
  • Manage stored procedures and parameters programmatically via MCP tools
  • Integrate SQL Server operations into workflows built on the Model Context Protocol

よくある質問

1

Why are query and stored procedure execution tools disabled by default?

For security reasons as of version 0.0.5. You must explicitly enable them by setting the corresponding environment variables to `"true"` to prevent unintended data modification.

2

What are the prerequisites for running the server?

.NET 10.0 SDK for local development/deployment, or Docker for container deployment. For integration tests, Docker must be running.

3

How can I enable query and stored procedure execution?

Set the environment variables `DatabaseConfiguration__EnableExecuteQuery`, `DatabaseConfiguration__EnableExecuteStoredProcedure`, `DatabaseConfiguration__EnableStartQuery`, and `DatabaseConfiguration__EnableStartStoredProcedure` to `"true"` in the MCP server configuration.

4

What are the two modes of operation?

**Database Mode** restricts operations to a single database specified in the connection string. **Server Mode** allows operations across all databases on the server when no database is specified.

5

How is the server deployed?

As a .NET global tool from NuGet (`Ave.McpServer.MsSqlClient`) or as a Docker image on Docker Hub (`aadversteeg/mssqlclient-mcp-server:latest`). You can also build from source using `dotnet build`.

コメント

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

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

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

Postgres Mcp

crystaldba

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

3.0K

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

Elasticsearch MCP Server

elastic

685
広告掲載