Poor SQL
poorsql.com
- Free plan
- Open source
- Windows
- Linux
- Web
- Browser extension
- API
What Poor SQL is
Poor SQL is a T-SQL formatter that reorganizes and colorizes code according to configurable preferences. You can set indentation, spaces per tab, maximum line width, and where statements and clauses break. Other controls expand comma lists, boolean expressions, and CASE expressions, or add breaks within JOIN ON sections. Input SQL, formatted output, and HTML source are available in separate views. An Obfuscate / Minify option can randomize colors, line lengths, and keyword case, or substitute keywords. The site processes formatting in the browser, works offline, and says submitted SQL is not sent to an external service. Downloads include plugins for SQL Server Management Studio, Visual Studio, and WinMerge, plus a command-line bulk formatter. Its open-source library is AGPL-licensed and works with Microsoft .NET and Mono; the JavaScript library can run in browsers and contexts such as Node.js. The project describes its parsing as coarse rather than full, especially for DDL. Poor SQL is free, and settings are remembered with a cookie.
Who it suits
Poor SQL suits T-SQL users who want configurable formatting in a browser, offline, or through supported plugins and command-line tools. Developers building around its library can use its .NET, Mono, or JavaScript options.
Good to know, and what to watch
- Works offline and processes formatting in the browser.
- Offers detailed indentation and line-break controls.
- Provides SSMS, Visual Studio, and WinMerge plugins.
- Includes a downloadable command-line bulk formatter.
- Parsing is coarse rather than full, especially for DDL.
- Blocking cookies restores default settings on each visit.
Plans
Every plan and priceFree
Free plan
Getting started
- Open https://poorsql.com/
- Enter T-SQL in the web interface
- Choose formatting and optional obfuscation settings
- View formatted SQL or HTML source
- Download a plugin or command-line formatter if needed
- Use the API or library in a supported environment
The Club's review
Poor SQL is a free T-SQL formatter for people who want to clean up queries in a browser or from existing development tools. It suits individual developers and teams whose needs fit its built-in formatting options; its coarse parsing makes it a less suitable choice for complex DDL.
Overview
The project brings together a browser formatter, downloadable plugins, a bulk command-line formatter, and the open-source Poor Man’s T-SQL Formatter library. That range lets T-SQL users work in different environments without paying for a plan. The trade-off is scope: it supports T-SQL, and its parsing is deliberately coarse rather than a full SQL parse.
Key features
Formatting controls cover indentation, spaces per tab, maximum width, statement and clause breaks, comma-list expansion, boolean and CASE expansion, and breaks within JOIN ON sections. Users can adjust the shape of the output, but custom rules are not supported, so teams with strict house styles may need another formatter. Automatic fixes are supported.
The browser interface has Input SQL, Formatted SQL, and HTML Source views. Its Obfuscate / Minify option can randomize colors, line lengths, and keyword case, or substitute keywords. Formatting runs locally in the browser, works offline, and the site says submitted SQL is not sent to an external service. This is useful for formatting without sending queries to a remote service, though it does not remove the parser’s limitations.
Downloads include plugins for SQL Server Management Studio, Visual Studio, and WinMerge, as well as a command-line bulk formatter. The AGPL-licensed library works with Microsoft .NET and Mono; its JavaScript library can run in browsers and other contexts such as Node.js. The project also includes a web service and a demo WinForms program. Formatting options are saved in a cookie, so blocking cookies restores the defaults on each visit.
The main caveat is parsing accuracy: the project describes its parsing as coarse, particularly for DDL. That matters when formatting schema definitions or other complex SQL, where users should not assume the tool understands the full structure of the code.
Pricing
Poor SQL is free: the Free plan costs nothing and includes online and offline formatting, the SSMS and Visual Studio plugins, the command-line bulk formatter, and the WinMerge plugin. There are no paid tiers to weigh against those features. The plan is best for users who need T-SQL formatting across these tools and can work within the built-in options and coarse parsing.
Platforms
Poor SQL is available on the web and Windows, with Linux support and an API component. Its libraries also run in .NET, Mono, browsers, and Node.js contexts. The downloadable plugins target SSMS, Visual Studio, and WinMerge; the command-line formatter supports bulk work.
Who it's for
Poor SQL fits T-SQL developers who want a no-cost formatter, prefer local or offline browser processing, or need plugins and batch formatting in an existing workflow. It is less compelling for teams that require custom formatting rules or dependable full parsing of complex DDL.
Pros and cons
Pros
- Local, offline browser formatting keeps SQL in the browser rather than sending it to an external service, according to the site.
- Free plugins, a bulk command-line formatter, and library options serve more than one workflow.
- Detailed built-in controls let users adjust layout, including comma lists, CASE expressions, and JOIN ON sections.
Cons
- Coarse parsing, especially for DDL, limits its fit for complex SQL.
- Custom formatting rules are unavailable, which can be a problem for teams enforcing a house style.
- Cookie-blocking resets formatting preferences to defaults each visit.
Alternatives
SQL Linters and Formatters is a broader list for readers comparing tools across the category. For a free open-source command-line option, consider SQLCheck. If browser-based formatting without installation is the priority, sqlfmt runs through WebAssembly. TSQLLint is another free T-SQL-related option, distributed through dotnet-tool, Homebrew, or NPM. JSQLFormatter is a free alternative for readers looking for a self-hosted option. For CI/CD pipelines and build machines, SQL Enlight offers a dedicated plan with custom pricing. Readers wanting a free web tool with a stated daily analysis allowance and five dialects can consider sqlfmt. Sqruff is another free option. For browser-local formatting combined with monthly AI requests, RegSQL has a free plan.
Verdict
Poor SQL is a sensible free choice for T-SQL developers who want flexible formatting across a browser, plugins, or a command line, especially when local and offline processing matters. Choose another tool if complex DDL needs careful parsing or your team depends on custom formatting rules.
The verdict
Poor SQL offers several ways to format T-SQL, from browser controls to downloadable plugins and a bulk command-line tool. Its coarse parsing, particularly for DDL, is an important limitation to consider.
Questions people ask
Is Poor SQL free?
Yes. The Free plan costs nothing and includes online and offline formatting, SSMS and Visual Studio plugins, a command-line bulk formatter, and a WinMerge plugin.
Which SQL dialect does it support?
Poor SQL supports T-SQL.
Can it work offline?
Yes. Formatting runs locally in the browser, allowing the site to work without an internet connection.
Does it send submitted SQL to an external service?
The formatting process runs in the browser, and submitted SQL is not sent to an external service.
Is the formatter open source?
The Poor Man's T-SQL Formatter library is open-source and AGPL-licensed.
Which integrations are available?
Downloads include plugins for SQL Server Management Studio, Visual Studio, and WinMerge, along with a command-line bulk formatter. The project also includes a web service, add-ins, a demo WinForms program, and library options for .NET, Mono, browsers, and Node.js.
What the maker publishes
- API component
- The project includes a web service alongside its demo WinForms program, add-ins, command-line utility, and plugins. source
- Changelog event
- Version 1.6.10 in November 2017 added Atom and Visual Studio Code plugins and fixed several formatting and installer issues. source
- Command line
- A command-line bulk formatter is available for download. source
- Command-line limitation
- The Node command-line tool does not currently produce syntax-highlighted HTML output. source
- Command-line package
- The Node command-line formatter installs globally with npm and accepts stdin, files, configurable formatting options, and output files. source
- Command-line performance
- The Node command-line implementation reports roughly half a second to format one query on the author’s laptop and describes itself as slower than the .NET formatter. source
- Comment limitation
- The standard formatter can move comments from their original positions in some compound keywords. source
- Community rating status
- Open Hub shows no user rating yet and invites the first rating. source
- Cookie behavior
- Formatting preferences are remembered in a cookie; blocking cookies restores default settings on each visit. source
- Data handling
- The site says SQL submitted for formatting is not sent to any external service and is processed in the browser. source
- DDL limitation
- DDL parsing is described as very coarse and limited to the minimum needed for ordered declarations. source
- Dialect support
- The project is focused on Microsoft T-SQL; support for other SQL dialects is possible but none is implemented as a dedicated dialect. source
- Editor integrations
- Downloads and repositories provide integrations for SSMS, Visual Studio, Notepad++, WinMerge, Atom, and Visual Studio Code. source
- External institutional mention
- A UCSF VA data-resources document lists Poor SQL as a SQL formatting tool among its SQL resources. source
- Formatting controls
- Options include indentation, spaces per tab, maximum width, statement and clause breaks, comma-list expansion, boolean and CASE expansion, and JOIN ON section breaks. source
- Formatting controls
- Controls include indentation, tab spacing, maximum width, statement and clause breaks, comma-list expansion, boolean and CASE expansion, and JOIN ON breaks. source
- Independent comparison
- A Korean SQL Server formatter comparison describes Poor SQL as an instant formatter with configurable options and says it targets SQL Server syntax. source
- Independent mention
- J.D. Hodges lists Poor SQL as a free online alternative for formatting SQL Server queries when SQL Server 2008 lacked a comparable built-in feature. source
- Installation limitation
- The same comparison reports that using the SSMS 2012 add-in required manually copying an AddIn file into the user’s roaming Addins folder. source
- Integrations
- Downloads include plugins for SQL Server Management Studio, Visual Studio, and WinMerge. source
- Library
- The underlying Poor Man’s T-SQL Formatter is a free .NET and JavaScript library with a demo UI, web service, command-line utility, and editor plugins. source
- Library contexts
- The library works with Microsoft .NET and Mono, and the JavaScript library works in browsers and other contexts such as Node.js. source
- Licence
- The project is released under the GNU Affero General Public License version 3. source
- Limit: detail
- The same Curated SQL review says the website is not as detailed as the reviewer wanted, despite being effective for quick formatting. source
Checked against the maker's pages on 14 Oct 2026.