Standard Postgres DATABASE_URL with Netlify extension (or derive username/password from API key)
If I'm understanding correctly, the Prisma Postgres Netlify extension provides a
DATABASE_URL using the prisma+postgres:// scheme. Is there a way to get credentials for a standard Postgres connection instead?6 Replies
You're in no rush, so we'll let a dev step in. Enjoy your coffee, or drop into
#ask-ai if you get antsy for a second opinion!Yes it's possible.
Can you try creating a new API Key from settings?
You should be able to see both connection strings -
prisma+postgres:// as well as postgres://oh to clarify i specifically meant the netlify integration
as documented here https://www.prisma.io/docs/postgres/integrations/netlify
Prisma Postgres via Netlify Extension | Prisma Documentation
Learn how to create Prisma Postgres databases via the official Netlify extension and deploy your applications with it.
if it's not possible to use the integration without prisma orm then i can just manage secrets manually of course, but i wanted to know if that was supported
Ah, I get it now.
Currently, only the
prisma+postgres:// connection string is propogated to netlify and not the Direct TCP postgres:// one.