広告掲載
MCP.so
ログイン

MS SQL Server MCP Server

@TerraCo89

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT

トランスポート

stdio

作者

TerraCo89

MS SQL Server MCP Server について

MCP server for Microsoft SQL Server - typed schema inspection and parameterized CRUD tools for LLM agents

#mcp-server#mssql#database-integration

MS SQL Server MCP Server の設定

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

{
  "mcpServers": {
    "mcp-server-mssql": {
      "command": "python",
      "args": [
        "-m",
        "venv",
        "venv"
      ]
    }
  }
}

MS SQL Server MCP Server のツール

6

List all user tables in the configured database

Column names, types, nullability, and defaults for a table

Read rows with optional column selection, WHERE filters, ORDER BY, and LIMIT

Insert one or more rows (column/value validated against schema)

Update rows matching a filter; returns affected count

Delete rows matching a filter; returns affected count

概要

What is MS SQL Server MCP Server?

The MS SQL Server MCP Server is a Model Context Protocol server that gives LLM agents safe, structured access to Microsoft SQL Server. It provides schema inspection and row-level CRUD operations, with every query parameterized and logged for accountability.

How to use MS SQL Server MCP Server?

Requires Node.js 18+ and network access to a SQL Server instance. Clone the repository, install dependencies, copy .env.example to .env and fill in database connection variables (MSSQL_HOST, MSSQL_USER, MSSQL_PASSWORD, MSSQL_DATABASE), then build with npm run build. Run with node dist/server.js and configure as an MCP server (stdio) in Claude Desktop or Claude Code.

Key features of MS SQL Server MCP Server

  • Six typed tools: list_tables, get_table_schema, read_table_rows, create_table_records, update_table_records, delete_table_records
  • All queries are parameterized to prevent SQL injection
  • Table and column names validated against live schema before execution
  • Structured logging to a logs/ directory
  • Supports row-level insert, update, and delete with affected-row counts
  • Communicates over stdio with any MCP client

Use cases of MS SQL Server MCP Server

  • An LLM agent inspects database schema before constructing queries
  • Read rows with optional column selection, WHERE filters, ORDER BY, and LIMIT
  • Safely insert, update, or delete records while maintaining audit trails
  • Provide structured database access to Claude Desktop or Claude Code
  • Let a least‑privilege SQL login drive agent interactions

よくある質問

1

What runtime does the server require?

Node.js 18 or later and network access to a SQL Server instance.

2

How do I configure the database connection?

Set environment variables: `MSSQL_HOST`, `MSSQL_USER`, `MSSQL_PASSWORD`, `MSSQL_DATABASE`, and optionally `MSSQL_PORT` (default 1433), `MSSQL_ENCRYPT`, `MSSQL_TRUST_SERVER_CERTIFICATE`, and `LOG_LEVEL`.

3

Can the server connect to multiple databases?

No – it connects to a single database per server instance, configured via the `MSSQL_DATABASE` variable.

4

What transport protocol does it use?

It uses stdio transport, suitable for MCP clients like Claude Desktop and Claude Code.

5

How does the server protect against injection?

All queries are parameterized, and identifier names (table and column) are validated against the live schema before any statement runs. You should connect with a least‑privilege SQL login

コメント

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

Chroma MCP Server

chroma-core

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

569

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K
広告掲載