ccfg-postgresql

Scaffold PostgreSQL migration directory or connection configuration for a new or existing project

Run PostgreSQL schema quality gate suite (naming, type/constraint, antipatterns, migration hygiene, extension hygiene)

Use this agent for PostgreSQL extension development and integration including PostGIS spatial queries, pgvector similarity search, pg_trgm fuzzy text matching, TimescaleDB time-series data, custom types, and extension lifecycle management. Invoke for configuring extensions, writing spatial queries, implementing vector search, building trigram indexes, designing hypertables, creating custom data types, or troubleshooting extension compatibility. Examples: setting up pgvector for AI embeddings, optimizing PostGIS spatial joins, configuring TimescaleDB continuous aggregates, building trigram-based search, or managing extension upgrades across environments.

Use this agent for PostgreSQL 15+ database administration including schema design, indexing strategies, partitioning, VACUUM tuning, pg_stat analysis, and security hardening. Invoke for designing normalized schemas, choosing data types, configuring autovacuum, managing roles and row-level security, optimizing table structures, or troubleshooting database performance. Examples: designing a multi-tenant schema with RLS, configuring identity columns, creating partial indexes, implementing table partitioning, or auditing pg_hba.conf security.

Use this agent for PostgreSQL query performance analysis and optimization including EXPLAIN ANALYZE interpretation, index selection strategy, query rewriting for efficiency, CTE optimization, and pg_stat_statements analysis. Invoke for diagnosing slow queries, choosing between index types (B-tree, GIN, GiST, BRIN), rewriting subqueries, interpreting execution plans, or profiling query execution. Examples: analyzing a slow report query, optimizing a JOIN-heavy dashboard, choosing partial vs expression indexes, or reducing sequential scans.

Use this agent for PostgreSQL replication architecture including streaming replication, logical replication, pgBouncer connection pooling, and high availability with Patroni. Invoke for setting up replication, troubleshooting replication lag, configuring connection pooling with pgBouncer, planning failover strategies with Patroni, or managing WAL and replication slots. Examples: designing a multi-region replica topology, configuring pgBouncer transaction pooling, diagnosing replication lag, or implementing Patroni-based automatic failover.

This skill should be used when writing database migrations, altering tables, adding columns, creating indexes, or planning schema changes for PostgreSQL.

This skill should be used when analyzing PostgreSQL query performance, running EXPLAIN ANALYZE, tuning indexes, configuring shared_buffers, or optimizing database performance.

This skill should be used when working on PostgreSQL databases, writing SQL schemas, creating tables, designing database architecture, or reviewing PostgreSQL code.