Create and manage tables

Define structured data for your app using tables with rows and columns.

Tables are where your data lives. Think of them like spreadsheets: each row is a record, each column is a field. You can use this data to populate your interface and control exactly who can access what data.

Table vs View

• Table — Here is where you store your data and configure its columns
• View — A saved configuration on top of a table. Views don't store data themselves, they simply show filtered/sorted sets of data from a table

Create a table

1. Go to Data & API > Tables
2. Click Add Table
3. Choose your data source
4. Enter a Name and optional Description
5. Keep the API endpoints toggle enabled to auto-generate CRUD (common data actions) API Endpoints
   • Most data sources: Create API endpoints to access or update table data
   • Supabase: Create API endpoints on your WeWeb server to access or update table data
6. Click Continue

If you choose Supabase as the data source for your first Supabase table, WeWeb first asks How do you want to use Supabase? so you can pick whether table data goes through the WeWeb server or directly from the browser. Learn more about Supabase table modes →

Choosing a data source

• Project tables — Creates a native table in WeWeb. You'll define columns and add data from scratch
• Any other data source (for example, Airtable, REST API, Supabase, etc.) — Connects your table to an external data source. This lets you use external data inside WeWeb without importing it

To learn more about our available data integrations, check out the dedicated integrations documentation →

HOW EXTERNAL DATA WORKS

When you choose a data source outside of WeWeb, WeWeb does not copy or import your data. Instead, WeWeb creates a connection to your integrated data source and retrieves the data on demand whenever your app needs it. No data is ever actually copied into WeWeb’s servers.

Rename a table

To rename a table, select it in Data & API > Tables, click Settings at the top of the table, update the Name, then click Save.

Like renaming a column, this opens Review rename impact so you can see what WeWeb updates for you and what you need to update yourself.

Authentication tables cannot be renamed.

Managing columns

To create a column:

1. Click the + in the header to add a new column
2. Enter a Name for your column (when possible, use words separated by _, like first_name, for better compatibility when you use the column in bindings, formulas, and API Endpoints)
3. Choose a Column Type (see Columns and relationships for a full list of column types →)
4. Set a Default Value — This will be the value used in the column for newly created records if this column is not given a value at creation
5. Define if the Value must be unique — This will not allow multiple records in the table to have the same value for this column
6. Define if the Value is required — This will not allow new records to be created if no value is given for this column

DON'T SEE THE + BUTTON?

If you do not see the + button, you are likely in a view of the table. Regular columns (Text, Number, Date, and so on) can only be added on the root table Data tab.

To return to the root table, select the table name in the sidebar (above its views list).

FORMULA COLUMNS

Formula columns are the exception to the rule above: you can add one from the root table Data tab or from any view of the table. Click the + at the end of the column headers and choose Formula as the column type. The column belongs to the table either way.

Learn more about formula columns →

Edit a column

You can change a column after you create it, even when the table already holds data.

1. Open the column menu in the table header and choose Edit Column
2. Update the Column Name, Column Type, Default Value, Constraints, or Description
3. Click Save changes

When the change is safe for the data you already stored, WeWeb applies it right away. When it could affect that data, WeWeb opens a review step first so you decide what happens to the existing values.

Some columns are protected. On primary key columns and built-in columns (id, createdAt, and updatedAt), you can only change the Description. Formula columns, relation columns, and subcolumns do not have an Edit Column option.

EDIT COLUMNS FROM THE EDITOR ENVIRONMENT

The Edit Column option is only available when the environment selector at the top is set to Editor. Your changes reach the other environments when you publish your project.

Review a change that affects existing data

Before touching your data, WeWeb analyzes the change and opens Review column change when it finds something to decide. This happens when you:

• Change the Column Type
• Turn on Value is required while some rows have no value
• Turn on Value must be unique while the column holds duplicates
• Link the column to another table while some values have no matching record

For each point, WeWeb explains what it found and asks How should existing values be handled?. The options depend on the column.

Options that discard data ask you to tick a confirmation box before you can continue. To see the exact SQL WeWeb will run, click Advanced: show SQL. Click Apply change to run it, or Cancel to leave the column as it is.

If no option can solve the problem, WeWeb shows Manual cleanup required. Fix the affected values directly in the table, then try the change again.

If the change cannot run, WeWeb shows a Migration failed message and your data stays exactly as it was.

Rename a column

Renaming a column opens Review rename impact instead, because other parts of your project point at the old name.

WeWeb updates its own references for you and tells you how many internal configurations it will update. Custom code, custom SQL, and anything outside WeWeb that calls your API endpoints keep using the old name until you update them yourself. When WeWeb spots a name that looks like it is used in custom code, it lists the location so you can check it after renaming.

Review the impact, then click Rename.

USE WEWEB AI

You can also ask WeWeb AI to add, rename, update, or delete columns in Build mode, for example: "Add a price column to my products table. It should store a number and be required."

WeWeb AI goes through the same review step, so it asks you to choose how existing values are handled before applying anything.

Learn more about WeWeb AI →

Work with records

You can add and/or edit records directly from the UI.

• Insert — Use the Insert menu or your generated endpoint

• Edit — Click a row to open the record panel and update fields

• Delete — Select one or more rows, then delete

• Bulk actions — Use the row checkboxes to act on many records

PROGRAMMATICALLY UPDATING DATA

To let users create, edit, or delete records from your app, use API Endpoints.

Learn how to create an API Endpoint →

CONTINUE LEARNING

Next, learn about defining the right column types and relationships.

Columns and relationships →