Docs/Manage/Database Browser

Database Browser

Updated May 3, 2026Manage

Inspect tables, run queries and watch data changes — without leaving XAIO.

Where to find it

Web App and Platform Builder projects have a Database tab in the workspace toolbar (next to Backend). It shows the schema of your project's PostgreSQL database — the same DB that gets created when you connect PostgreSQL via the Integrations menu.

What you can do

  • Browse tables — pick a table from the sidebar, see all columns with their types and constraints, page through rows
  • Search & filter rows by any column without writing SQL
  • Inspect schema — primary keys, foreign keys, indexes, defaults
  • Run ad-hoc queries — for read-only investigation; the editor has tab-complete on table and column names
  • Migrations — every schema change the agent applies appears here as a Flyway-style versioned migration; you can see the history

Dev vs Prod

The browser switches between your dev (workspace) database and your prod (published) database via a top-right toggle. Concurrent writes are isolated; running queries on prod doesn't touch dev and vice versa.

Safety

The browser has a read-only mode by default. Destructive statements (DROP, DELETE without WHERE, TRUNCATE) require explicit toggle to write-mode and a confirmation. Migrations are the canonical way to alter the schema — direct DDL is discouraged because it desyncs from the migration history.

Asking the agent about your data

The AI chat can also reach the database when you ask data questions ("how many orders last week?", "which user spent the most?"). The agent uses a read-only role with row limits and statement timeouts, so it can't accidentally wreck anything.