広告掲載
MCP.so
ログイン

MS SQL MCP Server 1.1

@MCP-Mirror

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

GPL-3.0 license

トランスポート

stdio

作者

MCP-Mirror

MS SQL MCP Server 1.1 について

Mirror of

#mssql#database#ai-assistant

MS SQL MCP Server 1.1 の設定

標準の設定はありません

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

リポジトリ

MS SQL MCP Server 1.1 のツール

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

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

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

概要

What is MS SQL MCP Server 1.1?

A bridge that lets AI assistants like Claude directly query and explore Microsoft SQL Server databases. It enables read-only SQL queries, table discovery, schema viewing, and natural-language-to-SQL generation without coding.

How to use MS SQL MCP Server 1.1?

Install Node.js (v14+), clone the repository, run npm install, copy .env.example to .env, edit database credentials, then start with npm start (stdio) or npm run start:sse (HTTP/SSE). Use the bundled client with npm run client for a menu-driven interface.

Key features of MS SQL MCP Server 1.1

  • Read-only SQL execution to protect data
  • Database table discovery and schema viewing
  • Natural language question‑to‑SQL generation
  • Pattern‑based table search and pagination support
  • Offline/local credential storage – no external service
  • Bundled interactive client with menu‑driven tools

Use cases of MS SQL MCP Server 1.1

  • Data analysts get AI‑assisted insights without sharing credentials
  • Developers explore database structure via natural conversation
  • Business analysts query data without SQL expertise
  • DBAs provide controlled AI access to database schemas
  • Build business intelligence reports (sales trends, customer segmentation)

よくある質問

1

Is the server read‑only by default?

Yes, all queries are executed as read‑only to ensure data safety.

2

What transport protocols are supported?

The server supports stdio (default) and HTTP/SSE (start with `npm run start:sse`).

3

Where are database credentials stored?

Credentials are stored locally in the `.env` file and are never sent to external services.

4

What runtime is required?

Node.js version 14 or higher. Access to a Microsoft SQL Server database (on‑premises or Azure).

5

What tools does the server expose?

Key tools include `mcp_SQL_mcp_discover_database()`, `mcp_SQL_mcp_table_details()`, `mcp_SQL_mcp_execute_query()`, `mcp_SQL_mcp_discover_tables()`, and `mcp_SQL_mcp_get_query_results()`.

コメント

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

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

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

Database Gateway

centralmind

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

531
広告掲載