Manage Tables

Manage data rows

Browse, insert, edit, and delete table rows in Fakebase Studio.

Editing table rows in Fakebase Studio

Open a table and stay on the Data tab. The grid shows live rows from Postgres so you can inspect and change data without a SQL client.

You can run the same row changes in the SQL editor. The examples below use the orders table from Manage Tables.

Edit a row

Click a cell to edit it. Changes save back to the database. Inline editing needs a primary key on the table.

UPDATE public.orders
SET total = 49.00
WHERE id = '11111111-1111-1111-1111-111111111111';

Choose Insert.
Pick Insert row to fill in values, or Generate & insert to seed sample rows.
Save.

Foreign-key columns can pick a referenced record instead of typing an id by hand.

INSERT INTO public.orders (email, total)
VALUES ('ada@example.com', 49.00);

Select one or more rows, then choose Delete. Confirm to remove them from the database.

DELETE FROM public.orders
WHERE id = '11111111-1111-1111-1111-111111111111';