{"library":"sequelize-migration","type":"library","category":null,"description":"A module for handling database migrations using raw SQL scripts with Sequelize. This package allows you to manage versioned SQL script executions for MySQL and PostgreSQL. It creates a tracking table (`sph_script_execution`) to record which scripts have been applied, ensuring idempotent upgrades. The module takes a Sequelize instance and a module configuration including version, script directory, and per-dialect upgrade scripts. Designed for simple, file-based migration workflows. Version 1.0.1 is the latest stable release. Alternatives like Umzug or Sequelize's built-in migration CLI offer more features, but this package provides a lightweight approach for projects that prefer pure SQL. Low maintenance cadence.","language":"javascript","status":"active","version":"1.0.1","tags":["javascript","sequelize","migration"],"last_verified":"Sun Jun 07","install":[{"cmd":"npm install sequelize-migration","imports":["const SequelizeMigration = require('sequelize-migration');","new SequelizeMigration(sequelize);","migration.addModule({ module: 'my-module', version: '1.0.0', dir: './scripts', dialects: { mysql: [ { version: '1.0.0', upgrade: ['upgrade.sql'] } ] } });"]},{"cmd":"yarn add sequelize-migration","imports":[]},{"cmd":"pnpm add sequelize-migration","imports":[]}],"homepage":"https://github.com/saphyre/sequelize-migration#readme","github":"https://github.com/saphyre/sequelize-migration","docs":null,"changelog":null,"pypi":null,"npm":"sequelize-migration","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}