Show HN: Supabase-Test – Fast Isolated Postgres DBs for Testing Supabase RLS

npmjs.com

27 points by pyramation 4 days ago

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

Package: https://www.npmjs.com/package/supabase-test

Source + full test suite: https://github.com/launchql/supabase-test-suite

Happy to answer questions and get feedback, cheers :)

dang 6 hours ago

[under-the-rug stub]

[see https://news.ycombinator.com/item?id=45988611 for explanation]

  • adebelov 4 days ago

    Super cool!!! Congrats

    • pyramation 4 days ago

      thank you! much appreciated ;) hope it helps you guys ship secure supabase projects!

  • kevinle_clad 4 days ago

    Love this, great stuff

    • pyramation 4 days ago

      thank you! let us know if you need help setting it up!

  • richardfeynman 4 days ago

    Great tutorials.

    • pyramation 4 days ago

      thank 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 :)

  • michaelnemke 4 days ago

    Love this

    • pyramation 4 days ago

      appreciate it! let us know if you and your team have any feedback, cheers!!!