sqlfmt

What sqlfmt is

sqlfmt is a web-based SQL formatter and validator for preparing and checking queries. Choose a supported dialect and configure keyword case, indentation, comma style, and line width; it can also flag misspelled keywords. Its validator parses SQL for PostgreSQL, MySQL, SQLite, SQL Server (T-SQL), and BigQuery, and reports syntax errors with their line and column. Formatting, validation, and typo suggestions run locally in the browser. SQL is sent to the service when you save a snippet or create a shareable link. The Free plan costs nothing and includes 20 analyses per day, all five dialects, live formatting, saved snippets, and history. Pro costs $9 a month and includes unlimited analyses and REST API access with API keys. Pro API users can send requests to POST /api/v1/analyze, with a limit of 60 requests per minute per key; the API reference has examples for Shell, Node, Python, Ruby, and PHP. sqlfmt was built by Sharon Ben-Moshe. It is available on the web and as an API, and supports CI/CD integration.

Who it suits

sqlfmt suits people who want to format SQL and check syntax or misspelled keywords across its five supported dialects. Its Free plan accommodates up to 20 analyses per day, while Pro adds unlimited analyses and API access for users who need those capabilities.

Limits

The Free plan allows 20 analyses per day. REST API access is included with Pro, which costs $9 a month; each API key is limited to 60 requests per minute.

Getting started

1. Open https://www.sqlfmt.app/.
2. Choose a supported SQL dialect.
3. Set keyword case, indentation, comma style, and line width.
4. Use the Free plan for up to 20 analyses per day, or Pro for unlimited analyses and API access.
5. Sign in with Google or GitHub to save snippets and formatting options.

Verdict

Choose sqlfmt for browser-based SQL formatting and validation across its five supported dialects, especially if the Free plan's daily allowance is enough. Choose Pro at $9 a month for unlimited analyses and API access.