Query Editor

The SQL editor with syntax highlighting, schema browsing, query history, and result export.

Writing Queries

The editor uses Monaco (the same engine as VS Code) with full SQL syntax highlighting, bracket matching, and auto-indentation.

Keyboard Shortcuts

Schema Browser

The left sidebar shows all available tables grouped by schema. Click a table name to expand it and see its columns with their types. Use the + button to insert a table name directly into the editor.

Use the search box at the top to filter tables by name. Click "Refresh" to reload the table list after new data syncs.

Toggle the sidebar with the << / >> button in the toolbar.

Cost Estimation

As you type, the editor fetches a cost estimate for your query. The toolbar shows estimated bytes scanned, row count, and cost in EUR. This helps you avoid accidentally running expensive queries.

Results

Query results are displayed in a data grid below the editor. Features include:

• Column type indicators (# for numbers, T for text, D for dates, ? for booleans)
• Column resizing by dragging column borders
• Pagination (100 rows per page) with prev/next navigation
• NULL values displayed distinctly in italic

Status Bar

After execution, the status bar shows row count, execution time, and bytes scanned.

Save Query

Click the "Save" button in the toolbar to save the current SQL as a named query. Saved queries can be called via the REST API or CLI without re-typing the SQL.

If your SQL contains :param_name placeholders, they are automatically detected and registered as parameters.

After saving, find your query on the Saved Queries page with ready-to-copy curl and rq CLI commands.

Resizable Editor

Drag the border between the editor and the results pane to adjust the editor height. The editor uses the full available width with no wasted padding.

Export

Use the CSV and JSON buttons in the status bar to download your results. Export is done client-side from the current result set.

Query History

The last 50 queries are saved in your browser's local storage. Click the "History" button in the toolbar to browse previous queries. Each entry shows the timestamp, row count, and execution time. Click an entry to load it back into the editor.

Use "Clear all" to remove all history entries.

Deep Linking

You can link directly to the query editor with a pre-filled SQL statement using the ?sql= URL parameter:

/dashboard/query?sql=SELECT * FROM my_stripe.customers LIMIT 100

/dashboard/query?sql=SELECT * FROM my_stripe.customers LIMIT 100

The Lakehouse uses this to link "Open in Query Editor" for any table.

SQL Basics | Joins