7 replies

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!

Drizzle Team•17mo ago•

7 replies

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

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

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

Similar Threads

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

Similar Threads

Similar Threads

Similar Threads