Prisma MCP Server
OfficialProvides database access and management capabilities through Prisma ORM, including type-safe queries, database migrations, and data modeling for PostgreSQL, MySQL, SQLite, SQL Server, MongoDB, and CockroachDB databases.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Prisma MCP Servershow me the schema for the User model"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Using Prisma 7? It remains fully supported. Its source lives on the
v7branch of this repository and its docs at prisma.io/docs/orm/v7.
Prisma 8 is a release candidate.
8.0.0final 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 theprisma-8skill 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 thev7branch with bug fixes for twelve months after8.0.0final. 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, oryarn)
Related MCP server: PostgreSQL MCP
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 prismaYou 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 initorm 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 syncSee 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
postsmodel with a relation tousers, 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:
@prisma/orm-extension-pgvector: vector columns and similarity search.@prisma/orm-extension-postgis: geometry columns and geo queries.@prisma/orm-extension-paradedb: BM25 full-text search indexes (experimental).@prisma/orm-extension-supabase: Supabase auth and storage tables, role-bound clients (experimental).@prisma/orm-extension-arktype-json: JSON columns validated by an arktype schema.@cipherstash/prisma-next: searchable encryption and data-level access control.
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.
Discord: Talk to us in Discord
X: @prisma
Blog: prisma.io/blog
License
Apache 2.0. See LICENSE.
This server cannot be deployed
Maintenance
Related MCP Connectors
Manage Supabase projects end to end across database, auth, storage, realtime, and migrations. Moni…
Your Supabase account in natural language: run SQL, apply migrations, manage tables, storage, edge f
Comprehensive PostgreSQL documentation and best practices, including ecosystem tools
Related MCP Servers
- AlicenseNot gradedqualityAmaintenanceEnables secure, AI-driven PostgreSQL database administration, observability, and querying with support for extensions like PostGIS and pgvector, connection pooling, and advanced tool filtering.35 npm12MIT
- AlicenseNot gradedqualityCmaintenanceProvides AI-driven PostgreSQL database management with secure OAuth 2.1 authentication, enabling users to administer, monitor, and query databases with support for extensions like pgvector, PostGIS, and pg_cron.152 npm-

Berthofficial
AlicenseAqualityDmaintenanceDatabase management — connect, query, describe schemas, run migrations, and monitor active queries across PostgreSQL, MySQL, and SQLite.15MIT
lobsterdbofficial
AlicenseAqualityCmaintenanceEnables provisioning and managing PostgreSQL databases, running SQL queries, and evolving schemas with tracked migrations, with automatic account creation and no configuration needed.105 npmMIT