Ross ROSS = Recommend OSS · open-source software intelligence for agents

theory/pgtap

Some data may be outdated — see provenance labels.

PostgreSQL Unit Testing Suite observed · 2026-10-01

github.com/theory/pgtap · homepage · PLpgSQL observed · 2026-10-01

Health v2 · maintenance only

67/100

  • Activity 96
  • Release rhythm 11
  • Longevity 100

Flags: no_license

How is this computed?

round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-10-22. Adoption (stars, forks) is never an input.

  • gap_med: n/a
  • age_days: 6415
  • days_rel: 382
  • days_push: 24
  • n_releases_24m: 1

Full methodology

Adoption not part of the score

1166 stars · 108 forks observed · 2026-10-01

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

3 sources

Member repositories

RepositoryRoleHealth v2
theory/pgtapmain67

For agents

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

Data as of 2026-10-19T08:05:51.212177+00:00 · Report a problem