pgstrap allows you to easily run typescript migrations or generate a directory that represents your database schemas with table.sql files. Run pgstrap generate to generate a directory with the structure of your postgres database schemas!
- Migrations with TypeScript support
- Organized migration structure in
[src]/db/migrations - Database reset and migration scripts
- Automatic typed schema files in
[src]/db/zapatos(compatible with Zapatos and Kysely) - Database
table.sqlstructure dumps in[src]/db/structure - Easily run migrations inside of tests
npm install pgstrap --save-dev-
Initialize pgstrap in your project:
npx pgstrap init
-
This will set up the necessary configuration and scripts in your
package.json. -
Create your first migration:
npm run db:create-migration my-first-migration
-
Edit the migration file in
src/db/migrations/. -
Run the migration:
npm run db:migrate
-
Generate types and structure:
npm run db:generate
npm run db:migrate- Run pending migrationsnpm run db:reset- Drop and recreate the database, then run all migrationsnpm run db:generate- Generate types and structure dumpsnpm run db:create-migration- Create a new migration file
After running pgstrap init, you'll find a pgstrap.config.js file in your project root. Customize it as needed:
module.exports = {
defaultDatabase: "mydb",
schemas: ["public"],
dbDir: "./src/db", // optional, defaults to "./src/db"
}Migrations in pgstrap are written using node-pg-migrate, which provides a powerful and flexible way to define database changes.
To create a new migration:
npm run db:create-migration my-migration-nameThis will create a new file in src/db/migrations/ with a timestamp prefix.
A typical migration file looks like this:
import { MigrationBuilder, ColumnDefinitions } from "node-pg-migrate"
export const shorthands: ColumnDefinitions | undefined = undefined
export async function up(pgm: MigrationBuilder): Promise<void> {
// Your migration code here
}
export async function down(pgm: MigrationBuilder): Promise<void> {
// Code to revert your migration (optional)
}Here's an example of a migration that creates a new table:
export async function up(pgm: MigrationBuilder): Promise<void> {
pgm.createTable("users", {
id: "id",
username: { type: "text", notNull: true },
email: { type: "text", notNull: true, unique: true },
created_at: {
type: "timestamptz",
notNull: true,
default: pgm.func("current_timestamp"),
},
})
pgm.createIndex("users", "username")
}
export async function down(pgm: MigrationBuilder): Promise<void> {
pgm.dropTable("users")
}Contributions are welcome! Please feel free to submit a Pull Request.
This project is licensed under the MIT License - see the LICENSE file for details.
- This project was originally developed as seam-pgm by Seam Labs Inc. in 2024.
- Special thanks to the Zapatos and Kysely projects for their excellent TypeScript database tools.
If you encounter any issues or have questions, please file an issue on the GitHub repository.
Happy coding with pgstrap! 🚀