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.
ActionTry it
Integrate Prisma
with your AI CRM
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.
Explore Triggers and Actions
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.
ActionTry it
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.
ActionTry it
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.
ActionTry it
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.
ActionTry it
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.
ActionTry it
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.
ActionTry it
Execute SQL Query
Execute SQL SELECT queries against Prisma Postgres databases. Runs read-only queries safely through direct PostgreSQL connection with SSL. Uses credentials from create_connection action (host, user, pass fields). Perfect for data analysis, schema inspection, and reporting operations.
ActionTry it
Get Database Usage Metrics
Retrieve 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.
ActionTry it
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.
ActionTry it
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.
ActionTry it
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.
ActionTry it
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.
ActionTry it
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.
ActionTry it
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.
ActionTry it
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.
ActionTry it
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.
ActionTry it
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.
ActionTry it
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.
ActionTry it
List Workspace Integrations
Retrieve 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.
ActionTry it
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.
ActionTry it
Transfer Prisma Project
Transfer 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 project
ActionTry it
How the Prisma integration works
The Prisma integration connects your Dench AI CRM directly to Prisma, so agents can read and act on your Prisma data as part of everyday work — answering questions in chat, keeping your CRM in sync, and running automations without anyone copying data between tools.
22 actions are available for agents to invoke on your behalf. Every call runs through Prisma's own authorization, scoped to the account you connect.
Set up Prisma in Dench
- 1
Sign in to your Dench workspace and open Integrations.
- 2
Find Prisma and click Connect — you'll authorize access through Prisma's own sign-in flow. No API keys or code required.
- 3
Ask an agent to use Prisma in chat, or call it from an automation.
- 4
Manage or disconnect the connection any time from workspace settings.
Frequently asked questions
How does the Prisma integration work with Dench?
The Dench Prisma integration connects your AI CRM to Prisma, so AI agents can work with your Prisma data as part of chats, automations, and CRM workflows. You connect your account once, and every agent in your workspace can use it — governed by your workspace permissions.
What actions can AI agents perform with Prisma via Dench?
The Prisma integration currently exposes 22 actions, including Create Database Connection, Create Prisma Project, Create Project Database, Delete Database Connection, Delete Prisma Database, and Delete Prisma Project. Agents invoke them on your behalf from chat or from automations.
Do I need to write code to connect Prisma to Dench?
No. You connect Prisma from your Dench workspace using Prisma's own sign-in and authorization flow — no API keys to copy, no glue code to maintain.
Is the Prisma integration secure?
Connections are authorized through Prisma's own authentication flow, and Dench stores only the authorization needed to act on your behalf. You can review and disconnect the Prisma connection from your workspace settings at any time.