Drizzle Team•2mo ago

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!,
  },
  
});

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!

3 Replies

TARSOP•2mo ago

No one? bump

DoggeSlapper•2mo ago

It's not realted to drizzle. if you try connect with client will get same error

TARSOP•2mo ago

With client? What client? Thanks. Supabase client or? As you surely understand I'm not a senoir dev. It was a password error, my bad.

Gaming

Programming

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