SQL Editor: Write SQL with syntax highlighting and autocomplete
Join Across Files: Query and join data from different files
CTEs Support: Use Common Table Expressions for complex queries
Virtual Scrolling: View large result sets efficiently
Schema Explorer: Browse tables and columns
Export Results: Download query results as CSV or Parquet
Quick Start
Open the SQL Explorer panel: Ctrl+Shift+P → "SQL Explorer: Open"
Drag data files into the drop zone
Write SQL in the editor
Press Ctrl+Enter to execute
View results in the grid below
Supported File Types
Type
Extension
Notes
CSV
.csv
Auto-detects delimiter
Parquet
.parquet
Native support
Excel
.xlsx, .xls
Requires spatial extension
SQLite
.sqlite, .db
Attach as database
JSON
.json
JSON/NDJSON files
Example Queries
-- Simple query
SELECT * FROM sales WHERE amount > 100;
-- Join across files
SELECT c.name, SUM(o.total)
FROM customers c
JOIN orders o ON c.id = o.customer_id
GROUP BY c.name;
-- CTE example
WITH monthly_sales AS (
SELECT
DATE_TRUNC('month', order_date) as month,
SUM(amount) as total
FROM orders
GROUP BY 1
)
SELECT * FROM monthly_sales ORDER BY month;
