SQL AST Parser
Paste a SQL query to break it down into readable components — with a field-by-field breakdown and, where relevant, its structure tree. Everything is processed on your device.
Everything runs in your browser. Your data is never sent to our servers.
Example
Example Input
SELECT id FROM users WHERE age > 18
Example Output
AST: type SELECT, table users
How to Use
- 1Paste the a SQL query you want to parse into the input box.
- 2If the tool asks for an extra field (e.g. a JSON Pointer or JSONPath), fill it too.
- 3Click Parse (or press Ctrl+Enter).
- 4See the component breakdown in the Components tab, the tree structure in the Tree tab (when available), and the normalized JSON in the JSON tab. Click Copy to copy the JSON.
About SQL AST Parser
SQL AST Parser parses a SQL statement into an Abstract Syntax Tree — a structure describing the statement type (SELECT/INSERT/UPDATE/…), tables, columns, WHERE clauses, and more. Useful for analyzing, transforming, or validating SQL programmatically.
Parsing uses node-sql-parser loaded on demand, supporting several SQL dialects.
FAQ
Is my data sent to a server?
No. The entire parsing is done in your browser with JavaScript. Nothing is uploaded, logged, or stored on our servers — safe for sensitive data.
How is this parser different from a validator or formatter?
A parser turns raw input into its component structure so you can see its building blocks (and, for code, its AST/DOM tree). A validator only checks valid/invalid, and a formatter just tidies the layout. A parser focuses on "what it contains and how it is structured".