Skip to content
Back to search

orm

Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB

Safety scan

A static text scan, not a guarantee. Select the badge to see what was scanned and every finding.

Checked today

Check it deeper on your machine

It has changed since its scan on 11 Nov 2026.

As a Claude Code plugin, install it and then ask Claude Code:

/plugin marketplace add keithmackay/mackayi/plugin install scanskillsafety@mackayiDo a deep scan of https://github.com/prisma/orm with scanskillsafety

Or from a terminal, clone it and run it:

git clone https://github.com/keithmackay/scanskillsafety-skill ~/.claude/skills/scanskillsafetynode ~/.claude/skills/scanskillsafety/cli.cjs --deep 'https://github.com/prisma/orm'

It checks the exact commit: every file, its packages against OSV (api.osv.dev), how it compares with this page's scan (findsafeskills.com receives the repository's address), and, if you agree, Claude reading every file with your own Claude subscription. It never runs the code.

Badge for your README
findsafeskills safety rating

Markdown

[![findsafeskills safety rating](/api/listings/prisma--orm/badge.svg)](/listings/prisma--orm)

HTML

<a href="/listings/prisma--orm"><img src="/api/listings/prisma--orm/badge.svg" alt="findsafeskills safety rating" /></a>

Install

i

Install instructions from the README

As written by the repo's author. findsafeskills has not verified these steps.

1. Scaffold a new project

The interactive scaffolder picks an app template (Next.js, Hono, Nuxt, Astro, NestJS, SvelteKit, TanStack Start, or Elysia) and wires Prisma 8 in with your chosen database (PostgreSQL or MongoDB):

npm create prisma

You finish with a runnable app, a starter contract, and the agent skills already installed. See the [create-prisma reference](https://www.prisma.io/docs/prisma-orm/create-prisma) for every template and flag, or follow the [PostgreSQL](https://www.prisma.io/docs/prisma-orm/quickstart/postgresql) and [MongoDB](https://www.prisma.io/docs/prisma-orm/quickstart/mongodb) quickstarts.

2. Or, add Prisma 8 to an existing project

Run this from your repo root:

npx prisma orm init

`orm init` writes `prisma.config.ts`, scaffolds a starter contract and `db.ts` under `src/prisma/`, installs the runtime, and emits the contract. It does not touch your framework or build setup. Then install the agent skills:

npx prisma skills sync

See the [`orm init`](https://www.prisma.io/docs/cli/orm-init) and [`skills`](https://www.prisma.io/docs/cli/skills) CLI references, or the guides for adding Prisma 8 to an existing [PostgreSQL](https://www.prisma.io/docs/prisma-orm/add-to-existing-project/postgresql) or [MongoDB](https://www.prisma.io/docs/prisma-orm/add-to-existing-project/mongodb) app.

3. Use your AI agent for everything Prisma 8

Both installers leave a top-level **`prisma-8.md`** primer at your project root for any agent to read first, and install one **`SKILL.md`** per workflow into the directories agent runtimes read:

- `.claude/skills/<skill-name>/SKILL.md` — Claude Code - `.cursor/skills/<skill-name>/SKILL.md` — Cursor - `.agents/skills/<skill-name>/SKILL.md` — universal location for Copilot Agent and other runtimes - `.devin/skills/<skill-name>/SKILL.md` — Devin

Skills ship inside the Prisma packages your project installs, so they always describe the version in use. Your editor's AI assistant auto-loads the right skill when your prompt matches.

Just describe what you want. For example:

> *"Add a `posts` model with a relation to `users`, then write a query that loads each user's three most recent posts."*

The agent loads the `prisma-8` skill, opens its contract and queries references, then drives the change end-to-end.

For the full catalogue and what each skill covers, see [`skills/README.md`](./skills/README.md).

What was scanned

The files the safety scan read, as written by the repository's author and shown as plain text. Lines with a finding are marked.

README.md · README · 121 lines

View this file on GitHub (read at the repository's current version: the scan did not record which commit it read)

This file has changed since it was scanned, so this is not exactly the text that was scanned, and no line is marked. The findings are listed with the safety scan above.

  1. <p align="center">
  2. <a href="https://github.com/prisma/orm">
  3. <img src="./images/prisma-8.png" alt="Prisma 8" width="680" />
  4. </a>
  5. </p>
  6. <p align="center">
  7. <a href="https://www.prisma.io/docs/orm">Docs</a> | <a href="https://pris.ly/discord">Discord</a> | <a href="https://twitter.com/prisma">X</a> | <a href="https://pris.ly/pn-announcement">Blog Post</a> | <a href="./ARCHITECTURE.md">Architecture</a>
  8. </p>
  9. <p align="center">
  10. <a href="./LICENSE"><img alt="License: Apache-2.0" src="https://img.shields.io/badge/license-Apache--2.0-blue.svg" /></a>
  11. <a href="https://www.npmjs.com/package/prisma"><img alt="npm" src="https://img.shields.io/npm/v/prisma?label=prisma" /></a>
  12. <a href="https://github.com/prisma/orm/actions/workflows/ci.yml"><img alt="CI" src="https://github.com/prisma/orm/actions/workflows/ci.yml/badge.svg" /></a>
  13. </p>
  14. ---
  15. > **Using Prisma 7?** It is maintained for eighteen months after `8.0.0` final; [supported versions](./docs/oss/versioning.md#supported-versions) says what that covers. Its source lives on the [`v7` branch](https://github.com/prisma/orm/tree/v7) of this repository and its docs at [prisma.io/docs/orm/v7](https://www.prisma.io/docs/orm/v7).
  16. > **Prisma 8 is a release candidate.** `8.0.0` final is expected in the next four to eight weeks. Until then a release candidate may include breaking changes, and every release ships with an upgrade recipe that the `prisma-8` skill applies for you. The candidate is a complete implementation we stand behind: we treat bugs in it as urgent, and the risk you take on is a feature that is not built yet rather than churn. The [feature scoreboard](./scorecard.md) names every gap. New projects should start here. Existing Prisma 7 applications can migrate incrementally, and Prisma 7 stays maintained on the [`v7` branch](https://github.com/prisma/orm/tree/v7) for eighteen months after `8.0.0` final. Star the repo, follow [@prisma on X](https://pris.ly/x), or read along on the [Prisma blog](https://www.prisma.io/blog).
  17. **Prisma 8** is a TypeScript rewrite of Prisma ORM, designed to be **extensible**, **composable**, and **AI-agent friendly** by default. Read the [announcement](https://pris.ly/pn-announcement) or start with the [docs](https://www.prisma.io/docs/orm).
  18. ## Prerequisites
  19. - Node.js 24 or newer
  20. - A package manager (`npm`, `pnpm`, or `yarn`)
  21. ## Getting started
  22. ### 1. Scaffold a new project
  23. The interactive scaffolder picks an app template (Next.js, Hono, Nuxt, Astro, NestJS, SvelteKit, TanStack Start, or Elysia) and wires Prisma 8 in with your chosen database (PostgreSQL or MongoDB):
  24. ```bash
  25. npm create prisma
  26. ```
  27. You finish with a runnable app, a starter contract, and the agent skills already installed. See the [create-prisma reference](https://www.prisma.io/docs/prisma-orm/create-prisma) for every template and flag, or follow the [PostgreSQL](https://www.prisma.io/docs/prisma-orm/quickstart/postgresql) and [MongoDB](https://www.prisma.io/docs/prisma-orm/quickstart/mongodb) quickstarts.
  28. ### 2. Or, add Prisma 8 to an existing project
  29. Run this from your repo root:
  30. ```bash
  31. npx prisma orm init
  32. ```
  33. `orm init` writes `prisma.config.ts`, scaffolds a starter contract and `db.ts` under `src/prisma/`, installs the runtime, and emits the contract. It does not touch your framework or build setup. Then install the agent skills:
  34. ```bash
  35. npx prisma skills sync
  36. ```
  37. See the [`orm init`](https://www.prisma.io/docs/cli/orm-init) and [`skills`](https://www.prisma.io/docs/cli/skills) CLI references, or the guides for adding Prisma 8 to an existing [PostgreSQL](https://www.prisma.io/docs/prisma-orm/add-to-existing-project/postgresql) or [MongoDB](https://www.prisma.io/docs/prisma-orm/add-to-existing-project/mongodb) app.
  38. ### 3. Use your AI agent for everything Prisma 8
  39. Both installers leave a top-level **`prisma-8.md`** primer at your project root for any agent to read first, and install one **`SKILL.md`** per workflow into the directories agent runtimes read:
  40. - `.claude/skills/<skill-name>/SKILL.md` — Claude Code
  41. - `.cursor/skills/<skill-name>/SKILL.md` — Cursor
  42. - `.agents/skills/<skill-name>/SKILL.md` — universal location for Copilot Agent and other runtimes
  43. - `.devin/skills/<skill-name>/SKILL.md` — Devin
  44. Skills ship inside the Prisma packages your project installs, so they always describe the version in use. Your editor's AI assistant auto-loads the right skill when your prompt matches.
  45. Just describe what you want. For example:
  46. > *"Add a `posts` model with a relation to `users`, then write a query that loads each user's three most recent posts."*
  47. The agent loads the `prisma-8` skill, opens its contract and queries references, then drives the change end-to-end.
  48. For the full catalogue and what each skill covers, see [`skills/README.md`](./skills/README.md).
  49. ## Found a bug, missing a feature, or have a question for the team?
  50. Ask your agent. The `prisma-8` skill's feedback flow drafts a structured GitHub issue or hands you a Prisma Discord link for live Q&A. You can review and confirm before anything is submitted.
  51. ## For extension authors
  52. Prisma 8 has a minimal core. Everything around it, including Postgres support itself, is built on the same public SPI that's available to any author. If you've wanted to integrate your tool, your database, or your library with Prisma, this is the way in.
  53. Extensions already shipping:
  54. - **[`@prisma/orm-extension-pgvector`](https://www.npmjs.com/package/@prisma/orm-extension-pgvector)**: vector columns and similarity search.
  55. - **[`@prisma/orm-extension-postgis`](https://www.npmjs.com/package/@prisma/orm-extension-postgis)**: geometry columns and geo queries.
  56. - **[`@prisma/orm-extension-paradedb`](https://www.npmjs.com/package/@prisma/orm-extension-paradedb)**: BM25 full-text search indexes (experimental).
  57. - **[`@prisma/orm-extension-supabase`](https://www.npmjs.com/package/@prisma/orm-extension-supabase)**: Supabase auth and storage tables, role-bound clients (experimental).
  58. - **[`@prisma/orm-extension-arktype-json`](https://www.npmjs.com/package/@prisma/orm-extension-arktype-json)**: JSON columns validated by an arktype schema.
  59. - **[`@prisma/orm-postgres-contrib`](https://www.npmjs.com/package/@prisma/orm-postgres-contrib)**: packs for the trusted PostgreSQL contrib modules, starting with `citext` case-insensitive text.
  60. - **[`@cipherstash/stack-prisma`](https://www.npmjs.com/package/@cipherstash/stack-prisma)**: searchable encryption and data-level access control.
  61. See [Using extensions](https://www.prisma.io/docs/orm/extensions/using-extensions) for how to install and register one. Want to ship your own? The **[call for extension authors](https://pris.ly/pn-extension-authors)** walks through the SPI, the layers your extension can hook into, and how the team features new extensions.
  62. ## Supported databases
  63. - **PostgreSQL** — the primary target, first-class support
  64. - **MongoDB** — first-class support
  65. - **SQLite** — planned next, a proof of concept today
  66. MySQL follows after SQLite. See the [feature scoreboard](./scorecard.md) for what each database supports today.
  67. ## Contributing
  68. See [CONTRIBUTING.md](./CONTRIBUTING.md) for setup, commands, DCO signoff, and PR expectations. For substantive changes, please open an issue first so we can give direction-fit feedback before you invest implementation time. The [vision](./docs/design/00-purpose/vision.md) says where Prisma 8 is going, and the [steering list](./docs/architecture%20docs/ADR-INDEX.md#steering-list) names requests we have already answered, with what to use instead.
  69. Security issues: follow the Private Vulnerability Reporting flow in [SECURITY.md](./SECURITY.md). Please do not file them as public issues.
  70. ## Community
  71. Built something with Prisma 8? Tag [@prisma](https://pris.ly/x) on X. The best community builds get a shout-out and a link here.
  72. - **Discord**: Talk to us in [Discord](https://pris.ly/discord)
  73. - **X**: [@prisma](https://pris.ly/x)
  74. - **Blog**: [prisma.io/blog](https://www.prisma.io/blog)
  75. ## License
  76. Apache 2.0. See [LICENSE](./LICENSE).

Ratings and comments

Sign in to rate this skill.

Sign in

Free to use. If it’s helped, pass it on.