Prisma Postgres, verified

MCP server by Prisma · Verified

Manage Prisma Postgres databases, backups and connection strings, run SQL and inspect schema from your assistant.

OAuth sign-in (You sign in with the vendor the first time you connect)Streamable HTTP

Connect to Prisma Postgres

Prisma Postgres needs sign-in. Connect with its own URL:

https://mcp.prisma.io/mcp

Your client opens Prisma’s sign-in the first time you use it. The token stays between your client and Prisma.

Share this server

Opens this page, with the URL and setup steps.

mcp.tc/i/prisma

About

Connects your assistant to the Prisma platform so it can list and delete Prisma Postgres databases, create and restore backups, manage connection strings, run SQL queries and introspect a database schema.

It runs as a hosted streamable HTTP endpoint at https://mcp.prisma.io/mcp. You sign in with your Prisma Console account through OAuth. Clients without native remote support can connect through the mcp-remote npm package. Prisma also publishes a separate local server, started with npx prisma mcp.

What you can do

  • List Prisma Postgres databases in your workspace
  • Create backups and restore them to a new database
  • Create, list and delete connection strings
  • Run SQL queries against a database
  • Introspect a database schema
  • Delete a database by id

Tools

Prisma Postgres lists its tools only after you sign in, so we can’t show them here. Your client lists them once you’re connected.

Example prompts

  • Show me a list of all the databases in my account.

  • Show me all available backups of my database.

  • Create a backup, then seed my database with realistic data.

  • Introspect the schema of my database and describe the tables.

Set up

Every client connects to mcp.prisma.io, and Prisma asks you to sign in the first time. Pick yours; the page remembers your choice.

Claude Code

  1. Run this in a terminal, in your project folder:
claude mcp add --transport http prisma https://mcp.prisma.io/mcp
  1. Start Claude Code, type /mcp, pick prisma and choose Authenticate. A browser window opens for the Prisma sign-in.

Add --scope user to make it available in every project, not just this one.

Claude Desktop

  1. Open Settings → Connectors and click Add custom connector.
  2. Name it Prisma Postgres and paste this URL:
https://mcp.prisma.io/mcp
  1. Click Add, then Connect, and sign in when Prisma asks.

Claude Desktop’s JSON config file only starts local servers. Remote servers go through Connectors, and connectors you add on claude.ai show up here too.

claude.ai

  1. Open the connector form on claude.ai. This button fills in the name and URL for you:
  1. Check that the URL reads https://mcp.prisma.io/mcp and click Add.
  2. Click Connect and sign in when Prisma asks.

Free plans allow one custom connector. On Team and Enterprise plans an owner adds it under Organization settings → Connectors.

ChatGPT

  1. On chatgpt.com, open Settings → Security and login and turn on Developer mode.
  2. Go to chatgpt.com/plugins and click + to create an app for a remote MCP server.
  3. Paste https://mcp.prisma.io/mcp as the server URL and choose OAuth. ChatGPT sends you to Prisma to sign in.

Developer mode is available on the web for Plus, Pro, Business, Enterprise and Education accounts.

Cursor

Or add it by hand to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project):

mcp.json
{
  "mcpServers": {
    "prisma": {
      "url": "https://mcp.prisma.io/mcp"
    }
  }
}

Cursor shows Needs login next to the server. Click it to sign in.

VS Code

Or from a terminal:

code --add-mcp '{"name":"prisma","type":"http","url":"https://mcp.prisma.io/mcp"}'

Or commit it to the repo in .vscode/mcp.json:

.vscode/mcp.json
{
  "servers": {
    "prisma": {
      "type": "http",
      "url": "https://mcp.prisma.io/mcp"
    }
  }
}

VS Code asks you to sign in the first time the server starts.

Devin Desktop

  1. Add it to ~/.config/devin/mcp_config.json (macOS and Linux) or %APPDATA%\devin\mcp_config.json (Windows):
mcp_config.json
{
  "mcpServers": {
    "prisma": {
      "serverUrl": "https://mcp.prisma.io/mcp"
    }
  }
}
  1. Refresh the MCP server list in Cascade and sign in when asked.

Devin Desktop is the new name for Windsurf. It reads serverUrl (or url) for remote servers.

Codex

codex mcp add prisma --url https://mcp.prisma.io/mcp
codex mcp login prisma

Or edit ~/.codex/config.toml directly:

config.toml
[mcp_servers.prisma]
url = "https://mcp.prisma.io/mcp"

Gemini CLI

gemini mcp add --transport http prisma https://mcp.prisma.io/mcp

Then, inside Gemini CLI, run /mcp auth prisma to sign in.

This adds it to the current project. Add -s user to use it everywhere.

Any client

Most clients accept this shape. Some name the URL field differently: serverUrl in Devin Desktop, httpUrl in Gemini CLI’s settings file.

{
  "mcpServers": {
    "prisma": {
      "type": "http",
      "url": "https://mcp.prisma.io/mcp"
    }
  }
}

Zed puts servers under context_servers in its settings. Cline needs "type": "streamableHttp", or it assumes SSE.

Client only starts local servers? Bridge it with npx -y mcp-remote https://mcp.prisma.io/mcp.

FAQ

Can I paste mcp.tc/i/prisma into my MCP client?

No. mcp.tc links are pages, not server addresses. Connect with https://mcp.prisma.io/mcp, so your client talks to Prisma Postgres directly. The sign-in token only works there anyway. The quick link is for sharing: it opens this page, with setup steps for every client.

Does Prisma Postgres need an API key or a sign-in?

Yes, you need a Prisma account. The first time your client connects, it opens Prisma’s sign-in page. The token goes straight to the server’s own URL, never through mcp.tc.

Is Prisma Postgres a remote or a local server?

Remote. Prisma hosts it at https://mcp.prisma.io/mcp, and it speaks Streamable HTTP. There’s nothing to install.

What can Prisma Postgres do?

You can list Prisma Postgres databases in your workspace, create backups and restore them to a new database and create, list and delete connection strings.

Which clients can use it?

Any client that supports remote MCP servers: Claude Code, Claude Desktop, claude.ai, ChatGPT in developer mode, Cursor, VS Code, Devin Desktop, Codex, Gemini CLI, Zed and others. The setup steps cover each one.

Who wrote this page?

mcp.tc’s robot read Prisma Postgres’s own metadata (its MCP handshake, tool list and public pages), and an AI model drafted the text from it. A person reviews anything the checks can’t confirm. The text can still be wrong, so if you spot a mistake, use Report this listing on this page.

Embed

Show Prisma Postgres in a README or on your site. Each embed links to this page, uses the server’s own URL, and sets no cookies. How embeds work

README badge

Badge preview, lightBadge preview, dark
Markdown
[![Prisma Postgres on mcp.tc](https://mcp.tc/i/prisma/badge.svg)](https://mcp.tc/i/prisma)
HTML
<a href="https://mcp.tc/i/prisma"><img src="https://mcp.tc/i/prisma/badge.svg" alt="Prisma Postgres on mcp.tc" height="20"></a>

It follows the reader’s light or dark mode. Add ?theme=light or ?theme=dark to fix it, or ?style=compact to show the mark without the word.

Website card

HTML
<script src="https://mcp.tc/w/prisma.js" async></script>

The card appears where the tag is. Add data-theme="dark" or data-size="compact" to the tag to change it. The file holds everything it needs, so it makes no other requests and sets no cookies.

iframe

HTML
<iframe src="https://mcp.tc/embed/prisma" title="Prisma Postgres on mcp.tc" width="420" height="200" loading="lazy" allow="clipboard-write" style="border:0;border-radius:8px;max-width:100%"></iframe>

Use it on pages that don’t allow scripts. Add ?theme=light or ?theme=dark to the address to fix the colors.

JSON

The listing as data for your own pages and tools: name, tagline, the server’s own URL, tools and the “Add to” links. Any site can read it (CORS is open).

https://mcp.tc/i/prisma.json

What each field means

mcp.tc isn’t affiliated with Prisma. This page was built from Prisma Postgres’s public metadata, last checked on 3 Oct 2026, and an AI model wrote the description, so it can be wrong. Names and marks belong to their owners. Something off? Report this listing.