Supabase Schema Health Check

For an indie dev onboarding to a new Supabase project (or validating an existing one) who wants a one-prompt health check. Verifies connectivity, inspects tables/columns/constraints, flags drift against an expected schema, optionally applies a migration.

Supabase logoSupabase
THE GRIND

Silent schema drift

Here's what doing this by hand looks like today — and why it doesn't scale.

Schema drift accumulates silently until prod breaks

Nobody runs connectivity or index checks until there's an outage

Dashboard spelunking for a health report wastes a morning

Composio collapses all of this into one prompt — here's what that looks like.

THE FLOW
8 steps · 1 toolkit

Your agent runs it end-to-end.

  1. 01
    Ping the project — confirm status = ACTIVE_HEALTHY
    supabase logo
  2. 02
    List tables in public schema
    supabase logo
  3. 03
    For each table, list columns with types, nullability, defaults
    supabase logo
  4. 04
    Check constraints (PKs, FKs, unique)
    supabase logo
  5. 05
    Check RLS status
    supabase logo
  6. 06
    If an expected schema is providedCompute drift: missing tables, missing columns, type mismatches, missing RLS.
  7. 07
    Compose a health report
  8. 08
    If apply_migration is true and drift is detected, author a DDL migration
    supabase logo
THE PAYOFF

Know your DB is healthy

A single prompt returns a health scorecard — connectivity, schema drift, missing indexes — before your users notice.

Paste this into Claude, Cursor, or Codex. It'll install the CLI, connect your apps, and run the task — end to end.