SQL Editor

Runs arbitrary SQL against the project database, in the browser. This is the portal's answer to everything the Table Editor and Database catalog only let you view: creating tables, altering columns, writing RLS policies, one-off data fixes. Existing Postgres schema scripts run unchanged — there's nothing shovelbase-specific about the SQL itself.

Surface	Availability
Portal UI	Full ad hoc SQL editor with results grid
CLI	No ad hoc query command. The CLI's SQL story is migrations (`shovelbase migration create` + `shovelbase db push`) — versioned, applied in order, not one-off.
SDK / HTTP	No SQL passthrough in the SDK (by design — apps should go through PostgREST/RLS). Scriptable via the management API's `POST /api/projects/<ref>/sql`.

management API

curl -X POST "https://shovelbase.com/api/projects/my-app/sql" \
  -H "Authorization: Bearer $TOKEN" -H "Content-Type: application/json" \
  -d '{"query": "select count(*) from public.todos"}'

Use that endpoint the way you'd use the browser SQL Editor from a script — it runs as the same project owner role a migration does, so it can create tables, alter RLS policies, and everything else a superuser-ish role can do. See Management API for the token flow.