5 ms·
Show HN: Supabase-Test – Fast Isolated Postgres DBs for Testing Supabase RLS
Hi HN — we've built a testing framework for Supabase that spins up fast,
isolated Postgres databases for each test case. It’s designed to make RLS
policies easy to validate with real database state, without global test
fixtures or mock auth.
Features:
- Instant isolated Postgres DBs per test
- Automatic rollback after each test
- RLS-native testing with `.setContext()` for auth simulation
- Flexible seeding (SQL, CSV, JSON, JS)
- Works with Jest, Mocha, and any async test runner
- CI-friendly (runs cleanly in GitHub Actions)
We also published example projects and a free set of tutorials:
https://launchql.com/learn/supabase https://launchql.com/learn/supabase
Package:
https://www.npmjs.com/package/supabase-test https://www.npmjs.com/package/supabase-test
Source + full test suite:
https://github.com/launchql/supabase-test-suite https://github.com/launchql/supabase-test-suite
Happy to answer questions and get feedback, cheers :)
- dang 10mo ago[under-the-rug stub] [see https://news.ycombinator.com/item?id=45988611 https://news.ycombinator.com/item?id=45988611 for explanation]
- richardfeynman 10mo agoGreat tutorials.
- pyramation 10mo agothank you! Appreciate that. Always want to make the glide path and ensure folks can run the software replicably on their machines! happy to help if you run into any issues :)
- adebelov 10mo agoSuper cool!!! Congrats
- pyramation 10mo agothank you! much appreciated ;) hope it helps you guys ship secure supabase projects!
- michaelnemke 10mo agoLove this
- pyramation 10mo agoappreciate it! let us know if you and your team have any feedback, cheers!!!
- kevinle_clad 10mo agoLove this, great stuff
- pyramation 10mo agothank you! let us know if you need help setting it up!
- John23832 10mo agoThis reminds me of a supabase testcontainers idea I explored.