StackMCP

Set up Prisma MCP in Claude Code

Run Prisma migrations, check migration status, reset databases, and manage Prisma Postgres instances directly from your AI editor.

1

Locate the config file

Claude Code reads MCP server configuration from the following file:

~/.claude.json

Create this file if it does not already exist.

2

Add the configuration

You can configure Prisma MCP using the CLI command or by editing the config file directly.

Option A: CLI command

bash
claude mcp add prisma-mcp -e DATABASE_URL=YOUR_DATABASE_URL -- npx -y prisma mcp

Option B: Config file

json
{
  "mcpServers": {
    "prisma-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "prisma",
        "mcp"
      ],
      "env": {
        "DATABASE_URL": "YOUR_DATABASE_URL"
      }
    }
  }
}
3

Set up environment variables

Prisma MCP requires the following environment variables:

DATABASE_URLRequired

Database connection string for Prisma (e.g. postgresql://user:pass@localhost:5432/mydb)

4

Verify it works

Restart Claude Code. Prisma MCP should appear in your MCP server list with 8 tools available.

This server adds approximately 4,120 tokens to your context window for tool definitions.

Set up Prisma MCP in other editors

CursorVS CodeWindsurfClaude DesktopContinue
← Back to Prisma MCP