Finder

Search this site

Search posts, books, micro posts, and projects.

Search across all published content.

Open Markdown

Using connection pooled URL with Supabase and Prisma

If you ever encounter this error while trying to run a migration with prisma on your supabase database:

Terminal window
Error: Schema engine error:
ERROR: prepared statement "s0" does not exist

You’re likely using the wrong URL to connect to your database. Prisma needs a different URL for doing migrations if your normal database URL uses connection pooling. For more information, see this article for a more comprehensive guide