Skip to main content

Schema Viewer

Once connected, browse your database schema visually without writing any SQL.

Opening the Schema Viewer​

  1. Go to Clouds and select a connection
  2. The Schema Viewer loads automatically, showing all tables

Views​

List view​

A structured tree view of your database:

  • Tables listed alphabetically
  • Expand a table to see its columns
  • Each column shows:
    • Column name
    • Data type (varchar, integer, timestamp, etc.)
    • Nullable (yes/no)
    • Primary key indicator
    • Foreign key indicator (with reference)

Diagram view​

A visual entity-relationship diagram:

  • Tables shown as cards with their columns
  • Foreign key relationships drawn as connecting lines
  • Draggable layout — arrange tables to understand relationships

Searching​

Use the search bar to find tables or columns by name. This is especially useful for large databases with hundreds of tables.

Fullscreen mode​

Click the fullscreen button to expand the Schema Viewer to fill your entire screen — helpful when working with large schemas.

Large databases​

For databases with many tables, the schema loads in the background and is cached for faster subsequent access. A loading indicator shows progress during the initial load.

Using schema info in workflows​

Understanding your schema helps you build better workflows:

  • Know which table to target for Target Database nodes
  • Understand column types for proper data mapping
  • Identify foreign keys for joining data across tables