Database Explorer

Browse your warehouse schema interactively. Explore databases, schemas, tables, and columns without writing a single query. Drag objects into the editor to build SQL faster.

Database ExplorerIntrospect

▶🗄️ANALYTICS_DB

▶📁PUBLIC

▶📊dim_customers

🔑customer_idINTEGER

·first_nameVARCHAR

·last_nameVARCHAR

·emailVARCHAR

·created_atTIMESTAMP

▶📊fct_orders

📊stg_payments

▶📁RAW

📊 dim_customersPUBLIC

Column	Type	Key
customer_id	INTEGER	🔑
first_name	VARCHAR
last_name	VARCHAR
email	VARCHAR
created_at	TIMESTAMP

💡 Drag any table or column into the editor to build SQL quickly

Overview

The Database Explorer provides a live, navigable tree of your connected warehouse. It automatically introspects your schema and keeps it up to date as your data models evolve.

Schema Tree

The left panel displays your warehouse structure as a collapsible tree:

Warehouse Connection
├── database_1
│   ├── schema_a
│   │   ├── table_orders
│   │   │   ├── order_id (INTEGER)
│   │   │   ├── customer_id (INTEGER)
│   │   │   └── order_date (DATE)
│   │   └── table_customers
│   └── schema_b
└── database_2

Navigation

• Expand/collapse databases, schemas, and tables
• Search to filter by name across all levels
• Column details show data type, nullability, and description

Drag and Drop

Drag any object from the tree directly into the SQL editor:

• Drag a table to insert the fully qualified table name
• Drag a column to insert the column name
• Drag multiple columns to build a SELECT list quickly

Automatic Introspection

dbdeux automatically introspects your warehouse schema:

• On project creation to immediately populate the tree
• After each dbt run to reflect any schema changes
• On save/test to keep the tree current during development
• On demand via the refresh button

A running indicator shows when introspection is in progress. The tree remains interactive during updates.

Manual Introspection

Click the refresh button to trigger a full re-introspection. The process runs asynchronously in the background so it never times out, even on large warehouses:

• A confirmation dialog explains what will happen and how long it may take
• Progress polling with exponential backoff keeps the UI responsive
• A long-running hint appears if introspection takes more than a few seconds
• Once complete, the tree auto-expands to show new or changed schemas
• Scroll position is preserved so you do not lose your place

Every connection also has an always-visible refresh button on its row in the Databases list, so you can re-introspect a single connection without opening it first. The same confirmation dialog appears, so a full re-crawl is never triggered by an accidental click.

Resilient Crawling

Introspection handles large warehouses gracefully:

• Processes schemas in parallel for faster completion
• If one schema fails, others continue unaffected
• Bounded queries prevent timeouts on very large databases
• Results are cached and incrementally updated

Workspace-Scoped Connections

Warehouse connections belong to the workspace they were created in, so each team sees only the databases relevant to them:

• A workspace filter at the top of the Databases page narrows the list to a single workspace, or shows all of them at once
• Every connection carries a workspace badge so you can tell at a glance where it lives
• New connections are stamped with the active workspace, and creating one while a workspace is filtered puts it straight into that workspace
• The workspace dropdown appears automatically whenever you belong to more than one workspace

Connection Access Levels

Not every connection should be usable by everyone. Each connection has an access level that controls who can see and use it:

Access level	Who can use it
Workspace members	Everyone the workspace is shared with can use the connection
Admins and owners only	Only you and organization owners/admins can see or use it, which is ideal for protecting production databases from accidental use
Private to me	Only you can see or use the connection

Organization owners and admins can change the access level of any connection, not just the ones they created, so a production warehouse can be locked down without hunting for whoever first added it.

Preview Queries

Right-click any table to generate a preview query:

• Automatically uses the correct SQL dialect for your warehouse | Warehouse | Preview Syntax | |-----------|---------------| | Snowflake | SELECT * FROM table LIMIT 100 | | BigQuery | SELECT * FROM table LIMIT 100 | | Redshift | SELECT * FROM table LIMIT 100 | | Databricks | SELECT * FROM table LIMIT 100 | | StarRocks | SELECT * FROM table LIMIT 100 | | PostgreSQL | SELECT * FROM table FETCH FIRST 100 ROWS ONLY | | Athena | SELECT * FROM table LIMIT 100 | | MotherDuck | SELECT * FROM table LIMIT 100 | | Microsoft Fabric | SELECT TOP 100 * FROM table | | Azure Synapse | SELECT TOP 100 * FROM table | | Fabric Lakehouse | SELECT * FROM table LIMIT 100 |

Preview results appear in the results panel for quick inspection.

Brand Icons

Each connection displays its warehouse brand icon (Snowflake, BigQuery, Redshift, Postgres, Databricks, Athena, MotherDuck, Microsoft Fabric, Azure Synapse, StarRocks) for quick visual identification when working with multiple connections.

Connection Status

The status bar shows the current connection state:

• Connected (green) with the active database and schema
• Reconnecting (yellow) during temporary interruptions
• Disconnected (red) with clear error messaging