Prisma MCP: manage Prisma Postgres from Claude or Cursor

Connect Prisma to Claude, ChatGPT or Cursor

1. 1Click Connect Prisma free and sign in with your Prisma account.
2. 2A read-only SQL query is safe. SQL commands change data, deleting a database destroys it, and transferring a project hands it to someone else, so switch those off and keep the query and schema tools.
3. 3Add ContextGate to your AI app as a connector or MCP server. The steps for each app are on the Works with page.
4. 4In Cursor, ask for the schema of your Prisma Postgres database and a row count for one table, then open Activity to see the queries.

Database work from Claude or Cursor

• List workspaces, projects and databases, and inspect a database's tables, columns and relationships.
• Run read-only SQL queries for analysis, or SQL commands that change data.
• Create a project or database in a region, plus connection strings for your app.
• List backups and restore one into a new database.

Keep production data safe

• Switch off the SQL command tool so your AI app can query but not change data.
• Switch off the delete and transfer tools; a deleted database is gone for good, and a transferred project leaves your hands.
• Policies can hide personal data in query results, and Activity records every SQL statement your AI apps ran.

What you get with Prisma and ContextGate

• Your AI apps can use PrismaClaude, Cursor, ChatGPT and other AI apps reach Prisma through the one ContextGate connection you add to them.
• You choose which tools they can useSwitch off any Prisma tool you don't want used. It's hidden from your AI apps and refused if called.
• Every call is checked and recordedYour policies check each call (for example, personal data is hidden and secrets are blocked), and Activity keeps a record of it.

ContextGate sees only the tool calls that go through it, not your AI app's built-in tools or your chats.

Prisma tools

Examples of what your AI apps can do in Prisma. You'll see the exact list of tools after you connect it.

• Create Database ConnectionCreate new api key connection for database access. creates connection string with embedded credentials for application database access. returns complete connection details ready for immediate use.
• Create Project DatabaseCreate new postgres database in an existing prisma project. creates database in specified region with connection strings and api keys. returns complete database details ready for immediate use.
• Create Prisma ProjectCreate new prisma project with managed postgres database. creates project in authenticated user's workspace with postgres database in specified region. returns complete project details including conne
• Execute SQL CommandExecute sql commands that modify database data or structure. runs insert, update, delete, create table, and other data modification commands safely through postgresql driver with parameterized query s
• Execute SQL QueryExecute sql select queries against prisma databases. runs read-only queries safely through postgresql driver with automatic type mapping. perfect for data analysis, schema inspection, and reporting op
• Get Prisma DatabaseRetrieve specific prisma database by id. returns database details including status, project context, and regional deployment. use for database monitoring, validation, and administrative operations.
• Get Prisma ProjectRetrieve specific prisma project by id. returns project details including name, creation timestamp, and workspace information. use for project detail views, validation, and administrative operations.
• Inspect Database SchemaInspect database schema structure and table information. returns comprehensive schema details including tables, columns, data types, constraints, and relationships. essential for understanding databas
• List Prisma Accelerate RegionsRetrieve all available regions for prisma accelerate. returns regions where accelerate global database cache can be deployed. use for cache region selection to minimize latency for your users.
• List Database BackupsRetrieve list of available backups for a specific database. returns backup details including status, size, type, and restoration readiness. use for backup monitoring, restoration planning, and complia
• List Database ConnectionsRetrieve paginated list of connections for a specific database. returns connection details including names, creation dates, and database context. use for api key management, security audits, and acces
• List Project DatabasesRetrieve paginated list of databases for a specific prisma project. returns database details including status, region, and project context. use for database discovery, monitoring, and project administ
• List Prisma Postgres RegionsRetrieve all available regions for prisma postgres. returns regions where prisma postgres databases can be deployed with current availability status. use for region selection during database creation
• List Prisma ProjectsRetrieve paginated list of prisma projects accessible to authenticated user. returns project ids, names, workspace info, and timestamps with cursor-based pagination. use for project discovery, ui sele
• List Prisma WorkspacesRetrieve paginated list of prisma workspaces accessible to authenticated user. returns workspace ids, names, creation timestamps with cursor-based pagination. use for workspace discovery, ui selection
• Restore Database BackupRestore database backup to new database instance. creates new database from existing backup with specified name. operation is asynchronous - monitor the returned database status for completion. restor
• Transfer Prisma ProjectTransfer prisma project ownership to another user. changes project ownership to recipient specified by their access token. current owner loses access unless explicitly granted by new owner.
• Delete Database ConnectionPermanently delete database connection and revoke api key access. warning: this immediately revokes database access for any applications using this connection string. ensure no critical systems depend
• Delete Prisma DatabasePermanently delete prisma database and all stored data. warning: this action cannot be undone. all data in the database will be permanently destroyed. default databases typically cannot be deleted.
• Delete Prisma ProjectPermanently delete prisma project and all associated resources. warning: this action cannot be undone. all databases, environments, and project data will be permanently destroyed. use with extreme cau