SQL client for macOS
Write, debug, and improve SQL faster. Connect to MySQL, PostgreSQL, local SQLite files, or Cloudflare D1, explore results, manage data workflows, and use AI assistance to explain errors, suggest fixes, and get from idea to query faster.
Product
MySQL, PostgreSQL, SQLite, and Cloudflare D1 connections in one workflow.
SELECT
u.country,
COUNT(*) AS n,
SUM(o.total) AS total_volume
FROM users u
JOIN orders o ON o.user_id = u.id
WHERE u.created_at > NOW() - INTERVAL 7 DAY
GROUP BY u.country;| # | country | n | total_volume |
|---|---|---|---|
| 1 | US | 1245 | 45230.00 |
| 2 | UK | 892 | 28115.50 |
| 3 | DE | 634 | 19402.10 |
| 4 | FR | 412 | 15208.25 |
| 5 | CA | 298 | 9876.40 |
| 6 | AU | 267 | 11234.00 |
| 7 | JP | 521 | 20450.75 |
| 8 | BR | 389 | 8750.20 |
| 9 | IN | 756 | 18900.00 |
| 10 | NL | 198 | 7650.30 |
| 11 | SE | 156 | 5432.10 |
| 12 | ES | 334 | 12340.55 |
Features
Connect, write, find, edit, review and move data, built for keyboards and careful hands.
MySQL, PostgreSQL, SQLite files and Cloudflare D1 sit side by side as access passes. Tag each one local, staging or production, and the color follows you everywhere.
Column, table and routine completion scoped to the tables in your query. Put the cursor in a statement and run just that one, or run a whole script and get a result tab per statement.
Chat with an assistant that sees your schema. Mention tables with @, attach rows you selected in the grid, and turn answers into charts. When a query fails, Fix with AI explains why and suggests a correction.
Keep queries, tables and .sql files open side by side in tabs. Drag a query editor out into its own window for a second display. Results still land in the main window.
Every table, view, routine and saved query in the current database, one keystroke away. Type a few letters, press enter, keep your hands on the keyboard.
Save queries you reach for into named groups with tags. Everything you run is kept in history, grouped by day, per connection and database. Open any of them in a new tab.
Double-click a cell and type. Add rows, delete rows, fix a typo in production. Nothing is written until you save, and every change is visible until then.
A WHERE and ORDER BY bar sits right above every table. Write any condition your database understands, with column autocomplete, and press enter.
Pending grid edits turn into plain INSERT, UPDATE and DELETE statements you can read before saving. Check them, copy them into a migration, then save.
Create a table or change an existing one from a single screen. Columns, types, defaults, indexes and foreign keys sit together, and Null works out the schema change for your database.
Give each connection its own safe mode. Leave local databases open, ask before changes on staging, and require your password or Touch ID on production.
Back up a database or a single schema, restore it somewhere else, import CSV with column mapping, and export any table or result to CSV, JSON or SQL.
Click a foreign key value to jump straight to the row it references.
Read one wide row top to bottom in a side panel, no horizontal scrolling.
Right-click rows to copy them as INSERT statements, JSON, CSV, Markdown or plain text.
Search loaded rows with ⌘F and jump between matches with ⌘G.
Browse databases and schemas as a tree, and back up or restore a single schema.
Set fonts, sizes and row density for the editor, grid and sidebar, plus zebra stripes and light or dark mode.
File menu with Open Recent, and .sql files open straight from Finder, with or without a connection.
Null lets you know when a signed update is ready and installs it in one click.
FAQ