Skip to content

Dataset Explorer

SQL-powered data exploration directly in your browser.

Features

  • SQL editor — write any DuckDB SQL query against your loaded data
  • Quick filters — column + operator + value → generates WHERE clause
  • Sortable results — click column headers to sort
  • Query history — last 10 queries, click to re-run
  • Export results — download query results as CSV
  • Keyboard shortcuts — Ctrl+Enter / Cmd+Enter to run query

Example queries

-- Basic exploration
SELECT * FROM data LIMIT 100;

-- Aggregation
SELECT category, COUNT(*) as cnt, AVG(price) as avg_price
FROM data GROUP BY category ORDER BY cnt DESC;

-- Filtering
SELECT * FROM data WHERE age > 30 AND city = 'London';

-- Window functions
SELECT *, ROW_NUMBER() OVER (PARTITION BY category ORDER BY price DESC) as rank
FROM data;

-- Joins (load multiple files!)
SELECT a.*, b.region FROM customers a JOIN regions b ON a.zip = b.zip;

DuckDB SQL reference

DuckDB supports full SQL including window functions, CTEs, joins, aggregations, and many built-in functions. See the DuckDB documentation.