SQL Server MCP Server

@Popplywop

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT license

トランスポート

stdio

作者

Popplywop

SQL Server MCP Server について

SQL Server MCP Server - Provides SQL Server database access via Model Context Protocol

SQL Server MCP Server の設定

標準の設定はありません

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

リポジトリ

SQL Server MCP Server のツール

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

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

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

概要

What is SQL Server MCP Server?

SQL Server MCP Server is a Model Context Protocol (MCP) server that provides tools for interacting with SQL Server databases. It allows Large Language Models (LLMs) to query and inspect SQL Server databases through a standardized protocol.

How to use SQL Server MCP Server?

Install the .NET 8.0 SDK, clone the repository, and run dotnet build. The server can be run with a direct connection string using --dsn or by referencing an environment variable with --env-var. Configure the server in your MCP client (e.g., Claude) using the provided JSON configuration, specifying the path to the executable and connection arguments.

Key features of SQL Server MCP Server

Execute SQL queries and retrieve results
List tables, views, and stored procedures
Get schema of a specific table
Get information about the connected database
Support for direct or environment variable connection strings
Command timeout and row limit options

Use cases of SQL Server MCP Server

Query data from SQL Server using natural language via an LLM
Inspect database schema to understand table structures
List available views and stored procedures for documentation
Retrieve database metadata for troubleshooting or analysis

よくある質問

What are the prerequisites for running SQL Server MCP Server?

You need the .NET 8.0 SDK or later and a SQL Server instance (local or remote).

How do I provide the database connection string?

You can provide it directly using the `--dsn` argument or reference an environment variable with the `--env-var` argument (e.g., `SQL_CONNECTION_STRING`).

What MCP tools does the server expose?

The server exposes tools for querying (`ExecuteQuery`), schema inspection (`ListTables`, `GetTableSchema`, `ListViews`, `ListStoredProcedures`), and database information (`GetDatabaseInfo`).

What security recommendations are given?

Use a SQL Server account with least privilege, store connection strings securely (avoid source control), prefer environment variables, and enable TLS/SSL for database connections.

What license is SQL Server MCP Server released under?

It is licensed under the MIT License, which permits reuse with minimal restrictions.

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

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes