About Prisma Postgres and Prisma Compute
An MCP server set from Prisma for managing Prisma Postgres databases. The local version suits developers who want an AI agent to handle database workflows on their machine, while the remote version suits AI platforms offering database management to their users.
Key features
- 01Local: migration status, migrate dev and database reset
- 02Remote: manage databases, connection strings and backups
- 03Remote: execute SQL queries and introspect schemas
- 04Local: open Prisma Studio and log in to Prisma Console
Use cases
- 01Letting an AI agent run Prisma migrations during local development
- 02Offering database creation and backup inside an AI platform
- 03Querying a database in natural language and analyzing order data
MCP support
The project is itself an MCP server, offered as a local server started with npx prisma mcp and a remote server at https://mcp.prisma.io/mcp, exposing database management tools to MCP clients.
Configuration
Remote servers need no local install. Pick your client, then copy the config or install in one click.
https://mcp.prisma.io/mcpclaude mcp add --transport http io-prisma https://mcp.prisma.io/mcp{"mcpServers":{"io-prisma":{"type":"http","url":"https://mcp.prisma.io/mcp"}}}Open in Cursor{"servers":{"io-prisma":{"type":"http","url":"https://mcp.prisma.io/mcp"}}}Open in VS Code{"mcpServers":{"io-prisma":{"type":"http","url":"https://mcp.prisma.io/mcp"}}}{"mcpServers":{"io-prisma":{"serverUrl":"https://mcp.prisma.io/mcp"}}}Run commands in a terminal; paste JSON into the client’s MCP config and restart. Servers that need sign-in will prompt on first connect.
https://mcp.prisma.io/mcpAuth requiredTools
Details
The maintainer has not added details yet. Check the README in the repository.
Comments
New to MCP?
From what the protocol is to installing your first server, these answers cover most first questions.
An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.