Prisma

databases 22 tools available

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.

Connect Prisma Visit Prisma

About this integration

Connect Prisma to Definable to automate repetitive tasks, sync data with the rest of your stack, trigger on real-world events. Personas call Prisma's 22 tools directly from chat or scheduled flows. You can wire it into any persona to read, write, and react when an event fires.

Connect Prisma to Definable and it becomes a set of typed tools your agents plan with — triggered by events, run on schedules, or invoked mid-conversation. Every write is checked by the verifier before it lands.

Auth OAuth2 · 2 clicks

Tools 22 exposed

Plans All, incl. Free

Data Never trained on

Prisma · in workflows

What teams actually run.

Three patterns teams run with Prisma on day one. Each one is a plain-English prompt — no canvas, no glue code — and you can remix them into anything.

Trigger on event

│ Listen for a new event

│ Parse and validate the payload

└ Take an action with the linked tool

Daily summary

│ Pull yesterday's activity

│ Summarise with the model of your choice

└ Send the digest via email or Slack

Cross-tool sync

│ Read records from one app

│ Transform with a persona

└ Write the result back via this integration

22 tools available

The Prisma toolbox.

Every Prisma capability your agents can call, each with a typed schema the planner reads. The router picks the right tool per step; the verifier checks the result.

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

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

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

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'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

See it run

One prompt, start to finish.

A real prompt, the Prisma tools it calls, and what comes back. This is the whole interface — describe the outcome, agents handle the rest.

❯

Run a real Prisma task end-to-end — plan it, execute across the API, and hand back a verified result.

prisma.create_database_connection Create new API key connection for database access. Creates connection string with embedded

prisma.create_project_database Create new postgres database in an existing Prisma project. Creates database in specified

prisma.create_prisma_project Create new Prisma project with managed postgres database. Creates project in authenticated · verified

done

Done. Prisma responded across 3 calls, the verifier signed off, and the result is logged with every payload.

FAQ · Prisma

Questions, answered.

What teams ask before connecting Prisma.

01 What can I automate with Prisma on Definable?

Anything Prisma exposes through its API. Common databases workflows on Definable include automate repetitive tasks, sync data with the rest of your stack, trigger on real-world events. Personas can call any of the 22 Prisma tools directly, then chain the result into another integration without you writing code.

02 How does Prisma authentication work?

Prisma uses OAUTH2, API_KEY on Definable. You connect once from the integrations page, scoped to the permissions you choose, and from then on any persona that has the integration enabled can act on your behalf. Tokens are encrypted at rest and rotated automatically.

03 Is the Prisma integration included in my Definable plan?

Yes — every Definable plan, including Starter, includes access to all 22 Prisma tools. You only need a separate Prisma subscription if Prisma itself charges per seat or per API call.

04 Is using Prisma through Definable secure?

Every call from a persona to Prisma is logged with the user, persona, prompt, and response. Tokens never leave Definable's secrets vault, scopes are configurable per persona, and you can revoke access at any time from the integration page.

05 How do I get started with Prisma on Definable?

Sign up for Definable, open the integrations page, find Prisma, and connect via OAuth or API key. You can immediately attach Prisma to any persona and start running workflows. The free Starter plan includes 5,000 credits/month.

06 What Prisma actions does Definable expose?

Definable exposes all 22 Prisma actions as callable tools — including `Create Database Connection`, `Create Project Database`, `Create Prisma Project`, plus 19 more. Each tool gets a typed parameter schema so personas know exactly how to call it.