Borrowing it
Nothing to install: this file belongs to arieffian/postgres-mcp-server. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.
curl -O https://raw.githubusercontent.com/arieffian/postgres-mcp-server/main/CLAUDE.mdgit clone --depth 1 https://github.com/arieffian/postgres-mcp-serverWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/instructions/arieffian/postgres-mcp-server/claude-md)<a href="https://agentmods.dev/instructions/arieffian/postgres-mcp-server/claude-md"><img src="https://agentmods.dev/badge/instructions/arieffian/postgres-mcp-server/claude-md/github.svg" alt="Measured on agentmods" height="20"></a>Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.
<a href="https://agentmods.dev/instructions/arieffian/postgres-mcp-server/claude-md"><img src="https://agentmods.dev/badge/instructions/arieffian/postgres-mcp-server/claude-md.svg" alt="Reviewed on agentmods" width="80" height="20"></a>What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.01616 | $0.01616 |
| Opus 5.5 | $0.00646 | $0.00646 |
| Sonnet 5.5 | $0.00323 | $0.00323 |
| Haiku 4.5 | $0.00162 | $0.00162 |
Grade A, and why
postgres-mcp-server CLAUDE.md 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 2mo ago.
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.
How it starts
The opening of the file, as written. The whole thing — 119 lines — stays where its author put it; the contents beside it link to each section on GitHub.
postgres-mcp-server
A general-purpose Model Context Protocol (MCP) server that lets an LLM query and (opt-in) mutate PostgreSQL databases safely. Node.js/TypeScript, distributed via npm.
Status: v0.2 (Phase 2). Meta, SQL, and schema introspection tools shipped; observability tools are deferred to Phase 3.
Stack
- Node.js ≥ 20 (ESM only,
"type": "module") - TypeScript 5.x strict (
strict: true, noanyinsafety/orconnections/layers) @modelcontextprotocol/sdk— MCP protocolpg(node-postgres) — Postgres driver + poolingzod— input schemas and config validationzod-to-json-schema— publishes real JSON Schema for tool inputspino— structured logging (stderr only; stdout reserved for MCP JSON-RPC)commander— CLI parsingvitest+@testcontainers/postgresql— unit / integration / smoke testschangesets— versioning + npm publish
Architecture — three horizontal layers
Middleware runs at the dispatcher, so any new tool inherits safety guarantees.
src/
server.ts # MCP stdio bootstrap, CLI, banner, shutdown
types.ts # ConnectionMode, ToolContext, ToolResult, Row
errors.ts # ToolError class + pgErrorToToolError
logging.ts # pino + redactUrl
config/
schema.ts # zod schema for the config file
loader.ts # discovery order + validation → { config, path }
connections/
manager.ts # ConnectionManager — pool per alias, owned getClient
session.ts # initSessionSQL (per-mode SET statements)
transactions.ts # TransactionManager — uuid handles, mutex, wall-clock cap
safety/
middleware.ts # assertModeAllowed (read < write < admin)
limit-cursor.ts # runWithCursorLimit (server-side cursor)
result-cap.ts # applyResultCap (byte cap, rowed + scalar paths)
tools/
registry.ts # ToolRegistry: schema validate → mode gate → dispatch → cap
index.ts # registerAllTools
meta/ # ping, list_connections
sql/ # query, begin_transaction, commit, rollback, execute
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.
- 2mo ago First seen · 119 lines · 1,616 tokens per session scan A 6e5d65fc2946
postgres-mcp-server CLAUDE.md is an instructions file published in the GitHub repository arieffian/postgres-mcp-server (0 stars, last pushed 3mo ago), licensed MIT. It adds 1,616 tokens to every session, about $0.0065 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.
postgres-mcp-server CLAUDE.md compared with instructions from other repositories
| Mod | Type | Stars | Last push | Licence | Scan | Tokens | Works with |
|---|---|---|---|---|---|---|---|
| postgres-mcp-server CLAUDE.mdarieffian/postgres-mcp-server | Instructions file | 0 | 3mo ago | MIT | A | 1,616 | Claude Code |
| vscode buildNext.instructions.mdmicrosoft/vscode | Instructions file | 196k | today | MIT | A | 9,719 | GitHub Copilot |
| next.js AGENTS.mdvercel/next.js | Instructions file | 144k | today | MIT | A | 8,130 | Codex, OpenCode |
| vscode oss-third-party-notices.instructions.mdmicrosoft/vscode | Instructions file | 196k | today | MIT | A | 5,685 | GitHub Copilot |
| langchain AGENTS.mdlangchain-ai/langchain | Instructions file | 150k | today | MIT | A | 4,680 | Codex, OpenCode |
| deepseek-harness AGENTS.mddeepseek-ai/deepseek-harness | Instructions file | 283k | today | MIT | A | 4,342 | Codex, OpenCode |
| vscode copilot-instructions.mdmicrosoft/vscode | Instructions file | 196k | today | MIT | A | 3,153 | GitHub Copilot |