Can I see your migration file

import {Kysely, sql} from 'kysely'
import { TABLENAMES} from '../shared/enums/table-names'

export async function up(db: Kysely<any>): Promise<void> {
    await  db.schema
        .createTable('user')
        .addColumn('id', 'uuid',(col) => col.primaryKey().defaultTo(sql`uuid_generate_v4()`))
        .addColumn('first_name', 'varchar(255)', (col) => col.notNull())
        .addColumn('last_name', 'varchar(255)', (col) => col.notNull())
        .addColumn('gender', 'varchar(255)', (col) => col.notNull())
        .addColumn('email', 'varchar(255)', (col) => col.notNull().unique())
        .addColumn('phone', 'varchar(11)')
        .addColumn('job_title', 'varchar(255)', (col) => col.notNull())
        .addColumn('birth_date', 'date')
        .addColumn('lockout', 'boolean', (col) => col.notNull().defaultTo(false))
        .execute();

    await db.insertInto('user')
        .values({
            first_name: 'Kabo',
            last_name: 'Mekgwe',
            gender: 'Male',
            email: '<mailto:kabokm@gmail.com|kabokm@gmail.com>',
            job_title: 'jsdfsd'
        });
}

export async function down(db: Kysely<any>): Promise<void> {
    await db.schema.dropTable('user').execute()
}

The file ext is .mjs

If you remove the shared enums import

no its not working

Oh wait I see

I'll search for it through out the whole project

It should just be in the migrations files

hay @thdxr sorry for the late reply. i was a bit busy earlier on i managed to get it to work. You where right... i didn't consider that it wasn't a typescript file. i also used this example https://www.npmjs.com/package/kysely#query-examples

they run automatically when deploying in non-local mode

Thanks