run migration scripts incrementally using postgres in the cli

Package no longer supported, use @ovotech/pg-sql-migrate:^2.0.0. It includes a cli
Last updated a year ago by ikerin .
Apache-2.0 · Original npm · Tarball · package.json
$ cnpm install @ovotech/pg-sql-migrate-cli 
SYNC missed versions from official npm registry.

Postgres migration tool with plain sql

A cli tool to simplify using @ovotech/pg-sql-migrate.

Using with CLI

yarn add @ovotech/pg-sql-migrate-sql
yarn pg-migrate create my_migration

add a configuration file, which by default is ./pg-sql-migrate.config.json to configure the connection:

  "client": "postgresql://postgres:dev-pass@"

This will create a file migrations/<timestamp>_my_migration.pgsql that you can place raw sql into. After that, you can run the migration(s) by calling

yarn pg-migrate execute

Running the tests

You can run the tests with:

yarn test

Coding style (linting, etc) tests

Style is maintained with prettier and tslint

yarn lint


Deployment is preferment by lerna automatically on merge / push to master, but you'll need to bump the package version numbers yourself. Only updated packages with newer versions will be pushed to the npm registry.


Have a bug? File an issue with a simple example that reproduces this so we can take a look & confirm.

Want to make a change? Submit a PR, explain why it's useful, and make sure you've updated the docs (this file) and the tests (see test folder).


This project is licensed under Apache 2 - see the LICENSE file for details

Current Tags

  • 1.0.3                                ...           latest (a year ago)

4 Versions

  • 1.0.3 [deprecated]           ...           a year ago
  • 1.0.2 [deprecated]           ...           2 years ago
  • 1.0.1 [deprecated]           ...           2 years ago
  • 1.0.0 [deprecated]           ...           2 years ago
Today 0
This Week 0
This Month 0
Last Day 0
Last Week 0
Last Month 0
Dependencies (2)
Dev Dependencies (14)
Dependents (0)

Copyright 2014 - 2017 © taobao.org |