supabase query, database health, count rows, insert record, rls policy, sql query, supabase table, postgresql
Query, inspect, and manage Supabase databases. Run SQL, count rows, insert records, check health, and audit RLS policies.
Run a raw SQL query.
bash
bash scripts/script.sh query "SELECT COUNT(*) FROM skills WHERE is_ours=true"
Query a table with optional filters and limit.
bash
bash scripts/script.sh select <table> [--limit N] [--filter col=eq.val]
Count rows — all tables or a specific one.
bash
bash scripts/script.sh count
bash scripts/script.sh count skills
Insert a record into a table.
bash
bash scripts/script.sh insert <table> '<json>'
Check API health and response time with row counts.
bash
bash scripts/script.sh health
Audit RLS policy issues using Supabase Security Advisor.
bash
bash scripts/script.sh rls
Show all available commands.
bash
bash scripts/script.sh help
Powered by BytesAgain | bytesagain.com