The Database tab

What it is

Code projects that keep information (sign-ups, orders, bookings, tasks) have a database of their own. The Database tab, at the top of the code editor, shows that real data: the same data the published site reads and writes.

Tables and fields are defined in the project's code, in the data/model.json file. To create a table, add a field or change permissions, ask the AI in the chat. The tab takes care of the data, not the structure. See Code mode.

What you find in the tab

View and edit records

1. 1

   Open the project and click Database

   On a phone, the list of tables becomes a menu at the top of the tab.

2. 2

   Pick a table under Tables

   Use Search… to filter the records.

3. 3

   Click New record or edit an existing one

   Required fields are marked, and links to other tables are picked from a list.

4. 4

   To remove one, use Delete

   The record goes to the Trash and can come back exactly as it was for 30 days.

Import and export spreadsheets

• Export CSV downloads the open table, following the search that is active.
• Import CSV accepts files up to 2 MB. The first row must hold the field names, as in the exported file. You can also paste the spreadsheet's contents.
• Before importing, click Check: Micronuage shows how many rows are ready and which ones have problems. Nothing is imported while there are errors.
• The expected format for dates, numbers, links and people is shown in the import window itself.

Read-only SQL queries

In SQL query you write a SELECT to answer questions such as how many orders came in this month. There are ready-made Examples and a list of the tables you can use. Click Run or press Ctrl+Enter.

• No query can change, create or delete data.
• Only this project's tables are visible. The app's users appear without passwords.
• Each query returns up to 500 rows and runs for up to 5 seconds. Use LIMIT, WHERE or aggregates for larger results.
• Copy as CSV takes the result into a spreadsheet.

Frequently asked questions