# Prisma AI integration on Definable

> Prisma Data Platform provides database tools including Accelerate (global database cache), Optimize (AI-driven query analysis), and Prisma Postgres (managed PostgreSQL).

## What this connects

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.

Vendor: https://console.prisma.io/

## Tools available

**22** tools available. First 12:

- `PRISMA_CREATE_CONNECTION` — 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.
- `PRISMA_CREATE_DATABASE` — 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.
- `PRISMA_CREATE_PROJECT` — 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.
- `PRISMA_DELETE_CONNECTION` — 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.
- `PRISMA_DELETE_DATABASE` — 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.
- `PRISMA_DELETE_PROJECT` — 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.
- `PRISMA_EXECUTE_SQL_COMMAND` — 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.
- `PRISMA_EXECUTE_SQL_QUERY` — 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.
- `PRISMA_GET_DATABASE` — 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.
- `PRISMA_GET_DATABASE_USAGE` — 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.
- `PRISMA_GET_PROJECT` — 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.
- `PRISMA_INSPECT_DATABASE_SCHEMA` — 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.

## Auth

Auth schemes: `OAUTH2`, `API_KEY`. Managed by Definable: `OAUTH2` — no client credentials required from the user.

## How agents use Prisma

Inside a Definable workflow, Prisma is one of the tools the **Distributor specialist** can call. Example coordination patterns:

- **Researcher → Prisma** — the Researcher (GPT-5.5) pulls context from Prisma (records, threads, documents), synthesises findings, and briefs the rest of the team.
- **Writer → Distributor → Prisma** — the Writer (Claude Opus 4.7) drafts copy in brand voice, the Verifier passes it, then the Distributor writes the result into Prisma (create record, post message, draft email).
- **Designer / Engineer → Distributor → Prisma** — the Designer ships an asset or the Engineer ships a code change, the Distributor delivers it via Prisma (attach file, open PR comment, post status).

The Verifier checks every Prisma call. On rate limit, schema drift, or auth refresh it self-heals and retries — the workflow completes without manual intervention.

## Categories

- databases — https://definable.ai/apps/category/databases/
- developer tools — https://definable.ai/apps/category/developer-tools/

## Related

- HTML page: https://definable.ai/apps/prisma/
- Same category (databases): https://definable.ai/apps/category/databases/
- All integrations: https://definable.ai/apps/
- Workflow (multi-agent loop): https://definable.ai/workflow/
- Apps llms.txt index: https://definable.ai/llms-apps.txt