When you want the exact query, write it. The editor autocompletes from your schema, runs raw SQL against Postgres, MySQL, SQLite, or ClickHouse, and streams the results with a Load more instead of a hang.
SELECT plan, sum(amount) AS mrr
FROM subscriptions
WHERE status = 'active'
GROUP BY plan
ORDER BY mrr DESC;| plan | mrr |
|---|---|
| Enterprise | $31,300 |
| Pro | $12,400 |
| Business | $4,700 |
| customer | plan | status |
|---|---|---|
| Acme | Pro | active |
| Globex | Starter | canceled |
| Northwind | Pro | active |
| Initech | Enterprise | active |
| Umbrella | Business | active |
| Stark | Starter | canceled |
| Wayne | Enterprise | active |
Completions come from the connected datasource, in the right SQL dialect. ⌘⏎ runs the statement under the cursor, ⌘⇧⏎ runs the whole file.
SELECT subscriptions.pClick into a cell and change it. Editors match the column type, text, number, boolean, enum, date. Add rows, delete rows, then save the batch in one go. Primary keys and views stay read-only.
| customer | plan | seats |
|---|---|---|
| Acme | Pro | 24 |
| Globex | Business | 5 |
| Northwind | Pro | 14 |
A statement that modifies data gets a confirmation before it executes. Long queries stream in pages and cancel cleanly, and any result saves to CSV in one click.
UPDATE subscriptions
SET plan = 'Business'
WHERE customer_id = 102;