postgres

A locally run MCP server that connects an AI coding agent to PostgreSQL, a database system. It provides tools for database administration, performance monitoring, and Java backend integration, and can be configured as read-only.

In plain words
What is it for?
Use it to monitor PostgreSQL performance, administer a database, or support Java backend work; it requires database connection settings.
Why use it?
It brings database inspection and administration tasks into the coding-agent workflow instead of requiring separate tools.

MCP server for Claude CodeCodexCursor

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add mcp/irsyadjpp/postgres-mcp-server/postgres
Clone the repo
git clone --depth 1 https://github.com/irsyadjpp/postgres-mcp-server

Made for: Claude Code, Codex, Cursor.

Per session not measured What this adds to a session before it is invoked.
When invoked not measured Not applicable: nothing here is loaded into a session.
Security scan A 0 findings. Scan, not verified.
Origin 86% copy Near-identical to another mod in the catalogue.
Security

Grade A, and why

postgres scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured yesterday.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

Origin

This is a copy

86% identical to postgres — 2 lines differ, which has more behind it and is treated as the original. This page carries a canonical link to it rather than competing with it.

.mcp.json · 17 lines

What it actually says

{
  "postgres": {
    "command": "npx",
    "args": [
      "@irsyadjpp/postgres-mcp-server@latest"
    ],
    "env": {
      "DB_HOST": "${DB_HOST:-127.0.0.1}",
      "DB_PORT": "${DB_PORT:-5432}",
      "DB_USER": "${DB_USER:-postgres}",
      "DB_NAME": "${DB_NAME:-postgres}",
      "DB_PASSWORD": "${DB_PASSWORD}",
      "DB_SSL": "${DB_SSL:-true}",
      "READ_ONLY": "${READ_ONLY:-true}"
    }
  }
}
Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. yesterday First seen · 17 lines scan A 517671f7b9e3

Subscribe to this mod's changes

postgres is an MCP server published in the GitHub repository irsyadjpp/postgres-mcp-server (0 stars, last pushed 26d ago), licensed ISC. Its token cost is not measured: an MCP server costs its tool schemas, not its config file. A static security scan graded it A with 0 findings. It is 86% identical to postgres, differing in 2 lines, and is treated as a copy.