Automate pg_regress SQL test execution and validation for the kham-pg extension.
npx skills add https://github.com/preedep/kham --skill pg-regress
Please help me install this Agent Skill. Skill: pg-regress Source: https://github.com/preedep/kham/tree/main/.claude/skills/pg-regress Command: npx skills add https://github.com/preedep/kham --skill pg-regress
Automates the execution and validation of pg_regress-based SQL tests for the kham-pg extension, ensuring SQL correctness and regression safety.
Run the regression suite to execute all kham-pg pg_regress tests.
High-intent search queries and answers about installing and using this skill.
Automate PostgreSQL regression testing by coordinating pg_regress test directories, Makefile targets, and Docker containers to execute SQL tests and validate deterministic exact-output comparisons for custom extensions.
Refresh expected output files by running automated pg_regress tests to capture actual SQL query results, then updating the expected output artifacts to match the current deterministic behavior for regression validation.
Debug failing integration tests by running the regression suite in a deterministic Docker container, which isolates the environment and provides clear expected versus actual output comparisons to pinpoint SQL regressions.
Yes, you can run pg_regress integration tests without manual setup by leveraging Docker-based containers that automatically coordinate the PostgreSQL environment and Makefile targets for deterministic execution.
SQL integration tests show mismatched outputs when environments lack determinism; running pg_regress inside Docker containers standardizes the PostgreSQL environment and Makefile targets to ensure exact-output comparisons.
Yes, pg-regress supports authoring new SQL test files for the kham-pg extension by automating the execution, validation, and expected output generation needed to verify SQL correctness and regression safety.
preedepBuild and test the kham-pg C extension against a local PostgreSQL instance.
JeffallanDevelop scalable Salesforce applications with Apex, LWC, SOQL, and Salesforce DX.
timequityAutomate containerized deployments using Docker and CI/CD pipelines.
Dev10x-GuruExecute read-only SQL queries against PostgreSQL databases with psql.
