Mcp Sql Server

Name: Mcp Sql Server
Author: ryudg

@ryudg

代码仓库

关于 Mcp Sql Server

Just Read only

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

基本信息

分类

数据库

传输方式

stdio

发布者

ryudg

提交者

유동균

配置

使用下面的配置,将此服务器添加到你的 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"
      }
    }
  }
}

工具

未检测到工具

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

概览

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

FAQ from Mcp Sql Server

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.

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.

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

How can I test the database connection?

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

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.