Table Editor
The portal's day-to-day view into a table's data. Switch between the data view (rows, paginated) and the definition view (the table's generated CREATE TABLE DDL — columns, types, defaults, constraints). There's no inline cell editing or a "new table" button here — those go through SQL Editor or a migration — but moving data in bulk is native to this page:
- Export a table's rows to CSV.
- Import rows from a CSV file — unknown columns are ignored, and rows that would violate a duplicate key are skipped rather than failing the whole import.
| Surface | Availability |
|---|---|
| Portal UI | Browse rows/definition, export/import CSV — no row insert/edit UI |
| CLI | No dedicated command. Use the direct Postgres connection string (Project Settings → Database) with psql, or drive it through migrations. |
| SDK / HTTP | shovelbase.from('table').select() / GET /rest/v1/<table> |
terminal — direct connection
# From Project Settings → Database → Direct connectionpsql "postgresql://<db_user>:<password>@<host>:5432/<db_name>"That connection has full owner access with no RLS applied — prefer the REST API and keys for anything an app itself does; reserve psql for one-off inspection. See Database for backups of the same underlying Postgres instance.