Drizzle TeamDT
Drizzle Team•5mo ago
Andrew Chung

drizzle-kit pull not working (freezes) with supabase

I'm trying to integrate drizzle to an existing supabase project with 77 tables.

When i run npx drizzle-kit pull i see this log

npm warn config ignoring workspace config at /Users/aschung/dev/typa/frontend/.npmrc
No config path provided, using default 'drizzle.config.ts'
Reading config file '/Users/aschung/dev/typa/frontend/drizzle.config.ts'
Pulling from ['public'] list of schemas

Using 'postgres' driver for database querying
[✓] 77 tables fetched
[⣟] 0  columns fetching
[✓] 33 enums fetched
[⣟] 0  indexes fetching
[⣟] 0  foreign keys fetching
[✓] 76 policies fetched
[⣟] 0  check constraints fetching
[⣟] 0  views fetching


and the command hangs there forever.

drizzle.config.ts looks like:
import 'dotenv/config';
import { defineConfig } from 'drizzle-kit';

export default defineConfig({
    out: './drizzle',
    schema: './src/db/schema/*',
    dialect: 'postgresql',
    dbCredentials: {
        url: process.env.DATABASE_URL!,
    },
    verbose: true,
    strict: true,
});


Weird thing is when I add tableFilter: ["user"] to the config the command works, but once I add more tables to the filter or try it without filters the command freezes.
Was this page helpful?