MCPQL - MCP Server for SQL Server database operations and analysis
概览
A comprehensive server for database operations. This server provides 10 powerful tools for database analysis, object discovery, and data manipulation through the MCP protocol. - Node.js 18+ and npm - SQL Server database with appropriate connection credentials - MCP-compatible client (like Claude Desktop, Cursor IDE, or any MCP client) No installation needed! Just configure your MCP client: 2. Create a .env file with your database credentials: MCPQL provides 11 comprehensive tools for SQL Server database operations: Complete table structure analysis including columns, keys, indexes, and constraints. Analyze stored procedure structure including parameters, dependencies, and source code. Preview table data with optional filtering and row limits.
README
以下为原文 README 节选，完整内容请查看原文。
MCPQL - 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.
🚀 Quick Start
Prerequisites
- Node.js 18+ and npm
- SQL Server database with appropriate connection credentials
- MCP-compatible client (like Claude Desktop, Cursor IDE, or any MCP client)
Installation & Configuration
Option 1: Using npx from GitHub (Recommended)
No installation needed! Just configure your MCP client:
For Claude Desktop (claude_desktop_config.json):
{
"mcpServers": {
"mcpql": {
"command": "npx",
"args": ["-y", "hendrickcastro/mcpql"],
"env": {
"DB_AUTHENTICATION_TYPE": "sql",安装
npx -y hendrickcastro/mcpql配置
{
"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"
}
}
}
}