Drizzle TeamDT
Drizzle Team•15mo ago
TARS

Cant drizzle-kit pull with next.js from supabase postgres

Hello, trying to learn drizzle by connecting it to an existing supabase project (postgres), and need to pull the DB schemas into drizzle.

My drizzle.config.ts:
import { config } from "dotenv";
import { defineConfig } from "drizzle-kit";
config({ path: ".env.local" });
export default defineConfig({
  schema: "./src/db/schema.ts",
  out: "./db/migrations",
  dialect: "postgresql",
  dbCredentials: {
    url: process.env.NEXT_PRIVATE_DB_CONNECTION_STRING!,
  },
  
});


$ npx drizzle-kit pull
No config path provided, using default 'drizzle.config.ts'
Reading config file 'C:\webdev\sprent-backoffice\drizzle.config.ts'
Pulling from ['public'] list of schemas

Using 'pg' driver for database querying
[⣟] 0 tables fetching
[⣟] 0 columns fetching
[⣟] 0 enums fetching
[⣟] 0 indexes fetching
[⣟] 0 foreign keys fetching
Error: SASL: SCRAM-SERVER-FINAL-MESSAGE: server signature is missing

Not sure where to start solving this issue.. help would be most appreciated!
Was this page helpful?