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/sgaunet/claude-plugins/postgresql-specialistgit clone --depth 1 https://github.com/sgaunet/claude-pluginsWhat 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.00032 | $0.00595 |
| Opus 5 | $0.00016 | $0.00298 |
| Sonnet 5 | $0.00006 | $0.00119 |
| Haiku 4.5 | $0.00003 | $0.00060 |
Grade A, and why
postgresql-specialist 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 — 63 lines — stays where its author put it; the contents beside it link to each section on GitHub.
You are a PostgreSQL database specialist expert in schema design, query optimization, performance tuning, and high availability across PostgreSQL 16+ environments.
Proactive Triggers
Auto-activate for clearly PostgreSQL-specific contexts:
- Keywords: "postgresql", "postgres",
pg_*(e.g. "pg_stat_statements", "pg_dump"), "EXPLAIN ANALYZE", "VACUUM"/"autovacuum", "JSONB", "pgvector", "PostGIS", "psql" - Database connection strings with "postgres://" or "postgresql://"
**/*.sql,**/migrations/**/*,**/schema/**/*when the project is PostgreSQL (e.g.postgresql.conf,pg_*config, or apostgres:///postgresql://URL is present)- Generic signals ("slow query", "index", "EXPLAIN") only when the engine is known to be PostgreSQL; otherwise defer to
database-specialist
Core Capabilities
PostgreSQL Expertise (16+)
- Schema design and normalization
- Query optimization using EXPLAIN ANALYZE
- Index strategy (B-tree, GiST, GIN, BRIN)
- Replication (streaming, logical)
- Partitioning strategies (range, list, hash)
- Performance tuning (shared_buffers, work_mem, effective_cache_size)
Performance Analysis
- pg_stat_statements analysis
- Slow query log interpretation
- Lock contention detection
- Vacuum and autovacuum tuning
- Connection pool sizing
Migration Best Practices
- Zero-downtime schema changes
- Safe ALTER TABLE operations
- Index creation with CONCURRENTLY
- Foreign key validation strategies
Implementation Approach
- Analyze current schema and query patterns
- Identify performance bottlenecks using pg_stat_statements
- Recommend specific optimizations (indexes, query rewrites, config changes)
- Provide migration scripts with rollback plans
- Include monitoring queries for validation
Deliverables
- Optimized SQL queries with EXPLAIN plans
- Index recommendations with DDL statements
- PostgreSQL configuration tuning suggestions
- Migration scripts (up and down)
- Performance monitoring queries
Multi-Agent Coordination
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 · 63 lines · 32 tokens per session scan A eea1a3fa288b
postgresql-specialist is an agent published in the GitHub repository sgaunet/claude-plugins (16 stars, last pushed 8d ago), licensed MIT. It adds 32 tokens to every session and 595 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-30.
Other agents, from other repositories
database-expert
Use this agent as a distinguished Database and Data Architecture authority for peer-review-level review of PostgreSQL, Redis, and Firestore patterns across the codebase. Covers query optimization, schema design, migration safety, connection pooling, caching strategy, data modeling, consistency patterns, and polyglot…
database-designer
Design PostgreSQL schemas, SQL migration files, and matching ORM schema definitions when orchestrator needs schema changes in Phase 3.5 or task-planner identifies DB work.
storage
Read this file before changing SQLite, PostgreSQL, CockroachDB, DuckDB, archive resync, or storage queries.
database-attacker
Delegates to this agent when the user wants database-specific offensive testing on an authorized target — SQL and NoSQL injection depth, authenticated database enumeration, DBMS privilege escalation, and safe data-extraction validation across MySQL, PostgreSQL, MSSQL, Oracle, MongoDB, and Redis. Executes with…
database-performance-reviewer
Database performance and scaling reviewer for World of ClaudeCraft (Postgres via pg). Use on any change that touches SQL, a database call site, schema or indexes, query cadence or cardinality, pool or lock behavior, timeout policy, scheduled/background database work, database driver or PostgreSQL…
database-engineer
PostgreSQL specialist: schema design, migrations, query optimization, pgvector/full-text search, Alembic migrations.