Dory Docs
Core Features

Explorer

Explorer helps you understand a database before writing SQL. It is the safest place to start when you are unfamiliar with a schema.

What You Can Inspect

AreaWhat to Look For
Databases and schemasAvailable namespaces and table grouping
TablesTable names, purpose, and row shape
ColumnsNames, types, and likely meanings
Sample rowsRepresentative values and null patterns
RelationshipsIDs, foreign-key-like names, and join candidates

Why It Matters

  • You can avoid guessing table and column names.
  • AI Chat can work with better schema context.
  • SQL Console queries are easier to validate.
  • You can identify safe preview queries before running larger analysis.
  1. Select a connection.
  2. Browse schemas and tables.
  3. Open a table and inspect columns.
  4. Preview a small sample when available.
  5. Move to SQL Console or AI Chat with the table context in mind.

Table Detail Pages

Use table details to understand column names, data types, and examples before writing filters, joins, or aggregations.

Working with AI

When asking AI to generate SQL, mention the exact table and columns you confirmed in Explorer. This reduces hallucinated column names and makes the first draft easier to review.

On this page