First Query in 3 Minutes

This guide assumes you already have a working database connection.

Before You Start

Start in Explorer. Pick a table and review its columns, sample rows, and relationships implied by names or keys.

Open SQL Console from the same connection. Keep Explorer available so you can confirm table and column names while writing SQL.

Start with a limited query:

select *
from your_table
limit 20;

Review the result columns before writing filters, joins, or aggregations.

Ask Dory AI for a more specific query. Include the table name, the metric you want, filters, and the expected output columns.

Example:

Ask AI to count rows by status for the last 7 days and return status plus count.

If the result is aggregated by time, category, or status, open charting from the results area and choose a chart type that matches the data shape.

When the query is useful, save it with a clear business name and a short description of the assumptions.

Check filters and time ranges. Start with a smaller set of conditions.

Ask AI to explain the error, then compare the suggested fix with Explorer schema.

Add limit, narrow the time range, or aggregate before returning rows.

Confirm the selected connection and schema are correct.

Compare the changed SQL with the last working version and ask AI to explain only the specific error message.

Give AI the exact table names, columns, desired filters, and expected output shape.

Continue with SQL Console or AI Chat.