# Prisma Postgres MCP server

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

- Listing: https://mcp.tc/i/prisma
- Connect: use the server's own URL `https://mcp.prisma.io/mcp` (OAuth sign-in at the server); clients connect to it directly. The listing link is a page, not an MCP endpoint.
- Type: remote (Streamable HTTP)
- Auth: OAuth sign-in
- Category: [Databases & Backend](https://mcp.tc/c/databases)
- Vendor: Prisma
- Verified: yes, mcp.tc checked that this is the official server (https://mcp.tc/verify). It says who runs the server, not that it is safe.
- Homepage: <https://www.prisma.io/docs/ai/tools/mcp-server>
- Repository: <https://github.com/prisma/mcp>

## 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 it 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

## 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."

## Install

### Claude Code

1. Run this in a terminal, in your project folder:

```bash
claude mcp add --transport http prisma https://mcp.prisma.io/mcp
```

2. 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:

```url
https://mcp.prisma.io/mcp
```

3. 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:

[Add to claude.ai](<https://claude.ai/customize/connectors?modal=add-custom-connector&connectorName=Prisma%20Postgres&connectorUrl=https%3A%2F%2Fmcp.prisma.io%2Fmcp>) (opens connector settings)

2. Check that the URL reads `https://mcp.prisma.io/mcp` and click **Add**.

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

[Add to Cursor](<https://cursor.com/install-mcp?name=prisma&config=eyJ1cmwiOiJodHRwczovL21jcC5wcmlzbWEuaW8vbWNwIn0%3D>) (opens Cursor)

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

`mcp.json`:

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

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

### VS Code

[Install in VS Code](<https://vscode.dev/redirect/mcp/install?name=prisma&config=%7B%22type%22%3A%22http%22%2C%22url%22%3A%22https%3A%2F%2Fmcp.prisma.io%2Fmcp%22%7D>) (opens VS Code)

Or from a terminal:

```bash
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`:

```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`:

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

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

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

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

`config.toml`:

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

### Gemini CLI

```bash
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.

```json
{
  "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`.

## Details

- Server version: 1.0.0
- Last checked: 2026-10-03 (reachable, asks for credentials)
- Listed: 2026-10-03
- Updated: 2026-10-04

---
Source: https://mcp.tc/i/prisma (mcp.tc is an independent directory, not affiliated with this server's publisher). Corrections: https://mcp.tc/report