Use the SQL editor

Open it

Databases > SQL Editor (SQL Query Console). Check the database picker at the top.

Create a table and query it

1. Choose Query Templates... and Create Table (UUID + JSONB), or type your own.
2. Choose Run (or Ctrl/Cmd + Enter).
3. Insert a row:

insert into items (data) values ('{"name":"first"}');
select * from items;

1. Open Table Editor to browse the rows.

Helpers

Format tidies SQL, History shows your last 50 runs filterable by All, Success and Errors, Cancel stops a long query.

Safety rails

• Dropping or truncating asks for confirmation with a Destructive Operation Warning.
• Statements over 30 seconds are stopped.
• Results show up to 500 rows; add LIMIT.
• Commands that reach the server or other tenants are refused.
• Viewer and Billing roles can only read.

Queries run as your database's application role, the same as your connection string.

Take a snapshot first

Before risky changes, open Backups and choose Create Instant Backup.

Try it

Run the Table Sizes & Storage template and read the output.

Recap

• The editor is real SQL on your real data.
• History, templates and confirmations help you avoid mistakes.