SQL cheatsheet — searchable syntax reference
A searchable reference of common SQL statements and clauses. It runs entirely in your browser (0 uploads, works offline).
How to use it
- Browse or search the SQL statements.
- Read what each does and its notes.
- Copy the snippet you need.
FAQ
How do I look up SQL syntax quickly, for free?
Search for a keyword like join or group by and this page shows the syntax and a short note on what it does — bundled and searched entirely in your browser with no upload.
Which SQL flavour is this?
Standard SQL that works across most databases (PostgreSQL, MySQL, SQLite, SQL Server). Vendor-specific extensions may differ slightly.
Is anything uploaded?
No. The reference is bundled and searched entirely in your browser and nothing is transmitted or stored, which you can verify by turning off your Wi-Fi.
Does it cover joins and aggregates?
Yes — SELECT/WHERE/ORDER, INSERT/UPDATE/DELETE, JOINs, GROUP BY/HAVING and the common aggregate functions are all included.
Limits
A curated quick reference, not a full SQL manual or a query runner.
Related
The Linux commands sheet covers the shell; the regex cheatsheet covers patterns.
Bookmark this page (Ctrl+D, or ⌘D on Mac) or install the app — it works offline the next time you need it.