supabase-drift-guard: a CI check for grant drift between your migrations and your live project #51151
SyrineSarray
started this conversation in
Show and tell
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
Built an open-source CI check that fails when live Supabase privileges drift from what your migrations define. For example, if a dashboard change accidentally gives anon access to a table. In my tests, supabase db diff didn’t catch that case.
Scope: Postgres grants only, including table, schema, and default privileges for
anon / authenticatedroles. It does not cover RLS, column-level grants, or functionEXECUTE.I’d love a few people to try:
npx supabase-drift-guard check .on a real project and tell me whether the output looks right, noisy, or broken.
All reactions