Prisma

The Model-Context-Protocol (MCP) enables your AI to call external APIs in a structured way, letting it manage databases and other resources through guided, tool-driven interactions. Prisma offers two MCP servers to fit different use cases: a local server for development on your machine and a remote server for building AI-enabled platforms that manage databases for users.

How to use

You connect your AI agent to an MCP server to access Prisma-managed databases and perform actions such as creating, listing, and restoring databases, backups, connection strings, and more. Use the remote server to expose these capabilities in an AI platform and the local server for agent-assisted database workflows on your machine. When connected, you can prompt the agent with natural language tasks like creating a database, listing backups, or applying migrations, and the MCP tools will handle the underlying Prisma operations.

How to install

Prerequisites: You need Node.js and npm installed on your machine.

To run the remote MCP server, execute the following command.

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

To run the local MCP server, execute the following command.

npx -y prisma mcp

Additional content

Tools represent the capabilities of each MCP server. The remote server exposes a set of tools for managing Prisma Postgres databases, backups, connection strings, and schema introspection. You can ask your AI to list all available Prisma tools after connecting to the remote server.

Local server tools cover migration workflows, authentication checks, database creation, and opening Prisma Studio, enabling hands-on database management directly from prompts. You can use prompts like creating a database in a specific region or seeding data with a backup.

Sample prompts and usage notes

Remote server examples:

• Show me a list of all the databases in my account.

• Create a new database in the US region for me.

• Show me all available backups of my database.

Available tools

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.

Prisma-Postgres-account-status

Check authentication status with Prisma Console via the provided command.

Prisma-Login

Authenticate with Prisma Console via the provided command.

Prisma-Studio

Open Prisma Studio via the provided command.