Database Fundamentals
DanielPodolsky/ownyourcode
Reviews schema design, SQL queries, ORM patterns. An agent skill from DanielPodolsky/ownyourcode.
Complete migration guide from Prisma ORM v6 to v7 covering all breaking changes.
$ npx skills add aiskillstore/marketplace --skill prisma-upgrade-v7 -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install aiskillstore/marketplace prisma-upgrade-v7 --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/aiskillstore/marketplace.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/prisma/prisma-upgrade-v7 .claude/skills/prisma-upgrade-v7 && rm -rf skills-srcUse ~/.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/
Install the "prisma-upgrade-v7" agent skill from https://github.com/aiskillstore/marketplace/tree/main/skills/prisma/prisma-upgrade-v7 into .claude/skills/prisma-upgrade-v7/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "prisma-upgrade-v7", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/aiskillstore/marketplace/tree/main/skills/prisma/prisma-upgrade-v7Type this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add aiskillstore/marketplace --skill prisma-upgrade-v7 -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install aiskillstore/marketplace prisma-upgrade-v7 --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/aiskillstore/marketplace.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/prisma/prisma-upgrade-v7 .agents/skills/prisma-upgrade-v7 && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "prisma-upgrade-v7" agent skill from https://github.com/aiskillstore/marketplace/tree/main/skills/prisma/prisma-upgrade-v7 into .agents/skills/prisma-upgrade-v7/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "prisma-upgrade-v7", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add aiskillstore/marketplace --skill prisma-upgrade-v7 -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install aiskillstore/marketplace prisma-upgrade-v7 --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/aiskillstore/marketplace.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/prisma/prisma-upgrade-v7 .cursor/skills/prisma-upgrade-v7 && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "prisma-upgrade-v7" agent skill from https://github.com/aiskillstore/marketplace/tree/main/skills/prisma/prisma-upgrade-v7 into .cursor/skills/prisma-upgrade-v7/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "prisma-upgrade-v7", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/aiskillstore/marketplace.git --path skills/prisma/prisma-upgrade-v7--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add aiskillstore/marketplace --skill prisma-upgrade-v7 -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install aiskillstore/marketplace prisma-upgrade-v7 --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/aiskillstore/marketplace.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/prisma/prisma-upgrade-v7 .gemini/skills/prisma-upgrade-v7 && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "prisma-upgrade-v7" agent skill from https://github.com/aiskillstore/marketplace/tree/main/skills/prisma/prisma-upgrade-v7 into .gemini/skills/prisma-upgrade-v7/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "prisma-upgrade-v7", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install aiskillstore/marketplace prisma-upgrade-v7Installs for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add aiskillstore/marketplace --skill prisma-upgrade-v7 -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/aiskillstore/marketplace.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/prisma/prisma-upgrade-v7 .github/skills/prisma-upgrade-v7 && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "prisma-upgrade-v7" agent skill from https://github.com/aiskillstore/marketplace/tree/main/skills/prisma/prisma-upgrade-v7 into .github/skills/prisma-upgrade-v7/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "prisma-upgrade-v7", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add aiskillstore/marketplace --skill prisma-upgrade-v7 -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install aiskillstore/marketplace prisma-upgrade-v7 --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/aiskillstore/marketplace.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/prisma/prisma-upgrade-v7 .opencode/skills/prisma-upgrade-v7 && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "prisma-upgrade-v7" agent skill from https://github.com/aiskillstore/marketplace/tree/main/skills/prisma/prisma-upgrade-v7 into .opencode/skills/prisma-upgrade-v7/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "prisma-upgrade-v7", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
prisma-upgrade-v7Complete migration guide from Prisma ORM v6 to v7 covering all breaking changes.
Prisma Upgrade V7 is an agent skill from aiskillstore/marketplace. Complete migration guide from Prisma ORM v6 to v7 covering all breaking changes. Use when upgrading Prisma versions, encountering v7 errors, or migrating existing projects. Triggers on "upgrade to prisma 7", "prisma 7 migration", "prisma-client generator", "driver adapter required".
Its SKILL.md is about 2k tokens, which your agent loads only when the skill is triggered. The skill folder holds 9 other files, including reference files (for example `references/accelerate-users.md`, `references/driver-adapters.md` and `references/env-variables.md`).
It sits in Databases, covering ORMs and data access. It works with Prisma, MongoDB and SQL. The repository describes itself as: Security-audited skills for Claude, Codex & Claude Code. One-click install, quality verified. The licence is MIT.
8 steps, taken from the step headings in SKILL.md.
Read from SKILL.md and the folder at commit 44923f3. It shows what the files ask for, not the result of running them.
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.
Shell commands in SKILL.md call:
npmnpxFrom the folder's file list and the shell code blocks in SKILL.md.
Links to these hosts (documentation or services it may open):
prisma.ioFrom URLs in SKILL.md, links to its own repository left out.
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Prisma Upgrade V7 loads about 2k tokens when it runs, and up to ~9k if it reads all its reference files. Until then it costs about 75 tokens; SKILL.md has 601 words of instructions outside code blocks.
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.
The automated check noted patterns worth knowing about, such as sudo or a known installer.
| Config file | `.env` + schema | `prisma.config.ts` |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.
The full file from aiskillstore/marketplace at commit 44923f3, republished under its MIT licence (© aiskillstore). 601 words, ~2,019 tokens.
.claude/skills/prisma-upgrade-v7/SKILL.md (or your agent's skills folder). This skill also uses 8 other files; get the full folder from GitHub.Complete guide for migrating from Prisma ORM v6 to v7. This upgrade introduces significant breaking changes around the new prisma-client generator, driver adapters, prisma.config.ts, explicit environment loading, and generated client entrypoints.
Reference this skill when:
prisma-client generatorprisma.config.ts| Priority | Category | Impact | Prefix |
|---|---|---|---|
| 1 | Schema Migration | CRITICAL | schema-changes |
| 2 | Database Connectivity | CRITICAL | driver-adapters |
| 3 | Module System | CRITICAL | esm-support |
| 4 | Config and Env | HIGH | prisma-config, env-variables |
| 5 | Removed Features | HIGH | removed-features |
| 6 | Accelerate | HIGH | accelerate-users |
schema-changes - generator migration, required output paths, generated entrypoints, and Prisma.validator replacementdriver-adapters - required adapter installation for SQL providers, pool differences, and Prisma Postgres adapter choicesesm-support - ESM-first setup plus CommonJS fallback with moduleFormat = "cjs"prisma-config - creating and using prisma.config.tsenv-variables - explicit environment loadingremoved-features - removed middleware, metrics, and legacy CLI behavioraccelerate-users - migration notes for Accelerate usersPrisma 7 has no MongoDB connector. Do not apply any step in this guide to a project with
provider = "mongodb" — see the prisma-mongodb-upgrade skill for the actual decision
(stay on v6 deliberately vs migrate to Prisma Next).
prisma-mongodb-upgrade)7.6.0esm by default, cjs if needed)prisma.config.tsPrisma.validatorprisma generate and test# Update packages
npm install @prisma/client@7
npm install -D prisma@7
# Install a driver adapter (PostgreSQL or Prisma Postgres via direct TCP)
npm install @prisma/adapter-pg pg
# Install dotenv for env loading
npm install dotenv
# Regenerate client
npx prisma generate| Change | v6 | v7 |
|---|---|---|
| Module format | Implicit / mixed | ESM-first, moduleFormat = "cjs" supported |
| Generator provider | prisma-client-js | prisma-client is the default, while prisma-client-js still exists for legacy setups |
| Output path | Auto (node_modules) | Required explicit |
| Driver adapters | Optional | Required for SQL providers |
| Config file | .env + schema | prisma.config.ts |
| Env loading | Automatic | Manual (dotenv) |
| Generated entrypoints | Single package export | client, browser, models, enums entrypoints |
| Type-safe query fragments | Prisma.validator() | TypeScript satisfies |
| Middleware | $use() | Client Extensions |
| Metrics | Preview feature | Removed |
Detailed migration guides for each breaking change:
references/esm-support.md - ESM and CommonJS configuration
references/schema-changes.md - Generator, output, imports, and generated entrypoints
references/driver-adapters.md - Required driver adapter setup
references/prisma-config.md - New configuration file
references/env-variables.md - Environment variable loading
references/removed-features.md - Middleware, metrics, and CLI flags
references/accelerate-users.md - Special handling for Accelerate{
"type": "module"
}If you need to stay on CommonJS, keep your app as CJS and set moduleFormat = "cjs" in the generator block instead of forcing ESM.
{
"compilerOptions": {
"module": "ESNext",
"moduleResolution": "bundler",
"target": "ES2023",
"strict": true,
"esModuleInterop": true
}
}// Before (v6)
generator client {
provider = "prisma-client-js"
}
// After (v7)
generator client {
provider = "prisma-client"
output = "../generated/prisma"
// Optional if you need CommonJS:
// moduleFormat = "cjs"
}import 'dotenv/config'
import { defineConfig, env } from 'prisma/config'
export default defineConfig({
schema: 'prisma/schema.prisma',
migrations: {
path: 'prisma/migrations',
},
datasource: {
url: env('DATABASE_URL'),
},
})# PostgreSQL
npm install @prisma/adapter-pg pg
# MySQL
npm install @prisma/adapter-mariadb mariadb
# SQLite
npm install @prisma/adapter-better-sqlite3 better-sqlite3
# Prisma Postgres in standard Node.js apps (recommended)
npm install @prisma/adapter-pg pg
# Prisma Postgres serverless driver (edge/serverless)
npm install @prisma/adapter-ppg @prisma/ppg
# Neon
npm install @prisma/adapter-neonMongoDB does not have a SQL @prisma/adapter-* package in the published Prisma 7.6.0 packages. If you're upgrading a MongoDB project, stop and keep that project on the latest Prisma 6.x release instead of following the standard Prisma 7 migration path.
// Before (v6)
import { PrismaClient } from '@prisma/client'
const prisma = new PrismaClient()
// After (v7)
import { PrismaClient } from '../generated/prisma/client'
import { PrismaPg } from '@prisma/adapter-pg'
const adapter = new PrismaPg({
connectionString: process.env.DATABASE_URL
})
const prisma = new PrismaClient({ adapter })import { Prisma } from '../generated/prisma/client'
const userSelect = {
id: true,
email: true,
name: true,
} satisfies Prisma.UserSelectnpx prisma generate
npx prisma migrate dev # if neededoutput path matches your import pathprisma generate ran successfullyssl: { rejectUnauthorized: false } to the adapter config if you need to preserve old behaviorNODE_EXTRA_CA_CERTS / OpenSSL CA settingsFollow references/schema-changes.md and references/driver-adapters.md first, then apply the remaining reference files based on your project setup.
© aiskillstore, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
SKILL.md and 8 other files (references) in skills/prisma/prisma-upgrade-v7 of aiskillstore/marketplace.
Open the folder on GitHubat commit 44923f3
Prisma Upgrade V7 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.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Prisma Upgrade V7 this skillaiskillstore/marketplace | 433 | — | ~2k | Automated safety check: Notes | MIT | |
| Database FundamentalsDanielPodolsky/ownyourcode | 290 | 1 repos | ~1.6k | Automated safety check: Pass | MIT | |
| DB SculptorEliasOulkadi/shokunin | 114 | — | ~3.1k | Automated safety check: Notes | MIT | |
| Database Testingpetrkindlmann/qa-skills | 170 | — | ~4.2k | Automated safety check: Pass | MIT | |
| Prisma Database Setupcurvenote/curvenote | 170 | 3 repos | ~1.4k | Automated safety check: Pass | MIT | |
| Create Auth Skilldeadlock-mod-manager/deadlock-mod-manager | 478 | 4 repos | ~3.4k | Automated safety check: Pass | GPL-3.0 |
DanielPodolsky/ownyourcode
Reviews schema design, SQL queries, ORM patterns. An agent skill from DanielPodolsky/ownyourcode.
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…
petrkindlmann/qa-skills
Validate database integrity, test migrations forward and backward, verify schema constraints, manage seed data, detect migration drift, and identify query performance issues.
curvenote/curvenote
Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, MongoDB, etc.).
deadlock-mod-manager/deadlock-mod-manager
Scaffold and implement authentication in TypeScript/JavaScript apps using Better Auth.
bretzel-app/crumbs
Drizzle ORM schema management and SQLite migrations — adding tables, modifying columns, creating indexes, generating and running migrations, Drizzle query patterns.
aiskillstore/marketplace
Analyze codebase with tokei (fast line counts by language) and difft (semantic AST-aware diffs).
aiskillstore/marketplace
Process JSON with jq and YAML/TOML with yq. An agent skill from aiskillstore/marketplace.
aiskillstore/marketplace
Scans for project documentation files (AGENTS.md, CLAUDE.md, GEMINI.md, COPILOT.md, CURSOR.md, WARP.md, and 15+ other formats) and synthesizes guidance.
aiskillstore/marketplace
Modern file and content search using fd, ripgrep (rg), and fzf.
aiskillstore/marketplace
Modern find-and-replace using sd (simpler than sed) and batch replacement patterns.
aiskillstore/marketplace
Detects stale project plans and suggests session commands. An agent skill from aiskillstore/marketplace.
Categories
Complete migration guide from Prisma ORM v6 to v7 covering all breaking changes. Prisma Upgrade V7 is an agent skill from aiskillstore/marketplace. Complete migration guide from Prisma ORM v6 to v7 covering all breaking changes.
Prisma Upgrade V7 fits situations like: upgrading Prisma versions; encountering v7 errors; migrating existing projects; upgrade to prisma 7.
Run `npx skills add aiskillstore/marketplace --skill prisma-upgrade-v7 -a claude-code`. Or copy the skill folder (skills/prisma/prisma-upgrade-v7 in aiskillstore/marketplace) into .claude/skills/prisma-upgrade-v7 in your project. Claude Code loads it when a task matches its description.
Run `npx skills add aiskillstore/marketplace --skill prisma-upgrade-v7 -a codex`. Or copy the skill folder (skills/prisma/prisma-upgrade-v7 in aiskillstore/marketplace) into .agents/skills/prisma-upgrade-v7 in your project. Codex loads it when a task matches its description.
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add aiskillstore/marketplace --skill prisma-upgrade-v7 -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-upgrade-v7, .gemini/skills/prisma-upgrade-v7, .github/skills/prisma-upgrade-v7 and .opencode/skills/prisma-upgrade-v7 in your project.
Going by SKILL.md and its folder, Prisma Upgrade V7 needs the command-line tools its instructions call (npm and npx). Our summary lists: Node.js.
SKILL.md names 1 domain. As links in the text: prisma.io. This is read from the text; nothing was executed.
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.
Prisma Upgrade V7 is published under the MIT licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.
About 2k tokens (SKILL.md is roughly 8.1k 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 7k tokens, read only when the agent opens those files.
Skills that share tags, products or a category with Prisma Upgrade V7: Database Fundamentals (DanielPodolsky/ownyourcode, 290 stars), DB Sculptor (EliasOulkadi/shokunin, 114 stars), Database Testing (petrkindlmann/qa-skills, 170 stars) and Prisma Database Setup (curvenote/curvenote, 170 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
aiskillstore (a GitHub organization) maintains it in aiskillstore/marketplace, which has 433 GitHub stars. The repository holds 1,044 skills in this directory. The repository was last updated on October 10, 2026.
Source: aiskillstore/marketplace on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.