Skip to main content

Utilities to assist in database schema versioning

Project description

Pyrseas provides utilities to describe a PostgreSQL database schema as YAML, to verify the schema against the same or a different database and to generate SQL that will modify the schema to match the YAML description.


  • Outputs a YAML description of a Postgres database’s tables and other objects (metadata), suitable for storing in a version control repository

  • Generates SQL statements to modify a database so that it will match an input YAML/JSON specification

  • Generates an augmented YAML description of a Postgres database from its catalogs and an augmentation specification.


  • PostgreSQL 10 or higher

  • Python 3.7 or higher


Pyrseas is free (libre) software and is distributed under the BSD license. Please see the LICENSE file for details.


Please visit Read the Docs for the latest documentation.

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release. See tutorial on generating distribution archives.

Built Distribution

Pyrseas-0.10.0-py2.py3-none-any.whl (113.9 kB view hashes)

Uploaded py2 py3

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page