DocsOpen Moon AI
Browse the docs

The data of an app

Give a published app its own database, choose who reads and writes each table, read and export its data, and keep enough free space.

On this page

An app can keep information: the requests of a form, the bookings of a salon, the menu of a restaurant. It lives in a database of its own, separate from Moon AI and from the other apps. You write no queries: Moon AI prepares the tables, and the app reads and writes through Moon AI.

Add a databaseLink to the Add a database section

Ask Moon AI for it while you build the app, saying what it must keep and who can see it:

Example request
Add a database: visitors send an appointment request (name, preferred date, message) and only I read them.

Moon AI creates the tables and their columns, picks the access rule of each one and describes them to you. Each row also gets an identifier and its creation and update dates. An app has at most 30 tables, of 50 columns each.

Who can read and writeLink to the Who can read and write section

Each table has an access rule. A table is never open to visitors without a rule. The publishing window and the “Data” screen show the rule of each table:

RuleWhat visitors doExample
“Only you”Nothing.Your management notes.
“Visitors can send, only you read”They add rows, without being able to read them back.A contact or request form.
“Visitors can read”They read everything; only admins write.A menu, a catalog, opening hours.
“Signed-in visitors”Once signed in, they read everything, add rows, and change or delete only their own.A guest book, a notice board.
“Each visitor sees their own”Once signed in, they only see and change their own rows.Bookings, a to-do list.

The last two rules need accounts for your visitors: see The accounts of the visitors. The admins of the app read and change every table, forms included. You read everything in the “Data” screen.

To fill a table visitors read (a menu, a catalog), the app needs an admin screen: ask Moon AI for one, then sign in to the app with an admin address.

The test database and the online databaseLink to the The test database and the online database section

  • The test database is used while you build: Moon AI prepares the tables there, and the preview of a version uses it. It holds 100 MB and is not backed up. Moon AI only works there: it never writes to the online database.
  • The online database is created when the app is published with tables, when its version goes online. Your visitors fill this one. A version under review creates nothing before it is accepted.

Change the data of an app that is onlineLink to the Change the data of an app that is online section

When you publish a new version of an app that is online:

  • additions (a table, a column, a rule) apply on their own;
  • whatever deletes a table or a column, or makes a table that already exists readable by everyone, is listed in the window (“This version deletes or opens up data”): check “I understand, go ahead.” to publish. A copy of what is deleted is kept for 30 days;
  • the type of a column doesn’t change once the app is online (“A column cannot change type”): ask for a new column instead;
  • if the database can’t be updated, the publication fails and the app stays on its version.

Going back to an earlier version never deletes a table. If it opens a table to everyone, it asks for the same confirmation.

The “Data” screenLink to the The “Data” screen section

Open the Library › “Apps”, then “Manage” on the app: the “Data” screen is in the window.

ItemEffect
“Online”, “Test database”Picks the database shown.
“Database size”The space used and the maximum.
The tablesThe rule of each table and its 20 latest rows. What visitors wrote shows as text, never as a page.
“Export CSV”Downloads the whole table.
“Export the app”Downloads an archive: the files of the version in service, the description of the data, a CSV file per table and the list of visitor accounts.
“Delete” on a rowAfter “Delete this row?”, the row is deleted for good.

The screen doesn’t add or change rows: do it in the app, signed in with an admin address. In a CSV file, a cell that starts with =, +, - or @ gets an apostrophe in front of it: what a visitor wrote doesn’t run as a formula in a spreadsheet.

Free spaceLink to the Free space section

The size of an app’s database depends on the plan of the workspace: “Database size” shows the space used and the maximum. See the plans.

  • At 80% of the maximum, the screen says “This database is almost full.”
  • When the database goes 10% past its maximum, it becomes read only: “This database is full: it is read only. Delete rows to make room.” Your visitors can still read, but can no longer add or change anything. Nothing is ever deleted for you.
  • To get out of it, delete rows, then click “Free up space”. The database can be written again once it is under its maximum.

The size is measured about every 15 minutes: after a deletion, it may take a while to go down. “Free up space” measures it right away.

What an app refusesLink to the What an app refuses section

  • A number that looks like a bank card or an IBAN, in any table visitors fill in or read. The “Only you” table is not affected.
  • A value that doesn’t have the type of its column: a text where a number is expected is refused, never converted.

An app must never ask for a password or a card number: a version that asks for one is checked before it goes online (see The check).

BackupsLink to the Backups section

Online databases are backed up every night. In a serious incident, what was written since the last backup may be lost: export what matters to you regularly. The test database is not backed up.

The data of your visitorsLink to the The data of your visitors section

The data of your visitors is kept by Moon AI on your behalf. You are the one asking for it: only ask for what the app needs.

  • A signed-in visitor can download their data and delete their account, with the rows they added while signed in: see The rights of your visitors.
  • Rows sent without an account, through a form for example, are linked to nobody. If a visitor asks you to erase them, delete them yourself in the “Data” screen.
  • The database of an app is deleted with the app (at the end of the bin), with your account or with the workspace.
  • “Export my data” (see Export all your data) includes your apps and their data, up to a size limit. “Export the app” contains everything.

Moon AI

Moon AI in action

0:00

Explore

Screenshots of chat.realmoon.ai taken on October 29, 2026, with fictional data.

Moon AI

Your preferences

Visits counted without cookies.

Our server counts visits without cookies or trackers. Your theme and your answer about ad measurement are remembered on this device.

Ad measurement

With your consent, our ad networks’ trackers (Google) measure our ads, from the visit to the sign-up and then to the first subscription and its amount, and may show you our ads. Your answer is valid for 13 months; you can change it here at any time.

No answer saved on this device.

After you decline, no tag is loaded anymore and the site deletes the cookies they had set on realmoon.ai. Those on the ad networks’ own domains are managed with them or in your browser.

The Moon AI app has its own privacy settings.