Thought this was an interesting meltano use case so I thought I'd share this portion of the meltano.yml

- name: alembic
    namespace: alembic
    pip_url: alembic>=1.13.1 psycopg2-binary>=2.9.3 # alembic requires psycopg2 to work with Postgres but it doesn't install as a dependency automatically
    commands:
      upgrade:
        args: upgrade head
        description: Upgrade to the latest version of the database schema.
      downgrade:
        args: downgrade base
        description: Downgrade to the initial version of the database schema.