> ## Documentation Index
> Fetch the complete documentation index at: https://bilt.me/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Database

> Browse, edit, and query the data your app stores

Every Bilt Cloud backend includes a PostgreSQL database. Bilt creates and manages the tables as your app needs them — you browse and edit everything from the **Data** tab under **Settings → Database**.

## Browse your tables

Each table shows its column count and two badges:

* **Links to N tables** — this table references others (for example, a `posts` table linked to `profiles`)
* **User-protected** (green) — rows are private to the user who created them. **Public** (amber) means the table is readable by anyone using the app.

Expand a table to see its columns, with plain-language types (Text, Number, Date & time, File), plus **Key** for identifiers and **Linked** for columns that point at another table.

## View and edit data

Click **View Data** on any table:

* Rows load 100 per page, with search, sorting, and a column show/hide control
* **Edit a cell** inline, or click **Add row** to insert one — ID columns stay read-only
* **Delete a row** permanently (Bilt asks you to confirm; it can't be undone)
* Each row has an **Ask Bilt** shortcut to hand it to the chat agent

## Run SQL directly

For developers: the **Advanced** tab has a SQL editor that runs queries against your database. Reads work immediately; to change or delete data, tick **"This can change or delete data"** first. Queries have a 30-second limit.

## Ask for it in chat

You never have to design tables yourself:

```text theme={null}
Create a "posts" table with title, content, and author fields.
Show all posts on the home screen.
```

<Tip>
  Data doesn't sync in real time between users. If one user should see another's changes, ask Bilt to refresh the data periodically or when the screen opens.
</Tip>

<Card title="Questions? We're happy to help" icon="circle-question" href="mailto:support@bilt.me">
  Email [support@bilt.me](mailto:support@bilt.me), or ask in the [Discord community](https://discord.gg/9Y8vpDAhbD).
</Card>