prisma/mcp

Overview

A model context protocol server that lets LLMs manage Prisma Postgres databases. It can spin up new database instances, run migrations, and execute queries. Built in JavaScript, it exposes database operations through the MCP standard.

Best for

Best for
Developers using Prisma who want to delegate database operations to language models

Use cases

• Spin up a Prisma Postgres database on demand via LLM commands
• Autonomously run database migrations during development
• Execute natural language queries against Postgres databases

How to use

Install

npx -y mcp-remote https://mcp.prisma.io/mcp

Tools exposed

• CreateBackupTool
• CreateConnectionStringTool
• CreateRecoveryTool
• DeleteConnectionStringTool
• DeleteDatabaseTool
• ListBackupsTool
• ListConnectionStringsTool
• ListDatabasesTool
• ExecuteSqlQueryTool
• IntrospectSchemaTool

Tested with

Claude Desktop, Claude Code, Cursor, Windsurf, VS Code, ChatGPT

Notes

A model context protocol server that lets LLMs manage Prisma Postgres databases. It can spin up new database instances, run migrations, and execute queries. Built in JavaScript, it exposes database operations through the MCP standard.

42 stars on GitHub. Last updated 2025-10-07.

Use cases

• Spin up a Prisma Postgres database on demand via LLM commands
• Autonomously run database migrations during development
• Execute natural language queries against Postgres databases

Pros

• Enables LLMs to perform database management tasks directly
• Integrates with Prisma’s schema and migration workflows
• Open source with straightforward setup

Cons

• Supports only Prisma Postgres, not other database providers
• Small community adoption (42 stars), indicating early stage
• Requires granting LLM access to database credentials and endpoints

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.