Your data, without a desktop client.
Browse schemas and tables, run SQL with completion from your live schema, and read execution plans — all inside your Balta dashboard, with read-only safety and a full audit trail.
- Included on every plan
- Read-only by default
- Every statement audited
SELECT c.name, date_trunc('month', i.issued_at) AS month, sum(i.total) AS revenue FROM invoices i JOIN customers c ON c.id = i.customer_id WHERE i.issued_at >= now() - interval '6 months' GROUP BY 1, 2 ORDER BY revenue DESC;
| name | month | revenue |
|---|---|---|
| Kestrel Studio | 2026-09-01 | 18,420.00 |
| Aurora Freight | 2026-09-01 | 12,905.50 |
| Vela Analytics | 2026-08-01 | 9,860.00 |
| Harbor & Pine | 2026-08-01 | 7,312.25 |
Example view with sample data.
Browse
Every table, one click away.
See every schema, table and view in your database, with their columns, types, indexes, constraints and foreign keys. Follow a foreign key straight to the rows it points at, and page through millions of rows with sorting and filters that stay fast on your largest tables.
| Column | Type | Nullable |
|---|---|---|
| id | bigint | not null |
| name | text | not null |
| citext | not null | |
| plan | text | |
| created_at | timestamptz | not null |
Example view with sample data.
Query
SQL that knows your schema.
Write queries with completion drawn from your actual tables and columns. Run a statement or a whole script and see the results for each one. When something fails, the error tells you exactly where — with PostgreSQL’s own message, hint and detail.
Keep your own query history, and save queries your whole team can reuse.
SELECT c.name, date_trunc('month', i.issued_at) AS month, sum(i.total) AS revenue FROM invoices i JOIN customers c ON c.id = i.customer_id WHERE i.issued_at >= now() - interval '6 months' GROUP BY 1, 2 ORDER BY revenue DESC;
| name | month | revenue |
|---|---|---|
| Kestrel Studio | 2026-09-01 | 18,420.00 |
| Aurora Freight | 2026-09-01 | 12,905.50 |
| Vela Analytics | 2026-08-01 | 9,860.00 |
| Harbor & Pine | 2026-08-01 | 7,312.25 |
Example view with sample data.
Performance
Read the plan, not a wall of text.
Run EXPLAIN or EXPLAIN ANALYZE and see the plan as a tree — every step with its cost, its estimated and actual rows, and the time it took. Spot the sequential scan that should have been an index lookup, without copying text into another tool.
- Sortcost 2,310rows 4 / 438.0 ms
- Hash Joincost 2,290rows 4 / 437.6 ms
- Seq Scan on invoicescost 1,980rows 2,000 / 18,41231.2 ms
- Index Scan on customerscost 180rows 4 / 40.9 ms
Example view with sample data.
Powerful, with guardrails.
Writes are switched on deliberately, per session. Nobody drops a table by accident.
Every statement runs with a timeout, so one heavy query can’t slow your application.
Editor sessions use a separate budget and never take connections from your app.
Who ran what, when, and how long it took — in your audit log.
Team access
The right access for every role.
Viewers can browse and run read-only queries. Developers and admins can switch on writes for a session. Every query runs as your own database role — so the editor can never do more than your permissions allow — and every statement is recorded in your audit log.
Example view with sample data.