Serverless PG Migrations

Database migrations for AWS Lambda and RDS using Sequelize Migrations.

About

This Serverless plugin can execute and rollback database migrations after deploys. See Usage

Heavily inspired by transmogrify. I tried to use it but encountered a lot of showstopping bugs for me, so I wrote my own, smaller and simpler version.

Notable differences from transmogrify:

• This plugin does not attempt to add handlers automatically (see Adding handlers)
• This plugin does not create or drop databases
• This plugin does not have a handler for checking database connection

Migrations

The plugin assumes that migration files live in a migrations directory inside your project.

For details on using migrations please see the Sequelize Migration docs.

Installation

yarn add serverless-pg-migrations OR npm install serverless-pg-migrations

Usage

Define a migration handler somewhere in your project. Example:

// /migrations.js

const { up, down } = require("serverless-pg-migrations/handlers");

module.exports.up = up;

module.exports.down = down;

Add the plugin and handlers to your serverless.yml:

provider:
  name: aws

plugins:
  - serverless-pg-migrations

up:
  handler: migrations.up
  timeout: 30
  environment:
    DATABASE_URL: postgres://root:password@domain.rds.amazonaws.com:5432/Database
down:
  handler: migrations.down
  timeout: 30
  environment:
    DATABASE_URL: postgres://root:password@domain.rds.amazonaws.com:5432/Database

Pass the function to the serverless deploy command to have it execute after the deploy is finished:

sls deploy --function up

You can also manually invoke the functions locally:

sls invoke local --function up

Or use the plugin directly without going through your function:

sls migrate up
sls migrate down

Configuration

The provided migration handlers can be imported with const { up, down} = require("serverless-pg-migrations/handlers").

The functions need to have the environment variable DATABASE_URL set to a valid pg connection uri.