pgsql-parser-testing-fixtures

What problem does it solve?

This Skill eliminates the manual overhead of maintaining consistent, regression-safe test suites for the pgsql-parser monorepo's PostgreSQL parsing, deparsing, and AST transformation tools, ensuring SQL parsing fidelity across code changes without repetitive test writing.

Core Features & Use Cases

• Automated Fixture Pipeline: Generates executable Jest test suites automatically from raw SQL fixture files for the deparser, PL/pgSQL deparser, and transform packages.
• Round-Trip Fidelity Validation: Verifies that parsed ASTs can be deparsed back to identical SQL and re-parsed to match the original AST, catching parsing and code generation regressions.
• Use Case: When contributing a new SQL parsing feature to pgsql-parser, use this Skill to add a test fixture, regenerate the test suite, and confirm your changes do not break existing parsing behavior.

Quick Start

Use the pgsql-parser testing fixtures skill to add a new SQL test case to the kitchen-sink fixtures, regenerate the full test suite, and run all deparser tests to confirm no regressions are introduced.