TOOL
SQL Extract Columns
List the column names from a SELECT clause. Tokens are split on commas and dots, so qualified names come back broken apart — u.id yields two entries, u and id; table prefixes are not preserved.
Try an example:
Local only
Recent history
No history yet
How to use
- Type or paste your input into the input box.
- Adjust any parameters if needed.
- Copy or download the result.
Frequently asked questions
- Is my data uploaded anywhere?
- No. All processing happens locally in your browser with no server round-trip.
- Does this tool work offline?
- Yes. Once the page loads, the tool runs entirely client-side and needs no network connection.
Related tools
SQL Extract Tables
List table names referenced after FROM and JOIN. Comma-style joins (FROM t1, t2) report only the first table — use explicit JOIN syntax for reliable extraction. TOOL
SQL Validate
A light SQL sanity check: the statement must start with a SQL keyword and brackets must balance. Statements that open with a parenthesis, like (SELECT 1) UNION (SELECT 2), are rejected — this is not a real SQL parser. TOOL
JSON to SQL
Convert a JSON representation back to a SELECT statement. TOOL
SQL SELECT Builder
Build a SELECT statement from JSON. TOOL
SQL to JSON
Convert a simple SELECT into JSON {type, columns, table, where}. Parsing is simplistic: everything after WHERE lands in the where field — ORDER BY and LIMIT clauses end up inside it; stick to single flat SELECT statements. TOOL