Queries, models and sync in one tool.

SQL editor

Syntax highlighting, autocompletion and tabs. The statement at the cursor runs with Ctrl/⌘ Enter and the whole script with Ctrl/⌘ ⇧ Enter; results appear in a grid that scrolls smoothly even with large tables and can be exported as CSV or JSON.

EER data model

Tables are drawn in a diagram; 1:1, 1:n and n:m relationships (with a junction table) are created from the toolbar. Column types, primary and foreign keys, indexes and default values are edited in the side panel; ready-made table templates are included.

Compare and sync

Differences between the model and a database (or two databases) are shown side by side. Renamed columns and tables are tracked, steps that risk data loss are flagged, and the script to be applied is shown first.

Reverse and forward engineering

The schema of a connected database is brought into the model; the model is turned into a CREATE script for MySQL, PostgreSQL or SQLite.

Users and privileges

MySQL accounts and PostgreSQL roles are listed; schema and table privileges, passwords and locks are edited. The GRANT / REVOKE statements to be applied are shown first.

SQLite everywhere

SQLite databases are opened, edited and saved in place in the browser, on phones and on the desktop (downloaded in browsers that do not support this); new empty databases can be created.

All features