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

Project Operations

Database Operations

Schema & Query Operations

Connection Operations

Region Operations

Backup Operations

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

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](https://claw-link.dev/?utm_source=clawhub&utm_medium=referral&utm_content=prisma) -- an integration hub for OpenClaw