agentmods.dev

mcp-postgres: Instructions file for Codex

AGENTS.md

mcp-postgres AGENTS.md is an instructions file for Codex, OpenCode from gldc/mcp-postgres. It costs 628 tokens per session, scanned A, original, MIT.

Repository instructions for a PostgreSQL server that lets AI agents query databases and inspect their structure. PostgreSQL is a widely used database system, and the Model Context Protocol is a standard way for AI assistants to use tools.

In plain words
What is it for?
Use them when developing, testing, formatting, or reviewing the gldc/mcp-postgres repository.
Why use it?
They give coding agents the project’s setup commands, layout, style rules, and testing expectations before they change the code.

Instructions file for CodexOpenCode

Written for Codex and OpenCode: the file is AGENTS.md.

This is gldc/mcp-postgres's own configuration. It tells Codex and OpenCode how to work on mcp-postgres itself, so it is not a mod to install elsewhere. Copy it as a starting point and replace the rules that are about this project. Everything mcp-postgres configures →

not rated 15repo 8mo ago A scan 628 tokens original MIT
View source ↗ gldc/mcp-postgres
Reuse

Borrowing it

Nothing to install: this file belongs to gldc/mcp-postgres. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.

Copy the file
curl -O https://raw.githubusercontent.com/gldc/mcp-postgres/main/AGENTS.md
Clone the repo
git clone --depth 1 https://github.com/gldc/mcp-postgres

Made for: Codex, OpenCode.

Wrote 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.

agentmods badge for mcp-postgres AGENTS.md

README.md
[![agentmods](https://agentmods.dev/badge/instructions/gldc/mcp-postgres/agents-md/github.svg)](https://agentmods.dev/instructions/gldc/mcp-postgres/agents-md)
Your own site
<a href="https://agentmods.dev/instructions/gldc/mcp-postgres/agents-md"><img src="https://agentmods.dev/badge/instructions/gldc/mcp-postgres/agents-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.

agentmods 80×15 button for mcp-postgres AGENTS.md

Your own site · 80×15
<a href="https://agentmods.dev/instructions/gldc/mcp-postgres/agents-md"><img src="https://agentmods.dev/badge/instructions/gldc/mcp-postgres/agents-md.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 628 This file is loaded in full into every session.
When invoked 628 The same file — it is already loaded in full.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

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.

ModelPer sessionOnce invoked
Fable 5.1 $0.00628 $0.00628
Opus 5.5 $0.00251 $0.00251
Sonnet 5.5 $0.00126 $0.00126
Haiku 4.5 $0.00063 $0.00063

Measured 2mo ago against content hash 9df4ffe63475, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

mcp-postgres AGENTS.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.

AGENTS.md · 44 lines

How it starts

The opening of the file, as written. The whole thing — 44 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Repository Guidelines

Concise guidance for contributing to the PostgreSQL MCP server in this repo.

Project Structure & Module Organization

  • Root: postgres_server.py (FastMCP server and tools), README.md, requirements.txt, smithery.yaml.
  • Tests: tests/test_tools.py (unit), tests/test_integration.py (requires DB).
  • Config: .env.example, permissions.yaml.example, railway.toml, smithery.yaml.

Build, Test, and Development Commands

  • Create env: python -m venv .venv && source .venv/bin/activate
  • Install runtime deps: pip install -r requirements.txt
  • Install test deps: pip install -r dev-requirements.txt
  • Run server (stdio): python postgres_server.py --conn "postgresql://user:pass@host:5432/db"
  • Run server (HTTP): python postgres_server.py --transport streamable-http --host 127.0.0.1 --port 8000
  • Run tests: pytest -q
  • Lint: ruff check .

Coding Style & Naming Conventions

  • Python 3.10+, PEP 8, 4-space indent; type hints and short docstrings.
  • Names: functions/vars snake_case; classes PascalCase; MCP tool names short snake_case.
  • Logging: use the module logger; avoid PII.

Testing Guidelines

  • Framework: pytest + pytest-asyncio with files in tests/ named test_*.py.
  • No-DSN behavior is required: without DATABASE_URL, tools must return friendly empty/notice results.
  • Integration tests are skipped unless DATABASE_URL is set.

Tools & Resources

  • Tools: query, list_schemas, list_tables, describe_table, get_foreign_keys, find_relationships, server_info, db_identity.
  • Resources: table://{schema}/{table} — reads up to 100 rows.
  • Prompts: write_safe_select, explain_plan_tips.

Commit & Pull Request Guidelines

  • Commits: conventional style (feat:, fix:, chore:, docs:), imperative and concise.
  • PRs: include purpose/scope, before/after behavior, example commands/queries, and config changes.
  • Do not commit secrets; .env and credentials are ignored by .gitignore.

Read the full file on GitHub · 44 lines

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. 2mo ago First seen · 44 lines · 628 tokens per session scan A 9df4ffe63475

Subscribe to this mod's changes

mcp-postgres AGENTS.md is an instructions file published in the GitHub repository gldc/mcp-postgres (15 stars, last pushed 8mo ago), licensed MIT. It adds 628 tokens to every session, about $0.0025 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-30.

DatabasesPostgreSQL
Related

mcp-postgres AGENTS.md compared with instructions from other repositories

mcp-postgres AGENTS.md next to 6 instructions from other repositories
ModTypeStarsLast pushLicenceScanTokensWorks with
mcp-postgres AGENTS.mdgldc/mcp-postgresInstructions file158mo agoMITA628Codex, OpenCode
vscode buildNext.instructions.mdmicrosoft/vscodeInstructions file195ktodayMITA9,719GitHub Copilot
next.js AGENTS.mdvercel/next.jsInstructions file143ktodayMITA7,461Codex, OpenCode
vscode oss-third-party-notices.instructions.mdmicrosoft/vscodeInstructions file195ktodayMITA5,516GitHub Copilot
langchain AGENTS.mdlangchain-ai/langchainInstructions file149ktodayMITA4,680Codex, OpenCode
vscode copilot-instructions.mdmicrosoft/vscodeInstructions file195ktodayMITA3,093GitHub Copilot
vscode ai-customization.instructions.mdmicrosoft/vscodeInstructions file195ktodayMITA1,907GitHub Copilot