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.
Pyrseas is in the process of being re-implemented as C++23 modules as
part of the Perseid project.
Features
- 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.
Requirements
- PostgreSQL 10 or higher
- Python 3.7 or higher
License
Pyrseas is free (libre) software and is distributed under the BSD
license. Please see the LICENSE file for details.
Documentation
Please visit Read the Docs
for the latest documentation.
View the README on GitHub(opens in a new tab)
