Preview and the live app share one database
What this means in practice:- Test data is live data. Sample records you or the AI add are visible to everyone who uses the published app. Remove them before you share the app.
- Schema changes don’t wait for Publish. If the AI renames or removes a column the live app still uses, the live app can break until you publish the matching code.
- There’s no staging database. You can’t test against a separate copy of your data.
Browse data in the Data tab
The Data tab is open by default in the app editor. Under App Database, switch between Data and Schema.Data view
The Data view is a read-only table browser:- Pick a table from the list on the left.
- Rows load 10 at a time. Use Previous and Next to page through them.
- Click a row to open a side panel with every field. Columns that hold JSON or other structured values appear only in this panel, not in the grid.
Schema view
The Schema view is a diagram of your database: each table with its columns and their data types, and lines showing how tables relate to each other. Use it to check the structure after the AI changes it.Apps without a database
Some older apps don’t have a database. Their Data tab shows “No database yet”. Click Add Database to create one.Other sub-tabs
The Integrations and External Database sub-tabs show your organization’s connected integrations and external databases. See Integrations and Databases.Change data and schema with the AI
The AI changes your database by running SQL directly. Each time it does, the chat shows Ran SQL query. Ask in plain language:Create a table for support tickets with a title, status, priority, assignee email and created date.
Add a “region” column to the customers table. Allowed values: North, South, East, West.
Show me all tickets created in the last 7 days.
Delete the test tickets whose title starts with “TEST”.Tips for good results:
- Say what the data means. Mention types when they matter: dates, amounts of money, a fixed list of values, or free text.
- Check the Schema view after the AI creates or changes tables.
- Seed sample data to test your UI, for example “Add 20 realistic sample tickets”, then remove it before people start using the app.
Use other databases from your app
An app isn’t limited to its own database. It can also use:
Set them up first. See Databases and Data queries. Then ask the AI to use them. You can type @ in the app chat to mention a database or data query by name.
Show open orders from our Postgres warehouse on the dashboard.
Store our team OKRs in a new organization database so our coworkers can read them too.To see the queries your app sends to external databases, add the External DB Queries tab from the + menu. It lists each query with its status, database, duration and any error.
Renaming a data query breaks apps that run it by its old name.
Backups and deleting data
- Checkpoints don’t touch your data. Restoring a checkpoint in the chat reverts code only, never the database. See Version history.
-
There’s no database restore in the editor. Before a risky change, ask the AI to make a copy first:
Before you change anything, copy the orders table to a new table called orders_backup.
- Archiving an app keeps its data. Deleting an app permanently deletes its database, and you can’t undo it. See Publishing.