PostgreSQL Engineering
Acknowledgement: Shared by Peter Bamuhigire, techguypeter.com, +256 784 464178.
Use this parent skill as the active PostgreSQL engineering entrypoint. Keep implementation guidance here short; load the relevant reference module only when the task needs that depth.
Use When
- Designing PostgreSQL-backed features, schemas, indexes, constraints, and access paths.
- Reviewing SQL correctness, transaction boundaries, isolation assumptions, or extension usage.
- Implementing functions, triggers, views, materialized views, or server-side routines.
- Consolidating PostgreSQL-specific engineering advice before pairing with
database-design-engineering or database-reliability.
Do Not Use When
- The task is unrelated to this parent skill or is better handled by a narrower active parent named in the workflow.
- The request only needs a trivial answer and no reference module needs to be loaded.
Required Inputs
- Gather the concrete system, repository, environment, constraints, and deliverable before loading references.
- Identify which absorbed reference file is needed; do not load every migrated reference by default.
Workflow
- Start with
database-design-engineering for logical model, integrity, tenancy, and migration shape.
- Load only the reference file matching the task:
references/postgresql-fundamentals.md for baseline PostgreSQL usage and core concepts.references/postgresql-patterns.md for schema and application patterns.references/postgresql-advanced-sql.md for advanced query design.references/postgresql-server-programming.md for functions, triggers, and server-side behaviour.
- Pair with
postgresql-operations for administration, performance incidents, tuning, backups, or production operations.
- Pair with
postgresql-ai-platform only when pgvector or AI platform concerns are central.
Quality Standards
- Preserve data integrity with constraints, types, and transaction design before relying on application checks.
- Make query plans reviewable: expected indexes, cardinality assumptions, and failure cases must be explicit.
- Treat migrations as reversible operational changes with lock, runtime, and rollback impact stated.
Anti-Patterns
- Treating absorbed reference files as active skills or separate routing entrypoints.
- Loading every migrated child reference instead of the one that matches the task.
- Producing generic advice without constraints, evidence, or next verification steps.
Outputs
- PostgreSQL schema, SQL, migration, or review notes with integrity and performance evidence.
- Reference files loaded and companion skills used.
References
- Load only the references/.md files named in the workflow when their depth is required.
Inputs
| Input |
Required |
Purpose |
| PostgreSQL version and schema |
yes |
Select valid features |
| Query plans and cardinalities |
yes |
Design indexes |
| Migration and availability constraints |
yes |
Plan safe change |
Capability contract
Review SQL and propose DDL by default. Execute migrations, extensions, routines, or data changes only with authorised scope and rollback.
Degraded mode
If EXPLAIN ANALYZE or statistics are unavailable, provide read-only hypotheses and validation SQL; do not claim measured improvement.
Decision rules
| Condition |
Action |
| Planner estimate is materially wrong |
Refresh or improve statistics |
| Index build may block writes |
Use a compatible concurrent path |
| Constraint encodes business truth |
Enforce it in the database |
Domain Anti-Patterns
- Running EXPLAIN ANALYZE on unsafe writes. Fix: use a rollback-safe test.
- Adding extensions without trust review. Fix: verify source and privileges.
- Indexing without workload evidence. Fix: compare read and write cost.
- Hiding null semantics in application code. Fix: define them in schema.
- Combining expand and contract in one release. Fix: stage compatibility.
1---2name: postgresql-engineering3description: Use when designing, implementing, or reviewing PostgreSQL application data models, SQL, indexes, constraints, extensions, server-side routines, and production query patterns. Load the absorbed PostgreSQL reference files for fundamentals, advanced SQL, schema patterns, and server programming.4---56# PostgreSQL Engineering7Acknowledgement: Shared by Peter Bamuhigire, techguypeter.com, +256 784 464178.89Use this parent skill as the active PostgreSQL engineering entrypoint. Keep implementation guidance here short; load the relevant reference module only when the task needs that depth.1011<!-- dual-compat-start -->12## Use When1314- Designing PostgreSQL-backed features, schemas, indexes, constraints, and access paths.15- Reviewing SQL correctness, transaction boundaries, isolation assumptions, or extension usage.16- Implementing functions, triggers, views, materialized views, or server-side routines.17- Consolidating PostgreSQL-specific engineering advice before pairing with `database-design-engineering` or `database-reliability`.1819## Do Not Use When2021- The task is unrelated to this parent skill or is better handled by a narrower active parent named in the workflow.22- The request only needs a trivial answer and no reference module needs to be loaded.2324## Required Inputs2526- Gather the concrete system, repository, environment, constraints, and deliverable before loading references.27- Identify which absorbed reference file is needed; do not load every migrated reference by default.28## Workflow29301. Start with `database-design-engineering` for logical model, integrity, tenancy, and migration shape.312. Load only the reference file matching the task:32 - `references/postgresql-fundamentals.md` for baseline PostgreSQL usage and core concepts.33 - `references/postgresql-patterns.md` for schema and application patterns.34 - `references/postgresql-advanced-sql.md` for advanced query design.35 - `references/postgresql-server-programming.md` for functions, triggers, and server-side behaviour.363. Pair with `postgresql-operations` for administration, performance incidents, tuning, backups, or production operations.374. Pair with `postgresql-ai-platform` only when pgvector or AI platform concerns are central.3839## Quality Standards4041- Preserve data integrity with constraints, types, and transaction design before relying on application checks.42- Make query plans reviewable: expected indexes, cardinality assumptions, and failure cases must be explicit.43- Treat migrations as reversible operational changes with lock, runtime, and rollback impact stated.4445## Anti-Patterns4647- Treating absorbed reference files as active skills or separate routing entrypoints.48- Loading every migrated child reference instead of the one that matches the task.49- Producing generic advice without constraints, evidence, or next verification steps.50## Outputs5152- PostgreSQL schema, SQL, migration, or review notes with integrity and performance evidence.53- Reference files loaded and companion skills used.5455## References5657- Load only the references/<old-skill>.md files named in the workflow when their depth is required.58<!-- dual-compat-end -->5960## Inputs61| Input | Required | Purpose |62|---|---|---|63| PostgreSQL version and schema | yes | Select valid features |64| Query plans and cardinalities | yes | Design indexes |65| Migration and availability constraints | yes | Plan safe change |6667## Capability contract68Review SQL and propose DDL by default. Execute migrations, extensions, routines, or data changes only with authorised scope and rollback.6970## Degraded mode71If EXPLAIN ANALYZE or statistics are unavailable, provide read-only hypotheses and validation SQL; do not claim measured improvement.7273## Decision rules74| Condition | Action |75|---|---|76| Planner estimate is materially wrong | Refresh or improve statistics |77| Index build may block writes | Use a compatible concurrent path |78| Constraint encodes business truth | Enforce it in the database |7980## Domain Anti-Patterns81- Running EXPLAIN ANALYZE on unsafe writes. Fix: use a rollback-safe test.82- Adding extensions without trust review. Fix: verify source and privileges.83- Indexing without workload evidence. Fix: compare read and write cost.84- Hiding null semantics in application code. Fix: define them in schema.85- Combining expand and contract in one release. Fix: stage compatibility.
peterbamuhigire