When “Everything Is Correct” but Your Database Still Won’t Connect (Supabase + Prisma)

Ezenagu Chinemerem — Fri, 17 Apr 2026 15:07:10 +0000

I recently hit a frustrating issue while connecting Prisma to a Supabase Postgres database.

At first glance, everything looked fine:

Correct credentials ✅
Database status: healthy ✅
Prisma schema: valid ✅

But then:

❌ "Can't reach database server at port 5432"
❌ "Network is unreachable"
⚠️ Prisma hangs when using connection pooler

🔍 What was actually happening?

The problem wasn’t Prisma.
It wasn’t Supabase either.

It was network-level IPv6 incompatibility.

My system resolved the database host to an IPv6 address, but my ISP/network doesn’t properly support IPv6 — so the connection failed silently.

⚙️ The breakdown

Supabase gives two connection types:

Direct DB (port 5432)

Requires stable IPv4/IPv6 support
Used for migrations
❌ Failed in my case due to IPv6

Connection Pooler (port 6543)

Works over IPv4
Designed for app runtime
⚠️ Not ideal for Prisma migrations

🛠️ Current workaround

Using pooler for database connection
Forcing Prisma to run with: PRISMA_CLIENT_ENGINE_TYPE=binary
Skipping direct DB access for now

🤔 Open questions

What’s the cleanest way to handle Prisma migrations without direct DB access?
Are people relying on CI/CD runners or VPS environments for this?
Is using a VPN the most practical fix long-term?

This was a good reminder that sometimes the issue isn’t your code or config — it’s the layer beneath everything.

Would love to hear how others have handled this.

prisma #supabase #postgres #debugging #backend

👋 My First Post — Let’s Build Something Real

Ezenagu Chinemerem — Mon, 13 Apr 2026 08:31:29 +0000

Hi Dev.to!

I’m a Backend Engineer who enjoys building scalable systems and clean APIs using Go and Python.

Over time, I’ve moved beyond just “writing code” to actually understanding how systems are designed, how they scale, and how real-world backend problems are solved. From structuring APIs properly to thinking about performance, data flow, and architecture. I’m focused on building things that actually work in production.

This space is where I’ll be sharing:

Practical backend projects (not just theory)
Lessons from real builds and mistakes
Clear breakdowns of complex concepts
Insights on growing as a backend engineer

If you’re into backend development, system design, or just trying to level up your engineering skills, you’ll feel at home here.

I’m here to learn, build, and share—consistently.

Let’s build something real 🚀

Forem: Ezenagu Chinemerem

When “Everything Is Correct” but Your Database Still Won’t Connect (Supabase + Prisma)

prisma #supabase #postgres #debugging #backend

👋 My First Post — Let’s Build Something Real