Db Migrate

Database Migration

Create migration scripts for Neon PostgreSQL following project conventions.

Instructions

1. Read current schema:

   • prisma/schema.sql for table definitions
   • src/lib/db.ts for TypeScript interfaces

2. Create migration script in scripts/ directory:

   • Filename: <action>-<description>.mjs (e.g., add-views-column.mjs)
   • Use existing pattern from scripts/add-summary-column.mjs

3. Migration script template:

   import { neon } from '@neondatabase/serverless';
   import { config } from 'dotenv';
   import { fileURLToPath } from 'url';
   import { dirname, join } from 'path';
   
   const __filename = fileURLToPath(import.meta.url);
   const __dirname = dirname(__filename);
   
   config({ path: join(__dirname, '..', '.env.local') });
   
   const sql = neon(process.env.DATABASE_URL);
   
   async function migrate() {
     console.log('Running migration...');
   
     await sql`
       ALTER TABLE table_name
       ADD COLUMN IF NOT EXISTS column_name TYPE
     `;
   
     console.log('Migration complete!');
   }
   
   migrate().catch(console.error);