pg-aiguide is a knowledge and tooling project that gives AI coding assistants version-aware PostgreSQL documentation and curated database practices. Developers use it through agent skills, an MCP server, or a Claude Code plugin to help coding tools generate better PostgreSQL code. The catalogue entries are its skills, instructions, MCP integration, and rule.
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.
npx agentmods add instructions/timescale/pg-aiguide/claude-mdgit clone --depth 1 https://github.com/timescale/pg-aiguideWrote 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/timescale/pg-aiguide/claude-md)<a href="https://agentmods.dev/instructions/timescale/pg-aiguide/claude-md"><img src="https://agentmods.dev/badge/instructions/timescale/pg-aiguide/claude-md.svg" alt="Measured on agentmods" 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 | $0.00419 | $0.00419 |
| Opus 5 | $0.00210 | $0.00210 |
| Sonnet 5 | $0.00084 | $0.00084 |
| Haiku 4.5 | $0.00042 | $0.00042 |
Grade A, and why
pg-aiguide 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 2d 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.
What it actually says
Tiger Docs MCP Server - Development Guidelines
Build, Test & Run Commands
- Build:
./bun run build- Compiles TypeScript to JavaScript - Watch mode:
./bun run watch http- Watches for changes and rebuilds automatically - Run server:
./bun run start stdio- Starts the MCP server using stdio transport - Checks:
./check- All-in-one command to lint and test. Run before every commit. Covers TypeScript (biome, tsc, tests) and Python (ruff format+ruff checkiningest/). Python checks are skipped with a warning ifuvis missing.
Code Style Guidelines
- Use ES modules with
.jsextension in import paths - Strictly type all functions and variables with TypeScript
- Follow zod schema patterns for tool input validation
- Use
.nullable()instead of.optional()for optional MCP tool parameters (required for gpt-5 compatibility) - Prefer async/await over callbacks and Promise chains
- Place all imports at top of file, grouped by external then internal
- Use descriptive variable names that clearly indicate purpose
- Implement proper cleanup for timers and resources in server shutdown
- Follow camelCase for variables/functions, PascalCase for types/classes, UPPER_CASE for constants
- Handle errors with try/catch blocks and provide clear error messages
- Use consistent indentation (2 spaces) and trailing commas in multi-line objects
Python (ingest/)
- Formatted and linted by
ruff; config lives iningest/pyproject.toml - Never commit generated artifacts (
__pycache__/,*.pyc,.venv/,.ruff_cache/) - Add dev-only tooling to the
devdependency group, notdependencies - Commit the regenerated
uv.lockwhenever dependencies change; CI runsuv lock --check - Chain re-raised exceptions with
raise ... from eto preserve the original traceback
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.
- 2d ago Changed · +10 lines · +157 tokens per session f971da0ef30d
- 5d ago First seen · 23 lines · 262 tokens per session scan A a6435d5eb457
pg-aiguide CLAUDE.md is an instructions file published in the GitHub repository timescale/pg-aiguide (1,835 stars, last pushed today), licensed Apache-2.0. It adds 419 tokens to every session, about $0.0021 per session on Opus 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.
Other instructions, from other repositories
pdlc-skills CLAUDE.md
Claude Code instructions for kanfu-panda/pdlc-skills, covering claude.md, repository purpose, repository layout, sub-skill naming and common commands.
skills AGENTS.md
AGENTS.md instructions for tony/skills, covering agents.md — claude-plugins, project identity, official documentation references, git commit standards and project component naming.
blanewarrene CLAUDE.md
Claude Code instructions for enalbenerraw/blanewarrene, covering project: product in acquisitions os, where this lives in the repo, author conventions (apply to all plugin content), what is in each skill and week-0-readiness.
blanewarrene AGENTS.md
AGENTS.md instructions for enalbenerraw/blanewarrene, covering agent instructions, non-negotiables, naming, whatever agent you are and before you commit.
skills CLAUDE.md
Claude Code instructions for tony/skills, a project described as: Language-agnostic AI workflow plugins for Claude Code and Codex. Every workflow is a skill.
skills GEMINI.md
Gemini CLI instructions for tony/skills, a project described as: Language-agnostic AI workflow plugins for Claude Code and Codex. Every workflow is a skill.