stripe/pg-schema-diff

View on GitHub

Go library for diffing Postgres schemas and generating SQL migrations

Stars: 884
Forks: 82
Open beginner issues: 0
Indexed issues: 61

Dominant language: Go
License: MIT
Last GitHub push: Aug 6, 2026
Latest indexed: Sep 19, 2026
Contributing guide: Contributing guide
Code of conduct: Code of conduct
Beginner labels: good first issue
PR merge metrics: No merged PRs in 30d

Beginner friendly Everything

Open All

61 open issues indexed

[BUG] "prohibited" misspelled as "prohited" Open

bug

Difficulty 1/5 Under an hour Newbie friendliness 76/100

stripe/pg-schema-diff#302 · 1 comment · Opened Jul 29, 2026
[BUG] Plan fails when altering an INCLUDE column of a referenced primary key Open

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

stripe/pg-schema-diff#301 · Opened Jul 23, 2026
Is the repo active? Open

Difficulty 1/5 Under an hour Newbie friendliness 15/100

stripe/pg-schema-diff#289 · 7 reactions · Opened May 28, 2026
Views that call functions are not ordered after those functions Open

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

stripe/pg-schema-diff#284 · Opened May 15, 2026
View dependency query produces false positives and misses view-to-view dependencies Open

Difficulty 2/5 1-3 hours Newbie friendliness 82/100

stripe/pg-schema-diff#283 · 1 reaction · Opened May 15, 2026
Function body table/view references not tracked for dependency ordering Open

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

stripe/pg-schema-diff#282 · Opened May 15, 2026
[BUG] Postgres error when changing column type of a table with dependant view Open

bug

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

stripe/pg-schema-diff#280 · Opened May 6, 2026
[BUG] Deferrable unique constraint produces error and spurious diff in plan Open

bug

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

stripe/pg-schema-diff#273 · Opened Mar 28, 2026
pg-schema-diff plan ignores VIEW ACL diffs (both missing GRANT and missing REVOKE) Open

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

stripe/pg-schema-diff#271 · Opened Mar 9, 2026
Add --no-privileges flag to exclude GRANT/REVOKE from plan/apply Open

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

stripe/pg-schema-diff#269 · 7 reactions · Opened Feb 10, 2026
Add support for schema privileges Open

enhancement

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

stripe/pg-schema-diff#267 · Opened Feb 4, 2026
[BUG] Policy ordering: policy created before referenced table exists Open

bug

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

stripe/pg-schema-diff#266 · 1 comment · Opened Jan 14, 2026
[BUG] Failing to handle indexes with expressions in Open

bug

Difficulty 2/5 1-3 hours Newbie friendliness 48/100

stripe/pg-schema-diff#253 · Opened Dec 3, 2025
[FEATURE] Support deleting partitions without dropping parent table Open

enhancement

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

stripe/pg-schema-diff#252 · Opened Nov 28, 2025
[FEATURE] Add Option to Automatically Drop Functions When Return Type Changes Open

enhancement

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

stripe/pg-schema-diff#251 · Opened Nov 11, 2025
[FEATURE] Support swapping primary keys instead of dropping + creating Open

enhancement

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

stripe/pg-schema-diff#250 · 1 reaction · Opened Nov 7, 2025
[FEATURE] Add release binaries using a workflow Open

enhancement

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

stripe/pg-schema-diff#249 · 3 reactions · Opened Oct 10, 2025
[BUG] Functions with knowable dependencies are created before the tables they depend on Open

bug

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

stripe/pg-schema-diff#248 · 5 reactions · Opened Oct 1, 2025
[BUG] Tests fail to run successfully on the latest version 9966185 Open

bug

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

stripe/pg-schema-diff#247 · 2 comments · Opened Sep 18, 2025
[BUG] diff command generates superflous orders Open

bug

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

stripe/pg-schema-diff#246 · 7 comments · 6 reactions · Opened Sep 11, 2025
[FEATURE] Option to generate idempotent SQL Open

enhancement

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

stripe/pg-schema-diff#241 · 1 reaction · Opened Aug 29, 2025
[FEATURE] option to write out migration files Open

enhancement

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

stripe/pg-schema-diff#221 · 3 comments · 3 reactions · Opened Jul 26, 2025
[BUG] Constraint triggers generate invalid plans Open

bug

stripe/pg-schema-diff#213 · 1 comment · 1 assignee · Opened Jun 18, 2025
[BUG] Wrong statement when using `generated always as` Open

bug

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

stripe/pg-schema-diff#212 · Opened Jun 10, 2025
[QUESTION] Can I compare 2 schemas named differently? Open

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

stripe/pg-schema-diff#210 · Opened May 20, 2025
[FEATURE] Support for policies on partitions Open

enhancement

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

stripe/pg-schema-diff#209 · Opened May 19, 2025
[FEATURE] v13 support Open

enhancement

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

stripe/pg-schema-diff#208 · 1 comment · Opened May 12, 2025
[FEATURE] Diff and preserve comments Open

enhancement

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

stripe/pg-schema-diff#207 · 4 reactions · Opened May 2, 2025
[BUG] Foreign keys between tables in separate schemas fail Open

bug

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

stripe/pg-schema-diff#206 · 1 comment · Opened May 1, 2025
[FEATURE] Support for domains Open

enhancement

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

stripe/pg-schema-diff#205 · Opened Apr 23, 2025
Implementing my custom SchemaSource Open

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

stripe/pg-schema-diff#203 · Opened Apr 14, 2025
[FEATURE] Add support for excluding tables Open

enhancement

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

stripe/pg-schema-diff#197 · 1 comment · 1 reaction · Opened Mar 30, 2025
Dependency missed with a function used as default value Open

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

stripe/pg-schema-diff#191 · 1 comment · Opened Feb 6, 2025
Check constraints that depend on UDFs Open

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

stripe/pg-schema-diff#184 · 3 comments · 4 reactions · Opened Dec 5, 2024
[FEATURE] Support switching between non-coercible types via drop/add Open

enhancement good first issue

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

stripe/pg-schema-diff#179 · 2 comments · Opened Nov 8, 2024
[FEATURE] : Support User defined Types Open

enhancement

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

stripe/pg-schema-diff#178 · 1 comment · Opened Nov 1, 2024
[Question] Why not use `pg_dump --schema-only` to populate temporary database? Open

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

stripe/pg-schema-diff#170 · 3 comments · Opened Sep 4, 2024
Question : Can we have tables in destination but delete from source Open

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

stripe/pg-schema-diff#161 · 6 comments · Opened Aug 27, 2024
Add an ability to Save plan files Open

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

stripe/pg-schema-diff#157 · 1 comment · Opened Aug 26, 2024
Creating a FAQ/Troubleshooting Doc Open

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

stripe/pg-schema-diff#156 · 1 reaction · Opened Aug 26, 2024
Merge lock timeout and statement timeout modifier into one parameter Open

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

stripe/pg-schema-diff#145 · Opened Jul 11, 2024
Accelerate migration planning through pipelined statements Open

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

stripe/pg-schema-diff#144 · Opened Jul 10, 2024
Implement retry system Open

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

stripe/pg-schema-diff#143 · 1 reaction · Opened Jul 10, 2024
View support Open

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

stripe/pg-schema-diff#135 · 4 comments · 3 reactions · Opened May 29, 2024
Make statement generation and ordering independent Open

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

stripe/pg-schema-diff#131 · Opened May 27, 2024
Better dependency tracking for non-sql functions Open

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

stripe/pg-schema-diff#129 · 12 comments · Opened May 6, 2024
Create a user-facing ergnomic representation of schema Open

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

stripe/pg-schema-diff#126 · Opened Apr 22, 2024
Consider allowing users to define a .pg-schema-diff.yaml file that the CLI will read-in so users can quickly run the CLI Open

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

stripe/pg-schema-diff#121 · Opened Mar 30, 2024
Considering adding warning if a migration's success is dependent on the data Open

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

stripe/pg-schema-diff#114 · 1 reaction · Opened Feb 16, 2024
Create wrapper around schema name maps such that they can only be queried with a SchemaQualifiedName Open

tech debt

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

stripe/pg-schema-diff#103 · 3 comments · Opened Feb 2, 2024

stripe/pg-schema-diff

Get new issues in your inbox