A clean, opinionated SQL formatter for data professionals who want readable SQL.
Features
- Formats SQL to a consistent, readable style
- Smart handling of SELECT columns, JOINs, QUALIFY, and GROUP BY
Usage
- Open a
.sql file in VS Code.
- Select the SQL you want to format (or leave nothing selected to format the whole file).
- Run the command:
Command Palette → franks-sql-formatter
or shortcut → ctrl+alt+f
Before:
SELECT a.id, a.name, b.amount, SUM(c.score) as total_score FROM users a LEFT JOIN orders b ON a.id = b.user_id INNER JOIN scores c ON a.id = c.user_id WHERE a.status = 'active' AND b.amount > 500 QUALIFY ROW_NUMBER() OVER (PARTITION BY a.id ORDER BY b.amount DESC) = 1 GROUP BY 1,2,3;
After
SELECT
a.id,
a.name,
b.amount,
SUM(c.score) AS total_score
FROM users a
LEFT JOIN orders b ON a.id = b.user_id
INNER JOIN scores c ON a.id = c.user_id
WHERE a.status = 'active'
AND b.amount > 500
QUALIFY ROW_NUMBER() OVER (PARTITION BY a.id ORDER BY b.amount DESC) = 1
GROUP BY
1,
2,
3;
Release Notes
0.0.1
Initial release of franks-sql-formatter
0.0.2
Minor: Update logo and README.
