广告合作
MCP.so
登录
M

MCP Sql Server

@ryudg

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

ryudg

提交者

유동균

关于 MCP Sql Server

Just Read only

#mcp-sql-server#sql-database#ai-assistant

MCP Sql Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mcp-sql": {
      "command": "npx",
      "args": [
        "-y",
        "@donggyunryu/mcp-sql"
      ],
      "env": {
        "DB_HOST": "<localhost>",
        "DB_PORT": "1433",
        "DB_DATABASE": "<your_database>",
        "DB_USER": "<your_username>",
        "DB_PASSWORD": "<your_password>",
        "DB_ENCRYPT": "false",
        "DB_TRUST_SERVER_CERTIFICATE": "true"
      }
    }
  }
}

MCP Sql Server 工具

工具列表暂未提供

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

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

What is Mcp Sql Server?

A Model Context Protocol server that provides comprehensive access to SQL databases, starting with MSSQL support. It enables AI assistants to inspect database schemas, execute queries, and perform database operations with enterprise‑grade security and performance monitoring.

How to use Mcp Sql Server?

Install globally via npm install -g @donggyunryu/mcp-sql or run with npx -y @donggyunryu/mcp-sql. Create a .env file with your MSSQL credentials (DB_HOST, DB_PORT, DB_DATABASE, DB_USER, DB_PASSWORD). Then add the server configuration to your MCP‑compatible assistant (e.g., Claude Desktop, Cursor) using the provided JSON settings. Restart the assistant and start with natural‑language queries like “Show me all tables in my database.”

Key features of Mcp Sql Server

  • Full MSSQL support (MySQL and PostgreSQL coming soon)
  • Schema inspection and metadata extraction
  • Safe SQL execution with parameterized queries
  • Performance monitoring and real‑time metrics
  • SQL injection prevention and connection encryption
  • Batch operations and transaction management
  • Connection pooling with configurable settings
  • Native integration with Claude Desktop, Cursor, and others

Use cases of Mcp Sql Server

  • Exploring database schemas and table structures via natural language
  • Running safe, ad‑hoc SQL queries through AI assistants
  • Monitoring database performance and identifying slow queries
  • Processing multiple queries in batch or managing transactions
  • Generating performance reports and analyzing query statistics

常见问题

1

What databases does Mcp Sql Server support?

Currently only Microsoft SQL Server (MSSQL) is fully supported. MySQL and PostgreSQL support are planned for future releases.

2

What are the prerequisites to use Mcp Sql Server?

Node.js 18.0.0 or later, a running Microsoft SQL Server instance, and an MCP‑compatible AI assistant such as Claude Desktop or Cursor.

3

How do I configure Mcp Sql Server for Claude Desktop?

Add an entry to your `claude_desktop_config.json` with `"command": "npx"`, `"args": ["-y", "@donggyunryu/mcp-sql"]`, and the required environment variables (DB_HOST, DB_PORT, DB_DATABASE, DB_USER, DB_PASSWORD, etc.).

4

How can I test the database connection?

Run `npx @donggyunryu/mcp-sql test:db` or `npm run test:db` in a local environment.

5

What security measures are in place?

Connection encryption via TLS/SSL, parameter binding to prevent SQL injection, database user permission‑based access control, complete query logging, and comprehensive input sanitization.

评论

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

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 Model Context Protocol (PG-MCP) Server

stuzero

540

Local YDB MCP

astandrik

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

4

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

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