Until now, working with the data inside your managed PostgreSQL database meant reaching for a desktop client: download a tool, copy connection credentials out of the dashboard, paste them somewhere they probably should not live, and keep the whole thing updated. The database is managed — but the last mile to your rows was not.
That changes today. SQL Studio is now part of every managed PostgreSQL database on DanubeData: a complete, in-browser data studio that opens right from the instance page. Nothing to install, nothing to configure, and nothing extra on your invoice.
What you can do with it
Browse like a spreadsheet, filter like SQL
Open any table and you get a fast data grid with pagination, one-click column sorting, and per-column filters (=, !=, LIKE, ILIKE, ranges, IS NULL and friends). The sidebar lists every schema and table, with search.
Edit rows with staged, transactional commits
This is the part we are most proud of. Editing in SQL Studio works the way the best desktop clients taught us it should: changes stage locally first. Double-click a cell to edit it, add new rows inline, mark rows for deletion — everything is highlighted as pending while you work. When you are ready, one Commit applies the whole set in a single database transaction. If anything fails, nothing is written and your pending changes stay put so you can fix and retry. Changed your mind? Discard reverts it all.
The editor is precise where it matters: explicit Set NULL and Set DEFAULT controls (so an empty string never silently becomes a NULL, or the other way around), and full support for composite primary keys.
A SQL editor with a safety catch
The SQL tab runs ad-hoc queries in a read-only safe mode by default. Flip the write toggle when you actually mean to change things — and even then, destructive statements ask before they run. Save the queries you use all the time as snippets, re-open anything from your history with one click, and export results as CSV or JSON.
Schema tools included
- New table builder — define columns, types, nullability, defaults and the primary key visually.
- Right-click table operations — truncate, rename, duplicate (structure or structure + data), copy the CREATE statement, or drop. Dropping a table requires typing its name first.
- ER diagram — your schema drawn live: tables, columns, and foreign-key relationships, with pan and zoom.
- Objects browser — functions, triggers, views, roles, extensions and row-level-security policies, definitions included.
- CSV import — bulk-load rows into any table with a column-mapping wizard.
Built to be trusted with production
A database tool that lives next to your production data has to be paranoid by design. SQL Studio is:
- Read-only until you say otherwise. Every session starts in safe mode; writes require an explicit toggle.
- Atomic by default. Row edits apply as one transaction — all or nothing.
- Hard to fat-finger. Truncate asks for confirmation; drop makes you type the table name.
- Fully audited. Every write is recorded in your instance's query log: who ran what, when, and the exact SQL.
- Isolated per tenant. Queries are executed by an agent that runs inside your own tenant environment. Your database credentials never leave the platform — and never reach your browser.
Included free, available now
SQL Studio ships with every managed PostgreSQL plan at no extra cost — no add-on, no per-seat license. Open your PostgreSQL instance in the dashboard and click SQL Studio. (It is PostgreSQL-only for now; MySQL and MariaDB instances are not supported.)
👉 Read more on the SQL Studio page, dive into the documentation, or deploy a managed PostgreSQL database — Studio will already be there when you open it.
