广告合作
MCP.so
登录

SQL Server MCP Server

@Popplywop

代码仓库

基本信息

分类

数据库

许可证

MIT license

传输方式

stdio

作者

Popplywop

关于 SQL Server MCP Server

SQL Server MCP Server - Provides SQL Server database access via Model Context Protocol

SQL Server MCP Server 配置

暂无标准配置

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

代码仓库

SQL Server MCP Server 工具

工具列表暂未提供

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

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

概览

What is SQL Server MCP Server?

SQL Server MCP Server is a Model Context Protocol (MCP) server that provides tools for interacting with SQL Server databases. It allows Large Language Models (LLMs) to query and inspect SQL Server databases through a standardized protocol.

How to use SQL Server MCP Server?

Install the .NET 8.0 SDK, clone the repository, and run dotnet build. The server can be run with a direct connection string using --dsn or by referencing an environment variable with --env-var. Configure the server in your MCP client (e.g., Claude) using the provided JSON configuration, specifying the path to the executable and connection arguments.

Key features of SQL Server MCP Server

  • Execute SQL queries and retrieve results
  • List tables, views, and stored procedures
  • Get schema of a specific table
  • Get information about the connected database
  • Support for direct or environment variable connection strings
  • Command timeout and row limit options

Use cases of SQL Server MCP Server

  • Query data from SQL Server using natural language via an LLM
  • Inspect database schema to understand table structures
  • List available views and stored procedures for documentation
  • Retrieve database metadata for troubleshooting or analysis

常见问题

1

What are the prerequisites for running SQL Server MCP Server?

You need the .NET 8.0 SDK or later and a SQL Server instance (local or remote).

2

How do I provide the database connection string?

You can provide it directly using the `--dsn` argument or reference an environment variable with the `--env-var` argument (e.g., `SQL_CONNECTION_STRING`).

3

What MCP tools does the server expose?

The server exposes tools for querying (`ExecuteQuery`), schema inspection (`ListTables`, `GetTableSchema`, `ListViews`, `ListStoredProcedures`), and database information (`GetDatabaseInfo`).

4

What security recommendations are given?

Use a SQL Server account with least privilege, store connection strings securely (avoid source control), prefer environment variables, and enable TLS/SSL for database connections.

5

What license is SQL Server MCP Server released under?

It is licensed under the MIT License, which permits reuse with minimal restrictions.

评论

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

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

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.

1

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

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

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
广告合作