Skip to content
Prisma

Prisma

by Prisma
v7.9.1
Apache-2.0
Repository Docs npm
Databases & Data
prismapostgresdatabaseormmigrationsbackups

Summary

Prisma's official MCP servers — a local one for database workflows in your editor, and a remote one for managing Prisma Postgres from an AI platform.

Features

  • Local server for schema migrations and database creation in your editor
  • Remote server for managing Prisma Postgres on behalf of your users
  • Provision and delete databases; list them across a workspace
  • Create backups and restore to a new database from a backup id
  • Create, list and delete connection strings
  • Execute SQL and introspect a database schema

Installation

Set up this MCP server in your favorite AI agent — copy a ready-made configuration below.

Any MCP-compatible agent

Most agents (Claude, Cursor, Windsurf, VS Code, and more) read a standard mcpServers configuration.

  1. Open your agent's MCP configuration file.
  2. Merge the snippet below into it.
  3. Restart the agent — the "Prisma" tools will be available.
{
  "mcpServers": {
    "prisma": {
      "command": "npx",
      "args": [
        "-y",
        "prisma",
        "mcp"
      ]
    }
  }
}

Description

Prisma ships two MCP servers, and which one you want depends on who is holding the agent.

Local server

npx -y prisma mcp runs alongside your project and is aimed at developers. It lets a coding agent handle the database chores that surround application work — creating a Postgres database, applying schema migrations, and driving the local Prisma workflow — from prompts such as "create a Postgres database" or "apply the schema migration" in VS Code agent mode, Cursor, or Claude Code. The agent stays in the repository where the schema lives.

Remote server

https://mcp.prisma.io/mcp, reached through mcp-remote, is for products that want to give their users database management. It exposes managed Prisma Postgres as tools: ListDatabasesTool, CreateBackupTool, CreateRecoveryTool, ListBackupsTool, connection-string create, list and delete, DeleteDatabaseTool, ExecuteSqlQueryTool, and IntrospectSchemaTool. If you are building an AI platform where end users need to provision and query their own databases, this is the integration point — authentication runs through the Prisma Console rather than through a key you distribute.

What it is good at

The tool set covers the full lifecycle rather than just queries: provisioning, backup and point-in-time recovery to a new database, connection-string rotation, schema introspection, and SQL execution. That makes prompts like "seed my database with realistic data but take a backup first" resolvable in one turn, because the backup and the seed are both tools the agent already has.

Both servers follow standard JSON MCP configuration. Prisma is Apache-2.0 licensed and the CLI that hosts the local server is on the 7.x line.

Related MCP Servers

MCP: DBHub

by Bytebase

New

A universal database MCP server — one integration for PostgreSQL, MySQL, SQL Server, SQLite, and MariaDB.

Databases & Data

MCP: MongoDB

by MongoDB

New

MongoDB's official MCP server — query databases, explore schemas, and manage Atlas clusters from an AI client.

Databases & Data

MCP: Upstash Redis

by Upstash

New

Run Redis commands against Upstash's serverless Redis over HTTP, with documentation search built in.

Databases & Data

MCP: dbt

by dbt Labs

New

dbt Labs' official MCP server — explore project metadata, run dbt commands, and query the Semantic Layer.

Databases & Data
Browse all MCP servers →