SQLFormat.org
SQLFormat.org is a free online tool for formatting SQL statements, available through a web page and an API.
What SQLFormat.org is
SQLFormat.org is a free online tool for formatting SQL statements, available through a web page and an API. The browser formatter runs with Pyodide and sqlparse. Users can choose keyword and identifier case, indentation, output format, comment removal, and compact mode. The API formats SQL statements or splits a string into separate statements, returning JSON results; a single IP is limited to 500 requests per hour. The privacy policy says statements processed in the browser are not sent to a server or third party, stored on the server, or logged. It also says IP addresses are logged for security and performance monitoring, and errors are logged to Sentry. The site links to the sqlparse Python module for use in other applications and identifies its license as the New BSD License. That module uses a non-validating, dialect-agnostic parser that can handle syntactically incorrect SQL statements; no specific SQL dialects are listed. Users can provide feedback or report bugs through the page’s Feedback button. The listed contact email is [email protected].
Good
- Free browser-based SQL formatting.
- Offers case, indentation, and output options.
- API formats and splits SQL statements.
- Browser-processed SQL is not sent to servers.
- Links to a New BSD-licensed Python module.
Watch out
- API access is limited to 500 requests per hour per IP.
- No specific SQL dialects are listed.
- IP addresses and errors are logged.
Who it suits
SQLFormat.org suits people who want to format SQL in a browser or through a lightweight API. Its linked Python module may interest developers who want to use sqlparse in their own applications.
Verdict
SQLFormat.org offers straightforward SQL formatting in a browser, with an API for formatting and splitting statements. Its API limit and dialect-agnostic, non-validating parser are worth considering for specialized workflows.
Plans and prices
From SQLFormat.org's own pricing page, checked 4 Oct 2001.
| Plan | Price | What it gives you |
|---|---|---|
| SQLFormat | Free | API: 500 requests per hour per IP |
| Free | Free | browser formatter · API limited to 500 requests/hour/IP · Python module |
The facts
Each one read from SQLFormat.org's own pages, with the date it was checked.
What it does
- API
- The API can format SQL statements and split a string into SQL statements, returning JSON results.checked 4 Oct 2001
- API examples
- The documentation supplies usage examples for Python, JavaScript, Bash, Ruby and PowerShell clients.checked 15 Oct 2001
- API format endpoint
- The API accepts POST requests at /api/v1/format and returns formatted SQL in a JSON result field.checked 15 Oct 2001
- API limit
- API access is limited to 500 requests per hour for one IP address.checked 15 Oct 2001
- API options
- API parameters include reindent, indent_width, identifier_case, keyword_case and strip_comments.checked 15 Oct 2001
- API responses
- The API documents 200, 400, 429 and 500 HTTP responses, with error bodies normally returned as plain text.checked 15 Oct 2001
- API split endpoint
- The /api/v1/split endpoint separates a string containing multiple SQL statements and returns them as a JSON list.checked 15 Oct 2001
- Chrome extension details
- The related SQL Format extension has about 3,000 users, version 4.1, and was updated May 23, 2024.checked 15 Oct 2001
- Command line
- Installing sqlparse also installs a sqlformat command that reads stdin, writes stdout and can edit files in place.checked 15 Oct 2001
- Contact
- The site lists [email protected] as its contact email.checked 4 Oct 2001
- Downloadable code
- The site links to the sqlparse Python module source and says it can be used in your own applications.checked 4 Oct 2001
- Extensibility
- The project documents a pre-commit hook and invites contributions, bug reports and feature requests through GitHub.checked 15 Oct 2001
- File input
- The web interface includes an upload-file control for bringing SQL into the formatter.checked 15 Oct 2001
- Formatting controls
- The interface offers keyword case, identifier case, indentation, output-format, comment-removal and compact-mode controls.checked 15 Oct 2001
- Formatting options
- Options include keyword and identifier case, indentation, output format, comment removal, and compact mode.checked 4 Oct 2001
- Keyboard shortcuts
- Ctrl/Cmd+Enter formats a statement, while Shift+Ctrl/Cmd+Enter formats and copies it.checked 15 Oct 2001
- Latest release
- PyPI lists sqlparse 0.6.0 as released on August 13, 2026, with one maintainer identified as Andi Albrecht.checked 15 Oct 2001
- Licence
- The sqlparse module is released under the New BSD/BSD-3-Clause licence.checked 15 Oct 2001
- License
- The site says the sqlparse module is released under the New BSD License.checked 4 Oct 2001
- Limit: API integration
- A Stack Overflow user reported receiving HTTP 400 responses when posting JSON from R to the format endpoint and used a GET workaround.checked 15 Oct 2001
- Limit: parser security history
- GitHub Security lists high, moderate and critical denial-of-service advisories affecting sqlparse versions, including regex and deeply nested-input issues.checked 15 Oct 2001
- Limit: request volume
- A Stack Overflow question specifically identifies the 500-requests-per-hour single-IP ceiling as a constraint for programmatic use.checked 15 Oct 2001
Where it runs
- Browser processing
- The current web formatter runs Pyodide with sqlparse in the browser, so entered SQL is processed locally.checked 15 Oct 2001
The company
- Company identity
- The SQLFormat merchandise page says Andi runs both sqlformat.org and phasenpunkt.de.checked 15 Oct 2001
