広告掲載
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 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

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

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

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

広告掲載