Run Tests

Run Go test suites for diff, plan, and dump workflows.

994|57|Updated Jun 8, 2025
One-click install
npx skills add https://github.com/pgschema/pgschema --skill run-tests-pgschema
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Run Tests
Source: https://github.com/pgschema/pgschema/tree/main/.claude/skills/run_tests
Command: npx skills add https://github.com/pgschema/pgschema --skill run-tests-pgschema

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Running tests for pgschema can be tedious and error-prone without a repeatable process. This skill provides a structured way to execute the full test suite and validate diffs, plans, and dumps.

Core Features & Use Cases

  • Orchestrates Go-based diff, plan, and dump tests to ensure migrations are correct across fixtures and embedded PostgreSQL.
  • Helps catch regressions early during feature development, bug fixes, and CI validation.
  • Supports deterministic test runs and quick verification of updates to test fixtures.

Quick Start

Run the test suite locally to validate the diff, plan, and dump workflows for the latest changes.

Frequently Asked Questions about Run Tests

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

FAQPage Schema
How do I automate Go test suites for PostgreSQL migration workflows?

You can automate Go test suites for PostgreSQL migration workflows by orchestrating diff, plan, and dump tests across multiple fixtures. This validates migrations deterministically during feature development, bug fixes, and CI validation.

What is the best way to validate pgschema diffs and plans during feature development?

The best way to validate pgschema diffs and plans is by running structured test suites that execute Go-based workflows across embedded PostgreSQL versions. This catches regressions early and ensures migration correctness using testdata fixtures.

Do I need standard Go tooling to run pgschema tests locally?

Yes, you need standard Go tooling and test fixtures present in testdata to run pgschema tests locally. These prerequisites ensure deterministic test runs and quick verification of updates to dump workflows.

Can I use this approach for CI validation of database dump workflows?

Yes, you can use this approach for CI validation of database dump workflows. It orchestrates Go-based tests across multiple test fixtures and embedded PostgreSQL versions to provide deterministic results during continuous integration.

Why are my pgschema test runs returning inconsistent results across fixtures?

Inconsistent pgschema test runs often occur when test fixtures in testdata are missing or standard Go tooling is improperly configured. Running a structured test suite ensures deterministic results by validating diff, plan, and dump workflows uniformly.

When do I need to run tests for embedded PostgreSQL versions?

You need to run tests for embedded PostgreSQL versions when validating pgschema migrations across different environments. This ensures diff, plan, and dump workflows function correctly during bug fixes and feature development.