The object explorer on the left of the project screen shows your connections and the live databases under them as a tree. Here you find tables and objects and open them in detail tabs, drag them into an ERD, and refresh, create or drop things from the context menu. How connections, databases and schemas relate is explained in Connections and execution targets.
What's on the screen
| No. | Name | Description |
|---|---|---|
| 1 | button | The top button on the left rail. It opens the explorer. Pressing it again while the explorer is open collapses the left panel. |
| 2 | Connection... button | Opens the window for a new connection. See Create and edit a connection. |
| 3 | Filter tables... box | Keeps only the tables, views and objects whose names contain what you type. See "Finding a table" below. |
| 4 | Connection node | The dot before the name is the connection state. See "Nodes and indicators" below. |
| 5 | Refresh and edit buttons of the connection | The refresh button reads this connection's lists from the database again, and the pencil button opens the connection window. Database, schema and group nodes also have a refresh button. |
| 6 | Schema node | A schema you selected in the connection window. DBMSs with a database level have a database node above it. |
| 7 | Group node | The Tables group, the Views group and the object groups of each DBMS. The number in parentheses is how many items it holds. |
| 8 | Table node | Double-click it to open the table tab (Table tab). The refresh button at the right end re-reads only this table, and the ⋮ button opens the context menu. |
| 9 | ERD and SQL list | The project's ERDs and SQL documents. See ERD and SQL list. |
- The Secret Key Lock button on the right of the toolbar appears only in account projects while signed in. Only the owner can turn it on. See Zero-knowledge encryption.
- With no connections, the tree is replaced by the No connections yet message and the Add connection button.
Nodes and indicators
The tree goes connection › (database) › schema › group › object. Database nodes exist only for DBMSs with a database level, such as PostgreSQL and SQL Server. Only the schemas you selected on the Schema tab of the connection window appear, not every schema in the database.
| Node | Indicator and meaning |
|---|---|
| Connection | The dot before the name: green is connected, yellow is connecting, a red × is a failed connection (hover to see the error), and a hollow grey circle is not connected yet. Expanding the node connects. |
| Connection (no connection details) | The name is followed by Not configured. It is a design-only connection with just a DBMS chosen, so menus that read the database are absent. |
| Connection (disabled) | Shown dimmed with a lock icon and Disabled. In the web app, SQLite and localhost connections look like this with Desktop only. |
| Orange warning on a connection | The custom driver set for the connection is missing on this device. The bundled driver with the same driver class is used if there is one; otherwise it cannot connect (Custom driver is missing on this device. The bundled driver with the same driver class is used if there is one; otherwise the connection fails.). |
| Shield icon on a connection | In PostgreSQL, some tables have row-level security (RLS) enabled and the signed-in user cannot bypass it. Queries may return only some rows. |
| Database, schema | Hover to see the database comment, if there is one. A schema without a name shows as (no schema). |
| System schemas | Gathers system schemas such as PostgreSQL's pg_catalog and schemas you marked as system, shown in grey. Tables in system schemas cannot be edited. |
| Group | Under a schema: the Tables group, the Views group and groups that differ by DBMS (indexes, triggers, Routines for functions and procedures, and so on). The Server Objects group right under the connection holds server-level objects such as users, sessions, locks and server settings. A group is read from the database the first time you expand it. |
| Table, view | The name color shows how it differs from the database: green is a virtual table not yet in the database, blue has changes not yet applied, and red strikethrough is marked for deletion. A renamed table is followed by ←old name. Expand it to see the columns. |
| Object | A single object such as a sequence, function or trigger. Functions show their arguments in short form, and indexes and triggers show the table they belong to. Objects with compile errors carry a red mark. |
| Data Dictionary | Appears only when a data dictionary is assigned to the connection. Clicking it opens the data dictionary tab of the connection window, and clicking the domain or dictionary node below it opens that tab. See Assigning to a connection. |
When you switch to another tab, the connection, database and schema it points to are highlighted in the tree, which scrolls to them if they are out of view.
Opening nodes
| Node | Click | Double-click |
|---|---|---|
| Connection, database, schema, group | A schema is selected. Expand and collapse with the arrow in front | No tab opens. Groups that have their own list screen (Views, indexes, the groups under Server Objects, and so on) open the list in an object tab (Object tabs) |
| Table | Selects it | Opens the table tab (Table tab) |
| View, object | Selects it | Opens an object tab (Object tabs). A progress indicator spins on the node while the definition is read from the database |
- The menu in the context menu does the same as double-clicking a table or view. With several selected, it opens a tab for each.
- Groups under Server Objects that have no dedicated list screen open in the tab, a simple screen with the list of rows and the properties of the selected row.
Finding a table
- Type part of a table name in the Filter tables... box (3). Case does not matter.
- Only tables, views and objects whose names contain the text remain. Indexes and triggers are also matched by the name of their table. Connection, schema and group nodes stay.
- Clear the box to see every node again.
- The filter only looks at nodes already read. It cannot find objects in a group you have never expanded, so expand it first.
- Changing the filter clears a multiple selection.
Selecting several nodes
- Click with
Ctrl(Cmdon macOS) held to add or remove one at a time. Click withShiftheld to select from the last node you clicked to the one you click now. - Only nodes under the same parent can be selected together. Clicking a node in another group starts a new selection. Schemas can be combined with
Ctrleven across connections (this is for Schema compare). - Right-clicking one of the selected nodes applies the menu to all of them, and only menus that every selected node accepts appear. Right-clicking a node outside the selection clears it and shows the menu for that node alone.
Bringing tables into an ERD
- Open an ERD tab.
- Drag a table node from the explorer onto the ERD canvas. On hover the icon turns into a drag handle (Drag to ERD or SQL editor). If you selected several tables, drag one of them to bring them all.
- The table appears where you dropped it, several tables stacked vertically. Save the ERD.
- The menu in the context menu places the table in the middle of the ERD tab you are looking at and saves the ERD right away. It cannot be pressed unless an ERD tab is in front.
- Tables from another connection cannot be dropped. An ERD made for one schema accepts only tables of that schema. Tables already in the ERD are skipped.
- Dropping a table node on the SQL editor opens a menu that writes SQL such as SELECT or INSERT. See SQL editor.
Refreshing
After changing the database with another tool or applying changes, refresh to bring the tree in line with the database.
| Target | What is read again |
|---|---|
| A node's refresh button | The list under the node (the tables of a schema, the objects of a group, and so on) |
| A table node's refresh button, the menu on a table | That table's columns, keys and indexes |
| The menu on a connection, schema or group | The lists below it, and the information of the tables visible under it |
When tables are read again and some of them have changes not yet applied to the database, you are asked what to do.
| Button | Result |
|---|---|
| Replace button | Discards all changes, resets to the database state and saves. |
| Merge button | Takes the current structure from the database while keeping the entity settings for code generation. Does not save. |
- Tables linked by foreign keys are read again too. If there are any, their names are shown and you are asked to continue.
- Pressing the window's close button reads nothing.
- Disabled connections and virtual tables not yet in the database cannot be refreshed.
Connecting and disconnecting
A connection connects on its own when you expand its node or open one of its tabs. To connect or disconnect yourself, right-click the connection.
- Right-click the connection node.
- If it is not connected, press the menu. If it is connected or connecting, press the Disconnect menu.
- Use the Connect menu to retry a connection that failed. A failed connection is not retried automatically.
- When connecting takes long, a connection task appears in the Background Processes window of the status bar. If a firewall blocks the connection, it fails after the connection timeout and the error stays in the window (App menu, top bar and status bar).
- The Disconnect menu only closes the link to the database. The connection, ERDs and SQL documents stay. Expanding the node or opening a tab afterwards connects again.
Context menu
Right-click a node to see only the menus that apply to it, grouped by separators. Menus that read or change the database appear only for connections with connection details. The ⋮ button on table and object nodes opens the same menu.
| Menu | On which nodes | What it does |
|---|---|---|
| Table, view | Opens the detail tab ("Opening nodes" above). | |
| Connection, database, schema, group, table, view, object | Same as "Refreshing" above. | |
| Connection | Same as "Connecting and disconnecting" above. Shown as the Disconnect menu when connected. | |
| / | Connection | Opens the connection window to edit it, or copies its settings into a new connection. Create and edit a connection |
| Disabled connection | Turns a connection disabled by plan cleanup back on and reads its lists. Account projects only. Manage Subscription | |
| Connection | Opens the data dictionary tab of the connection window. Assigning to a connection | |
| Table | Adds the table to the ERD you are looking at ("Bringing tables into an ERD" above). | |
| / | Table | Exports the table's data to a file or imports it from one. Data export, import and native backup |
| / | Table, schema, database or connection, depending on the DBMS | Backs up and restores with the DBMS's dump tools. Data export, import and native backup |
| Most nodes, from connections down to columns | Opens an SQL tab targeting that location. If SQL documents exist for the same location, you can pick one from a submenu. SQL editor | |
| Same as above | Creates a new ERD for that location. ERD and SQL list | |
| Schema, Tables | Creates a virtual table and opens its table tab. Table tab | |
| Groups of objects that can be created (sequences, functions, and so on) | Opens an object tab that creates that object. Object tabs | |
| / | User mappings of a PostgreSQL foreign server | Creates or edits a user mapping. Object tabs |
| Connection, database, schema, Tables | Reads DDL statements and creates virtual tables. Import tables from DDL | |
| Database, schema | Changes the comment or owner. Shown only for DBMSs that have such properties. On a database node it appears as the Modify Database menu. | |
| Database, schema | Renames it. ERDs, SQL tabs and cached tables that use the name follow the new name. Shown only for DBMSs that support it, and never on system schemas. On a database node it appears as the Rename Database... menu. | |
| Connection (not SQLite) | Creates a database and adds it to the tree. MySQL, MariaDB and H2 show the Create Schema menu, and Oracle shows the Create Schema (User) menu, which opens an object tab that creates a user. | |
| Database | Creates a schema in that database and adds it to the tree. | |
| Connection, schema, Tables, index group, table | Shows the DDL for the changed tables inside and runs it. Apply changes to the database | |
| Table, view, function, procedure, sequence | Writes and shows SQL such as SELECT. SQL editor | |
| Table | Generates source code from templates. Generating source code | |
| Connection, database, schema | Downloads a table report as an Excel file. Table report | |
| Schema (two schemas when two are selected) | Compares the structure of two schemas. Schema compare | |
| / | PostgreSQL schema / table or view with RLS enabled | Shows RLS permissions per role, and lets you query as another role. RLS matrix and simulator |
| Schema | Moves the schema into the System schemas group. See "Marking system schemas" below. | |
| Schema you marked as system | Removes the mark. | |
| Connection | Deletes the connection from the project. See "Deleting" below. | |
| Schema | Removes the schema from the project only. The schema in the database stays. | |
| Database | Drops the database on the live database server. | |
| Schema (not SQLite) | Drops the schema on the live database server. Oracle shows the Drop Schema (User) menu. | |
| Table, view | Marks the table for deletion or drops it in the database. On a view it appears as the Drop View... menu. | |
| Table marked for deletion | Removes the deletion mark. A marked table shows this menu instead of the menu. |
- With several nodes selected, only menus that work on all of them appear. For example, the menu appears when exactly two schemas are selected, and the data menus when the tables belong to the same connection and database.
- The , , and menus also appear in the web app, but pressing them only shows This feature is only available in the desktop app.. Use the desktop app.
- Right-clicking an empty part of the explorer shows the Project Settings... item, the New Connection... item, the menu and the new SQL and ERD menus. Account projects also show the zero-knowledge encryption menu.
Menus by node
The pictures show a SQLite connection in the desktop app. SQLite has no menus to create or drop databases and schemas. Other DBMSs show the corresponding menus from the table above.
Creating and changing databases and schemas
- Right-click the connection node for a new database, or a database node for a new schema.
- Press the menu or the menu.
- Enter the name and properties in the window and run it. What you create is added to the connection's schema list and appears in the tree right away.
- Change the comment and owner with the menu, and the name with the menu. After a rename, ERDs, SQL tabs and cached tables that used the old name move to the new one. Renaming a database ends the sessions of SQL tabs connected to it.
- These menus run DDL on the live database. In account projects they are dimmed and cannot be pressed for members whose DDL is restricted. They cannot be pressed on disabled connections either.
- In Oracle a schema is a user, so the Create Schema (User) menu opens an object tab that creates a user. If the signed-in account may not create users, the menu is dimmed.
Marking system schemas
Marking a schema the database relies on, or one you will not touch, as a system schema moves it into the System schemas group in grey.
- Right-click the schema node and press the menu.
- The schema moves into the System schemas group.
- To undo, right-click the schema and press the menu.
- System schemas are grey in the ERD and SQL editor too, and their tables cannot be edited. The and menus in the explorer are blocked as well.
- System schemas defined by the DBMS, such as PostgreSQL's
pg_catalogandinformation_schema, cannot be unmarked. - The mark is saved in the connection settings.
Deleting
The delete menus of the explorer either remove something from the project only or drop it in the live database. Check the menu name before you press it.
| Menu | Where it deletes | What else happens |
|---|---|---|
| Project | Deletes the connection, the ERDs made with it, and the dashboard tiles that use it. In account projects, ERD copies posted to the gallery are deleted too. SQL documents are kept and only unlinked from the connection. If anything is affected, a table lists it for you to confirm. The database does not change. | |
| Project | Deletes ERDs made for this schema alone, and removes this schema's tables from ERDs that hold several schemas. The schema in the database is not dropped. | |
| Live database server | Shows the DDL first and runs only after you type the database name exactly. You can choose to end connected sessions and drop. The maintenance database cannot be dropped. | |
| Live database server | After a confirmation, drops the schema with every object and row in it. In SQL Server the schema must be empty, and in Oracle the user account is dropped too. System schemas cannot be dropped. | |
| Your choice | Explained below. |
When a database or schema is dropped in the database, the ERDs and SQL tab bindings made from it are cleaned up as well.
- Right-click a table (several also work) and press the menu.
- In the Delete Tables / Views window, choose what to do with the tables that exist in the database. Flag Only (Keep in the database) only marks them for deletion, and Execute DROP TABLE (Delete from the database) shows and runs the DROP TABLE statement.
- Press the Delete button.
- A marked table stays in red strikethrough and is dropped from the database at the next apply (Apply changes to the database). Until then, undo it with the menu.
- Virtual tables not yet in the database are removed from the project without a choice. Views are dropped right away with DROP VIEW.
- Tables in system schemas cannot be deleted. In account projects, members whose DDL is restricted cannot drop views, and dropping a table becomes an approval request instead of running.
Things to keep in mind
- The menu and the menu appear side by side. The first only removes the schema from the project; the second drops the schema and its data in the live database and cannot be undone.
- The menu also deletes the ERDs made with that connection. To change only the connection details, use the menu.
- Choosing the Replace button when refreshing discards every table change not yet applied to the database.
- The explorer shows only the schemas selected in the connection window. If a schema is missing, add it in Create and edit a connection.
- Use SQLite and
localhostconnections in the desktop app. A lock marks them in the web explorer. Web and desktop
Related screens
- Create and edit a connection: create connections and choose the schemas shown in the explorer.
- Table tab: the tab opened by double-clicking a table.
- Object tabs: tabs for views, routines, sequences and other objects, and server objects.
- ERD canvas: arrange the tables dragged from the explorer.
- ERD and SQL list: the ERD and SQL list below the explorer.
- Apply changes to the database: apply changed tables and deletion marks to the database.