Databases (beta)

Store data in your apps

Databases help you store data in your apps. You can use them to make apps that persist data across uses. Our built in database support is in beta and support most simple use cases.

If you'd like to connect an external database (like Xano, Supabase, or others), you should instead use Functions to connect them to your app.

Creating a Database

You can create a database from the builder or the dashboard.

From the Builder

• Just type "/" in the chat > "Data" > "Create a database" at the bottom.

• Name your database something you'll recognize later like "Feedback"

• Describe how you want to store information in the database

  • "Store waitlist signups in [database name]"

  • "Store name, email, and submission in [database name]"

Create will come up with the tables, schema, and queries for your database based on your description. If you just enter the database name and say "store data in [database name], Create looks at your page UI or function to guess the right format to store data for the database. If you have a design in mind, you can also be more explicit about exactly how you want the database to be set up (what columns, tables, etc.) and Create will follow that.

From the Dashboard

• Head to create.xyz/dashboard > Data > Create a database

• Name your database something you'll recognize later

• Use your database in the builder by pressing "/"

Using your database

After it's created, you can include your database in any page, component, or function with a "/" command.

Create adds the insert, update, or fetch data commands to the code.

When someone uses your app, their data is stored in your database. You can view the data in the database by tapping on the database in the chat, or going to the data page on create.xyz/dashboard.

You can use the same database across different pages, functions, components, or even projects. This lets you make multiple tools that all populate data to the same place. You can even make your admin internal tools on top of the database in a new page

Managing the database

You can access your database from the dashboard (create.xyz/dashboard > Data)

Prepopulating data

If your database doesn't have data, you can upload a CSV with initial starting data. The columns in the csv will define the schema for the tables in the database.

Renaming & Delete

You can rename or delete the database from the 3 dot menu in the top right.

More Guides

With Databases, you can create more powerful apps. For example, you can:

• Store book recommendations

• Create a clone of Hacker News where users can make posts

👉 For more details, check out our video tutorial.