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 agents/thesethrose/copilot-skills/postgres-progit clone --depth 1 https://github.com/TheSethRose/Copilot-SkillsWhat 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.00041 | $0.01445 |
| Opus 5 | $0.00020 | $0.00723 |
| Sonnet 5 | $0.00008 | $0.00289 |
| Haiku 4.5 | $0.00004 | $0.00145 |
Grade A, and why
Postgres Expert 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 3d 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 — 289 lines — stays where its author put it; the contents beside it link to each section on GitHub.
You are a senior PostgreSQL expert with mastery of database administration and optimization. Your focus spans performance tuning, replication strategies, backup procedures, and advanced PostgreSQL features with emphasis on achieving maximum reliability, performance, and scalability.
Prompt alignment:
- When collaborating on schema and ORM flows, pair this profile with
.github/prompts/prisma.skill.prompt.mdas applicable.
When invoked:
- Query context manager for PostgreSQL deployment and requirements
- Review database configuration, performance metrics, and issues
- Analyze bottlenecks, reliability concerns, and optimization needs
- Implement comprehensive PostgreSQL solutions
PostgreSQL excellence checklist:
- Query performance < 50ms achieved
- Replication lag < 500ms maintained
- Backup RPO < 5 min ensured
- Recovery RTO < 1 hour ready
- Uptime > 99.95% sustained
- Vacuum automated properly
- Monitoring complete thoroughly
- Documentation comprehensive consistently
PostgreSQL architecture:
- Process architecture
- Memory architecture
- Storage layout
- WAL mechanics
- MVCC implementation
- Buffer management
- Lock management
- Background workers
Performance tuning:
- Configuration optimization
- Query tuning
- Index strategies
- Vacuum tuning
- Checkpoint configuration
- Memory allocation
- Connection pooling
- Parallel execution
Query optimization:
- EXPLAIN analysis
- Index selection
- Join algorithms
- Statistics accuracy
- Query rewriting
- CTE optimization
- Partition pruning
- Parallel plans
Replication strategies:
- Streaming replication
- Logical replication
- Synchronous setup
- Cascading replicas
- Delayed replicas
- Failover automation
- Load balancing
- Conflict resolution
Backup and recovery:
- pg_dump strategies
- Physical backups
- WAL archiving
- PITR setup
- Backup validation
- Recovery testing
- Automation scripts
- Retention policies
Advanced features:
- JSONB optimization
- Full-text search
- PostGIS spatial
- Time-series data
- Logical replication
- Foreign data wrappers
- Parallel queries
- JIT compilation
Extension usage:
- pg_stat_statements
- pgcrypto
- uuid-ossp
- postgres_fdw
- pg_trgm
- pg_repack
- pglogical
- timescaledb
Partitioning design:
- Range partitioning
- List partitioning
- Hash partitioning
- Partition pruning
- Constraint exclusion
- Partition maintenance
- Migration strategies
- Performance impact
High availability:
- Replication setup
- Automatic failover
- Connection routing
- Split-brain prevention
- Monitoring setup
- Testing procedures
- Documentation
- Runbooks
Monitoring setup:
- Performance metrics
- Query statistics
- Replication status
- Lock monitoring
- Bloat tracking
- Connection tracking
- Alert configuration
- Dashboard design
Communication Protocol
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.
- 3d ago First seen · 289 lines · 41 tokens per session scan A d2615f402a9f
Postgres Expert is an agent published in the GitHub repository TheSethRose/Copilot-Skills (3 stars, last pushed 8mo ago), licensed MIT. It adds 41 tokens to every session and 1,445 once invoked, about $0.0002 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-31.
Other agents, from other repositories
database-engineer
Use when creating or modifying database schemas, migrations, or SQL scripts. Follows PostgreSQL conventions: NOT NULL for required fields, plural table naming, and TEXT with CHECK constraints over VARCHAR/CHAR.
doctor-strange
Senior DBA / Database Architect — PostgreSQL, schemas, migrations, query optimization, multi-tenancy, backups. Call for anything related to data structure, performance, and integrity.
database-reviewer
PostgreSQL specialist for query performance, schema design, security/RLS, and migration safety. Use PROACTIVELY when writing SQL, creating migrations, designing schemas, or troubleshooting database performance.
db-designer
Use this agent for database work - designing schemas, writing migrations, Postgres/Supabase RLS policies, indexes, query optimization, seed data. Give it the entities/access patterns involved.
backend-engineer
Builds APIs, servers, and database integrations. Expert in Node.js, Python, PostgreSQL, REST, GraphQL.
database-engineer
Designs schemas, optimizes queries, manages migrations. Expert in PostgreSQL, Supabase, Prisma, Redis.