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. 1. Open /app/query - the query playground.
2. 2. Pick your instance from the Instance dropdown.
3. 3. Paste the engine bearer (oc_live_…) into Bearer token.
4. 4. Click the SQL tab.
5. 5. Paste the INSERT statement below into the editor.
6. 6. Click Run →. The result panel shows row-affected count and the WAL LSN.

SQL samples

INSERT INTO shop.customers (id, email)
VALUES ('c_1', 'a@b.com');

-- Note: writes via /sql currently translate to a typed payload but
-- do not execute. For real production writes, use the row endpoints
-- directly - see /docs/insert for cURL + Python + TS + Go examples.
--
-- The /sql route is useful for SELECTs from the dashboard;
-- mutations should go through /rows.

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, WHERE (AND only), GROUP BY + aggregates, INNER / LEFT / RIGHT / FULL OUTER JOIN, and LIMIT. ORDER BY, HAVING, OR in WHERE, CTEs, and window functions are not supported yet.
• duplicate primary key - writes via the row endpoints are overwrite-by-default; add ?expect=insert to fail on duplicates instead.
• instance not running - resume the instance from /app/instances.