Schema diagram

Explore your database structure visually through the schema diagram. This tool lets you:

Select schemas — Choose one or multiple schemas to display
Navigate freely — Pan and zoom to focus on specific areas
View table relationships — See how tables connect through foreign keys
Filter your view — Show or hide tables and columns by relationship type
Color links by root table — Trace relationships back to their source at a glance. Links inherit the color of the table that defines the relationship (e.g., all user_id foreign keys match the users table color)
Reset the layout — Return to the default view which auto-arranges tables ensuring the most linked tables are central

It allows you to explore the schema structure, view table relationships, and manage the layout of the schema diagram. You can pan and zoom the diagram, select schemas, filter tables and columns based on their relationship types, reset the layout. Link color modes allow you to better understand related tables and foreign key properties.

Controls

Top controls

Table relationship filter: Display tables based on their relationship type. Options include: all, linked (with relationships), orphaned (without relationships).
Column relationship filter: Display columns based on their relationship type. Options include: all, references (with relationships), none (no columns/only table names will be shown).
Link colour mode: Colour links by: default (fixed colour), root table (the colour of the table the relationship tree originates from), on-delete/on-update (colour based on constraint referential action).
Reset layout: Moving tables is persisted the state database. Clicking this resets the schema diagram layout to its initial state.
Close schema diagram: Closes the schema diagram and returns to the dashboard menu.

Workspaces menu

Workspaces are a powerful feature that allows you to organize your work within a connection. The opened views and their layout is saved to the workspace, so you can switch between different sets of data and configurations without losing your progress.

The workspaces menu provides access to all available workspaces for the selected connection. You can create new workspaces, switch between existing ones, and manage workspace settings. Each workspace allows you to work with a separate set of data and configurations, making it easier to organize your work and collaborate with others. The menu also includes options to clone existing workspaces and delete them if they are no longer needed.

Workspaces: List of available workspaces. Click to switch to a different workspace.
- Delete workspace: Opens the delete workspace confirmation dialog
  - Delete workspace: Confirms the deletion of the selected workspace.
- Clone workspace: Creates a copy of the selected workspace with a new name.
- Workspace settings: Opens the settings for the selected workspace, allowing you to manage its properties.
Create new workspace: Opens the form to create a new workspace for the selected connection.
- Workspace name: Name of the new workspace.
- Create workspace: Create and switch to the new workspace with the specified name.
Toggle layout mode: Switches between fixed and editable layout modes for the current workspace. Fixed mode locks the layout, preventing it from being changed by the user.

Workspace area

The workspace area is the main place for interacting with your data. It includes the SQL editor, data tables, maps, and timecharts, allowing you to execute queries, visualize data, and manage database objects.

SQL editor: The SQL editor allows users to write and execute SQL queries against the selected database. It provides a user-friendly interface for interacting with the database.
Table view: Allows interacting with a table/view from the database.
Map view: Displays a map visualization based on the Table/SQL query results.
Timechart view: Displays a timechart based on the Table/SQL query results.