Databases
“Data” is a Studio feature (included in the trial). Rail entry under “Editor”.
Connections
New connection: label, engine (MySQL, MariaDB, PostgreSQL), host, port, user and password (with reveal, copy and paste buttons), default database, SSH tunnel through a host of the Parc (the database address is then as seen from that host), TLS, tags. Test really opens the connection. The connection is stored in the vault: encrypted, synced between your devices.
Schema
On the left, the databases then the tables (approximate row count). Clicking a table opens its tabs.
Data
Grid sortable by header, free WHERE filter, pages of 50 to 1000 rows. Double click a cell to edit it, Enter confirms, Esc cancels, Shift+Delete sets NULL. Adding a row opens a form; deleting asks for confirmation. All through the primary key: a table without one is read only.
Structure
Columns, types, nullability, key, default, extra.
Query
Highlighted SQL editor, Cmd+↵ or “Run”; a selection runs only the selection. Result as a grid with the row count and the duration; server errors in clear; history of the last 100 queries.
Users
List of MySQL users (user@host) or PostgreSQL roles. Creation with a generated password and “all privileges on” a database; deletion with confirmation. Superusers cannot be deleted here.