Agent skill

Prisma Database Setup

by curvenote in curvenote/curvenote

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

MITAuto-check passedDatabases

Install Prisma Database Setup

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

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

GitHub CLI
$ gh skill install curvenote/curvenote prisma-database-setup --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-database-setup .claude/skills/prisma-database-setup && 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-database-setup
GitHub stars
170
Used in
3 other repos
Token cost
~1.4k tokens
SKILL.md length
433 words
Files
9 (incl. references)
Skills in repo
10
Repo updated
First seen
Licence
MIT

At a glance

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

  • Works in 3 steps: All providers use prisma/schema.prisma. → Prisma 7 SQL setups typically use… → MongoDB projects should stay on Prisma…
  • Setting up a new project
  • SKILL.md covers When to Apply, Rule Categories by Priority, System Prerequisites and Bun Runtime, plus 7 more sections
  • Calls npm, npx and bunx

What it does

Prisma Database Setup is an agent skill from curvenote/curvenote. Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, MongoDB, etc.). Use when setting up a new project, changing databases, or troubleshooting connection issues. Triggers on "configure postgres", "connect to mysql", "setup mongodb", "sqlite setup".

Its SKILL.md is about 1.4k tokens, which your agent loads only when the skill is triggered. The skill folder holds 9 other files, including reference files (for example `references/cockroachdb.md`, `references/mongodb.md` and `references/mysql.md`).

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

When your agent uses it

  • Setting up a new project
  • Changing databases
  • Troubleshooting connection issues
  • Configure postgres

Example prompts

  • “configure postgres”
  • “connect to mysql”
  • “setup mongodb”
  • “/prisma-database-setup”

Requirements

  • Node.js

Workflow steps

3 steps, taken from the first numbered list in SKILL.md.

  1. All providers use prisma/schema.prisma.
  2. Prisma 7 SQL setups typically use prisma.config.ts for datasource URLs.
  3. MongoDB projects should stay on Prisma 6.x, keep url = env("DATABASE_URL") in the schema, and continue using the classic MongoDB setup.

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:

    • npm
    • npx
    • bunx

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

  • Network

    No URLs in SKILL.md. Its commands use npm, npx and bunx, which can reach the network depending on how they are called.

    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 Database Setup loads about 1.4k tokens when it runs, and up to ~5.9k if it reads all its reference files. Until then it costs about 77 tokens; SKILL.md has 433 words of instructions outside code blocks.

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

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 passed

The automated check found no risky patterns in SKILL.md.

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). 433 words, ~1,414 tokens.

Download SKILL.mdSave it as .claude/skills/prisma-database-setup/SKILL.md (or your agent's skills folder). This skill also uses 8 other files; get the full folder from GitHub.
name
prisma-database-setup
description
Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, MongoDB, etc.). Use when setting up a new project, changing databases, or troubleshooting connection issues. Triggers on "configure postgres", "connect to mysql", "setup mongodb", "sqlite setup".
license
MIT
metadata.author
prisma
metadata.version
7.6.0

Prisma Database Setup

Comprehensive guides for configuring Prisma ORM with various database providers.

When to Apply

Reference this skill when:

  • Initializing a new Prisma project
  • Switching database providers
  • Configuring connection strings and environment variables
  • Troubleshooting database connection issues
  • Setting up database-specific features
  • Generating and instantiating Prisma Client

Rule Categories by Priority

PriorityCategoryImpactPrefix
1Provider GuidesCRITICALprovider names
2Prisma PostgresHIGHprisma-postgres
3Client SetupCRITICALprisma-client-setup

System Prerequisites

  • Node.js 20.19.0+
  • TypeScript 5.4.0+

Bun Runtime

If you're using Bun, run Prisma CLI commands with bunx --bun prisma ... so Prisma uses the Bun runtime instead of falling back to Node.js.

Supported Databases

DatabaseProvider StringNotes
PostgreSQLpostgresqlDefault, full feature support
MySQLmysqlWidespread support, some JSON diffs
SQLitesqliteLocal file-based, no enum/scalar lists
MongoDBmongodbMongo-specific workflow; do not apply SQL driver-adapter guidance
SQL ServersqlserverMicrosoft ecosystem
CockroachDBcockroachdbDistributed SQL, Postgres-compatible
Prisma PostgrespostgresqlManaged serverless database

Configuration Files

Your configuration shape depends on the provider and Prisma major version:

  1. All providers use prisma/schema.prisma.
  2. Prisma 7 SQL setups typically use prisma.config.ts for datasource URLs.
  3. MongoDB projects should stay on Prisma 6.x, keep url = env("DATABASE_URL") in the schema, and continue using the classic MongoDB setup.

Driver Adapters

The standard SQL workflow uses a driver adapter. Choose the adapter and driver for your database and pass the adapter to PrismaClient.

DatabaseAdapterJS Driver
PostgreSQL@prisma/adapter-pgpg
CockroachDB@prisma/adapter-pgpg
Prisma Postgres (Node.js)@prisma/adapter-pgpg
Prisma Postgres (edge/serverless)@prisma/adapter-ppg@prisma/ppg
MySQL / MariaDB@prisma/adapter-mariadbmariadb
SQLite@prisma/adapter-better-sqlite3better-sqlite3
SQLite (Turso/LibSQL)@prisma/adapter-libsql@libsql/client
SQL Server@prisma/adapter-mssqlnode-mssql

MongoDB should not follow the Prisma 7 SQL adapter workflow. Use the latest Prisma 6.x release for MongoDB projects and do not install a SQL @prisma/adapter-* package for it.

Example (PostgreSQL):

ts
import 'dotenv/config'
import { PrismaClient } from '../generated/client'
import { PrismaPg } from '@prisma/adapter-pg'

const adapter = new PrismaPg({ connectionString: process.env.DATABASE_URL })
const prisma = new PrismaClient({ adapter })
Show full SKILL.md (177 more words)Show less

Prisma Client Setup (Required)

Prisma Client must be installed and generated for any database.

  1. Install Prisma CLI and Prisma Client:

    bash
    npm install prisma --save-dev
    npm install @prisma/client
  2. Add a generator block (prisma-client requires an explicit output path):

    prisma
    generator client {
      provider = "prisma-client"
      output   = "../generated"
    }
  3. Generate Prisma Client:

    bash
    npx prisma generate
  4. For SQL providers, instantiate Prisma Client with the database-specific driver adapter:

    typescript
    import { PrismaClient } from '../generated/client'
    import { PrismaPg } from '@prisma/adapter-pg'
    
    const adapter = new PrismaPg({ connectionString: process.env.DATABASE_URL })
    const prisma = new PrismaClient({ adapter })
  5. Re-run prisma generate after every schema change.

Quick Reference

PostgreSQL
prisma
datasource db {
  provider = "postgresql"
}

generator client {
  provider = "prisma-client"
  output   = "../generated"
}
MySQL
prisma
datasource db {
  provider = "mysql"
}

generator client {
  provider = "prisma-client"
  output   = "../generated"
}
SQLite
prisma
datasource db {
  provider = "sqlite"
}

generator client {
  provider = "prisma-client"
  output   = "../generated"
}
MongoDB
prisma
datasource db {
  provider = "mongodb"
  url      = env("DATABASE_URL")
}

generator client {
  provider = "prisma-client-js"
}

For MongoDB, stay on the latest Prisma 6.x line and keep the connection URL in schema.prisma. Do not move a MongoDB project to the Prisma 7 SQL adapter setup.

Rule Files

See individual rule files for detailed setup instructions:

references/postgresql.md
references/mysql.md
references/sqlite.md
references/mongodb.md
references/sqlserver.md
references/cockroachdb.md
references/prisma-postgres.md
references/prisma-client-setup.md

How to Use

Choose the provider reference file for your database, then apply references/prisma-client-setup.md to complete client generation and adapter setup. For MongoDB, use references/mongodb.md instead of copying the SQL adapter examples or Prisma 7 config pattern.

© 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 8 other files (references) in .agents/skills/prisma-database-setup of curvenote/curvenote.

  • SKILL.md
  • references/cockroachdb.md
  • references/mongodb.md
  • references/mysql.md
  • references/postgresql.md
  • references/prisma-client-setup.md
  • references/prisma-postgres.md
  • references/sqlite.md
  • references/sqlserver.md

Open the folder on GitHubat commit 91febfe

Used in 3 other repositories

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

Compare with similar skills

Prisma Database Setup 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 Database Setup compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Prisma Database Setup this skillcurvenote/curvenote1703 repos~1.4kAutomated safety check: PassMIT
Database Expertcin12211/orca-q224—~2.8kAutomated safety check: PassMIT
Better Drizzlealmeidazs/better-drizzle348—~1.7kAutomated safety check: PassApache-2.0
Database FundamentalsDanielPodolsky/ownyourcode2901 repos~1.6kAutomated safety check: PassMIT
Prisma 8 Contract-First ORMprisma/orm48k—~3.8kAutomated safety check: NotesApache-2.0
DB SculptorEliasOulkadi/shokunin114—~3.1kAutomated safety check: NotesMIT

Similar skills

  • Database Expert

    cin12211/orca-q

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

    224 GitHub stars~2.8k tokensUpdated 18 days ago
    DatabasesAuto-check passed
  • 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…

    348 GitHub stars~1.7k tokensUpdated yesterday
    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
  • 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.8k tokensUpdated today
    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 4 days ago
    DatabasesAuto-check: notes
  • Automating Database Backups

    jeremylongshore/tons-of-skills-marketplace

    Automate database backup processes with scheduling, compression, and encryption.

    2.8k GitHub stars~1.5k tokensUpdated today
    DatabasesAuto-check passed

More from curvenote/curvenote

All 10 skills in this repo
  • Supabase

    curvenote/curvenote

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

    170 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.

    170 GitHub starsUsed in 4 repos~1.1k tokens
    Auto-check passed
  • Prisma Client API

    curvenote/curvenote

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

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

    curvenote/curvenote

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

    170 GitHub starsUsed in 1 repo~937 tokens
    Auto-check: notes
  • Prisma Postgres Setup

    curvenote/curvenote

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

    170 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.

    170 GitHub stars~1.6k tokensUpdated 11 days ago
    Auto-check passed

Categories

Questions about Prisma Database Setup

What does Prisma Database Setup do?

Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, MongoDB, etc.). Prisma Database Setup is an agent skill from curvenote/curvenote.).

When should I use Prisma Database Setup?

Prisma Database Setup fits situations like: setting up a new project; changing databases; troubleshooting connection issues; configure postgres.

How do I install Prisma Database Setup in Claude Code?

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

How do I install Prisma Database Setup in Codex?

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

Can I use Prisma Database Setup 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-database-setup -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-database-setup, .gemini/skills/prisma-database-setup, .github/skills/prisma-database-setup and .opencode/skills/prisma-database-setup in your project.

What does Prisma Database Setup need to run?

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

Does Prisma Database Setup access the network?

SKILL.md contains no URLs. Its commands use npm and npx, which can reach the network depending on how they are called. This is read from the text; nothing was executed.

Is Prisma Database Setup safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Prisma Database Setup use?

Prisma Database Setup 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 Database Setup use?

About 1.4k tokens (SKILL.md is roughly 5.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 4.5k tokens, read only when the agent opens those files.

What are the alternatives to Prisma Database Setup?

Skills that share tags, products or a category with Prisma Database Setup: Database Expert (cin12211/orca-q, 224 stars), Better Drizzle (almeidazs/better-drizzle, 348 stars), Database Fundamentals (DanielPodolsky/ownyourcode, 290 stars) and Prisma 8 Contract-First ORM (prisma/orm, 48k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Prisma Database Setup?

curvenote (a GitHub organization) maintains it in curvenote/curvenote, which has 170 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.