広告掲載
MCP.so
ログイン

MCP SQL Server

@MKhan997733

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

MKhan997733

MCP SQL Server について

概要はまだありません

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

MCP SQL Server の設定

標準の設定はありません

このサーバーの README には解析可能な MCP 設定ブロックが含まれていません。インストール手順はリポジトリをご確認ください。

リポジトリ

MCP SQL Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is MCP SQL Server?

MCP SQL Server is a Model Context Protocol (MCP) server that enables AI assistants like Claude to securely interact with SQL Server databases through local connections. It provides tools for database exploration, query execution, and data analysis via a controlled interface.

How to use MCP SQL Server?

Clone the repository, install dependencies (npm install), configure environment variables (DB_SERVER, DB_NAME, DB_USER, DB_PASSWORD, DB_PORT) in a .env file, then add the server to Claude Desktop’s claude_desktop_config.json with the correct absolute path and environment variables. After restarting Claude Desktop, you can ask questions like “What tables are in my database?” or “Show me the schema of the Users table”.

Key features of MCP SQL Server

  • Secure local database access using SQL Authentication
  • Schema exploration: discover tables, columns, and relationships
  • Query execution with proper error handling
  • Built‑in safety controls against harmful operations
  • Read‑only query execution by default
  • Tools to list stored procedures, indexes, and constraints

Use cases of MCP SQL Server

  • Enabling Claude to explore and query a local SQL Server database
  • Discovering table structures and relationships without manual inspection
  • Executing safe, read‑only SELECT queries through natural language
  • Auditing database schema, indexes, and constraints via AI assistance
  • Rapidly retrieving top‑ or filtered‑data from production‑like local databases

よくある質問

1

What dependencies does MCP SQL Server require?

Node.js 18.0 or higher, npm, a SQL Server instance, and the Claude Desktop application.

2

How does MCP SQL Server access the database?

It connects to a local SQL Server using SQL Authentication, configured through environment variables (DB_SERVER, DB_NAME, DB_USER, DB_PASSWORD, DB_PORT). Only localhost connections are accepted.

3

Is query execution read‑only?

By default, the `execute_query` tool runs SELECT queries only. For enhanced security, you should configure the database user with read‑only permissions.

4

How do I configure MCP SQL Server in Claude Desktop?

Edit `claude_desktop_config.json` found in the Claude Desktop config directory (macOS: `~/Library/Application Support/Claude/`, Windows: `%APPDATA%\Claude\`, Linux: `~/.config/Claude/`) and add a server entry pointing to `node` with the absolute path to `mcp-server-sql/index.js` and the required environment variables.

5

What security best practices are recommended?

Use a dedicated SQL Server login with minimal required permissions, configure the database user for read‑only access, restrict connections to localhost, and enable SQL Server audit logging to track all queries.

コメント

「データベース」の他のコンテンツ

Database Gateway

centralmind

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

531

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

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

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617
広告掲載