MSSQL MCP Server

Name: MSSQL MCP Server
Author: c0h1b4

@c0h1b4

リポジトリ

MSSQL MCP Server について

概要はまだありません

基本情報

カテゴリ

データベース

ライセンス

MIT

ランタイム

node

トランスポート

stdio

公開者

c0h1b4

設定

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

{
  "mcpServers": {
    "mssql-mcp-server-c0h1b4": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "@c0h1b4/mssql-mcp-server",
        "--client",
        "claude"
      ]
    }
  }
}

ツール

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

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

概要

What is MSSQL MCP Server?

A Model Context Protocol (MCP) server that connects to Microsoft SQL Server databases. It provides tools for executing SQL queries and managing database connections, primarily for AI assistants like Claude.

How to use MSSQL MCP Server?

Install via npm (npm install mssql-mcp-server) or using Smithery. Add the server to your MCP settings configuration file with environment variables for either a full connection string or individual connection parameters (host, port, database, user, password). Then invoke the query tool to run SQL queries.

Key features of MSSQL MCP Server

Execute SQL queries on Microsoft SQL Server databases
Supports connection string or individual connection parameters
Blocks dangerous SQL commands (DROP, TRUNCATE, ALTER, etc.)
Validates input parameters and database names
Implements connection pooling for performance and security
Runs locally or in Docker container

Use cases of MSSQL MCP Server

Let an AI assistant query a SQL Server database in natural language
Automate database reporting through an AI agent
Build intelligent workflows that read and analyze database tables
Provide a secure, sandboxed SQL interface for LLM-based tools

FAQ from MSSQL MCP Server

What is MSSQL MCP Server?

It is an MCP server that enables AI assistants to connect to and query Microsoft SQL Server databases using the Model Context Protocol.

How do I install MSSQL MCP Server?

You can install it via npm with npm install mssql-mcp-server or automatically through Smithery using npx -y @smithery/cli install @c0h1b4/mssql-mcp-server --client claude.

How do I configure the database connection?

Set environment variables in your MCP settings file: either MSSQL_CONNECTION_STRING with a full connection string, or individual parameters like MSSQL_HOST, MSSQL_PORT, MSSQL_DATABASE, MSSQL_USER, and MSSQL_PASSWORD.

What safety measures does MSSQL MCP Server include?

It blocks potentially harmful commands such as DROP, TRUNCATE, ALTER, CREATE, and EXEC. It also validates input parameters, limits query length and timeout, and uses connection pooling.

Can I run MSSQL MCP Server with Docker?

Yes. A docker-compose.yml is provided to start both SQL Server and the MCP server, or you can build the image manually with docker build -t mssql-mcp-server . and run the container.