Guides

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.

Query a CSV File with SQL

Run real SQL on a CSV file with no SQL Server, no Postgres, and nothing to install.
Query JSON Files with SQL

Load a JSON array or newline-delimited JSON file into a real database and query it with SQL.
SQL Cheat Sheet for CSV & JSON Analysis

Copy-paste SQL patterns for filtering, aggregating, sorting, and joining your files.
Ask Your Data Questions in Plain English

Skip SQL entirely — Synth's built-in AI assistant answers questions about your data directly.
Turn a CSV into a SQLite Database, No Install

Convert any CSV into a real SQLite database entirely in your browser tab.
How to Join Two CSV Files with SQL

Load two CSVs as separate tables and join them with real SQL — no VLOOKUP required.
Privacy-First Data Analysis: Nothing Leaves Your Browser

Query sensitive files without uploading them anywhere — even the AI assistant only ever sees your schema.

Try it on your own file

Free to start, no sign-in required.

Open Synth