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`).

数据库分类下的更多 MCP 服务器

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

Chroma MCP Server

chroma-core

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

569

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s