pgFormatter

pgFormatter is ranked #13 of 34 in code formatting tools on The Geeks Club. It runs on API, Linux, Self-hosted, Web. There is a free plan.

pgFormatter plans and pricing

pgFormatter Free Free software distributed under the PostgreSQL Licence github.com · 30 Sept 2026

Compared on code formatting tools

Free plan: Yes

Best pgFormatter alternatives

7.2 autopep8

7.2 Dart pub

7.2 gofmt Free plan

7.2 Prettier Free plan

7.1 Accessibility Test Framework for Android Free plan

7.1 Biome Free plan

pgFormatter

Purpose: pgFormatter beautifies PostgreSQL SQL queries and PL/pgSQL code, and supports keywords from several SQL standards as well as PostgreSQL-specific keywords.
Other databases: The project says pgFormatter also works with other databases.
Ways to run: It can run as a console program or a CGI application, producing text or HTML based on its environment.
Formatting options: Options include changing keyword, function, identifier, and type case; adjusting indentation; wrapping queries; and choosing comma placement.
Anonymization: The command line option --anonymize obscures query literals before formatting.
JSON API: When called as a CGI application with an Accept: application/json header, pgFormatter can return a JSON response; the API can be disabled in its CGI configuration.
Online demo limit: The README describes an online demo that limits SQL queries to ten thousand characters.
Installation: The README documents installation from a GitHub source tarball using Perl Makefile.PL, make, and make install.
Docker: The project documents building a Docker image and piping SQL input to a container running pgFormatter.
Editor integrations: The README describes use with Vim and (Neo)Vim and links to Atom and Visual Studio Code integrations.
Pre-commit integration: The README documents configuring pgFormatter as a pre-commit hook for SQL files.
Security and privacy: The anonymization option is described as useful for hiding confidential data before formatting; the repository page opened did not state security certifications or compliance claims.
Support and limits: The README notes that pgFormatter cannot detect user-defined functions or keywords for other databases automatically, but allows custom lists for them.
Maker and license: The README credits Gilles Darold as the original author and says pgFormatter is free software distributed under the PostgreSQL Licence.
Price from: Free

Visit site Alternatives

Where it ranks on The Geeks Club

Best Code Formatting Tools in 2026#13 of 34
Best SQL Linters and Formatters in 2026#7 of 26

Is pgFormatter yours?

Claim it for free: prove the domain, then correct facts, plans and screenshots. An editor reviews every change.

Claim it free Promote pgFormatter

Sources

github.com/darold/pgformatter· checked 30 Sept 2026