Sql Server MCP Server

@hendrickcastro

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

hendrickcastro

投稿者

H. C.

Sql Server MCP Server について

A comprehensive Model Context Protocol (MCP) server for SQL Server database operations. This server provides 10 powerful tools for database analysis, object discovery, and data manipulation through the MCP protocol.

#mcp #modelcontextprotocol #sqlserver#azuresql#database#databaseanalysis#databasetools#mssql#tsql

Sql Server MCP Server の設定

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

{
  "mcpServers": {
    "mcpql": {
      "command": "npx",
      "args": [
        "-y",
        "hendrickcastro/mcpql"
      ],
      "env": {
        "DB_AUTHENTICATION_TYPE": "sql",
        "DB_SERVER": "your_server",
        "DB_NAME": "your_database",
        "DB_USER": "your_username",
        "DB_PASSWORD": "your_password",
        "DB_PORT": "1433",
        "DB_ENCRYPT": "false",
        "DB_TRUST_SERVER_CERTIFICATE": "true"
      }
    }
  }
}

Sql Server MCP Server のツール

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

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

上のボタンで一時的なサンドボックスでこのサーバーを実行し、ツール一覧を取得できます。

概要

What is Sql Server Mcp?

Sql Server Mcp is a comprehensive Model Context Protocol (MCP) server for SQL Server database operations. It provides 10 tools for database analysis, object discovery, and data manipulation through the MCP protocol. The server is designed for developers and DBAs using MCP-compatible clients like Claude Desktop or Cursor IDE.

How to use Sql Server Mcp?

Installation is recommended via npx with no local setup required. Configure your MCP client (e.g., Claude Desktop or Cursor IDE) with the command npx -y hendrickcastro/mcpql and set the required environment variables for database connection. Alternatively, clone the repository, run npm install and npm run build, then point your MCP client to the built server file.

Key features of Sql Server Mcp

10 dedicated MCP tools for SQL Server operations
Supports SQL Server, SQL Server Express, and Azure SQL
SQL, Windows, and Azure AD authentication
Connection pooling and comprehensive timeout settings
Docker-ready and security audited
Configurable via environment variables or connection string

Use cases of Sql Server Mcp

Analyze table structures, indexes, and constraints via MCP tools
Execute custom SQL queries and stored procedures with parameters
Search database objects by name and definition across the entire database
Preview data and get column statistics for quick analysis
Discover object dependencies for tables, views, and procedures

よくある質問

What databases does Sql Server Mcp support?

It supports SQL Server 2016+, SQL Server Express (named instances), and Azure SQL Database.

What authentication types are available?

Sql Server Mcp supports SQL Server Authentication, Windows Authentication, and Azure Active Directory Authentication (including service principals).

Do I need to install anything locally to use Sql Server Mcp?

No. You can use `npx -y hendrickcastro/mcpql` directly – no local installation required.

What are the required environment variables?

At minimum, you must set `DB_AUTHENTICATION_TYPE`, `DB_SERVER`, and `DB_NAME`. For SQL auth, also set `DB_USER` and `DB_PASSWORD`. See the README for the full variable table.

How is data privacy handled?

The server connects directly to your SQL Server instance; data stays on your database. All configuration is done through environment variables or a connection string.

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

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi