theory/pgtap

Health v2 · maintenance only

Flags: no_license

Adoption not part of the score

1161 stars · 108 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

pgTAP is a unit testing framework for PostgreSQL written in PL/pgSQL and PL/SQL. It provides a comprehensive set of TAP-emitting assertion functions for testing schemas, functions, triggers, and query results, and integrates with TAP harnesses or xUnit-style testing.

Use cases

• unit test postgresql database functions
• verify database schema structure in tests
• test triggers and views in postgres
• run TAP-emitting database tests with a harness
• write xUnit-style tests inside postgres
• assert query results match expected sets

When to choose

• you develop PostgreSQL-backed applications and want to test the database itself
• you want TAP output compatible with existing test harnesses
• you need assertions for schema objects, functions, triggers, and result sets

When to avoid

• you use a database other than PostgreSQL
• you cannot install extensions on the database server host
• you only need application-level tests that happen to touch the database

Facets

library · maturity active

testing databases testing developer-tools windows cli postgresql tap unit-testing plpgsql database-testing xunit linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="theory/pgtap")