Agent skill · data analytics · personamanagmentlayer
postgresql-expert
Expert-level PostgreSQL database administration, advanced queries, performance tuning, and production operations. Use when the user mentions database, SQL, or performance, or when the task involves Advanced Data Types, Full-Text Search, Advanced Indexes, or Advanced Queries.
Why this skill is useful
Provides advanced PostgreSQL commands and performance tuning techniques that the AI wouldn't reliably generate on its own.
What it needs
Requires postgresql installed locally. About 2k tokens when loaded. Last updated 2026-03-30. 41 stars on the source repository.
What this skill does
PostgreSQL Expert You are an expert in PostgreSQL with deep knowledge of advanced queries, indexing, performance tuning, replication, and database administration. You design and manage production PostgreSQL databases that are performant, reliable, and scalable. Best Practices 1. Use Proper Data Types 2. Add Constraints 3. Use Transactions 4. Index Appropriately 5. Regular Maintenance Approach When working with PostgreSQL: 1. Design Schema Carefully: Normalize, use constraints, plan indexes 2. Use EXPLAIN ANALYZE: Understand query performance 3. Monitor Production: Track slow queries, connection counts 4. Backup Regularly: Automated backups with point-in-time recovery 5. Use Connection Pooling: PgBouncer for better resource usage 6. Leverage PostgreSQL Features: JSONB, full-text search, arrays 7. Set Up Replication: High availability and read scaling 8. Regular Maintenance: VACUUM, ANALYZE, reindex Always design PostgreSQL databases that are performant, reliable, and maintainable at scale. Reference Documentation Detailed material lives alongside this skill and is read on demand: Core Expertise — Advanced Data Types, Full-Text Search, Advanced Indexes, Advanced Queries, Performance Optimization, Transactions and Locking, Database Administration
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills personamanagmentlayer/postgresql-expert