MS SQL MCP Server 1.1

@dperussina

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

GPL-3.0

トランスポート

stdio

作者

dperussina

投稿者

Danny P

MS SQL MCP Server 1.1 について

MCP server for MS SQL Server

#mssql #sql-server#database-query

MS SQL MCP Server 1.1 の設定

標準の設定はありません

このサーバーの README には解析可能な MCP 設定ブロックが含まれていません。インストール手順はリポジトリをご確認ください。

リポジトリ

MS SQL MCP Server 1.1 のツール

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

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

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

概要

What is MS SQL MCP Server 1.1?

MS SQL MCP Server 1.1 is a bridge that lets AI assistants like Claude directly query and explore Microsoft SQL Server databases. It requires no coding experience and executes read-only SQL queries by default to keep data safe.

How to use MS SQL MCP Server 1.1?

Install Node.js (version 14+), clone the repository, run npm install, copy .env.example to .env, and configure database credentials (DB_USER, DB_PASSWORD, DB_SERVER, DB_DATABASE, PORT, HOST, TRANSPORT, SERVER_URL, DEBUG, QUERY_RESULTS_PATH). Start with npm start (stdio transport) or npm run start:sse (HTTP/SSE transport). Use the bundled interactive client via npm run client.

Key features of MS SQL MCP Server 1.1

Discover tables and their structures (columns, data types)
Execute read-only SQL queries safely
Generate SQL queries from natural language requests
Supports offset/fetch and cursor-based pagination
Query results saved as JSON files locally
Operates via stdio or HTTP/SSE transport

Use cases of MS SQL MCP Server 1.1

Sales performance analysis: monthly trends and top products by region
Customer segmentation by purchase frequency and order value
Database schema optimization and data quality auditing
API exploration: analyze schema to design endpoints
Natural language database interrogation for non-technical users

よくある質問

Can MS SQL MCP Server 1.1 modify my database?

No. All queries are read-only by default, ensuring data safety.

What are the runtime requirements?

Node.js version 14 or higher and access to a Microsoft SQL Server database (on-premises or Azure).

How do I change the transport mode?

Edit the `.env` file: set `TRANSPORT=stdio` for local use or `TRANSPORT=sse` for network access, then start with `npm start` or `npm run start:sse` respectively.

Where are query results stored?

Results of executed queries are saved as JSON files in the directory specified by the `QUERY_RESULTS_PATH` environment variable.

Does the server support pagination?

Yes. It supports both offset/fetch (`OFFSET ... ROWS FETCH NEXT ... ROWS ONLY`) and cursor-based pagination (`WHERE ID > last_id ORDER BY ID`).

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

Chroma MCP Server

chroma-core

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

569

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