convez.ai
MCP Server
achmadya-dev

mcp-mssql-query

achmadya-dev/mcp-mssql-query

Ver no GitHub
InicialPluginScore · de 0 a 100

Model Context Protocol (MCP) server for Microsoft SQL Server (MSSQL) to run SQL queries via stdio

Instalação

$npx convez-ai achmadya-dev/mcp-mssql-query

1 comando no terminal: detecta o formato do repositório (marketplace ou plugin avulso) e instala via Claude Code. Requer Node 18+ e o Claude Code instalado.

Métricas

Estrelas
0
Forks
1
Acompanhando
0
Saúde
42%
Último commit
há 5 meses
Versão
v0.3.2
Issues abertas
0
Contribuidores
2

README

A tradução para o português deste README ainda está na fila.

@achmadya-dev/mcp-mssql-query

MCP server for Microsoft SQL Server. Runs a single T-SQL statement per tool call over stdio. Read-only by default — writes and DDL require explicit env flags.

Requirements

  • Node.js ≥ 20
  • A reachable SQL Server instance

Install from npm

{
  "mcpServers": {
    "mssql": {
      "command": "npx",
      "args": ["-y", "@achmadya-dev/mcp-mssql-query"],
      "env": {
        "MSSQL_HOST": "localhost",
        "MSSQL_PORT": "1433",
        "MSSQL_USER": "sa",
        "MSSQL_PASSWORD": "your_password",
        "MSSQL_DATABASE": "your_database",
        "MSSQL_TRUST_SERVER_CERTIFICATE": "true"
      }
    }
  }
}

Or use envFile instead of inline env.

Develop from source

git clone https://github.com/achmadya-dev/mcp-mssql-query.git
cd mcp-mssql-query
pnpm install
pnpm run build
pnpm test

Open the repo root in Cursor. You need a reachable SQL Server instance — set connection env in .cursor/mcp.json or via envFile:

{
  "mcpServers": {
    "mssql": {
      "command": "node",
      "args": ["${workspaceFolder}/dist/index.js"],
      "env": {
        "MSSQL_HOST": "localhost",
        "MSSQL_PORT": "1433",
        "MSSQL_USER": "sa",
        "MSSQL_PASSWORD": "your_password",
        "MSSQL_DATABASE": "your_database",
        "MSSQL_TRUST_SERVER_CERTIFICATE": "true"
      }
    }
  }
}

Environment variables

Connection

VariableDefaultDescription
MSSQL_HOSTlocalhostSQL Server host
MSSQL_PORT1433Port
MSSQL_USER(empty)Username
MSSQL_PASSWORD(empty)Password
MSSQL_DATABASE(optional)Database name
MSSQL_INSTANCE_NAME(optional)Instance name (e.g. SQLEXPRESS)
MSSQL_ENCRYPTtrueEncrypt connection
MSSQL_TRUST_SERVER_CERTIFICATEtrueTrust server certificate (local dev)
MSSQL_CONNECTION_TIMEOUT_MS15000Connection timeout (ms)
MSSQL_REQUEST_TIMEOUT_MS15000Request timeout (ms)
MSSQL_MAX_ROWS500Max rows for row-returning queries

Write access

VariableAllows
ALLOW_INSERT_OPERATIONINSERT
ALLOW_UPDATE_OPERATIONUPDATE
ALLOW_DELETE_OPERATIONDELETE
ALLOW_DDL_OPERATIONDDL

Enabled values: true, 1, yes, on.

Tools

ToolStatementsEnv flag
mssql_selectSELECT, VALUES, PRINTalways on
mssql_insertINSERTALLOW_INSERT_OPERATION
mssql_updateUPDATEALLOW_UPDATE_OPERATION
mssql_deleteDELETEALLOW_DELETE_OPERATION
mssql_ddlDDLALLOW_DDL_OPERATION

Each tool accepts one sql string.

Behavior and security

  • One T-SQL statement per request.
  • Results are JSON text; row-returning queries include truncation metadata.
  • Non-row commands return kind: "execute" with affectedRows.

Package scripts

pnpm run build
pnpm test
pnpm start
Ver o original no GitHub

Bom para

Relacionados