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 rules/timescale/pg-aiguide/postgres-best-practicesgit clone --depth 1 https://github.com/timescale/pg-aiguideWhat 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.00000 | $0.00274 |
| Opus 5 | $0.00000 | $0.00137 |
| Sonnet 5 | $0.00000 | $0.00055 |
| Haiku 4.5 | $0.00000 | $0.00027 |
Grade A, and why
postgres-best-practices 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
PostgreSQL best practices
When writing or reviewing SQL, designing schemas, or working with PostgreSQL:
- Use the
search_docstool to look up PostgreSQL syntax, functions, and behavior for the version in use. - Use
search_docswith sourcetigerwhen working with TimescaleDB or Tiger Cloud features. - Before designing tables, invoke the
design-postgres-tablesskill for data type, constraint, and indexing guidance. - For time-series, IoT, or event data on TimescaleDB, invoke the
setup-timescaledb-hypertablesskill. - When adding vector search with pgvector, invoke the
pgvector-semantic-searchskill. - When combining keyword and semantic search, invoke the
postgres-hybrid-text-searchskill. - Prefer
search_type: "semantic"for natural-language questions andsearch_type: "keyword"for exact term lookups. - Always specify the correct PostgreSQL
versionparameter (14-18 or "latest") to get version-accurate results.
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 First seen · 22 lines · 0 tokens per session scan A 3e47969165e0
postgres-best-practices is a cursor rule published in the GitHub repository timescale/pg-aiguide (1,830 stars, last pushed today), licensed Apache-2.0. It costs nothing until one of its globs matches a file; then it loads 274 tokens. 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 cursor rules, from other repositories
elixir-general-engineering-rule
技术栈: Elixir, Phoenix, Docker, PostgreSQL, Tailwind CSS, LeftHook, Sobelow, Credo, Ecto, ExUnit, Plug, Phoenix LiveView, Phoenix LiveDashboard, Gettext, Jason, Swoosh, Finch, DNS Cluster, File System Watcher, Release Please, ExCoveralls.
30-database-postgres
PostgreSQL and persistence rules.
postgresql
PostgreSQL: advanced SQL, performance, extensions.
coding-style
Go coding standards for order-service.
testing
Testing standards and TDD enforcement for order-service.
angular-20
This rule provides comprehensive best practices and coding standards for Angular development, focusing on modern TypeScript, standalone components, signals, and performance optimizations.