convez.ai
MCP Server
achmadya-dev

mcp-postgres-query

achmadya-dev/mcp-postgres-query

Ver no GitHub
InicialPluginScore · de 0 a 100

Model Context Protocol (MCP) server for PostgreSQL to run SQL queries via stdio

Instalação

$npx convez-ai achmadya-dev/mcp-postgres-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-postgres-query

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

Requirements

  • Node.js ≥ 20
  • A reachable PostgreSQL server

Install from npm

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": ["-y", "@achmadya-dev/mcp-postgres-query"],
      "env": {
        "POSTGRES_HOST": "localhost",
        "POSTGRES_PORT": "5432",
        "POSTGRES_USER": "your_user",
        "POSTGRES_PASSWORD": "your_password",
        "POSTGRES_DATABASE": "your_database"
      }
    }
  }
}

Or use envFile instead of inline env (see Cursor MCP docs).

Develop from source

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

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

{
  "mcpServers": {
    "postgres": {
      "command": "node",
      "args": ["${workspaceFolder}/dist/index.js"],
      "env": {
        "POSTGRES_HOST": "localhost",
        "POSTGRES_PORT": "5432",
        "POSTGRES_USER": "your_user",
        "POSTGRES_PASSWORD": "your_password",
        "POSTGRES_DATABASE": "your_database"
      }
    }
  }
}

Environment variables

Connection

VariableDefaultDescription
POSTGRES_HOSTlocalhostPostgreSQL host
POSTGRES_PORT5432Port
POSTGRES_USER(empty)Username
POSTGRES_PASSWORD(empty)Password
POSTGRES_DATABASE(optional)Default database
POSTGRES_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
postgres_selectSELECT, EXPLAIN, TABLE, VALUES, SHOWalways on
postgres_insertINSERTALLOW_INSERT_OPERATION
postgres_updateUPDATEALLOW_UPDATE_OPERATION
postgres_deleteDELETEALLOW_DELETE_OPERATION
postgres_ddlDDLALLOW_DDL_OPERATION

Tool input

ParameterRequiredDescription
sqlyesSingle SQL statement
databasenoOverrides POSTGRES_DATABASE for this call

Example:

{
  "sql": "SELECT datname FROM pg_database",
  "database": "postgres"
}

Use schema.table in sql for other schemas in the same database.

Behavior and security

  • One statement per request.
  • Results are JSON text with columns, rows, rowCount, truncated, maxRows for row-returning queries.
  • Execute results return kind: "execute" with affectedRows.

Package scripts

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

Bom para

Relacionados