Agent skill

Prisma Postgres

by curvenote in curvenote/curvenote

Prisma Postgres setup and operations guidance across Console, create-db CLI, Management API, and Management API SDK.

MITAuto-check: notesDatabases

Install Prisma Postgres

skills CLI
$ npx skills add curvenote/curvenote --skill prisma-postgres -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install curvenote/curvenote prisma-postgres --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/curvenote/curvenote.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.agents/skills/prisma-postgres .claude/skills/prisma-postgres && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
prisma-postgres
GitHub stars
169
Used in
1 other repo
Token cost
~937 tokens
SKILL.md length
339 words
Files
5 (incl. references)
Skills in repo
10
Repo updated
First seen
Licence
MIT

At a glance

Prisma Postgres setup and operations guidance across Console, create-db CLI, Management API, and Management API SDK.

  • Works in 5 steps: Console-first workflow → Quick provisioning with create-db → Link an existing local project → …
  • Creating Prisma Postgres databases
  • SKILL.md covers When to Apply, Rule Categories by Priority, Quick Reference and Core Workflows, plus 2 more sections
  • Calls npx and npm; reaches api.prisma.io and console.prisma.io

What it does

Prisma Postgres is an agent skill from curvenote/curvenote. 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.

Its SKILL.md is about 940 tokens, which your agent loads only when the skill is triggered. The skill folder holds 5 other files, including reference files (for example `references/console-and-connections.md`, `references/create-db-cli.md` and `references/management-api-sdk.md`).

It sits in Databases, covering ORMs and data access. It works with Prisma and PostgreSQL. The repository describes itself as: Create, edit, share, and publish scientific and technical documents. The licence is MIT.

When your agent uses it

  • Creating Prisma Postgres databases
  • Working in Prisma Console
  • Provisioning with create-db/create-pg/create-postgres
  • Integrating programmatic provisioning with service tokens

Example prompts

  • “/prisma-postgres”

Requirements

  • Node.js

Workflow steps

5 steps, taken from the step headings in SKILL.md.

  1. Console-first workflow
  2. Quick provisioning with create-db
  3. Link an existing local project
  4. Programmatic provisioning with Management API
  5. Type-safe integration with Management API SDK

What it can do on your machine

Read from SKILL.md and the folder at commit 91febfe. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • npx
    • npm

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    Hosts in commands or code, which the agent is likely to contact:

    • api.prisma.io
    • console.prisma.io

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Prisma Postgres loads about 937 tokens when it runs, and up to ~3k if it reads all its reference files. Until then it costs about 83 tokens; SKILL.md has 339 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~83
When it runs · the whole SKILL.md, loaded when a task matches
~937
With references · SKILL.md plus every file in references/, read only if the agent opens them
~3k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check: notes

The automated check noted patterns worth knowing about, such as sudo or a known installer.

  • NoteMentions a .env fileSKILL.md:84
    This flow updates your local `.env` with `DATABASE_URL`, then you can run `prisma generate` and `prisma migrate dev`.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from curvenote/curvenote at commit 91febfe, republished under its MIT licence (© curvenote). 339 words, ~937 tokens.

Download SKILL.mdSave it as .claude/skills/prisma-postgres/SKILL.md (or your agent's skills folder). This skill also uses 4 other files; get the full folder from GitHub.
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
metadata.version
7.6.0

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

PriorityCategoryImpactPrefix
1CLI ProvisioningCRITICALcreate-db-cli
2Management APICRITICALmanagement-api
3Management API SDKHIGHmanagement-api-sdk
4Console and ConnectionsHIGHconsole-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.

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.

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.

© curvenote, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 4 other files (references) in .agents/skills/prisma-postgres of curvenote/curvenote.

  • SKILL.md
  • references/console-and-connections.md
  • references/create-db-cli.md
  • references/management-api-sdk.md
  • references/management-api.md

Open the folder on GitHubat commit 91febfe

Used in 1 other repository

We found 1 copy of this SKILL.md (exact, near-identical or edited) in other folders, from 1 other GitHub owner. This page covers the copy in curvenote/curvenote, which our catalogue first saw on October 7, 2026.

Compare with similar skills

Prisma Postgres next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Prisma Postgres compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Prisma Postgres this skillcurvenote/curvenote1691 repos~937Automated safety check: NotesMIT
Better Drizzlealmeidazs/better-drizzle347—~1.7kAutomated safety check: PassApache-2.0
Add Backendahpxex/open-dashboard146—~3.6kAutomated safety check: PassMIT
Database FundamentalsDanielPodolsky/ownyourcode2901 repos~1.6kAutomated safety check: PassMIT
Database Expertcin12211/orca-q223—~2.8kAutomated safety check: PassMIT
Prisma 8 Contract-First ORMprisma/orm48k—~3.7kAutomated safety check: NotesApache-2.0

Similar skills

  • Better Drizzle

    almeidazs/better-drizzle

    Write, review, and debug code that uses better-drizzle, the typed repository layer over Drizzle ORM 1.x (better(db), client.users.findMany, paginate, cursor, upsertMany, relation include/connect…

    347 GitHub stars~1.7k tokensUpdated 2 days ago
    DatabasesAuto-check passed
  • Add Backend

    ahpxex/open-dashboard

    Everything about the data layer — pick one of six ready-to-run backend templates (TanStack Start + Drizzle + better-auth, Hono + Drizzle + better-auth, Hono + Prisma + better-auth, Hono + Drizzle +…

    146 GitHub stars~3.6k tokensUpdated 3 mo ago
    DatabasesAuto-check passed
  • Database Fundamentals

    DanielPodolsky/ownyourcode

    Reviews schema design, SQL queries, ORM patterns. An agent skill from DanielPodolsky/ownyourcode.

    290 GitHub starsUsed in 1 repo~1.6k tokens
    DatabasesAuto-check passed
  • Database Expert

    cin12211/orca-q

    Database performance optimization, schema design, query analysis, and connection management across PostgreSQL, MySQL, MongoDB, and SQLite with ORM integration.

    223 GitHub stars~2.8k tokensUpdated 16 days ago
    DatabasesAuto-check passed
  • Official

    Routes Prisma 8 tasks such as contracts, migrations, queries and upgrades to the right reference files for projects on the contract-first @prisma/orm packages.

    48k GitHub stars~3.7k tokensUpdated yesterday
    DatabasesAuto-check: notes
  • DB Sculptor

    EliasOulkadi/shokunin

    Design database schemas with Prisma/Drizzle, PostgreSQL index strategy (B-tree, GIN, GiST, BRIN, Hash), query optimization (EXPLAIN ANALYZE), migration safety (expand/contract, zero-downtime), and…

    114 GitHub stars~3.1k tokensUpdated 2 days ago
    DatabasesAuto-check: notes

More from curvenote/curvenote

All 10 skills in this repo
  • Supabase

    curvenote/curvenote

    A skill your agent uses when doing ANY task involving Supabase.

    169 GitHub starsUsed in 5 repos~2.2k tokens
    Auto-check passed
  • React Router Framework Mode

    curvenote/curvenote

    Build full-stack React applications using React Router's framework mode.

    169 GitHub starsUsed in 4 repos~1.1k tokens
    Auto-check passed
  • Prisma Database Setup

    curvenote/curvenote

    Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, MongoDB, etc.).

    169 GitHub starsUsed in 3 repos~1.4k tokens
    Auto-check passed
  • Prisma Client API

    curvenote/curvenote

    Prisma Client API reference covering model queries, filters, operators, and client methods.

    169 GitHub starsUsed in 2 repos~1.6k tokens
    Auto-check passed
  • Prisma Postgres Setup

    curvenote/curvenote

    Set up a new Prisma Postgres database and connect it to a local project using the Management API.

    169 GitHub starsUsed in 1 repo~2.7k tokens
    Auto-check: notes
  • Prisma CLI

    curvenote/curvenote

    Prisma CLI commands reference covering all available commands, options, and usage patterns.

    169 GitHub stars~1.6k tokensUpdated 9 days ago
    Auto-check passed

Categories

Questions about Prisma Postgres

What does Prisma Postgres do?

Prisma Postgres setup and operations guidance across Console, create-db CLI, Management API, and Management API SDK. Prisma Postgres is an agent skill from curvenote/curvenote. Prisma Postgres setup and operations guidance across Console, create-db CLI, Management API, and Management API SDK.

When should I use Prisma Postgres?

Prisma Postgres fits situations like: creating Prisma Postgres databases; working in Prisma Console; provisioning with create-db/create-pg/create-postgres; integrating programmatic provisioning with service tokens.

How do I install Prisma Postgres in Claude Code?

Run `npx skills add curvenote/curvenote --skill prisma-postgres -a claude-code`. Or copy the skill folder (.agents/skills/prisma-postgres in curvenote/curvenote) into .claude/skills/prisma-postgres in your project. Claude Code loads it when a task matches its description.

How do I install Prisma Postgres in Codex?

Run `npx skills add curvenote/curvenote --skill prisma-postgres -a codex`. Or copy the skill folder (.agents/skills/prisma-postgres in curvenote/curvenote) into .agents/skills/prisma-postgres in your project. Codex loads it when a task matches its description.

Can I use Prisma Postgres in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add curvenote/curvenote --skill prisma-postgres -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/prisma-postgres, .gemini/skills/prisma-postgres, .github/skills/prisma-postgres and .opencode/skills/prisma-postgres in your project.

What does Prisma Postgres need to run?

Going by SKILL.md and its folder, Prisma Postgres needs the command-line tools its instructions call (npx and npm). Our summary lists: Node.js.

Does Prisma Postgres access the network?

SKILL.md names 2 domains. In commands or code: api.prisma.io and console.prisma.io; the agent is likely to contact these when it follows the instructions. This is read from the text; nothing was executed.

Is Prisma Postgres safe to install?

Our automated static check of SKILL.md found notes only (mentions a .env file), nothing it rates as a warning. It is not a guarantee. Review the folder before installing.

What licence does Prisma Postgres use?

Prisma Postgres is published under the MIT licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Prisma Postgres use?

About 937 tokens (SKILL.md is roughly 3.7k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 2.1k tokens, read only when the agent opens those files.

What are the alternatives to Prisma Postgres?

Skills that share tags, products or a category with Prisma Postgres: Better Drizzle (almeidazs/better-drizzle, 347 stars), Add Backend (ahpxex/open-dashboard, 146 stars), Database Fundamentals (DanielPodolsky/ownyourcode, 290 stars) and Database Expert (cin12211/orca-q, 223 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Prisma Postgres?

curvenote (a GitHub organization) maintains it in curvenote/curvenote, which has 169 GitHub stars. The repository holds 10 skills in this directory. The repository was last updated on September 28, 2026.

Source: curvenote/curvenote on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.