Documentation

1. Open the editor and add one or more CSV, JSON, or Parquet files from the Add Data sidebar section.
2. Review the generated table names in Database, then expand a table to inspect its schema.
3. Write a query in the current tab, or create a fresh tab for a different idea.
4. Press Ctrl/Cmd + Enter to run the selected SQL or the whole query.
5. Review the Data, Visualisation, or Classification result tabs.
6. Export the result as CSV, save the current database to your browser, or create a Parquet ZIP backup to move elsewhere.

• Monaco provides SQL syntax highlighting plus autocomplete for tables, columns, and common SQL keywords.
• If you select part of a query and run it, only the selected text executes.
• DDL changes such as creating or dropping tables refresh the Database sidebar after execution.
• Query History stores recent runs locally, including status, row count, and execution time. You can reload, download, or delete entries from the sidebar.
• Editor tab names and SQL drafts are persisted locally in your browser so you can come back to unfinished work.

Example queries

SELECT *
FROM sales
LIMIT 25;

SELECT
  o.order_id,
  c.customer_name,
  o.total_amount
FROM orders o
JOIN customers c ON o.customer_id = c.id
WHERE o.total_amount > 100
ORDER BY o.total_amount DESC;

SELECT
  country,
  COUNT(*) AS orders,
  AVG(total_amount) AS avg_order_value
FROM orders
GROUP BY country
ORDER BY orders DESC;

• Expand any table in Database to inspect its columns and data types.
• Use the preview action to open a new tab with a sample query: SELECT * FROM table LIMIT 100.
• The data grid displays up to 1,000 rows for responsiveness.
• Column headers in the Data tab are sortable.
• CSV export uses the full Arrow result, so exported files can include all rows even when the UI only shows the first 1,000.

On Mac, use Cmd anywhere the interface shows Ctrl.