MCP server for managing Prisma Postgres.

Overview

The Model-Context-Protocol (MCP) gives LLMs a way to call APIs and thus access external systems in a well-defined manner.

Prisma's provides two MCP servers: a local and a remote one. See below for specific information on each.

If you're a developer working on a local machine and want your AI agent to help with your database workflows, use the local MCP server.

If you're building an "AI platform" and want to give the ability to manage database to your users, use the remote MCP server.

Remote MCP server

You can start the remote MCP server as follows:

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

Tools

Tools represent the capabilities of an MCP server. Here's the list of tools exposed by the remote MCP server:

• CreateBackupTool: Create a new managed Prisma Postgres Backup.
• CreateConnectionStringTool: Create a new Connection String for a Prisma Postgres database with the given id.
• CreateRecoveryTool: Restore a Prisma Postgres Database to a new database with the given Backup id.
• DeleteConnectionStringTool: Delete a Connection String with the given connection string id.
• DeleteDatabaseTool: Delete a Prisma Postgres database with the given id.
• ListBackupsTool: Fetch a list of available Prisma Postgres Backups for the given database id and environment id.
• ListConnectionStringsTool: Fetch a list of available Prisma Postgres Database Connection Strings for the given database id and environment id.
• ListDatabasesTool: Fetch a list of available Prisma Postgres Databases for user's workspace.
• ExecuteSqlQueryTool: Execute a SQL query on a Prisma Postgres database with the given id.
• IntrospectSchemaTool: Introspect the schema of a Prisma Postgres database with the given id.

Once you're connected to the remote MCP server, you can also always prompt your AI agent to "List the Prisma tools" to get a full overview of the latest supported tools.

Usage

The remote Prisma MCP server follows the standard JSON-based configuration for MCP servers. Here's what it looks like:

{
  "mcpServers": {
    "Prisma-Remote": {
      "command": "npx",
      "args": ["-y", "mcp-remote", "https://mcp.prisma.io/mcp"]
    }
  }
}

[!TIP] If you want to try it the remote MCP server and explore it's capabilities, we recommend Cloudflare's AI Playground for that. Add the https://mcp.prisma.io/mcp URL into the text field with the Enter MCP server URL placeholder, click Connect, and then authenticate with the Prisma Console in the popup window. Once connected, you can send prompts to the Playground and see what MCP tools the LLM chooses based on your prompts.

Sample prompts

• "Show me a list of all the databases in my account."
• "Create a new database in the US region for me."
• "Seed my database with real-looking data but create a backup beforehand."
• "Show me all available backups of my database."
• "Show me all customers and run an analysis over their orders."

Local MCP server

You can start the local MCP server as follows:

npx -y prisma mcp

[!TIP] If you're using VS Code, you can use VS Code agent mode to enter prompts such as "create Postgres database" or "apply schema migration" directly in the chat. The VS code agent handles all underlying Prisma CLI invocations and API calls automatically. See our VS Code Agent documentation for more details.

Tools

Tools represent the capabilities of an MCP server. Here's the list of tools exposed by the local MCP server:

• migrate-status: Checks your migration status via the prisma migrate status command.
• migrate-dev

... View full README on GitHub