Skip to content
Appmake
Product · Database

Tables and data, set up for you.

Kalle designs your database from what you describe: the tables, the fields and how they connect. Browse and edit it like a spreadsheet, and change the structure by asking.

customers
nametext
emailtext
marketingyes/no
orders
numberint
statuspaid · shipped
totalkr
customer→ customers
products
nametext
pricekr
stockint
Database ready · 3 tables
From a sentence

Describe your business, get a database

Kalle works out the tables, the fields and how they connect from what you tell it. Pick an example.

A shop for handmade ceramics with gift wrapping
products
nametext
pricekr
stockint
imagefile
orders
numberint
statuspaid · shipped
totalkr
customer→ customers
customers
nametext
emailtext
marketingyes/no
order_items
order→ orders
product→ products
quantityint
Fields marked → link to another table.
Data view

Your data, like a spreadsheet

Browse, filter and edit every table without writing a query. Click a status to change it.

OrderCustomerItemsTotalStatus
#1042Ida Holm2kr 620
#1041Jonas Berg1kr 240
#1040Sara Lind3kr 1,140
#1039Omar Aziz1kr 380
#1038Mette Krog2kr 760
5 of 5 ordersExample data
Relationships

Connected the right way

Tables are linked the way your business works, and Kalle explains each link in plain words.

customers1,284 rows
1 → many
orders3,912 rows
many ↔ many
products64 rows
One customer can have many orders. Each order belongs to one customer.One order can hold many products, and one product can be in many orders.Delete a customer, and Kalle asks what should happen to their orders first.
Change by asking

Change the structure without breaking anything

Ask for a new field or table. Kalle writes a migration, keeps every existing row and updates the pages that use it.

Let customers add a gift message to their order
Added a gift message field to orders and to the checkout. Your 3,912 existing orders are unchanged.
orders
numberint
statuspaid · shipped
totalkr
customer→ customers
migrations/0007_gift_message.sql
alter table orders
add column gift_message text;
Import

Bring the data you already have

Drop in a spreadsheet or connect your Shopify store. Kalle matches the columns and converts the values for you.

customers.xlsx · 1,284 rowscustomers
Full namenameMatched
E-mailemailMatched
Phone no.phoneMatched
Newsletter (Y/N)marketingY/N to yes/no
Customer sincecreated_atRead as dates
CSV, Excel or Shopify
Access rules

Who can see what, decided per table

Rules are set on the database itself, so they hold on every page and in every request.

TableVisitorsCustomersStaffOwner
productsReadReadEditEdit
orders—Own onlyEditEdit
customers—Own onlyReadEdit
revenue———Read
Customers only ever see their own orders.Revenue is visible to the owner only.Change a rule by asking, like any other change.
Backups

Go back to any hour of the last week

Your database is backed up automatically. Pick a moment and restore it, or copy it to a new project to look first.

Wed 06:00

Restoring the database does not change your app's code. To roll back code, use Versions.

Under the hood

A real Postgres database, on Supabase

No proprietary format. Your data lives in standard Postgres, so it works with the tools developers already use.

Supabase
PostgreSQL
Standard and openEvery app gets its own Postgres database on Supabase, included on every plan.
postgres://app_marlowe:••••••••@db…Connect your own toolsUse the connection string with any Postgres client, BI tool or script.
Export SQLExport CSVTake it with youExport the whole database or a single table whenever you want.
Questions

Questions about the database

No. Describe what you need and Kalle sets up the tables. The SQL is there if you want to read it.

Yes. Only people you give access can see it, and Kalle never trains on your projects or data.

Yes. Changes made in the data view show up in your app straight away, and changes made in the app show up in the data view.

Export it as SQL or CSV at any time. It is standard Postgres, so it works anywhere.

Describe your data. Kalle builds the database.

Every Appmake app comes with its own Postgres database, on every plan.