MCPHub LabRegistryprisma/prisma
prisma

prisma/prisma

Built by prisma • 45,627 stars

What is prisma/prisma?

Prisma is a modern database toolkit that makes it easier for applications to work with databases. It acts as a bridge between your application code and your database, providing a simple way to read, write, and manage data without writing complex database queries.

How to use prisma/prisma?

First, define your database structure in a special schema file. Then generate a client that provides simple methods to interact with your data. Finally, use the client in your application to create, read, update, and delete records with simple commands like 'find all users' or 'create new post'.
🛡️ Scoped (Restricted)
npx @modelcontextprotocol/prisma-prisma --scope restricted
🔓 Unrestricted Access
npx @modelcontextprotocol/prisma-prisma

Key Features

Type-safe database queries that catch errors before runtime
Visual database browser to see your data
Automatic database migration tools
Support for multiple database types
Generated client code for easy data access

Optimized Use Cases

Building web applications that need to store user accounts and content
Creating REST APIs that manage business data
Developing e-commerce sites with product catalogs
Building content management systems
Creating any application that needs reliable data storage

prisma/prisma FAQ

Q

Do I need to know SQL to use Prisma?

No, Prisma generates simple methods like 'findMany()' or 'create()' so you don't need to write SQL queries manually.

Q

Can I use my existing database with Prisma?

Yes, Prisma can connect to existing databases and automatically generate a schema based on your current database structure.

Official Documentation

View on GitHub
<p align="center"> <a href="https://github.com/prisma/orm"> <img src="./images/prisma-8.png" alt="Prisma 8" width="680" /> </a> </p> <p align="center"> <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> </p> <p align="center"> <a href="./LICENSE"><img alt="License: Apache-2.0" src="https://img.shields.io/badge/license-Apache--2.0-blue.svg" /></a> <a href="https://www.npmjs.com/package/prisma"><img alt="npm" src="https://img.shields.io/npm/v/prisma?label=prisma" /></a> <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> </p>

Using Prisma 7? It remains fully supported. Its source lives on the v7 branch of this repository and its docs at prisma.io/docs/orm/v7.

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 names every gap. New projects should start here. Existing Prisma 7 applications can migrate incrementally, and Prisma 7 stays on the v7 branch with bug fixes and security updates for eighteen months after 8.0.0 final. Star the repo, follow @prisma on X, or read along on the Prisma blog.

Prisma 8 is a TypeScript rewrite of Prisma ORM, designed to be extensible, composable, and AI-agent friendly by default. Read the announcement or start with the docs.

Prerequisites

  • Node.js 24 or newer
  • A package manager (npm, pnpm, or yarn)

Getting started

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 for every template and flag, or follow the PostgreSQL and 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 and skills CLI references, or the guides for adding Prisma 8 to an existing PostgreSQL or 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.

Found a bug, missing a feature, or have a question for the team?

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.

For extension authors

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.

Extensions already shipping:

See Using extensions for how to install and register one. Want to ship your own? The call for extension authors walks through the SPI, the layers your extension can hook into, and how the team features new extensions.

Supported databases

  • PostgreSQL — the primary target, first-class support
  • MongoDB — first-class support
  • SQLite — planned next, a proof of concept today

MySQL follows after SQLite. See the feature scoreboard for what each database supports today.

Contributing

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

Security issues: follow the Private Vulnerability Reporting flow in SECURITY.md. Please do not file them as public issues.

Community

Built something with Prisma 8? Tag @prisma on X. The best community builds get a shout-out and a link here.

License

Apache 2.0. See LICENSE.

Global Ranking

8.5
Trust ScoreMCPHub Index

Based on codebase health & activity.

Manual Config

{ "mcpServers": { "prisma-prisma": { "command": "npx", "args": ["prisma-prisma"] } } }