Skip to content
MCP Server Directory logo
data-storage

Prisma MCP Server

Gives AI agents tools to manage Prisma Postgres databases, including creating database instances and running schema migrations.

Reviewed overview

MCP 服务器概览

What is Prisma MCP Server?

Prisma MCP Server exposes a Model-Context-Protocol (MCP) HTTP server that lets AI agents and developer tools manage Prisma Postgres databases. It provides a stable set of tools (create/delete databases, backups, connection strings, run SQL, introspect schemas, etc.) and a read-only documentation search tool to answer Prisma questions with citations.

How to use it

  • Add the MCP server JSON to your tool’s MCP configuration, e.g.: { “mcpServers”: { “Prisma”: { “url”: “https://mcp.prisma.io/mcp” } } }
  • Install or register the Prisma MCP server in supported tools (VS Code, Codex, Cursor, Windsurf, Warp, Claude, ChatGPT, Gemini CLI) via one-click links or configuration files.
  • On first use the server authenticates with Prisma Console to access your workspace. Then prompt your AI agent with natural-language commands (sample prompts: “List my databases”, “Create a DB in US region”, “Show backups”).

Key features

  • A set of MCP tools: CreateBackup, CreateConnectionString, CreateRecovery, DeleteConnectionString, DeleteDatabase, ListBackups, ListConnectionStrings, ListDatabases, ExecuteSqlQuery, IntrospectSchema.
  • search_prisma_documentation: natural-language, cited answers grounded in official Prisma docs.
  • Standard MCP JSON configuration for easy integration across many AI tools and IDEs.
  • Authentication with Prisma Console for workspace-scoped access.
  • AI safety guardrails to block or require explicit user consent for destructive operations.

Use cases

  1. Provision and manage Prisma Postgres instances via natural language.
  2. Run ad-hoc SQL queries and schema introspection from within editor or agent workflows.
  3. Create and restore backups, manage connection strings and environments.
  4. Seed or analyze data (with backup first) and run analytics via agents.
  5. Ask agents Prisma-specific documentation questions with citations without leaving the editor.

FAQ (from the project)

  • How do I connect the MCP server?

Add the Prisma MCP snippet to your tool’s MCP config (URL: https://mcp.prisma.io/mcp) or use the one-click installer for supported integrations.

  • Which tools/platforms are supported?

VS Code, Codex, Cursor, Windsurf, Warp, Claude (Code/Desktop/Web), ChatGPT, Gemini CLI, and other MCP-compatible tools.

  • Is it safe to let AI perform destructive DB actions?

Prisma includes built-in safety guardrails. Destructive actions are blocked or require explicit, unambiguous user consent before proceeding.

  • Do I need Prisma Console or credentials?

Yes — the MCP server authenticates with Prisma Console on first use to access the selected workspace.

  • Can the agent read the Prisma docs?

Yes — the search_prisma_documentation tool returns cited, up-to-date answers from the official Prisma docs.