How can I contribute to the project?

The code is hosted on GitHub. You can provide feedback, submit pull requests, or report issues on the GitHub repository.

Does it support Visual Studio Code?

Yes, a Visual Studio Code extension is available on the Visual Studio Marketplace.

Poor Man's T-SQL Formatter

Poor Man's T-SQL Formatter | Find AI List

Overview

Poor Man's T-SQL Formatter is a free, open-source tool designed to format SQL (T-SQL) scripts. It handles complete multi-batch scripts, including object definition scripts like stored procedures and triggers. The tool provides options to cater to different formatting styles and standards, including the option to output "colorized" HTML code. It also offers a "minifier" option to strip comments and whitespace, suitable for obfuscation. Available as a SSMS and Visual Studio add-in/extension, Notepad++ plugin, command-line utility, Winforms app, WinMerge plugin, and JS library. Written in C#, it employs a pluggable design, intending to support other SQL dialects in the future. The formatter offers various integration points, including a command-line utility for bulk formatting and a WinMerge plugin for comparing SQL files based on content changes only.

Common tasks

SQL Formatting Code Minification Syntax Highlighting

FAQ

View all

What SQL dialects are supported?

Currently, the formatter primarily supports T-SQL. However, the pluggable design aims to allow support for other SQL dialects in the future.

How do I install the Notepad++ plugin?

For Notepad++ 7.6.3 and later, create a new folder called "PoorMansTSqlFormatterNppPlugin" in your Notepad++ install folder's "plugins" subfolder and unzip the contents of the ZIP file into this folder. For older versions, unzip directly into the plugins folder.

Is there a command-line version available?

Yes, there is a command-line bulk formatting utility available for Windows (.Net) and other environments (node/npm).

Can I use this in a commercial project?

The tool is available as a .Net 2.0/3.5 library and a JS library, both of which can be used in other GPL/AGPL projects or internal non-distributed projects. Check the licensing for full details.

FAQ+