Saas-voc-server/scripts/migrate.ts

import 'dotenv/config';
import { loadConfig } from '../src/config/env.js';
import { createDatabasePool } from '../src/db/pool.js';
import { runMigrations } from '../src/db/migrations.js';

const config = loadConfig();
const pool = createDatabasePool(config, {
  connectionString: config.database.migrationUrl,
  applicationName: 'saas-voc-migration',
});

try {
  const applied = await runMigrations(pool);
  console.log(applied.length ? `Applied migrations: ${applied.join(', ')}` : 'Database is up to date');
} finally {
  await pool.end();
}