Execute SQL queries against the local Postgres database using psql.
Pipe the query via stdin:
echo "<SQL_QUERY>" | PGPASSWORD=c0d3ly7v psql -h localhost -p 5432 -U supabase_admin -d postgres -tA
Tips
- If you need to discover schemas or tables, query
information_schema.tablesdirectly instead of reading migration files. - Go straight to the query. No need to inspect Docker or init scripts beforehand.