Write pgTAP tests to verify your PostgreSQL schema, RLS policies, and constraints.
BeforeMerge offers hundreds of code review rules, guides, and detection patterns to help your team ship better code.
pgTAP is a PostgreSQL extension that lets you write unit tests for your database schema, functions, and policies.
pgTAP is built into Supabase. Tests go in supabase/tests/*.sql.
# Run all tests
supabase test db
# Run with specific test
supabase test db --filter "schema_basics"BEGIN;
SELECT plan(5); -- Number of assertions
-- Table exists
SELECT has_table('public', 'users', 'users table exists');
-- Column checks
SELECT has_column('public', 'users', 'email', 'has email column');
SELECT col_not_null('public', 'users', 'email', 'email is NOT NULL');
SELECT col_is_pk('public', 'users', 'id', 'id is primary key');
-- RLS is enabled
SELECT row_level_security_is_enabled('public', 'users', 'RLS on users');
SELECT * FROM finish();
ROLLBACK; -- Clean up test stateSELECT has_table(schema, table, description);
SELECT has_column(schema, table, column, description);
SELECT col_type_is(schema, table, column, type, description);
SELECT col_not_null(schema, table, column, description);
SELECT col_has_default(schema, table, column, description);SELECT col_is_pk(schema, table, column, description);
SELECT col_is_fk(schema, table, column, description);
SELECT has_index(schema, table, index_name, description);
SELECT has_unique(schema, table, description);SELECT row_level_security_is_enabled(schema, table, description);
SELECT policies_are(schema, table, ARRAY['policy1', 'policy2'], description);
SELECT has_function(schema, function_name, description);SELECT results_eq(
'SELECT count(*) FROM users',
ARRAY[42::bigint],
'expected user count'
);