Prisma MCP server
23 operations0 webhooks
Database platform API. Manage Prisma Postgres projects, databases, connection strings and backups, list workspaces, regions and integrations, and run read-only queries, writes and schema inspection over Postgres.
Try Prisma with your agent
Connect Prisma, then paste this into Claude, ChatGPT or Cursor. For ideas from other apps, see the use cases.
Using Corsair, show me what you can do in Prisma on my account, then run one read-only example and show me the result.
Prisma tools and triggers
Tools are what your agent can do in Prisma through Corsair's MCP server. Triggers are the Prisma events a routine can start from.
Databases
- CreateWrite
Create a database in a project
databases.create
- DeleteDestructive
Delete a database and all of its data
databases.delete
- GetRead-only
Retrieve database details
databases.get
- Get UsageRead-only
Retrieve database usage metrics for a time period
databases.getUsage
- Inspect SchemaRead-only
Inspect a database schema (tables, columns, types, constraints)
databases.inspectSchema
- ListRead-only
List databases for a project
databases.list
Projects
- CreateWrite
Create a project and its default/database environment
projects.create
- DeleteDestructive
Delete a project and all of its data
projects.delete
- GetRead-only
Retrieve project details
projects.get
- ListRead-only
List projects the token has access to
projects.list
- TransferWrite
Transfer a project to another workspace
projects.transfer
Connections
- CreateWrite
Create a connection (returns a ready-to-use connection string)
connections.create
- DeleteDestructive
Delete/revoke a connection and access for anything using it
connections.delete
- ListRead-only
List connections
connections.list
Regions
- ListRead-only
List all available regions across products (optionally by product)
regions.list
- List AccelerateRead-only
List all available Prisma Accelerate regions
regions.listAccelerate
- List PostgresRead-only
List all available Prisma Postgres regions with availability
regions.listPostgres
Backups
- ListRead-only
List backups for a database
backups.list
- RestoreDestructive
Restore a backup onto the target database (async, overwrites current data)
backups.restore
Sql
- ExecuteDestructive
Execute a SQL command (INSERT/UPDATE/DELETE/DDL) over the Postgres connection
sql.execute
- QueryRead-only
Execute a read-only SQL query (SELECT) over the Postgres connection
sql.query
Integrations
- ListRead-only
List integrations (OAuth clients, granted scopes) for a workspace
integrations.list
Workspaces
- ListRead-only
List workspaces the token can access
workspaces.list
Connect Prisma to Claude, ChatGPT or Cursor
- 1
Connect Prisma in Corsair
Add your Prisma API key or sign in with OAuth once in Corsair. Corsair stores the credential encrypted and makes the Prisma API calls for your agent, so it never goes into a prompt or a config file. Connect Prisma
If your link lets the agent add apps, you can skip this: it gives you a sign-in link the first time it needs Prisma. On a ChatGPT personal plan, connect Prisma here first.
- 2
Add Corsair's MCP server to your agent
Every client uses the same address:
https://mcp.corsair.dev/mcpOpen Customize → Connectors → Add custom connector, paste the address, then select Connect.Add a custom MCP server with the address and choose OAuth. Personal plans get read tools only.Add to CursorOr add this to~/.cursor/mcp.json. Cursor opens Corsair to sign in the first time it connects.{ "mcpServers": { "corsair": { "url": "https://mcp.corsair.dev/mcp" } } }Run this, then run/mcpin Claude Code to sign in.claude mcp add --transport http corsair https://mcp.corsair.dev/mcpCodex, Gemini CLI, VS Code, Zed and other clients with OAuth sign-in work the same way. Clients without it, such as GitHub Copilot's coding agent, use a link's own address and an API key. Setup for every client
- 3
Sign in and choose what needs your approval
Your client opens Corsair to sign in. Pick a link: the apps your agent can use and a mode that decides what it may do without asking. In the default Cautious mode, Prisma's read and write operations run right away and its 5 destructive operations wait for your approval. Strict mode asks before every write and refuses destructive operations, and Read mode allows reads only.
FAQ
Install corsair and @corsair-dev/prisma, add the Prisma plugin, and connect with an API key or OAuth. Then call methods like corsair.prisma.api.backups.list() from your app. Corsair stores tokens, and syncs data per tenant.
Yes. Prisma supports an API key or OAuth. Use credentials or OAuth scopes that match what you automate. Create them in the Prisma developer console, then paste into Corsair or connect through managed auth in Hub.
Yes. One Corsair client can hit Prisma, GitHub, Notion, Stripe, and the rest. Trigger Prisma from a webhook, push updates to Slack, or chain actions across plugins. Same tenant context across integrations, plain TypeScript.
Teams use Corsair for database platform api. manage prisma postgres projects, databases, connection strings and backups, list workspaces, regions and integrations, and run read-only queries, writes and schema inspection over postgres. Common builds include sync jobs, admin tooling, and agents that call Prisma APIs from your backend. Local DB entities let you query synced Prisma records without hitting the API on every read.
The SDK is open source. Self-host and you pay Corsair nothing for the integration layer. Hub bills for hosted auth and execution, not per Prisma API call. Hub has a generous free tier. For hobby projects you can probably run the whole thing on free. Paid plans start to matter with more tenants or heavier traffic.
We maintain @corsair-dev/prisma in the open repo. When Prisma ships API changes, upgrade the package. Your call sites stay typed. You should not need to rewrite the integration layer each time.
No. Corsair does not read your Prisma data or hold individual access credentials. Credentials stay in your database. API calls run on your instance. We do not store Prisma data on your behalf.
Yes. Add https://mcp.corsair.dev/mcp as a custom connector or MCP server in Claude, ChatGPT, Cursor, VS Code, Claude Code, Codex or any client that supports remote MCP servers with OAuth sign-in, then sign in to Corsair. On ChatGPT personal plans, custom servers currently get read tools only.
Yes. Put Prisma on a link in Strict mode and every write waits for your approval, while destructive actions are refused. The default Cautious mode asks only before the 5 destructive Prisma operations. You can change a link's mode at hub.corsair.dev/me.