PHPackages                             davidburger/pgup - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. davidburger/pgup

ActiveLibrary[Database & ORM](/categories/database)

davidburger/pgup
================

PHP PostgreSQL database migration tool

v1.2(10y ago)0162Apache-2.0PHPPHP >=5.3.3

Since May 23Pushed 10y ago1 watchersCompare

[ Source](https://github.com/davidburger/pgup)[ Packagist](https://packagist.org/packages/davidburger/pgup)[ Docs](https://github.com/davidburger/pgup)[ RSS](/packages/davidburger-pgup/feed)WikiDiscussions master Synced 4w ago

READMEChangelogDependenciesVersions (4)Used By (0)

Simple PHP Postgres database migration tool
===========================================

[](#simple-php-postgres-database-migration-tool)

---

Useful for synchronization of database changes within development team.

Installation
------------

[](#installation)

```
composer require davidburger/pgup
```

Prerequisities
--------------

[](#prerequisities)

- psql client must be installed

```
# debian/ubuntu:
sudo apt-get install postgresql-client
```

- PDO\_PGSQL driver is required for sync\_mode = 'database'

Setup
-----

[](#setup)

- if `/migrations` folder does not exist, it will be created with initial config file

```
cd
./vendor/bin/pgup
```

- edit database credentials in `/migrations/config/global.php`

Basic principles
----------------

[](#basic-principles)

- password for individual hosts are stored in ~.pgpass - see
- if ~/.pgpass does not exist, it is created automatically
- sql files could be successfully processed only once for given environment - they are checked for their equivalent stored in "applied" folder (sync\_mode = filesystem) or in the database table "migration" (sync\_mode = database)
- output is written to the path defined by 'log\_dir' configuration variable

Usage
-----

[](#usage)

- create empty sql migration file from template:

```
php vendor/bin/pgup create --comment="add_new_table"
```

- process migration files:

```
php vendor/bin/pgup
```

- process migration files for specific environment:

```
php vendor/bin/pgup --env=development
```

###  Health Score

27

—

LowBetter than 47% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity10

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity60

Established project with proven stability

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~18 days

Total

3

Last Release

3655d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/d55a5ae319b7b7bce01e36327497d29f25bb8d509f552bcb29be2c407672ec02?d=identicon)[davidburger](/maintainers/davidburger)

---

Top Contributors

[![davidburger](https://avatars.githubusercontent.com/u/7066003?v=4)](https://github.com/davidburger "davidburger (1 commits)")

---

Tags

migrationdatabasepostgresqlpostgres

### Embed Badge

![Health badge](/badges/davidburger-pgup/health.svg)

```
[![Health](https://phpackages.com/badges/davidburger-pgup/health.svg)](https://phpackages.com/packages/davidburger-pgup)
```

###  Alternatives

[scienta/doctrine-json-functions

A set of extensions to Doctrine that add support for json query functions.

58825.9M49](/packages/scienta-doctrine-json-functions)[aura/sqlquery

Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.

4883.1M37](/packages/aura-sqlquery)[aura/sqlschema

Provides facilities to read table names and table columns from a database using PDO.

44243.2k4](/packages/aura-sqlschema)[atlas/query

Object-oriented query builders and performers for MySQL, Postgres, SQLite, and SQLServer.

41256.9k7](/packages/atlas-query)[sad_spirit/pg_wrapper

Converter of complex PostgreSQL types and an OO wrapper for PHP's pgsql extension

2212.2k2](/packages/sad-spirit-pg-wrapper)[schema-keeper/schema-keeper

Track PostgreSQL schema as one-file-per-object dumps. Detect drift in CI. Read-only — complements your migrations.

136.1k](/packages/schema-keeper-schema-keeper)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)