darold/pgFormatter

View on GitHub

A PostgreSQL SQL syntax beautifier that can work as a console program or as a CGI. On-line demo site at http://sqlformat.darold.net/

Stars: 2k
Forks: 121
Open beginner issues: 0
Indexed issues: 17
Avg merge: 4d 21h
Merged PRs (30d): 7

Dominant language: PLpgSQL
License: PostgreSQL
Last GitHub push: Sep 19, 2026
Latest indexed: Sep 20, 2026
Contributing guide: No contributing guide
Code of conduct: No code of conduct
Beginner labels: No beginner labels indexed

Beginner friendly Everything

Open All

17 open issues indexed

Proposal: optional matching-parenthesis line breaks Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

darold/pgFormatter#417 · Opened Sep 19, 2026
vertical-align may stop working with certain CHECK constraint expressions Open

Difficulty 4/5 3-5 days Newbie friendliness 52/100

darold/pgFormatter#412 · Opened Sep 14, 2026
Bad indentation with subquery inside nested paratheses Open

Difficulty 3/5 1-2 days Newbie friendliness 58/100

darold/pgFormatter#391 · 1 comment · Opened Apr 14, 2026
Add support for json_agg formatting Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 45/100

darold/pgFormatter#351 · 5 reactions · Opened Jan 13, 2025
bad formatig on create table with clause Open

Difficulty 3/5 1-2 days Newbie friendliness 42/100

darold/pgFormatter#347 · Opened Sep 24, 2024
Ability to work in streaming mode Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

darold/pgFormatter#333 · 4 comments · 1 reaction · Opened Mar 5, 2024
How to preserve as least 1 newline between comments? Open

Difficulty 3/5 1-2 days Newbie friendliness 42/100

darold/pgFormatter#328 · 2 comments · 5 reactions · Opened Dec 25, 2023
Create Table with "WITH" Inline Function Not Have Correct Indentation Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

darold/pgFormatter#324 · Opened Sep 16, 2023
Formatting Help (Potential Feature Request) Open

Difficulty 3/5 1-2 days Newbie friendliness 30/100

darold/pgFormatter#308 · 1 comment · Opened Mar 8, 2023
Breaks query when CTE is present Open

Difficulty 4/5 3-5 days Newbie friendliness 42/100

darold/pgFormatter#296 · 1 comment · Opened Oct 20, 2022
Nested CTEs identation problem Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

darold/pgFormatter#290 · 1 reaction · Opened Aug 10, 2022
Bad indentation with nested array syntax Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

darold/pgFormatter#273 · Opened Dec 28, 2021
Bad indentation for CTE and `Count(*) AS` in return query statement Open

Difficulty 3/5 1-2 days Newbie friendliness 42/100

darold/pgFormatter#258 · 2 comments · 1 reaction · Opened Aug 28, 2021
indentation of FROM and WHERE in longer subquery doesn't match Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

darold/pgFormatter#243 · 1 comment · 1 reaction · Opened Apr 8, 2021
Indentation breaks when `HAVING` clause with subquery is used Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

darold/pgFormatter#195 · Opened May 18, 2020
create newline before right parenthesis and reset indent Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 35/100

darold/pgFormatter#177 · 2 comments · 9 reactions · Opened Apr 9, 2020
idea: can you support Joe Celko SQL formatting? Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

darold/pgFormatter#40 · 5 comments · 11 reactions · Opened Aug 22, 2017

darold/pgFormatter

Get new issues in your inbox