MS SQL MCP Server 1.1

@MCP-Mirror

代码仓库

基本信息

分类

数据库

许可证

GPL-3.0 license

传输方式

stdio

作者

MCP-Mirror

关于 MS SQL MCP Server 1.1

Mirror of

#mssql #database #ai-assistant

MS SQL MCP Server 1.1 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

MS SQL MCP Server 1.1 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is MS SQL MCP Server 1.1?

A bridge that lets AI assistants like Claude directly query and explore Microsoft SQL Server databases. It enables read-only SQL queries, table discovery, schema viewing, and natural-language-to-SQL generation without coding.

How to use MS SQL MCP Server 1.1?

Install Node.js (v14+), clone the repository, run npm install, copy .env.example to .env, edit database credentials, then start with npm start (stdio) or npm run start:sse (HTTP/SSE). Use the bundled client with npm run client for a menu-driven interface.

Key features of MS SQL MCP Server 1.1

Read-only SQL execution to protect data
Database table discovery and schema viewing
Natural language question‑to‑SQL generation
Pattern‑based table search and pagination support
Offline/local credential storage – no external service
Bundled interactive client with menu‑driven tools

Use cases of MS SQL MCP Server 1.1

Data analysts get AI‑assisted insights without sharing credentials
Developers explore database structure via natural conversation
Business analysts query data without SQL expertise
DBAs provide controlled AI access to database schemas
Build business intelligence reports (sales trends, customer segmentation)

常见问题

Is the server read‑only by default?

Yes, all queries are executed as read‑only to ensure data safety.

What transport protocols are supported?

The server supports stdio (default) and HTTP/SSE (start with `npm run start:sse`).

Where are database credentials stored?

Credentials are stored locally in the `.env` file and are never sent to external services.

What runtime is required?

Node.js version 14 or higher. Access to a Microsoft SQL Server database (on‑premises or Azure).

What tools does the server expose?

Key tools include `mcp_SQL_mcp_discover_database()`, `mcp_SQL_mcp_table_details()`, `mcp_SQL_mcp_execute_query()`, `mcp_SQL_mcp_discover_tables()`, and `mcp_SQL_mcp_get_query_results()`.

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

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

Local YDB MCP

astandrik

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

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.