Drizzle Team•5mo ago

NeonDbError: Error connecting to database

I got this error in connecting to my db on neon postgres, couldn't figure out why, I've tried both http and websocket connection to connect to my database, but nothing worked as expected, and also drizzle studio didn't work either, and I got this on error on drizzle studio "@Neondatabase/serverless' can only connect to remote Neon/Vercel Postgres/Supabase instances through a websocket"

2 Replies

Servesh•5mo ago

could u share your drizzle config? also try to log the values of the env variables to see if they're set correctly..

Saifur•5mo ago

import { defineConfig } from 'drizzle-kit'

import { env } from '~/env'

console.log(env.DATABASE_URL)

export default defineConfig({
  schema: './src/lib/db/schema.ts',
  out: './src/lib/db/migrations',
  dialect: 'postgresql',
  dbCredentials: {
    url: env.DATABASE_URL,
  },
})

import { defineConfig } from 'drizzle-kit'

import { env } from '~/env'

console.log(env.DATABASE_URL)

export default defineConfig({
  schema: './src/lib/db/schema.ts',
  out: './src/lib/db/migrations',
  dialect: 'postgresql',
  dbCredentials: {
    url: env.DATABASE_URL,
  },
})

and yes, I've tried logging the env var, it works fine, I'm also using the latest version I've tried to test this with a hono, bun server, it it worked in some arieas, The "drizzle-kit push" and "drizzle-kit studio" didn't work, then I set up maigration for neon db, then It worked. and yes db queries are working in hono server, but I'm having complete brekdown on my next.js app

Gaming

Programming

NeonDbError: Error connecting to database