Postgres has become the lingua franca of databases — powering startups, enterprises, and everything in between. Supabase took that power and made it feel native to the modern web stack, creating a new wave of "vibe coders" who build entire backends in TypeScript.
But while the rest of the stack evolved, testing tools stayed rooted in SQL.
The Problem
For years, pgTap has been the go-to framework for database testing — great for Postgres veterans, but inaccessible to most web developers. It requires knowledge of plpgsql stored procedures and complex programming logic in the database.
TypeScript is how people build apps now. It's where collaboration, testing, and iteration actually happen. Yet until now, there hasn't been a Supabase-native way to write database tests that feel as natural as testing frontend code.
The Solution
That's why we built Supabase Test Suite, powered by supabase-test. Each test spins up its own isolated Postgres database — a sandbox you can thrash, reset, and experiment in freely.
You can test real RLS behavior, swap roles, seed data however you want, and watch results live with pnpm test:watch. It's fast, modular, and built for how developers actually code today.
Developer Experience
The feedback loop is everything. Most devs end up as quality assurance clicking buttons and navigating to test things out, when you can literally just hit save on the code — saving you carpal tunnel and giving you developer productivity and happiness.
- ⚡ Instant feedback with
pnpm test:watch - <1s response from code change → test result
- Automatic rollback after each test
- RLS pass/fail toggle visible live
Key Differentiators
We researched the wild and found only a few test solutions in the Supabase ecosystem. We were compelled to make something more low-level, geared towards RLS and postgres/typescript:
- Test-framework agnostic: Works with Jest, Mocha, Vitest — no lock-in
- Pure TypeScript + Node: Runs fully headless; no browsers or Supabase JS client required
- Multi-user RLS simulation: Switch roles and JWT claims directly in SQL within a single test
- Direct Postgres access: Low-level SQL control — test functions, triggers, constraints, and policies natively
- Instant isolation: Each test runs in a transaction or ephemeral DB with automatic rollback
- Lightning fast: No HTTP or browser overhead — executes in milliseconds
- CI-ready: Lightweight, deterministic, perfect for GitHub Actions or local pipelines
The Vision
Supabase + Postgres = standard for modern backend. Supabase Test bridges the gap between database dev and web dev, bringing vibe coding and Postgres testing together.
Testing is the key missing piece for safe RLS adoption. With Supabase Test Suite, you can build secure backends with confidence, knowing your Row-Level Security policies work exactly as intended.
The future of database testing is here — and it speaks TypeScript.
In the next lessons, you'll learn how to set up your own testing workspace and build modular test suites for your Supabase projects. Each test runs in its own isolated database — a complete Postgres sandbox you can seed, modify, and destroy without affecting anything else. You'll compose these tools however you need: organize by feature, by table, or by user role. The testing environment is yours to build, and every test gives you real database behavior with instant feedback. Let's get started. 🚀