Databases

The Database Workspace

Learn about The Database Workspace in WaymakerOS.

BrowseQueryManage

Open any database from the Databases section and you land in its workspace — everything you need to browse, query, and manage the database, in one place, no separate tool to install.

Across the top you'll see the app name, the region and status, and a branch switcher (for preview branches). Below that are the tabs.

The tabs

TabWhat it's for
OverviewStatus, region, whether end-user sign-in is on, and when it was created. Your at-a-glance summary.
DataBrowse the actual rows in your tables. Pick a table on the left, see its contents on the right. Read-only.
TablesThe shape of your database: every table with its columns (name, type, whether it's required, which is the key), plus row counts and size.
SQL ConsoleRun read queries against your data — see Querying with the SQL Console below.
AuthTurn on sign-in for your app's own end-users. See Site Auth.
Data APITurn on a REST API over your tables. See The Data API.
MonitoringLive activity, table sizes, and daily usage & credits. See Monitoring below.
BackupTake and restore snapshots. See Backups & Restore.
SettingsDelete the database (permanent, type-to-confirm).

Querying with the SQL Console

The SQL Console is for reading your data. Write a query, press ⌘/Ctrl + Enter, and see the results in a table below.

  • Reads only. The console runs SELECT (and WITH) queries. Anything that changes data or structure is rejected here on purpose — those go through migrations, so schema changes stay deliberate.
  • Results are capped (200 rows by default, up to 500) so a stray query can't pull your whole database into the browser. Use LIMIT and WHERE to focus.
  • Your recent queries are remembered on this device, so you can re-run something you wrote earlier without retyping it.

Monitoring

The Monitoring tab answers "is my database healthy, and what is it costing me?"

  • Live activity — what the database is doing right now (refresh to update).
  • Table sizes — which tables are using the most space, shown as proportional bars.
  • Usage & credits — your daily consumption, so cost never surprises you.

Metrics are summarised by hour and day rather than by the second — enough to spot trends and runaway tables, not a per-request profiler.

Next Steps