- Category: databases
- Auth: OAUTH2, API_KEY
- Composio-managed OAuth available? Yes
- Tools: 22
- Triggers: 0
- Slug:
PRISMA - Version: 20261101_00
Tools
Create Bucket
Create Bucket
Create Bucket Key
Create Bucket Key
PRISMA_CREATE_BUCKET_KEYCreate an access key for an existing Prisma object-store bucket. Choose read-only or read/write access and optionally a display name. Returns connection details and a secretAccessKey that is returned exactly once and never stored by Prisma; copy it immediately.Input Parameters
Output
Create Database Connection
Create Database Connection
PRISMA_CREATE_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.Input Parameters
Output
Create Project Database
Create Project Database
PRISMA_CREATE_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.Input Parameters
Output
Create Managed Connection
Create Managed Connection
Create Managed Database
Create Managed Database
PRISMA_CREATE_MANAGED_DATABASECreate a managed database in a Prisma project, optionally cloning or restoring it. Omit source for an empty database. Select a region, default status, branch and declared logical identity as needed. Returns database and connection metadata.Input Parameters
Output
Create Prisma Project
Create Prisma Project
PRISMA_CREATE_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 connection strings and API keys.Input Parameters
Output
Create Service Token
Create Service Token
PRISMA_CREATE_SERVICE_TOKENCreate a service token in a Prisma workspace, optionally limited to one project. Returns the secret value exactly once; copy it immediately. Expiry defaults to 90 days when omitted; explicitly pass null to create a token without expiry.Input Parameters
Output
Delete Bucket
Delete Bucket
Delete Bucket Key
Delete Bucket Key
Delete Database Connection
Delete Database Connection
PRISMA_DELETE_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 on this connection.Input Parameters
Output
Delete Prisma Database
Delete Prisma Database
PRISMA_DELETE_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.Input Parameters
Output
Delete Integration
Delete Integration
Delete Prisma Project
Delete Prisma Project
PRISMA_DELETE_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 caution in production environments.Input Parameters
Output
Delete Service Token
Delete Service Token
Execute SQL Command
Execute SQL Command
PRISMA_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 support.Input Parameters
Output
Execute SQL Query
Execute SQL Query
PRISMA_EXECUTE_SQL_QUERYExecute SQL queries through a direct SSL PostgreSQL connection and return rows, row count, and execution time. SQL is not restricted to read-only statements; commands may modify data even if fetching results fails.Input Parameters
Output
Get Bucket
Get Bucket
Get Connection
Get Connection
Get Current Principal
Get Current Principal
Get Prisma Database
Get Prisma Database
PRISMA_GET_DATABASERetrieve specific Prisma database by ID. Returns database details including status, project context, and regional deployment. Use for database monitoring, validation, and administrative operations.Input Parameters
Output
Get Database Usage Metrics
Get Database Usage Metrics
PRISMA_GET_DATABASE_USAGERetrieve usage metrics for a specific Prisma database. Returns metrics including storage usage and operation counts (reads/writes) for the specified time period. Use for monitoring resource consumption, cost analysis, and capacity planning.Input Parameters
Output
Get Integration
Get Integration
Get Prisma Project
Get Prisma Project
PRISMA_GET_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.Input Parameters
Output
Get Workspace
Get Workspace
Get Workspace Subscription
Get Workspace Subscription
Inspect Database Schema
Inspect Database Schema
PRISMA_INSPECT_DATABASE_SCHEMAInspect tables and columns in the public database schema, optionally for a named table. Returns data types, nullability, defaults, primary and foreign key information, and row counts.Input Parameters
Output
List Prisma Accelerate Regions
List Prisma Accelerate Regions
List All Connections
List All Connections
List All Databases
List All Databases
List Database Backups
List Database Backups
PRISMA_LIST_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 compliance auditing.Input Parameters
Output
List Bucket Keys
List Bucket Keys
List Buckets
List Buckets
List Database Connections
List Database Connections
PRISMA_LIST_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 access control.Input Parameters
Output
List Project Databases
List Project Databases
PRISMA_LIST_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 administration.Input Parameters
Output
List Integrations
List Integrations
List Prisma Postgres Regions
List Prisma Postgres Regions
List Prisma Projects
List Prisma Projects
PRISMA_LIST_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 selection flows, and administrative operations.Input Parameters
Output
List Regions
List Regions
List Service Tokens
List Service Tokens
PRISMA_LIST_SERVICE_TOKENSList workspace service-token metadata, newest first, without secret values. Returns one page. Pass pagination.nextCursor as cursor with the same workspaceId to retrieve the next page. The list is empty when the workspace does not exist or the caller is not a member of it.Input Parameters
Output
List Workspace Integrations
List Workspace Integrations
PRISMA_LIST_WORKSPACE_INTEGRATIONSRetrieve paginated list of integrations for a specific Prisma workspace. Returns integration details including OAuth client info, granted scopes, and creator. Use for security audits, integration management, and workspace administration.Input Parameters
Output
List Prisma Workspaces
List Prisma Workspaces
PRISMA_LIST_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 flows, and administrative operations.Input Parameters
Output
Poll Agent Approval
Poll Agent Approval
Restore Database Backup
Restore Database Backup
PRISMA_RESTORE_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. Restoration may take several minutes.Input Parameters
Output
Restore Database
Restore Database
PRISMA_RESTORE_DATABASEDestructively overwrite all target database data with a specified backup. This immediately and irreversibly replaces all data in the existing target; data written since the backup was taken is lost. Ensure you have a recent target backup before proceeding. Connections and credentials are preserved. Restore is asynchronous: status remains recovering until it completes.Input Parameters
Output
Revoke Integration Tokens
Revoke Integration Tokens
Rotate Connection Credentials
Rotate Connection Credentials
PRISMA_ROTATE_CONNECTION_CREDENTIALSGenerate new credentials for an existing Prisma connection. Previous credentials are invalidated on a best-effort basis: revocation is not guaranteed. Update applications to use the returned new connection strings and credentials, and store them securely.Input Parameters
Output
Transfer Prisma Project
Transfer Prisma Project
PRISMA_TRANSFER_PROJECTTransfer Prisma project ownership to another user’s workspace. Transfers project ownership from the current authenticated user to the recipient specified by their OAuth2 access token. This is typically used in partner integrations where databases are provisioned on the partner’s workspace and later transferred to end users. The project and all its databases are moved to the recipient’s workspace. The current owner loses access unless the new owner explicitly grants it. Requirements: - Valid project ID owned by the current user - Valid OAuth2 access token for the recipient user - Recipient workspace must have sufficient quota for the projectInput Parameters
Output
Update Bucket
Update Bucket
PRISMA_UPDATE_BUCKETUpdate a bucket’s display label, logical identity, or branch. A display name change leaves the provider bucket name, objects, and access keys unchanged. Move the bucket separately from setting or clearing logicalId. To replace an existing logicalId, clear it with null first, then set the new one.Input Parameters
Output
Update Database
Update Database
PRISMA_UPDATE_DATABASEUpdate a database’s display name, logical identity, or branch. Every database belongs to a branch; null branch selectors cannot detach it. Move the database separately from setting or clearing logicalId. To replace an existing logicalId, clear it with null first, then set the new one.