Navigation


What Navigation does

Navigation is the object panel on the left side of the window: it lists the databases, schemas, tables, views, functions, and stored procedures of the current connection in a hierarchy, and from here you open tables, start queries, and switch connections. It is the main entry point for browsing a database, handling navigation only and never modifying data.

Which panel is shown depends on the icon selected in the Nav Bar; clicking the same icon again collapses the panel.

▶ Tutorial: Navigation

Switch connection → expand objects → context menu

Panel layout

The panel has four parts, from top to bottom:

  1. Connection row: the current connection name; click to expand the connection list.
  2. Icon row: filter panel, pinned panel, refresh, clear filter, expand/collapse.
  3. Database / schema row: choose which databases and schemas to show.
  4. Object tree: database → schema → table / view / materialized view / function / stored procedure.

Navigation panel

Top to bottom: connection name, icon row, database and schema selection, object tree

Connection row

Click the connection name to expand the connection list, which has two groups:

  • Recent: recently used connections.
  • Saved: all saved connections, grouped by database type.

There is a search box at the top; with many connections, type a name to filter. Selecting a connection switches to it, and open tabs stay open.

Filter box

The filter box at the top of the tree filters objects by name and supports two forms:

  • % like: fuzzy match, such as %order%
  • /RegEx: regular expression match, such as /^tbl_/

The × on the right clears the conditions.

Switch workspace & datasource

Below is the full process of switching workspaces from the top of Navigation: searching for a connection, choosing a target, and how the interface changes after switching.

▶ Tutorial: Switch workspace

Search → switch → state preserved

Workspace & DataSource

ConceptWhat it is
DataSourceA saved connection configuration: name, type, host, port, account, and SSH / SSL parameters
WorkspaceThe working environment for that connection: open tabs, selected databases and schemas, tree expansion and filters, and query files

A DataSource maps to one Workspace, with the same name as the DataSource. Opening a connection loads the workspace’s own state; after closing the connection, the state stays on this machine.

So switching Workspace and switching DataSource are the same thing: a different connection also means a different set of tabs, database selections, and query files.

The connection name at the top of Navigation is the switching entry point. Open the dropdown to list the workspaces you can switch to; select one to switch.

Saved

Switch workspace dropdown

Full-window view; the red box marks the connection-name dropdown

The dropdown has only the Saved group, collapsed by database type:

GroupContents
sqlite / mysql / postgres / oracle …Each type lists its connections in saved order

The current workspace is highlighted in the dropdown. With many connections, narrow the range with the search box first, then expand a group.

Search connections

Type a keyword in Search here… at the top of the dropdown to filter the list by connection name; the list narrows as you type and expands back to the full list when cleared.

Switch

Click a connection in the dropdown to switch: Navigation shows that workspace’s tree, and the tab bar shows that workspace’s own tabs.

Switching preserves working state; each workspace remembers its own:

  • open tabs and the active tab;
  • selected databases and schemas;
  • tree expansion state and filter conditions.

When you switch away, this state is written back to this machine and restored when you return.

Switched to the Oracle workspace

Full-window view; the red box marks the Oracle connection’s own tab (the EMP table) after switching

Switched back to the PostgreSQL workspace

Full-window view; the red box marks the chinook tab that is still open in that workspace after switching back

After switching

After switching, Navigation loads according to the target workspace and the data area switches to that connection’s tabs.

Switching only changes the current workspace; the previous workspace’s files and settings remain on this machine and you can switch back at any time. The connection you switch to keeps its previously selected databases and schemas and does not prompt automatically.

Select Database & Schema

Select Database & Schema dialog

Check the boxes and click OK; the selected databases and schemas appear in the tree together

This controls which databases and schemas the tree shows at once. It selects a display scope, not a new current database: check several and they appear side by side in the tree.

Two ways in:

  • the database icon at the right of the connection row (hover to see which databases and schemas are selected);
  • the tree’s context menu item Select Schemas….

The dialog opens with the currently selected databases and schemas already checked; add or remove from that default and click OK to apply.

Select Database & Schema in full

Full-window view; the red box marks the dialog

  • Each database has a checkbox and several can be selected; expand one to check individual schemas.
  • The character set is shown to the right of each schema to confirm the encoding.
  • System schemas (pg_temp_*, pg_toast_*) are hidden by default; check display buildin schemas to show them.
  • The filter at the top supports % like and /RegEx, and Reset clears it; use the refresh button after changing permissions or creating a database.
  • OK applies and Cancel discards.

Toolbar

Icon row at the top of the tree

Five buttons in the icon row: filter panel, pinned panel, refresh, clear filter, expand/collapse

IconAction
FunnelShow/hide the filter box
PinShow/hide the pinned panel
Circular arrowReload the objects of the current connection (Cmd+R, win: Ctrl+R)
×Clear the filter conditions
⌃⌄Collapse all / expand all

Use Expand All with care on large databases: expanding too many nodes at once triggers a large number of metadata queries.

Object menu

Right-click any node in the tree (database, schema, table, view, function, and so on) to open the same menu; items are enabled or hidden depending on the node type.

Object context menu

Context menu on a table node; the setting submenu is at the bottom

Menu itemDescription
RefreshRefresh the current node (Cmd+R, win: Ctrl+R)
Pin to TopPin to the top of the list (Cmd+T, win: Ctrl+T)
PinAdd to the pinned panel to keep several frequently used objects in one place
Copy NameCopy the object name to avoid retyping it in SQL
New ▸Create a Table / Schema / Query Editor / Folder
Alter TableOpen the structure view to change the table definition
Rename…Rename the object; press Enter to confirm
Truncate…Clear the table data, keeping the structure
Drop…Drop the object
Export Table…Export the table structure or data
Import table…Import a file into the table
Select Schemas…Adjust which databases and schemas the tree shows
setting ▸Show related settings; see the next section

Truncate and Drop cannot be undone; confirm the environment of the current connection before running them.

Pin to Top only changes the order in the tree; Pin moves the object into a separate pinned area.

Settings

setting submenu

Group by type, Merge schema, Allow Hidden Root, Restore Default

SettingEffect
Group by typeGroup by Tables / Views / Materialized Views / Functions / Procedures; when off, objects are listed flat
Merge schemaMerge like nodes across schemas to reduce nesting
Allow Hidden RootAllow hiding the root node and starting directly at the database or schema
Restore DefaultRestore the default display settings without affecting database contents