Poor SQL

What is Poor SQL and why is it used?

Poor SQL is a T-SQL formatter that improves code readability across platforms and editors.

Welcome to the Galaxy, Guardian!

Oops! Something went wrong while submitting the form.

Description

Poor SQL, also known as Poor Man’s T-SQL Formatter, is a code formatting tool designed to improve the readability of T-SQL. It supports multiple integration options including:

SSMS Add-In
Command-line usage
Browser-based formatting
Editor plugins (e.g., Notepad++)

It’s open source, cross-platform (C#/.NET and JavaScript versions), and widely used by developers working with SQL Server.

You can try it online at poorsql.com.

Why Poor SQL is important

Readable SQL is easier to debug, share, and maintain. Poor SQL helps enforce consistent formatting and improves collaboration.

Poor SQL Example Usage

Poor SQL Syntax

Common Mistakes

Assuming it formats all SQL dialects (it focuses on T-SQL).
Using it without reviewing formatting settings.
Expecting built-in linting or syntax validation (it's a formatter only).
Not leveraging its CLI or editor integrations.

Frequently Asked Questions (FAQs)

Q: Is Poor SQL free to use?
A: Yes, it is open source and free for personal and commercial use.

Q: Does it support MySQL or PostgreSQL?
A: No, it is designed specifically for formatting T-SQL (SQL Server).

Q: Can it be used in CI/CD pipelines?
A: Yes, with the CLI version you can automate formatting in your workflow.