dashboard · insert
Insert via the dashboard.
Insert your first row from the dashboard. You will need a running instance, the engine bearer token shown on instance creation (or rotated from /app/keys), and a registered schema — see Schemas in dashboard if you have not registered one yet.
- 1. Open /app/query — the query playground.
- 2. Pick your instance from the Instance dropdown.
- 3. Paste the engine bearer (
ocd_…) into Bearer token. - 4. Click the SQL tab.
- 5. Paste the INSERT statement below into the editor.
- 6. Click Run →. The result panel shows row-affected count and the WAL LSN.
SQL samples
basic insert
INSERT INTO shop.customers (id, email)
VALUES ('c_1', 'a@b.com'); idempotent insert
-- Idempotent insert: skips rows whose primary key already exists.
INSERT INTO shop.customers (id, email)
VALUES ('c_1', 'a@b.com')
ON CONFLICT (id) DO NOTHING; Common errors
unknown table 'shop.customers'— register the schema first; see Schemas in dashboard.401 unauthorized— bearer wrong, expired, or pasted with a stray newline. Rotate from/app/keys.syntax error near …— SQL grammar mismatch. The SQL surface covers SELECT/INSERT/DELETE/JOIN/GROUP BY; UPDATE and multi-statement transactions are not in scope.duplicate primary key— use theON CONFLICT (id) DO NOTHINGform for at-least-once retries.instance not running— resume the instance from/app/instances.