xataio/pgroll

View on GitHub

PostgreSQL zero-downtime migrations made easy

Stars: 6.6k
Forks: 153
Open beginner issues: 0
Indexed issues: 86

Dominant language: Go
License: Apache-2.0
Last GitHub push: Sep 8, 2026
Latest indexed: Sep 20, 2026
Contributing guide: No contributing guide
Code of conduct: No code of conduct
Beginner labels: good first issue hacktoberfest help wanted
PR merge metrics: No merged PRs in 30d

Beginner friendly Everything

Open All

86 open issues indexed

Unexpected migration schema numbering Open

bug

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

xataio/pgroll#1041 · 5 comments · Opened Jun 17, 2026
GENERATED ALWAYS columns not supported for operation with backfill ? Open

bug

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

xataio/pgroll#1035 · 3 comments · Opened May 26, 2026
Setting search_path assumes database clients have access to migration schemas Open

documentation question

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

xataio/pgroll#1032 · 1 comment · Opened May 11, 2026
Spurious "table does not exist" errors applying simple migration. Open

bug documentation

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

xataio/pgroll#1029 · 1 comment · Opened May 3, 2026
Check expressions in create_constraint break when column name appears as substring in a function name Open

bug

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

xataio/pgroll#1028 · 1 comment · Opened Apr 16, 2026
Discord link in the website is invalid Open

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

xataio/pgroll#1026 · Opened Apr 5, 2026
Versioned-schema views can block pg_partman retention drops on partition child tables Open

sql2pgroll

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

xataio/pgroll#1024 · 1 comment · Opened Mar 9, 2026
Pgroll migration fails to create index when under load, but succeeds after nth time. Open

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

xataio/pgroll#1013 · 1 comment · 1 reaction · Opened Jan 9, 2026
PG error when creating baseline version Open

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

xataio/pgroll#1010 · 1 comment · Opened Dec 18, 2025
pgroll support for changing primary keys Open

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

xataio/pgroll#1006 · 1 comment · Opened Dec 11, 2025
pgroll convert fails when converting from raw sql . Open

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

xataio/pgroll#1004 · Opened Nov 22, 2025
pgroll creates and deletes predicate index on complete if multiple operations are combined Open

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

xataio/pgroll#1003 · Opened Nov 21, 2025
pgroll migrate exits 0 even if command is not successful Open

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

xataio/pgroll#999 · Opened Nov 19, 2025
pgroll convert on some drizzle-kit generate output is unresolvable Open

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

xataio/pgroll#998 · 3 comments · 2 reactions · Opened Nov 12, 2025
Application Code Configuration with schema versioning Open

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

xataio/pgroll#997 · 1 comment · Opened Nov 12, 2025
pgroll init --role app_admin ignores --role Open

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

xataio/pgroll#993 · 2 comments · 1 reaction · Opened Nov 10, 2025
Preserve column order when creating views for table abstractions Open

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

xataio/pgroll#989 · Opened Oct 15, 2025
pg: role "postgres" does not exist on pgroll init Open

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

xataio/pgroll#970 · 3 comments · Opened Aug 22, 2025
Error during `pgroll start 01_files.yaml` does not revert schema changes Open

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

xataio/pgroll#966 · 1 reaction · Opened Aug 12, 2025
Generated (stored) columns are treated as column with default value, which breaks versioned schema views Open

bug

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

xataio/pgroll#965 · 5 comments · 2 reactions · Opened Aug 12, 2025
Add a way to view the migration plan in pgroll Open

enhancement

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

xataio/pgroll#956 · 4 reactions · Opened Jul 28, 2025
Add a new command to get latest schema from migration files instead of the db Open

enhancement

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

xataio/pgroll#954 · 4 comments · 1 reaction · Opened Jul 19, 2025
Allow raw SQL operations to run in migrations with other operations Open

enhancement

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

xataio/pgroll#943 · 3 comments · 3 reactions · Opened Jul 1, 2025
Changing multiple columns of composite primary key is not supported Open

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

xataio/pgroll#933 · Opened Jun 24, 2025
Undesired behaviour of `LAST_VALUE()` during batch update query generation for backfilling Open

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

xataio/pgroll#908 · 2 comments · Opened Jun 16, 2025
Explicit Transaction management needed in few areas and also need `pgbench` testing Open

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

xataio/pgroll#907 · 2 comments · Opened Jun 16, 2025
`INSERT` and `UPDATE` queries can fail between dropping the column and dropping the trigger during `COMPLETE` or `ROLLBACK` phase Open

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

xataio/pgroll#906 · Opened Jun 16, 2025
`INSERT` and `UPDATE` queries can fail in the window between temporary column creation and trigger creation during the `START` phase Open

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

xataio/pgroll#905 · Opened Jun 16, 2025
Option to disable animations and colors. Open

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

xataio/pgroll#895 · Opened Jun 13, 2025
Make it easy to find cli-definition.json for a released version Open

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

xataio/pgroll#866 · Opened Jun 4, 2025
Adding constraints spanning multiple `NOT NULL` columns can fail unexpectedly Open

bug

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

xataio/pgroll#830 · Opened May 13, 2025
Investigate alternatives to using `search_path` to distinguish schema versions Open

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

xataio/pgroll#829 · 2 comments · 4 reactions · Opened May 12, 2025
pgroll cannot recover from broken migration state Open

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

xataio/pgroll#786 · 5 reactions · Opened Apr 8, 2025
Run `sql` migrations in transactions Open

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

xataio/pgroll#785 · 3 reactions · Opened Apr 8, 2025
Remove support for PG14 Open

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

xataio/pgroll#751 · Opened Mar 26, 2025
Support `NULLS NOT DISTINCT` Open

xataio/pgroll#730 · 2 comments · 1 assignee · Opened Mar 17, 2025
`COPY` statements unsupported Open

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

xataio/pgroll#729 · 3 comments · Opened Mar 14, 2025
`pgroll migrate --squash` Open

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

xataio/pgroll#725 · 3 comments · 4 reactions · Opened Mar 13, 2025
pgroll migrate command to complete existing migration Open

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

xataio/pgroll#724 · 4 comments · Opened Mar 13, 2025
`pgroll convert` higher level to watch for new generated .sql files Open

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

xataio/pgroll#721 · 1 comment · Opened Mar 13, 2025
Docs: Link to top level flags and env vars from every cli command Open

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

xataio/pgroll#718 · 1 comment · Opened Mar 13, 2025
`pgroll init` defaults to localhost:5432 Open

enhancement

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

xataio/pgroll#717 · 4 comments · Opened Mar 13, 2025
Remove the `rename_constraint` operation Open

breaking-changes

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

xataio/pgroll#686 · Opened Feb 14, 2025
Transform complete SQL migration files into pgroll operations Open

sql2pgroll

xataio/pgroll#683 · 4 reactions · 1 assignee · Opened Feb 13, 2025
Unify constraint options in all migrations Open

xataio/pgroll#680 · 1 comment · 1 assignee · Opened Feb 13, 2025
[feature request] exclusion constraints Open

enhancement

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

xataio/pgroll#677 · 1 comment · Opened Feb 12, 2025
Use JSON schema validation during `Validate` phase Open

good first issue

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

xataio/pgroll#673 · 2 comments · Opened Feb 11, 2025
Remove `comment` from `alter_column` operations Open

breaking-changes

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

xataio/pgroll#663 · 1 comment · Opened Feb 7, 2025
Support multiple backfill-requiring changes to the same column in a single migration Open

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

xataio/pgroll#659 · Opened Feb 6, 2025
Multiple backfill-requiring operations in the same migration cause redundant backfills Open

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

xataio/pgroll#646 · Opened Jan 31, 2025

xataio/pgroll

Get new issues in your inbox