postgres-test

What problem does it solve?

This Skill automates the end-to-end setup of PostgreSQL environments for immutable data model projects, enabling deterministic tests by booting a per-project container, loading project-specific DDL and sample data, and executing a query suite to validate results.

Core Features & Use Cases

• Isolated per-project PostgreSQL containers with automatic initialization of schema and data.
• DDL, data integrity, and query validation workflow with automated report generation.
• Use Case: Quickly validate a new data model by running a full DDL/test cycle and reviewing the generated Markdown report.
• Query suite execution: Executes all queries from artifacts/{project-name}/query_examples.sql and records results.

Quick Start

Run the postgres-test skill for a project named <project-name> to initialize a container, load the project’s schema and data, execute all queries, and generate a test report. Ensure artifacts/<project-name> contains schema.sql, sample_data_relative.sql, and query_examples.sql.