> For the complete documentation index, see [llms.txt](https://docs.uptiq.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.uptiq.ai/ai-workbench-qore/console/app-builder/build/db-explorer.md).

# 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.

{% hint style="info" %}
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.
{% endhint %}

## 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.

<figure><img src="https://1326225582-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0qmgQjJ5aArDTj2ACFHG%2Fuploads%2Fgit-blob-aaa367a0686184ea89be6bb5effe7dcaa1d12732%2Fqore_app-builder_studio-import-an-existing-app-more-db-explorer-preview-db_rounded_shadow.png?alt=media" alt="The DB Explorer Visualizer, showing linked tables with column types and relationship lines"><figcaption><p>The Visualizer, viewing the Preview DB schema.</p></figcaption></figure>

## 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.

<figure><img src="https://1326225582-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0qmgQjJ5aArDTj2ACFHG%2Fuploads%2Fgit-blob-8a576872e2e4bcb79647de38f539c2d0a8437439%2Fqore_app-builder_studio-import-an-existing-app-more-db-explorer-preview-db-console_rounded_shadow.png?alt=media" alt="The DB Explorer Console, listing queries with their SQL, parameters, and result"><figcaption><p>The Console, showing queries run against the database.</p></figcaption></figure>

## SQL

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

{% hint style="warning" %}
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.
{% endhint %}

## 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

{% content-ref url="/pages/6de8c0921a81fc6dc038359c161a4825e5e9aa3e" %}
[App Config](/ai-workbench-qore/console/app-builder/build/app-config.md)
{% endcontent-ref %}

{% content-ref url="/pages/4844ee4b9bc46117ccc5a5bc36b61b43cb4a3936" %}
[Data Flow](/ai-workbench-qore/console/app-builder/build/data-flow.md)
{% endcontent-ref %}

***

{% columns %}
{% column width="83.33333333333334%" %}

<p align="right"><em>Maintained by</em> <mark style="color:green;">Abhishek Paul</mark><br><code>AI-assisted, human-approved</code></p>
{% endcolumn %}

{% column width="16.666666666666664%" %}

<div align="left"><img src="https://1326225582-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0qmgQjJ5aArDTj2ACFHG%2Fuploads%2Fgit-blob-d034645b4f8f8ee661985f5306b60ded3289653c%2Fmaintainer-abhishek-paul.png?alt=media" alt="" width="60"></div>
{% endcolumn %}
{% endcolumns %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.uptiq.ai/ai-workbench-qore/console/app-builder/build/db-explorer.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.