hendrickcastro/mcpql

Developer tools

Эта страница переведена автоматически. Технические детали смотрите в оригинале. Открыть оригинал

15 stars 5 forks Качество 72 Тренд 21MIT

Repository Install

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",

Открыть полный README на GitHub

Установка

npx -y hendrickcastro/mcpql

Новичок в MCP? Начните с руководства на mcpskill.org →

Конфигурация

{
  "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"
      }
    }
  }
}