prisma-postgres
/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.
- Author
- shunwuyu ↗
- Repository
- ai_lesson ↗
- Licence
- MIT
- Last repository change
- 27.10.2026
Assessment and security
- Files in this package
- 5
- Scripts
- 0
- HTML comments
- 0
- URLs in SKILL.md
- 4
No signals detected. Repository changed on 27.10.2026, without references to retired models or APIs.
MIT, open: use and modify while retaining author attribution.
What it does and when to use it
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.
Original author description
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.
How it works
- When to Apply
- Rule Categories by Priority
- Quick Reference
- Core Workflows
- Rule Files
- How to Use
SKILL.md preview
--- name: prisma-postgres description: 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. license: MIT metadata: author: prisma version: "7.9.1" --- # Prisma Postgres Guidance for creating, managing, and integrating Prisma Postgres across interactive and programmatic workflows. ## When to Apply Reference this skill when: - Setting up Prisma Postgres from Prisma Console - Provisioning instant temporary databases with `create-db` - Linking an existing local project with `prisma postgres link` - Managing Prisma Postgres resources via Management API - Using `@prisma/management-api-sdk` in TypeScript/JavaScript - Handling claim URLs, connection strings, regions, and auth flows ## Rule Categories by Priority | Priority | Category | Impact | Prefix | |----------|----------|--------|--------| | 1 | CLI Provisioning | CRITICAL | `create-db-cli` | | 2 | Management API | CRITICAL | `management-api` | | 3 | Management API SDK | HIGH | `management-api-sdk` | | 4 | Console and Connections | HIGH | `console-and-connections` | ## Quick Reference - `create-db-cli` - instant databases and current CLI flags (`--ttl`, `--copy`, `--quiet`, `--open`) - `management-api` - service token and OAuth API workflows - `management-api-sdk` - typed SDK usage with token storage - `console-and-connections` - Console operations, `prisma postgres link`, direct TCP connections, and serverless-driver choices ## Core Workflows ### 1. Console-first workflow Use Prisma Console for manual setup and operations: - Open `https://console.prisma.io` - Create/select workspace and project - Use Studio in the project sidebar to view/edit data - Retrieve direct connection details from the project UI ### 2. Quick provisioning with create-db Use `create-db` when you need a database immediately: ```bash npx create-db@latest ``` Aliases: ```bash npx create-pg@latest npx create-postgres@latest ``` For app integrations, you can also use the programmatic API (`create()` / `regions()`) from the `create-db` npm package. Temporary databases auto-delete after ~24 hours unless claimed. ### 2b. Persistent databases with the Platform CLI For databases that belong to a Project (not throwaway `create-db` databases), use `@prisma/cli`: ```bash npx -y @prisma/cli@latest database create --help npx -y @prisma/cli@latest database list --json npx -y @prisma/cli@latest database connection create db_123 npx -y @prisma/cli@latest database usage db_123 npx -y @prisma/cli@latest database backup list db_123 ``` `database create` and `database connection create` print a one-time connection URL; store it immediately. Destructive commands (`remove`, `restore`) require exact `--confirm <id>`. For automation, prefer `--json --no-interactive`, resolve ids before mutations, and verify the installed command's help because this CLI is beta. ### 3. Link an existing local project Use `prisma postgres link` when the database already exists and you want to wire a local project to it: ```bash prisma postgres link ``` For CI or other non-interactive environments: ```bash prisma postgres link --api-key "<your-api-key>" --database "db_..." ``` This flow updates your local `.env` with `DATABASE_URL`, then you can run `prisma generate` and `prisma migrate dev`. ### 4. Programmatic provisioning with Management API Use API endpoints on: ```text https://api.prisma.io/v1 ``` Explore the schema and endpoints using: - OpenAPI docs: `https://api.prisma.io/v1/doc` - Swagger Editor: `https://api.prisma.io/v1/swagger-editor` Auth options: - Service token (workspace server-to-server) - OAuth 2.0 (act on behalf of users) ### 5. Type-safe integration with Management API SDK Install and use: ```bash npm install @prisma/management-api-sdk ``` Use `createManagementApiClient` for existing tokens, or `createManagementApiSdk` for OAuth + token refresh. The SDK exposes typed workspace service-token list, create, and revoke routes. A newly created token value is returned exactly once. Let the installed SDK types or OpenAPI document settle exact beta endpoint shapes. ## Rule Files Detailed guidance lives in: ``` references/console-and-connections.md references/create-db-cli.md references/management-api.md references/management-api-sdk.md ``` ## How to Use Start with `references/create-db-cli.md` for fast setup, then switch to `references/management-api.md` or `references/management-api-sdk.md` when you need programmatic provisioning.
Files in this package (5)
- SKILL.md 5 KB
- references/console-and-connections.md 2 KB
- references/create-db-cli.md 3 KB
- references/management-api-sdk.md 2 KB
- references/management-api.md 3 KB
Versions
The database has no other skills named prisma-postgres.
Database snapshot: 13.11.2026 · package version ca3cada72d2e (SHA-256 digest of the entire package)
Downloads in the last 30 days: 0 · ranking
Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.
Similar skills
- 100prisma-postgres-setup
Set up a new Prisma Postgres database and connect it to a local project using the Management API. Use when asked to "set up a database", "create a Prisma Postgres project", "get a connection string", "connect my app to Prisma Postgres", or "provision a database". - 100prisma-postgres-upgrade
Upgrade a PostgreSQL app from Prisma ORM 6 or 7 straight to Prisma 8 in one pass, keeping the existing schema.prisma, database and data. Use when a Postgres project on Prisma 6 or 7 wants Prisma 8, including before deploying it on Prisma Compute, which runs only Prisma 8.… - 95prisma-postgres-setup
Obtain or reuse a Prisma Postgres database and connect an application. Use when the user needs a database and has none configured ("I need a database", "add a Postgres database", "set up a database for this app"), runs or mentions `create-db` or `npx create-db`, or asks to set… - 90prisma-8
Use when working in a project that depends on @prisma/orm-postgres, @prisma/orm-sqlite, or @prisma/orm-mongo (Prisma 8, formerly Prisma Next): editing contract.prisma or a contract.ts builder, running `prisma contract emit`, planning or applying migrations, editing migration.ts,… - 100prisma-orm
Use when modeling data or writing type-safe queries with Prisma ORM in TypeScript — `schema.prisma`, `prisma.config.ts`, the generated Prisma Client, and Prisma Migrate, including the v6 to v7 upgrade. NOT schema-as-TS with a SQL builder (that is `drizzle-orm`), NOT ORM-agnostic… - 100prisma-next-runtime
Wire the Prisma Next runtime — `db.ts` setup using `postgres<Contract>(...)` from `@prisma-next/postgres/runtime`, `sqlite<Contract>(...)` from `@prisma-next/sqlite/runtime`, or `mongo<Contract>(...)` from `@prisma-next/mongo/runtime`; middleware composition (telemetry from…