pgadmin-org / pgadmin-org/pgadmin4

Schema Diff CLI

Open
#7,847 0 comments 3 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Feature
Dominant language
Python
Stars
3.8k
Forks
891
Avg merge
4d 7h
Merged PRs (30d)
8

Description

Describe the solution you'd like

We are using pgAdmin for our database management but not having a cli interface creates a need for extra dependencies. Maybe I am missing it but it would be really helpful to have a cli tool for at least schema diff and migration script generation. I saw someone made some progress on their own but discussion seems inactive. Any plans for this?

Describe alternatives you've considered

Some other tools like liquibase, sqitch etc. but they come with lots of things we do not want.

Additional context

Would be really helpful to integrate this to our CI/CD

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

The issue proposes a CLI for PostgreSQL schema diffs and migration-script generation, with CI/CD integration, but names no files, tests, or entry points. First identify any existing pgAdmin CLI or schema-comparison entry point, then define the command scope and completion criteria before implementation.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python
Domain
ci-cd, cli, databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.