prisma-postgres

Prisma Postgres setup and operations guidance across Console, create-db CLI, Management API, and Management API SDK. Use when creating Prisma Postgres databases, working in Prisma Console, provisioning with create-db/create-pg/create-postgres, or integrating programmatic provisioning with service tokens or OAuth.

34stars2forksUpdated 5/2/2026

Developer Tools #management-api #postgres #sdk #prisma #cli #database-management

Security Assessment

Low Risk(80/100)

Detected risks:

Sensitive File Access([SKILL.md] .env, [references/console-and-connections.md] .env, [references/create-db-cli.md] .env)

Security Score80/100

About prisma-postgres

The 'prisma-postgres' skill provides comprehensive guidance on setting up and managing Prisma Postgres databases across various platforms, including the Prisma Console, CLI, Management API, and Management API SDK. This skill aims to simplify and streamline the process of creating, provisioning, and linking Prisma Postgres databases for both manual and programmatic workflows. It offers clear instructions for a wide range of users, from those using interactive interfaces like Prisma Console to developers seeking to automate database creation and integration through APIs and SDKs.

FAQ

How can I quickly provision a database using Prisma Postgres?

You can provision a database instantly using the 'create-db' command via the CLI. Simply run `npx create-db@latest`, or use the aliases `npx create-pg@latest` or `npx create-postgres@latest`. These will create a temporary database that auto-deletes after approximately 24 hours unless claimed.

Can I link an existing local project to a Prisma Postgres database?

Yes, you can link an existing local project to a Prisma Postgres database using the 'prisma postgres link' command. If you're working in a non-interactive environment, you can pass the API key and database information directly via command-line flags.

Is there a way to automate the creation of Prisma Postgres databases?

Yes, you can automate database creation using the Management API or the Management API SDK. These tools allow you to provision and manage databases programmatically using service tokens or OAuth authentication methods.

What are the key features of the Prisma Postgres Management API SDK?

The Prisma Postgres Management API SDK allows you to interact with the Prisma Management API in a type-safe manner. It supports both service token and OAuth authentication, providing a flexible way to manage resources and databases programmatically with automatic token refresh.

Are there any limitations on Prisma Postgres database lifetime?

Yes, temporary databases created using the 'create-db' CLI or its aliases will automatically delete after approximately 24 hours unless they are claimed. This is ideal for quick, temporary testing environments.