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.
Borrowing it
Nothing to install: this file belongs to timescale/pg-aiguide. 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/timescale/pg-aiguide/main/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/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/timescale/pg-aiguide/claude-md"><img src="https://agentmods.dev/badge/instructions/timescale/pg-aiguide/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.00560 | $0.00560 |
| Opus 5.5 | $0.00224 | $0.00224 |
| Sonnet 5.5 | $0.00112 | $0.00112 |
| Haiku 4.5 | $0.00056 | $0.00056 |
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 1mo 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 — 45 lines — stays where its author put it; the contents beside it link to each section on GitHub.
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
Releasing
- Release with
./bun release <version | major | minor | patch>from a cleanmain; don't create tags or releases in the GitHub UI. See DEVELOPMENT.md. - The script bumps the version in
package.json,.claude-plugin/marketplace.json, and.cursor-plugin/plugin.json, commitsrelease: vX.Y.Z, tags, and pushes. The tag push triggers.github/workflows/publish.yml. - The push to
mainrequires bypassing the pull-request rule. Without that access the tag pushes but the commit is rejected, leavingmainbehind the released version.
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.
- 1mo ago Changed · +12 lines · +141 tokens per session a50530e456d5
- 1mo ago Changed · +10 lines · +157 tokens per session f971da0ef30d
- 1mo 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,873 stars, last pushed yesterday), licensed Apache-2.0. It adds 560 tokens to every session, about $0.0022 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.
Other instructions, from other repositories
vscode buildNext.instructions.md
Working notes and architecture documentation for the new esbuild-based build system in build/next. Use when making changes to the new build pipeline (transpile/bundle commands, NLS plugin, source-map handling, resource copying, or self-hosting watch tasks).
next.js AGENTS.md
AGENTS.md instructions for vercel/next.js, covering next.js development guide, codebase structure, monorepo overview, core package: packages/next and other important packages.
vscode oss-third-party-notices.instructions.md
Instructions for microsoft/vscode, covering vs code oss third-party-notices pipeline, architecture, pipeline flow in ci, cache eligibility and rollout and applying the notice (cutover).
langchain AGENTS.md
AGENTS.md instructions for langchain-ai/langchain, covering global development guidelines for the langchain monorepo, corridor security analysis, project architecture and context, monorepo structure and development tools & commands.
vscode copilot-instructions.md
Copilot instructions for microsoft/vscode, covering vs code copilot instructions, project overview, root folders, core architecture (src/ folder) and built-in extensions (extensions/ folder).
deno copilot-instructions.md
Copilot instructions for denoland/deno, covering deno development guide for github copilot, network access, high level overview, key directories and key files to understand first.