goose – golang database migration tool

go get bitbucket.org/liamstask/goose/cmd/goose

mkdir db

# vim db/dbconf.yml
development:
    driver: mymysql
    open: dbname/username/password
    import: github.com/ziutek/mymysql/godrv
    dialect: mysql

goose create init sql

goose up

goose down

goose redo

goose status

-- +goose Up
CREATE TABLE post (
    id int NOT NULL,
    title text,
    body text,
    PRIMARY KEY(id)
);

-- +goose Down
DROP TABLE post;