pgCodeKeeper User Guide

The pgCodeKeeper plug-in is designed for comparing PostgreSQL, MS SQL Server, Greenplum, Clickhouse database schemas and selective applying the differences, considering possible dependencies between the schema objects.

Work in pgCodeKeeper is conducted with the help of projects. A project is represented by DB schema objects, stored in separate files with hierarchical structure.

Using the project, it is possible to view the structure of files-objects and create a project scheme migration script for DB or vice versa, modify the project structure with objects from a DB.

pgCodeKeeper source code is available at GitHub for free.

Supported database versions:

  • PostgreSQL 9.4+

  • MS SQL 2012+

  • ClickHouse 23+

  • Greenplum 6+