skills.rest
tis-abe-akira
tis-abe-akiraCOMMUNITY
Explore all skills by this author →
GitHub

postgres-test

Provides automated cross-platform builds and publishes artifacts to GitHub Releases and/or Baidu B2C Cloud from tags or CI pipelines.

Updated Aug 27, 2026
Search Tags:#automation#testing#postgresql#docker#data-validation#immutable-model
One-click install
npx skills add https://github.com/tis-abe-akira/cc-data-modeler --skill postgres-test
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-test
Source: https://github.com/tis-abe-akira/cc-data-modeler/tree/main/.claude/skills/postgres-test
Command: npx skills add https://github.com/tis-abe-akira/cc-data-modeler --skill postgres-test

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires psycopg2, docker, and includes scripts (resource) and references (resource) components.

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.

Frequently Asked Questions about postgres-test

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate PostgreSQL database setup and testing for immutable data models?▼

Automate PostgreSQL database setup by booting a per-project Docker container, loading project-specific DDL and sample data, and executing a query suite to generate a comprehensive Markdown test report.

Do I need Docker and Python to run automated PostgreSQL database testing?▼

Yes, Docker and Python dependencies including psycopg2 and the docker package are required to boot isolated PostgreSQL containers, manage database connections, and execute automated SQL testing workflows.

What SQL files are required to initialize a PostgreSQL container for data validation?▼

PostgreSQL data validation requires schema.sql, sample_data_relative.sql, and query_examples.sql placed within the artifacts/<project-name> directory to initialize schema, load sample data, and execute validation queries.

How does DDL validation and query execution work for PostgreSQL immutable data?▼

DDL validation and query execution work by loading project-specific schema and sample data into an isolated PostgreSQL container, executing all queries from query_examples.sql, and recording results in an automated test report.

What is the best way to validate a new PostgreSQL data model without affecting my main database?▼

The best way to validate a new PostgreSQL data model is by using isolated per-project Docker containers that automatically initialize schema and data, executing a full DDL and query validation cycle without impacting your main database.

Why is my automated PostgreSQL test not generating a validation report?▼

Automated PostgreSQL test report generation fails when the required artifacts directory is missing schema.sql, sample_data_relative.sql, or query_examples.sql files, or when Docker and psycopg2 dependencies are not properly configured.

Related Skills

Explore More Software Engineering Skills→
galactivalegalactivale

database-schema-guide

Document VaultCPA's PostgreSQL schema with Prisma models and query patterns.

Community
Advanced
jeffabaileyjeffabailey
3

review-data

Analyze database schema design, migration safety, and query correctness with evidence.

Community
Advanced
kevintsengtwkevintsengtw
28

dotnet-testing-advanced-testcontainers-database

Provision and tear down containerized SQL Server and PostgreSQL instances for .NET integration tests.

Community
Advanced
george11642george11642
2

db-supabase

Execute SQL, apply migrations, and deploy edge functions via Supabase MCP tools.

Community
Intermediate