SQL Server MCP Server

@ranjithr99

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

ranjithr99

关于 SQL Server MCP Server

暂无概览

#sql #database #mcp

SQL Server MCP Server 配置

暂无标准配置

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

代码仓库

SQL Server MCP Server 工具

工具列表暂未提供

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

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

概览

What is SQL-Server-MCP?

A lightweight MCP stdio server that connects to Microsoft SQL Server using provided credentials and exposes tools to query and discover schema. It is designed for MCP-compatible clients such as Claude Desktop.

How to use SQL-Server-MCP?

Install Node.js >= 18, then run npm install and npm run build to build the server. Start it with npm start. The server communicates over stdio and must be driven by an MCP client. Use the connect tool first with SQL Server credentials, then use other tools like query, info, or list_* tools.

Key features of SQL-Server-MCP

Connects to Microsoft SQL Server via MCP stdio.
Exposes tools: connect, disconnect, query, info.
Lists databases, schemas, and tables.
Executes arbitrary SQL queries securely.
Credentials provided at call-time, not stored.
Built with TypeScript, MIT licensed.

Use cases of SQL-Server-MCP

Query a SQL Server database from an MCP client like Claude Desktop.
Discover database schema: list databases, schemas, and tables.
Execute ad-hoc SQL queries and retrieve results.
Integrate SQL Server data into AI assistant workflows.

常见问题

How do I connect to SQL Server?

Use the `connect` tool with `server`, `port`, `user`, `password`, optional `database`, and `encrypt` flag.

What tools are available after connecting?

Tools: `info` (returns `@@VERSION`), `query` (execute SQL), `list_databases`, `list_schemas`, `list_tables`.

Are credentials stored?

No, credentials are provided at call-time and not stored. TLS encryption defaults to `true`.

What are the runtime requirements?

Node.js version 18 or higher is required.

Can I list tables from a specific schema?

Yes, the `list_tables` tool accepts an optional `schema` parameter to filter results.

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

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

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

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

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.

Local YDB MCP

astandrik

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