Prisma

Prisma

Prisma Data Platform provides database tools including Accelerate (global database cache), Optimize (AI-driven query analysis), and Prisma Postgres (managed PostgreSQL). Manage workspaces, projects, environments, and API keys programmatically.

54VIEWS
2719USERS

Install MCP Server

Paste and run this command in your terminal to set up Cursor with MCP

npx @composio/cli add cursor --app prismanpx @composio/cli add cursor --app prismanpx @composio/cli add cursor --app prismanpx @composio/cli add cursor --app prisma

After running the command, restart Cursor to start using the MCP Server.

Available Tools

Create Database Connection

Create 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 Database

Create 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 Project

Create 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 connection strings and api keys.

Delete Database Connection

Permanently 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 on this connection.

Delete Prisma Database

Permanently 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 Project

Permanently 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 caution in production environments.

Execute Sql Command

Execute 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 support.

Execute Sql Query

Execute 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 operations.

Get Prisma Database

Retrieve 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 Project

Retrieve 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 Schema

Inspect database schema structure and table information. returns comprehensive schema details including tables, columns, data types, constraints, and relationships. essential for understanding database structure before executing queries.

List Prisma Accelerate Regions

Retrieve 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 Backups

Retrieve 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 compliance auditing.

List Database Connections

Retrieve 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 access control.

List Project Databases

Retrieve 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 administration.

List Prisma Postgres Regions

Retrieve 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 and capacity planning.

List Prisma Projects

Retrieve 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 selection flows, and administrative operations.

List Prisma Workspaces

Retrieve 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 flows, and administrative operations.

Restore Database Backup

Restore 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. restoration may take several minutes.

Transfer Prisma Project

Transfer 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.

20 actions available