Docs/Data Explorer

Data Explorer

Data Explorer is the built-in workspace for exploring your databases, files, and storage connections. Use it to browse structure, view and edit data, run SQL, and generate ER diagrams — all before or during stream work.

Two-pane layout

Data Explorer uses a split layout for side-by-side viewing. Both panes are fully independent — each can browse, query, and edit, like split editors in an IDE.

One pane is active at a time, indicated by a blue line above its tab bar. Navigator clicks open content in the active pane. Click inside either pane to switch.

Tabs

  • Single-click an item in the navigator — opens a shared tab (italic title). The next single-click reuses this slot.
  • Double-click an item — opens a dedicated tab (normal title) that stays until closed.

Managing panes

ActionHow
Open in active paneSingle-click (shared) or double-click (dedicated) in navigator
Open in specific paneRight-click in navigator → Open in Left/Right Pane, or hover a supported object and use the quick action
Move tab to other paneRight-click tab → Move to Right/Left Pane
Switch active paneClick inside the target pane
Close a tabClick × on the tab, or right-click → Close
Reopen closed tabRight-click tab bar → Reopen Closed Tab (Ctrl+Shift+T)

Keyboard shortcuts

ShortcutAction
Ctrl+1Focus left pane
Ctrl+2Focus right pane
Ctrl+WClose active tab
Ctrl+Shift+TReopen closed tab

On macOS, use instead of Ctrl. See individual pages below for feature-specific shortcuts.

Features

PageWhat it covers
Navigator and Object BrowsingConnection tree, filter buttons, database overview, S3 and file browsing
Examining Table StructureColumns, keys, indexes, and DDL inspection
Viewing DataData grid, sorting, filtering, pagination, summary statistics
Editing DataInline insert, update, delete with staged changes and review panel
SQL ConsoleDirect and file-aware SQL with autocomplete and diagnostics
Federated QueriesCross-database and multi-source SQL via DuckDB
Database DiagramsInteractive ER diagrams with export
ocs/database-explorer",1776197804062]