Neon Prisma or Drizzle Migration Fails (Pooled Connection)

How to fix it

Try these in order — the most common fix is first.

1. 1. Use a direct URL for migrations

   Copy steps
   1. Copy both connection strings from the Connect modal
   2. Prisma 6 and earlier: set directUrl in schema.prisma to the non-pooler URL
   3. Prisma 7: set the url in prisma.config.ts to DATABASE_URL_UNPOOLED
   4. Drizzle: use the non-pooler URL in drizzle.config.ts for drizzle-kit
   Did this fix it? Yes No

2. 2. Add a connect timeout

   1. Append ?sslmode=require&connect_timeout=15 to the migration URL
   Did this fix it? Yes No

3. 3. Avoid session features on the pooler

   1. Use SET LOCAL inside a transaction, or schema-qualified table names instead of SET search_path
   Did this fix it? Yes No

Symptoms

prisma migrate or drizzle-kit hangs or errors, P1001 on migrate, SET search_path ignored, prepared statement or session errors.

Why it happens

• PgBouncer runs in transaction mode: SET, LISTEN/NOTIFY, temp tables and session advisory locks are unreliable
• Migration tool pointed at the -pooler URL
• Compute asleep and connect_timeout too short

This guide also covers

• neon prisma migrate error
• neon drizzle migration pooler
• neon prisma p1001
• neon directUrl

The same problem in other apps

All not loading, error messages & connection guides →

• Supabase Max Client Connections Reached (Supabase)
• PlanetScale Prisma Connection Errors (PlanetScale)
• Railway SSL Certificate Stuck or Not Working (526, 525, Too Many Redirects) (Railway)

Other Neon errors

• Neon Connection Timeout After Scale to Zero (Cold Start)
• Neon "Remaining Connection Slots Are Reserved" (Too Many Connections)
• Neon Compute Time Quota Exceeded (Free Plan Limit Reached)
• Neon Free Plan Storage Limit Reached (Writes Blocked)
• Neon Cannot Create Branch: Branch Limit Reached
• Neon SSL Required Error (Connection Is Insecure)
• Neon "The Endpoint ID Is Not Specified" / Password Authentication Failed
• Neon "Active Endpoints Limit Exceeded" / Compute Suspended