DB Explorer

Inspect schemas, review queries, and query app databases safely.

DB Explorer lets you inspect an app's database — see its schema as a diagram, review the queries that ran, and run your own. Open it from the app workspace's More menu → DB Explorer.

Choose the database and schema

DB Explorer can inspect either of the app's databases: pick Preview DB or Publish DB depending on whether you want the build you're previewing or the one that's live, and choose the schema. The tables in the chosen schema are listed for you to open.

Preview and Publish are separate databases. Confirm which one you've selected before you read a value or run a query — they can hold different data.

Visualizer

The Visualizer draws the schema as a set of linked tables. Each column shows its name and type, marked for primary key, nullable, and foreign key, with relationship lines between tables — for example a one-to-many link from a User table to a UserIdentity table. It's the fastest way to understand the app's data model at a glance.

The Visualizer, viewing the Preview DB schema.

Console

The Console shows the queries Qore has run against the database, each with its SQL, its parameters, and whether it succeeded — useful for seeing what the app is actually doing to its data.

The Console, showing queries run against the database.

SQL

The SQL editor lets you run your own queries against the selected database.

The SQL editor runs real queries against the app's database. Be careful running anything that changes data, and confirm you're pointed at the intended database — Preview DB or Publish DB — first.

Why this matters

• DB Explorer shows what an app stores and what it's doing to its data, without leaving the workspace.

• Which database you're on — Preview or Publish — governs everything here; the same schema can differ between them.

Related

App ConfigData Flow