2 replies

Drizzle Studio Not Showing Tables that are in Supabase

I am starting to work on a project and using Drizzle and Supabase. I just did a

drizzle-kit generate

drizzle-kit generate

followed by a

drizzle-kit migrate

drizzle-kit migrate

. When I look in supabase.com it shows that table. However, when I run

drizzle-kit studio

drizzle-kit studio

, I just get a spinner. This is what my

drizzle.config.ts

drizzle.config.ts

looks like

import { defineConfig } from 'drizzle-kit'
import { env } from '@/app/env'

export default defineConfig({
  dialect: 'postgresql',
  schema: './server/db/schema.ts',
  out: './supabase/migrations',
  dbCredentials: {
    url: env.POSTGRES_URL,
  },
})

import { defineConfig } from 'drizzle-kit'
import { env } from '@/app/env'

export default defineConfig({
  dialect: 'postgresql',
  schema: './server/db/schema.ts',
  out: './supabase/migrations',
  dbCredentials: {
    url: env.POSTGRES_URL,
  },
})

The

POSTGRES_URL

POSTGRES_URL

is from the Vercel & Supabase integration and uses the port

. However, if I use the

POSTGRES_URL_NON_POOLING

POSTGRES_URL_NON_POOLING

env var that ends in

, the studio will load. When looking into Supabase's Database Settings, it looks like the one ending in

is for transaction mode and the one ending in

is for session mode. Does this mean I need to use the non pooling URL for drizzle studio?

Drizzle Team•2y ago•

2 replies

jsingleton37

Drizzle Studio Not Showing Tables that are in Supabase

I am starting to work on a project and using Drizzle and Supabase. I just did a

drizzle-kit generate

drizzle-kit generate

followed by a

drizzle-kit migrate

drizzle-kit migrate

. When I look in supabase.com it shows that table. However, when I run

drizzle-kit studio

drizzle-kit studio

, I just get a spinner. This is what my

drizzle.config.ts

drizzle.config.ts

looks like

import { defineConfig } from 'drizzle-kit'
import { env } from '@/app/env'

export default defineConfig({
  dialect: 'postgresql',
  schema: './server/db/schema.ts',
  out: './supabase/migrations',
  dbCredentials: {
    url: env.POSTGRES_URL,
  },
})

import { defineConfig } from 'drizzle-kit'
import { env } from '@/app/env'

export default defineConfig({
  dialect: 'postgresql',
  schema: './server/db/schema.ts',
  out: './supabase/migrations',
  dbCredentials: {
    url: env.POSTGRES_URL,
  },
})

The

POSTGRES_URL

POSTGRES_URL

is from the Vercel & Supabase integration and uses the port

. However, if I use the

POSTGRES_URL_NON_POOLING

POSTGRES_URL_NON_POOLING

env var that ends in

, the studio will load. When looking into Supabase's Database Settings, it looks like the one ending in

is for transaction mode and the one ending in

is for session mode. Does this mean I need to use the non pooling URL for drizzle studio?

Drizzle Studio Not Showing Tables that are in Supabase

Similar Threads

Drizzle Studio Not Showing Tables that are in Supabase

Similar Threads

Similar Threads

Similar Threads