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.

Want to learn about other SQL terms?

dbt tests

dbt tests are declarative assertions in dbt that automatically validate data quality during model builds.

dbt utils

dbt utils is a community-maintained dbt package that adds time-saving utility macros for analytics engineers, such as generating surrogate keys, safely unioning models, and automating date spines.

dbt Tutorial Glossary: Build, Test & Deploy SQL Models

dbt is an open-source framework that lets data teams transform raw warehouse tables into tested, documented, production-ready datasets using version-controlled SQL.

Trusted by top engineers on high-velocity teams