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.

Databases Developer Tools Web del proveedor

Acciones

Triggers

Autenticación

—

OAuth gestionado

Sí

Información técnica: el detalle de parámetros, schemas y triggers de esta página está pensado para equipos de integración. Si solo necesitas saber si tu herramienta favorita está disponible, basta con ver la lista de acciones.

Acciones disponibles (20)

Cada acción es una operación que el agente puede ejecutar contra este conector. Haz clic en una acción para ver sus parámetros.

Create Database ConnectionPRISMA_CREATE_CONNECTIONAcción

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.

Parámetros de entrada

namestringObligatorio
Human-readable name for the new connection/API key. This will be displayed in UIs and used for identification. Choose descriptive names like 'Production API Key', 'Analytics Access', 'Dev Environment', etc.
databaseIdstringObligatorio
Unique database identifier to create connection for (format: 'db_xxxxx'). Must be a database the authenticated user has write access to. The new connection will provide API key access to this database.

Parámetros de salida

dataobjectObligatorio
Complete connection object including connection string with credentials. Contains all necessary information for applications to access the database. Store the connection string securely as it provides full database access.
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Create Project DatabasePRISMA_CREATE_DATABASEAcción

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.

Parámetros de entrada

namestringObligatorio
Human-readable name for the new database. This will be displayed in UIs and used for identification. Choose descriptive names like 'Production DB', 'Analytics', etc.
regionstringObligatorio
AWS region where the database will be deployed. Common values: 'us-east-1', 'us-west-2', 'eu-west-1', 'ap-southeast-1'. Choose region closest to your users for optimal performance.
isDefaultboolean
Whether this database should be the default for the project. Default false. Only one database can be default per project. Setting to true will make other databases non-default.
projectIdstringObligatorio
Unique project identifier to create database in (format: 'prj_xxxxx'). Must be a project the authenticated user has write access to. The new database will belong to this project.

Parámetros de salida

dataobjectObligatorio
Complete database object including connection strings and API keys. Contains all necessary information to start using the database: connection details, regional deployment info, and access credentials.
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Create Prisma ProjectPRISMA_CREATE_PROJECTAcción

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.

Parámetros de entrada

namestringObligatorio
Human-readable name for the new project. This will be displayed in UIs and used for identification. Choose descriptive names like 'Production API', 'Dev Environment', etc.
regionstringObligatorio
AWS region where the postgres database will be deployed. Common values: 'us-east-1', 'us-west-2', 'eu-west-1', 'ap-southeast-1'. Choose region closest to your users for optimal performance.

Parámetros de salida

dataobjectObligatorio
Complete project object including embedded postgres database. Contains all necessary information to start using the project: connection strings, API keys, and regional deployment details.
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Delete Database ConnectionPRISMA_DELETE_CONNECTIONAcción

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.

Parámetros de entrada

idstringObligatorio
Unique connection identifier to delete (format: 'con_xxxxx'). WARNING: This permanently revokes API key access to the database. Any applications using this connection string will lose access immediately. This action cannot be undone - ensure no critical systems depend on this connection.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Delete Prisma DatabasePRISMA_DELETE_DATABASEAcción

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.

Parámetros de entrada

databaseIdstringObligatorio
Unique database identifier to delete (format: 'db_xxxxx'). WARNING: This permanently deletes the database and all stored data. Default databases typically cannot be deleted. This action cannot be undone. Ensure all important data is backed up before deletion.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Delete Prisma ProjectPRISMA_DELETE_PROJECTAcción

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.

Parámetros de entrada

idstringObligatorio
Unique project identifier to delete (format: 'prj_xxxxx'). WARNING: This permanently deletes the project and all associated data including databases, environments, and configurations. This action cannot be undone. Ensure all important data is backed up before deletion.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Execute SQL CommandPRISMA_EXECUTE_SQL_COMMANDAcción

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.

Parámetros de entrada

commandstringObligatorio
SQL command to execute against the database (INSERT, UPDATE, DELETE, CREATE TABLE, etc.). Examples: 'INSERT INTO users (name, email) VALUES ($1, $2)', 'UPDATE users SET active = $1 WHERE id = $2', 'DELETE FROM sessions WHERE expires_at < NOW()', 'CREATE TABLE logs (id SERIAL PRIMARY KEY, message TEXT, created_at TIMESTAMP DEFAULT NOW())'
parametersarray
Optional array of parameters for parameterized commands using $1, $2, etc. placeholders. Example: command='INSERT INTO users (name, email) VALUES ($1, $2)', parameters=['John Doe', 'john@example.com']. Parameters are automatically escaped to prevent SQL injection.
connectionStringstringObligatorio
Prisma connection string from database actions (format: 'prisma+postgres://...'). Use connection strings obtained from create_project, list_connections, or create_connection actions. Must include valid API key for authentication with Prisma Accelerate.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Execute SQL QueryPRISMA_EXECUTE_SQL_QUERYAcción

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.

Parámetros de entrada

querystringObligatorio
SQL SELECT query to execute against the database. Use standard PostgreSQL syntax. Common examples: 'SELECT * FROM users LIMIT 10', 'SELECT name, email FROM customers WHERE active = true', 'SELECT table_name FROM information_schema.tables WHERE table_schema = 'public''. Avoid INSERT/UPDATE/DELETE - use execute_sql_command for those operations.
parametersarray
Optional array of parameters for parameterized queries using $1, $2, etc. placeholders. Example: query='SELECT * FROM users WHERE id = $1 AND active = $2', parameters=[123, true]. Parameters are automatically escaped to prevent SQL injection.
connectionStringstringObligatorio
Prisma connection string from database actions (format: 'prisma+postgres://...'). Use connection strings obtained from create_project, list_connections, or create_connection actions. Must include valid API key for authentication with Prisma Accelerate.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Get Prisma DatabasePRISMA_GET_DATABASEAcción

Retrieve specific prisma database by id. returns database details including status, project context, and regional deployment. use for database monitoring, validation, and administrative operations.

Parámetros de entrada

databaseIdstringObligatorio
Unique database identifier to retrieve (format: 'db_xxxxx'). This ID is obtained from database listing or creation operations. Must be a database the authenticated user has access to.

Parámetros de salida

dataobjectObligatorio
Complete database information including status, project context, and region. Use this data for displaying database details, monitoring health, and administrative operations.
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Get Prisma ProjectPRISMA_GET_PROJECTAcción

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.

Parámetros de entrada

idstringObligatorio
Unique project identifier to retrieve (format: 'prj_xxxxx'). This ID is obtained from project listing or creation operations. Must be a project the authenticated user has access to.

Parámetros de salida

dataobjectObligatorio
Complete project information including name, creation date, and workspace context. Use this data for displaying project details, navigation, and administrative operations.
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Inspect Database SchemaPRISMA_INSPECT_DATABASE_SCHEMAAcción

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.

Parámetros de entrada

tableNamestring
Optional specific table name to inspect. If provided, returns detailed column information for that table only. If omitted, returns overview of all tables in the database. Use for focused schema analysis of specific tables.
includeIndexesboolean
Whether to include index information in the schema results. When true, shows primary keys, foreign keys, and other indexes. Useful for understanding table relationships and query optimization.
connectionStringstringObligatorio
Prisma connection string from database actions (format: 'prisma+postgres://...'). Use connection strings obtained from create_project, list_connections, or create_connection actions. Must include valid API key for authentication with Prisma Accelerate.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

List Prisma Accelerate RegionsPRISMA_LIST_ACCELERATE_REGIONSAcción

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.

Parámetros de entrada

Sin parámetros.

Parámetros de salida

dataobject[]Obligatorio
Array of Prisma Accelerate regions for global database caching. Choose regions closest to your users for optimal performance. All listed regions are available for cache deployment.
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

List Database BackupsPRISMA_LIST_BACKUPSAcción

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.

Parámetros de entrada

limitinteger
Maximum number of backups to return in a single request. Defaults to 25 if not specified. Typical range is 1-100. Use smaller values (10-25) for UI pagination, larger values (50-100) for processing.
databaseIdstringObligatorio
Unique database identifier to list backups for (format: 'db_xxxxx'). Must be a database the authenticated user has access to. All available backups for this database will be returned.

Parámetros de salida

dataobject[]Obligatorio
Array of backup objects for the specified database. Backups are ordered by creation date with most recent first. Only includes backups available for restoration within retention period.
metaobjectObligatorio
Backup policy metadata including retention configuration.
errorstring
Error if any occurred during the execution of the action
paginationobjectObligatorio
Pagination info for navigating through backup collections.
successfulbooleanObligatorio
Whether or not the action execution was successful or not

List Database ConnectionsPRISMA_LIST_CONNECTIONSAcción

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.

Parámetros de entrada

limitinteger
Maximum number of connections to return in a single request. Defaults to 100 if not specified. Valid range is typically 1-500. Use smaller values (10-50) for faster responses when you only need a few connections, or larger values (100-500) when bulk processing.
cursorstring
Pagination cursor for retrieving the next page of results. Use the 'nextCursor' value from a previous response to get subsequent pages. Leave as None/null for the first page. Enables efficient pagination through large numbers of connections without missing or duplicating entries.
databaseIdstringObligatorio
Unique database identifier to list connections for (format: 'db_xxxxx'). Must be a database the authenticated user has access to. All connection strings and API keys for this database will be returned.

Parámetros de salida

dataobject[]Obligatorio
Array of connection objects for the specified database. Connections are ordered by creation date with most recent first. Each connection represents an API key for database access with unique credentials.
errorstring
Error if any occurred during the execution of the action
paginationobjectObligatorio
Pagination info for navigating through connection collections.
successfulbooleanObligatorio
Whether or not the action execution was successful or not

List Project DatabasesPRISMA_LIST_DATABASESAcción

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.

Parámetros de entrada

limitinteger
Maximum number of databases to return in a single request. Defaults to 100 if not specified. Valid range is typically 1-500. Use smaller values (10-50) for faster responses when you only need a few databases, or larger values (100-500) when bulk processing.
cursorstring
Pagination cursor for retrieving the next page of results. Use the 'nextCursor' value from a previous response to get subsequent pages. Leave as None/null for the first page. Enables efficient pagination through large numbers of databases without missing or duplicating entries.
projectIdstringObligatorio
Unique project identifier to list databases for (format: 'prj_xxxxx'). Must be a project the authenticated user has access to. All databases belonging to this project will be returned.

Parámetros de salida

dataobject[]Obligatorio
Array of database objects within the specified project. Databases are ordered by creation date with most recent first. Includes both default and additional databases created for the project.
errorstring
Error if any occurred during the execution of the action
paginationobjectObligatorio
Pagination info for navigating through database collections.
successfulbooleanObligatorio
Whether or not the action execution was successful or not

List Prisma Postgres RegionsPRISMA_LIST_POSTGRES_REGIONSAcción

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.

Parámetros de entrada

Sin parámetros.

Parámetros de salida

dataobject[]Obligatorio
Array of Prisma Postgres regions with availability status. Filter for 'available' status when creating new databases. Regions are ordered by geographical priority.
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

List Prisma ProjectsPRISMA_LIST_PROJECTSAcción

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.

Parámetros de entrada

limitinteger
Maximum number of projects to return in a single request. Defaults to 100 if not specified. Valid range is typically 1-500. Use smaller values (10-50) for faster responses when you only need a few projects, or larger values (100-500) when bulk processing. The API may return fewer results than requested if fewer projects exist.
cursorstring
Pagination cursor for retrieving the next page of results. Use the 'nextCursor' value from a previous response to get subsequent pages. Leave as None/null for the first page. This enables efficient pagination through large numbers of projects without missing or duplicating entries.

Parámetros de salida

dataobject[]Obligatorio
Array of project objects accessible to the authenticated user. Projects are ordered by creation date with most recent first. Each project includes workspace context and creation metadata.
errorstring
Error if any occurred during the execution of the action
paginationobjectObligatorio
Pagination info for navigating through project collections.
successfulbooleanObligatorio
Whether or not the action execution was successful or not

List Prisma WorkspacesPRISMA_LIST_WORKSPACESAcción

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.

Parámetros de entrada

limitinteger
Maximum number of workspaces to return in a single request. Defaults to 100 if not specified. Valid range is typically 1-500. Use smaller values (10-50) for faster responses when you only need a few workspaces, or larger values (100-500) when bulk processing. The API may return fewer results than requested if fewer workspaces exist.
cursorstring
Pagination cursor for retrieving the next page of results. Use the 'nextCursor' value from a previous response to get subsequent pages. Leave as None/null for the first page. This enables efficient pagination through large numbers of workspaces without missing or duplicating entries.

Parámetros de salida

dataobject[]Obligatorio
Array of workspace objects accessible to the authenticated user. Each workspace represents a separate organizational unit with its own projects, environments, and team members. The list is ordered by most recently modified workspaces first. May be empty if the user has no workspace access or if all workspaces are beyond the pagination cursor. Each workspace object contains complete metadata including ID, name, creation timestamp, and object type for full programmatic access.
errorstring
Error if any occurred during the execution of the action
paginationobjectObligatorio
Pagination metadata enabling navigation through large workspace collections. Contains cursor information for retrieving subsequent pages and a boolean indicator of whether more pages exist. Essential for implementing complete workspace discovery in applications with many workspaces. Always present in responses for API consistency, even when all results fit in a single page.
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Restore Database BackupPRISMA_RESTORE_BACKUPAcción

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.

Parámetros de entrada

backupIdstringObligatorio
Unique backup identifier to restore. Must be a completed backup from the specified database. Use list_backups action to find available backup IDs.
databaseIdstringObligatorio
Unique source database identifier containing the backup (format: 'db_xxxxx'). Must be a database the authenticated user has access to. The backup will be restored from this database's backup collection.
targetDatabaseNamestringObligatorio
Name for the new database created from backup restoration. This will be displayed in UIs and used for identification. Choose descriptive names like 'Restored DB 2025-01-20', 'Production Rollback', etc.

Parámetros de salida

dataobjectObligatorio
Database object for the restoration operation. Check the 'status' field to monitor restoration progress. Database will be available for use when status becomes 'ready'.
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Transfer Prisma ProjectPRISMA_TRANSFER_PROJECTAcción

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.

Parámetros de entrada

idstringObligatorio
Unique project identifier to transfer (format: 'prj_xxxxx'). Must be a project owned by the authenticated user. After transfer, the current user will lose access unless explicitly granted by the new owner.
recipientAccessTokenstringObligatorio
Valid access token of the recipient user who will receive project ownership. The recipient must have a valid Prisma account and appropriate permissions to receive project transfers. This token authorizes the ownership change.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not