prisma

name	prisma
description	Prisma API integration with managed OAuth for database toolkit automation. Create projects, databases, and connections. Execute SQL queries, inspect schemas, manage backups, and monitor usage. Use this skill when users want to provision Prisma Postgres databases, run SQL queries, inspect database schemas, manage connections, or monitor database usage metrics.

Prisma

Prisma is a database toolkit providing managed PostgreSQL databases with connection pooling, schema management, and analytics. This integration uses managed OAuth through ClawLink to let you create and manage Prisma projects, databases, connections, and execute SQL queries directly.

Setup in 3 Steps

Step 1: Install	Step 2: Pair Account	Step 3: Connect Prisma
		App-specific connection GIF coming soon
Run the install command in OpenClaw	Sign in and approve the device	Open the dashboard and connect Prisma

How It Works

┌─────────────────┐     ┌──────────────┐     ┌──────────────────┐
│   OpenClaw      │────▶│   ClawLink   │────▶│   Prisma API     │
│   (User Chat)   │     │   (OAuth)    │     │                  │
└─────────────────┘     └──────────────┘     └──────────────────┘

Install

openclaw plugins install clawhub:clawlink-plugin
openclaw config set tools.alsoAllow '["clawlink-plugin"]' --strict-json
openclaw gateway restart

Quick Start

List your Prisma workspaces:

clawlink_execute_tool --integration prisma --tool prisma_list_workspaces

Run a SQL query against a database:

clawlink_execute_tool --integration prisma --tool prisma_execute_sql_query --args '{"host": "db-host", "user": "admin", "password": "pass", "database": "mydb", "query": "SELECT COUNT(*) FROM users"}'

Inspect a database schema:

clawlink_execute_tool --integration prisma --tool prisma_inspect_database_schema --args '{"databaseId": "db-uuid"}'

Authentication

Prisma uses OAuth 2.0 managed by ClawLink. No API keys are needed for the integration itself. Database connections created through Prisma generate their own API keys and connection strings. Connect your Prisma account through the ClawLink dashboard.

Connect at: https://claw-link.dev/dashboard?add=prisma

Connection Management

List connections:

clawlink_list_integrations

Verify connection:

clawlink_execute_tool --integration prisma --tool prisma_list_workspaces

Reconnect: If a connection expires, visit the dashboard URL above and reconnect Prisma.

Security & Permissions

• Read operations (listing projects, databases, connections, running SELECT queries, inspecting schemas, viewing backups and usage) are safe and require no confirmation.
• Write operations (creating projects/databases/connections, restoring backups, transferring projects) modify resources and require confirmation.
• Destructive operations (deleting projects, databases, connections, executing SQL commands that modify data) are high-impact and require explicit confirmation.

Tool Reference

Workspace Operations

Tool	Description	Mode
prisma_list_workspaces	List all Prisma workspaces accessible to the authenticated user	Read
prisma_list_workspace_integrations	List integrations configured for a specific workspace	Read

Project Operations

Tool	Description	Mode
prisma_list_projects	List all Prisma projects with cursor-based pagination	Read
prisma_get_project	Retrieve details of a specific project by ID	Read
prisma_create_project	Create a new Prisma project with a managed Postgres database	Write
prisma_delete_project	Permanently delete a project and all associated resources	Write (Destructive)
prisma_transfer_project	Transfer project ownership to another user's workspace	Write

Database Operations

Tool	Description	Mode
prisma_list_databases	List databases for a specific project	Read
prisma_get_database	Retrieve details of a specific database by ID	Read
prisma_get_database_usage	Retrieve usage metrics (storage, operations) for a database	Read
prisma_create_database	Create a new Postgres database in an existing project	Write
prisma_delete_database	Permanently delete a database and all stored data	Write (Destructive)

Schema & Query Operations

Tool	Description	Mode
prisma_inspect_database_schema	Inspect database schema structure, tables, columns, constraints	Read
prisma_execute_sql_query	Execute read-only SQL SELECT queries against a database	Read
prisma_execute_sql_command	Execute SQL commands that modify data or structure (INSERT, UPDATE, DELETE, DDL)	Write (Destructive)

Connection Operations

Tool	Description	Mode
prisma_list_connections	List API key connections for a specific database	Read
prisma_create_connection	Create a new API key connection with embedded credentials	Write
prisma_delete_connection	Permanently delete a connection and revoke its API key	Write (Destructive)

Region Operations

Tool	Description	Mode
prisma_list_postgres_regions	List available regions for Prisma Postgres deployment	Read
prisma_list_accelerate_regions	List available regions for Prisma Accelerate caching	Read

Backup Operations

Tool	Description	Mode
prisma_list_backups	List available backups for a specific database	Read
prisma_restore_backup	Restore a database backup to a new database instance	Write

Code Examples

List projects in a workspace:

{
  "tool": "prisma_list_projects",
  "args": {
    "workspaceId": "workspace-uuid"
  }
}

Create a new project with a database:

{
  "tool": "prisma_create_project",
  "args": {
    "workspaceId": "workspace-uuid",
    "name": "My App Database",
    "region": "us-east-1"
  }
}

Execute a SQL query:

{
  "tool": "prisma_execute_sql_query",
  "args": {
    "host": "aws-0-us-east-1.pooler.supabase.com",
    "user": "admin",
    "password": "connection-password",
    "database": "postgres",
    "query": "SELECT table_name FROM information_schema.tables WHERE table_schema = 'public'"
  }
}

Inspect a database schema:

{
  "tool": "prisma_inspect_database_schema",
  "args": {
    "databaseId": "database-uuid"
  }
}

Check database usage metrics:

{
  "tool": "prisma_get_database_usage",
  "args": {
    "databaseId": "database-uuid",
    "startDate": "2026-01-01",
    "endDate": "2026-06-01"
  }
}

Discovery Workflow

1. Call clawlink_list_integrations to confirm prisma is connected.
2. Call clawlink_list_tools --integration prisma to see the live catalog.
3. Start with prisma_list_workspaces to discover available workspaces.
4. Use prisma_list_projects to find projects within a workspace.
5. Use prisma_list_databases to find databases within a project.

Execution Workflow

Read Flow:
  list_workspaces → list_projects → list_databases → get_database / inspect_schema / execute_sql_query

Write Flow:
  list_workspaces → create_project → create_database → create_connection

Destructive Flow:
  (confirm) → delete_database / delete_project / execute_sql_command

Notes

• Default databases created with a project typically cannot be deleted.
• prisma_execute_sql_command runs modification SQL (INSERT, UPDATE, DELETE, DDL). Always confirm before executing.
• prisma_execute_sql_query is read-only and limited to SELECT statements.
• Connection strings and API keys are generated automatically when creating connections -- store them securely.
• The prisma_transfer_project action is typically used in partner integrations where databases are provisioned on one workspace and transferred to an end user.

Error Handling

Status / Error	Meaning
401 Unauthorized	OAuth token expired; reconnect Prisma from the dashboard
403 Forbidden	User lacks access to the requested workspace, project, or database
404 Not Found	Invalid workspace, project, or database ID
409 Conflict	Resource already exists (e.g., duplicate project name)
429 Too Many Requests	Rate limit exceeded; retry after a short delay

Troubleshooting

Tools Not Visible

Run clawlink_list_tools --integration prisma to verify the integration is active. If empty, reconnect at https://claw-link.dev/dashboard?add=prisma.

SQL Query Fails

Verify the connection credentials (host, user, password, database) match those returned by prisma_create_connection or prisma_list_connections. Ensure the query is a valid SELECT statement for prisma_execute_sql_query.

Cannot Delete Database

Default databases created with a project cannot be deleted. Only non-default databases support deletion.

Resources

• Prisma Docs: https://www.prisma.io/docs
• Prisma Data Platform: https://console.prisma.io
• ClawLink: https://claw-link.dev/?utm_source=clawhub&utm_medium=referral&utm_content=prisma
• ClawLink Docs: https://docs.claw-link.dev/openclaw

---

Powered by ClawLink -- an integration hub for OpenClaw