Guides to querying, joining, and analyzing your data
Everything below runs against Synth, a browser-based SQL and AI tool for CSV and JSON files. No install, no server, no account required to start.
60 hands-on lessons from your first SELECT to joins and window functions. Write a query, check your answer instantly, and see exactly what's off.
Run real SQL on a CSV file with no SQL Server, no Postgres, and nothing to install.
Load a JSON array or newline-delimited JSON file into a real database and query it with SQL.
Copy-paste SQL patterns for filtering, aggregating, sorting, and joining your files.
Skip SQL entirely. Synth's built-in AI assistant answers questions about your data directly.
Convert any CSV into a real SQLite database entirely in your browser tab.
Load two CSVs as separate tables and join them with real SQL, no VLOOKUP required.
First and last names, email domains, and lists in one cell turned into separate rows.
Distinct counts, how often each value appears, and how to ignore blanks and capitalization.
Turn JSON or NDJSON into a CSV in your browser, flatten nested objects, and split arrays into rows.
Totals by category, months as columns, percent of total and a grand total row, all with copy-paste SQL.
Spot every duplicate with one SQL query, including near-duplicates that differ by case or spaces, and export a clean file.
Query sensitive files without uploading them anywhere — even the AI assistant only ever sees your schema.