Sql Server Mcp
@hendrickcastro
Sql Server Mcp について
A comprehensive Model Context Protocol (MCP) server for SQL Server database operations. This server provides 10 powerful tools for database analysis, object discovery, and data manipulation through the MCP protocol.
基本情報
設定
以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。
{
"mcpServers": {
"mcpql": {
"command": "npx",
"args": [
"-y",
"hendrickcastro/mcpql"
],
"env": {
"DB_AUTHENTICATION_TYPE": "sql",
"DB_SERVER": "your_server",
"DB_NAME": "your_database",
"DB_USER": "your_username",
"DB_PASSWORD": "your_password",
"DB_PORT": "1433",
"DB_ENCRYPT": "false",
"DB_TRUST_SERVER_CERTIFICATE": "true"
}
}
}
}ツール
ツールは検出されませんでした
ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。
概要
What is Sql Server Mcp?
Sql Server Mcp is a comprehensive Model Context Protocol (MCP) server for SQL Server database operations. It provides 10 tools for database analysis, object discovery, and data manipulation through the MCP protocol. The server is designed for developers and DBAs using MCP-compatible clients like Claude Desktop or Cursor IDE.
How to use Sql Server Mcp?
Installation is recommended via npx with no local setup required. Configure your MCP client (e.g., Claude Desktop or Cursor IDE) with the command npx -y hendrickcastro/mcpql and set the required environment variables for database connection. Alternatively, clone the repository, run npm install and npm run build, then point your MCP client to the built server file.
Key features of Sql Server Mcp
- 10 dedicated MCP tools for SQL Server operations
- Supports SQL Server, SQL Server Express, and Azure SQL
- SQL, Windows, and Azure AD authentication
- Connection pooling and comprehensive timeout settings
- Docker-ready and security audited
- Configurable via environment variables or connection string
Use cases of Sql Server Mcp
- Analyze table structures, indexes, and constraints via MCP tools
- Execute custom SQL queries and stored procedures with parameters
- Search database objects by name and definition across the entire database
- Preview data and get column statistics for quick analysis
- Discover object dependencies for tables, views, and procedures
FAQ from Sql Server Mcp
What databases does Sql Server Mcp support?
It supports SQL Server 2016+, SQL Server Express (named instances), and Azure SQL Database.
What authentication types are available?
Sql Server Mcp supports SQL Server Authentication, Windows Authentication, and Azure Active Directory Authentication (including service principals).
Do I need to install anything locally to use Sql Server Mcp?
No. You can use npx -y hendrickcastro/mcpql directly – no local installation required.
What are the required environment variables?
At minimum, you must set DB_AUTHENTICATION_TYPE, DB_SERVER, and DB_NAME. For SQL auth, also set DB_USER and DB_PASSWORD. See the README for the full variable table.
How is data privacy handled?
The server connects directly to your SQL Server instance; data stays on your database. All configuration is done through environment variables or a connection string.
「データベース」の他のコンテンツ
Elasticsearch/OpenSearch MCP Server
cr7258A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction.
Snowflake MCP Server
isaacwasserman
Chroma MCP Server
chroma-coreA Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma
Sail MCP Server for Spark SQL
lakehqDrop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.
mcp_mysql_server
wenb1n-devModel Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展
コメント