ClawLink

How to connect Prisma to Hermes Agent

Connect the Prisma Data Platform to Hermes with ClawLink: paste one key once and 22 tools work from chat. Not Prisma Cloud and not Prisme.ai.

Get started for free
Hermes Agent
Hermes Agent
ClawLink
ClawLink
Prisma
Prisma
PrismaAPI KEYMCP

Database toolkit for managing schemas, migrations, and queries. Once connected, Hermes Agent can read and act on Prisma from chat — pairing, token refresh, and tool wiring handled for you.

22 tools

Most guides for giving Hermes Agent Prisma access start with registering your own OAuth app or pasting API keys into env files, then leave the token refresh and tool wiring to you. ClawLink gives Hermes a more practical Prisma setup: pair once in the browser and your always-on Hermes agent can act on Prisma for you, reading and doing real work on your behalf with no auth, token refresh, or tool wiring to build yourself.

Copy this prompt into Hermes to install the plugin and pair your account.

Prompt for Hermes
Set up ClawLink for Hermes and tell me when it's ready.

1. Install the plugin:
hermes plugins install ClawLink-HQ/hermes-plugin --enable

2. Start pairing. It prints an approval link, so show me the link and stop, don't wait:
hermes clawlink begin

3. I'll approve it in my browser, then reply "approved".

4. When I say approved, finish setup:
hermes clawlink finish

5. Then run `hermes clawlink test` and tell me whether ClawLink is ready.

Setup

It takes three steps to connect Hermes to Prisma.

  1. 1

    Install and pair

    Install the ClawLink plugin, then pair Hermes with a one-time browser approval:

    hermes plugins install ClawLink-HQ/hermes-plugin --enable
  2. 2

    Connect Prisma

    Paste your API key in the dashboard.

  3. 3

    Use it from chat

    Ask Hermes Agent: "What can you do with Prisma?"

Install by command

The prompt above walks Hermes through this. By hand, it is four commands and a browser approval:

hermes plugins install ClawLink-HQ/hermes-plugin --enable
hermes clawlink begin    # prints an approval link — open it and approve
hermes clawlink finish   # after approving in the browser
hermes clawlink test

Then connect Prisma in the ClawLink dashboard — paste your Prisma API key once.

Verify the connection by asking Hermes:

Call prisma_list_projects and prisma_list_workspaces and show me which projects live in which workspace. Flag anything with no databases attached.

Using a different agent?

The Hermes plugin is one client of ClawLink's MCP server. Claude Code, Cursor, Codex, or any agent that can run a shell command pairs with the same ClawLink account through the CLI:

npx -y @useclawlink/cli login

login opens the same browser approval and stores a credential locally. Once Prisma is connected in the dashboard, that agent calls the same 22 Prisma tools over MCP. Full setup for MCP clients and shell agents: connect apps to any AI agent.

Prisma MCP for Hermes

Looking for a Prisma MCP server for Hermes Agent? ClawLink connects Prisma to Hermes Agent and exposes 22 Prisma tools your agent can call over MCP, with hosted auth and nothing to run or maintain yourself. Using OpenClaw instead? The OpenClaw Prisma integration works the same way.

First, which Prisma. This page is about the Prisma Data Platform: managed Postgres databases, Accelerate, and the schema and query tooling around Prisma ORM. It is not Palo Alto Networks' Prisma Cloud, the security platform that owns most of the search results for Prisma error queries, and it is not Prisme.ai, the different vendor ChatGPT keeps citing for Prisma token errors. Search engines conflate all three, and the distinction matters because the error answers you will find online are mostly about the other two products. With that settled: this connection takes a Prisma Data Platform API key pasted once and held server-side, and the 22 tools below let the agent list projects, workspaces, databases, and backups, inspect schemas, and run read-only queries from chat.

The read-and-write line, stated plainly

Because the safety answers in search describe a fear, not this integration, here is the actual split.

  • The default is reads. prisma_execute_sql_query is SELECT-only, and the list and inspect tools only read. An agent left to its own devices can audit schemas, list databases, and check backups without any write path.
  • The writes are one narrow tool plus management actions. prisma_execute_sql_command accepts modifying SQL, and create, restore, and transfer tools change infrastructure. All of them are gated writes that stop for your confirmation.
  • The credential is held, not scattered. The API key is pasted once and stored server-side, so there is no connection string in an environment file on an agent machine, which is the exact configuration the mainstream safety advice warns about.
  • Read access is still account access. The agent can read whatever the connected account can read, so the account you connect is the access you grant. Connect the account whose scope matches what you want the agent to see.

In practice: let the agent read freely, and treat every prisma_execute_sql_command or create and transfer call as a change you review before it runs.

What the Hermes Agent Prisma integration can do

22 Prisma tools are ready for Hermes Agent once the account is connected. The 19 below are the ones people reach for most; your agent can call all 22.

19 of 22 Prisma tools for Hermes

ToolWhat it does
Execute SQL query prisma_execute_sql_queryExecute SQL SELECT queries against Prisma Postgres databases
Get database prisma_get_databaseRetrieve specific Prisma database by ID
Get database usage prisma_get_database_usageRetrieve usage metrics for a specific Prisma database
Get project prisma_get_projectRetrieve specific Prisma project by ID
Inspect database schema prisma_inspect_database_schemaInspect database schema structure and table information
List accelerate regions prisma_list_accelerate_regionsRetrieve all available regions for Prisma Accelerate
List backups prisma_list_backupsRetrieve list of available backups for a specific database
List connections prisma_list_connectionsRetrieve paginated list of connections for a specific database
List databases prisma_list_databasesRetrieve paginated list of databases for a specific Prisma project
List postgres regions prisma_list_postgres_regionsRetrieve all available regions for Prisma Postgres
List projects prisma_list_projectsRetrieve paginated list of Prisma projects accessible to authenticated user
List workspace integrations prisma_list_workspace_integrationsRetrieve paginated list of integrations for a specific Prisma workspace
List workspaces prisma_list_workspacesRetrieve paginated list of Prisma workspaces accessible to authenticated user
Create connection prisma_create_connectionCreate new API key connection for database access
Create database prisma_create_databaseCreate new postgres database in an existing Prisma project
Create project prisma_create_projectCreate new Prisma project with managed postgres database
Restore backup prisma_restore_backupRestore database backup to new database instance
Transfer project prisma_transfer_projectTransfer Prisma project ownership to another user's workspace
Execute SQL command prisma_execute_sql_commandExecute SQL commands that modify database data or structure

Try it: find the Prisma tool you need

Browse the 19 Prisma tools

Click any tool to see exactly what Hermes can do and copy a ready-to-use prompt.

Example prompts

Call prisma_list_projects and prisma_list_workspaces and show me which projects live in which workspace. Flag anything with no databases attached.

Use prisma_inspect_database_schema for database <id> and tell me the tables, their columns and types, and which relationships exist between them.

Run a SELECT via prisma_execute_sql_query against database <id> to answer this question: <question>. Keep it read-only, do not use prisma_execute_sql_command.

List the backups with prisma_list_backups for database <id> and tell me the newest, the oldest, and whether any database has no backup in the last 24 hours.

How the Prisma tools behave

Details that decide whether a Prisma prompt is a safe read or an unintended write.

  • Query and command are different tools with different gates. prisma_execute_sql_query is SELECT-only; prisma_execute_sql_command modifies data or structure and is a gated write. A prompt that says "run this SQL" must name the tool the agent is allowed to use.
  • Everything is id-addressed and workspace-scoped. Projects, databases, connections, and backups use ids, and the connected account only sees its own workspaces. prisma_list_workspaces and prisma_list_projects are where ids come from.
  • Management writes exist and are real. prisma_create_database, prisma_create_project, prisma_restore_backup, and prisma_transfer_project change infrastructure and go through confirmation, and transferring a project changes ownership, the largest-scope write in the set.
  • Accelerate and Postgres regions are readable. prisma_list_accelerate_regions and prisma_list_postgres_regions answer latency and placement questions directly.
  • Backups and connections are separate surfaces. prisma_list_backups and prisma_list_connections are their own tools, so "is this database backed up" and "who can connect to this database" are single calls.
  • Schema inspection is the grounding tool. prisma_inspect_database_schema is the cheapest way to give the agent the schema before it writes any SQL.

The alternative to ClawLink is usually manual API key setup plus your own token handling, permission troubleshooting, and tool plumbing for Hermes Agent. That is fine if you want to build and maintain the integration yourself. Most teams just want Prisma working from chat.

ManualClawLink
Credential handlingCollect, validate, store, and rotate the Prisma API key yourself, then make sure every tool call uses the right account.Users complete the hosted ClawLink setup once and the connected Prisma account becomes available to the agent without you building credential management.
Ongoing maintenanceYou own refresh logic, permission debugging, environment config, and every provider-specific edge case for Prisma.ClawLink handles the repetitive integration plumbing so your team can focus on the workflow instead of the infrastructure.
Agent usabilityYou still need to expose the right Prisma actions to the runtime in a format your agent can reliably use.22 tools for Prisma are already exposed through ClawLink, so the agent can read and act from chat immediately.

Composio also exposes Prisma to AI agents. It is developer infrastructure: Python and TypeScript SDKs, an MCP server, and a catalog past 1,000 apps, aimed at teams shipping agent products. ClawLink is built for Hermes Agent users instead. You install the plugin once, connect Prisma in the browser, and the 22 tools above work from chat. There is no SDK and no config file, and the Prisma key you paste at setup is stored server-side rather than kept in your environment. Choosing between them? Read the full Composio alternatives comparison.

Troubleshooting

Hermes paired but still can't use Prisma

Pairing is a two-step handshake: run hermes clawlink begin, approve the link in your browser, then run hermes clawlink finish. If you ran finish before approving, or the approval link expired, run hermes clawlink begin again to get a fresh link. Confirm the plugin was installed with --enable, then verify with hermes clawlink test.

Connection succeeds but no tools appear

Reconnect Prisma from the dashboard, then start a fresh chat if the runtime still has the old tool catalog loaded.

"Tool schema not loaded yet" error when calling Prisma tools

Prisma tool schemas load on demand the first time a tool runs and are cached after that, so this error usually clears on its own: wait a few seconds and retry the same request. If every Prisma call keeps failing with it in a fresh chat, reconnect from the dashboard, and contact support if it still persists — that pattern points to a configuration problem on our side, not something you can fix by reconnecting again.

Prisma returns 403 or "permission denied" on one action while others work

Two usual causes. The connected account may not have access to the specific workspace, inbox, store, or project in the request — check that first. If access looks right, the agent may have sent a placeholder value (like "YOUR_ID" or an example id from documentation) instead of a real one: ask it to run a list or search tool first, then retry the action with a real id from those results. Most failures at this stage are one of these two, not ClawLink bugs.

Prisma returns 401 invalid token while the account shows as connected

Every engine answers this for the wrong product: ChatGPT cites Prisme.ai's docs three out of three runs, and the rest of the search results teach Prisma Cloud token mechanics, JWTs that expire in minutes. Neither applies here. On this connection the credential is a Prisma Data Platform key pasted once and held server-side, and the failure that matches your symptom is a credential that went stale: expired, rotated, or revoked at the platform, which makes every tool 401 while the dashboard still shows a connection. The fix is the one ChatGPT lands on for its own wrong product, disconnect and reconnect from the ClawLink dashboard, which re-issues the credential. If only some calls fail, the credential is valid and the error is permission, see the 403 card.

Ask the agent to diagnose it:

Call prisma_list_projects and quote exactly what it returns including the status code. Do not retry the failing tools until we have that result.
Prisma returns 403 or the agent cannot see a project or database

The engines answer this with Prisma Cloud semantics, role configuration and feature licenses for a security platform, which does not describe this integration. For the Data Platform the real causes line up as: workspace and project membership, the connected account can only see workspaces and projects it belongs to, so a project from another workspace fails as a permission error rather than not-found; and placeholder ids, a project or database id from documentation, which fail exactly the same way because the object is not in the connected scope. If the agent can list some projects and not others, it is almost always membership: the missing project lives in a workspace the connected account does not have access to.

Ask the agent to diagnose it:

Call prisma_list_workspaces and prisma_list_projects and tell me which succeeds and which ids you can see. Then quote the exact error from the failed call and which id it involved.
A Prisma tool is not found, or no Prisma tools appear

If Hermes shows no Prisma tools, the connection or pairing is incomplete: confirm the plugin was installed with --enable, both hermes clawlink begin and hermes clawlink finish ran, and Prisma shows as connected in the dashboard. If most tools work and a single name fails, the name is wrong, and the error lists the closest real ones. There is also the first-call timing case unique to this setup: schemas load on demand, so the opening Prisma call in a fresh session can arrive before the catalog and needs one retry. The standard advice for this symptom, which assumes a locally declared MCP server in a client config, does not apply.

Ask the agent to diagnose it:

List the Prisma tools you actually have access to. If there are none, say so plainly. If there are, tell me which one lists projects and use that exact name.
API key setup works but results look incomplete

Double-check that the API key for Prisma has the right scopes or account access. A valid key can still be too limited for some reads or writes.

FAQ

Is there a Hermes Agent Prisma integration?

Yes. ClawLink is the fastest way to connect Hermes to Prisma: link your Prisma account once in the browser and Hermes Agent can call the Prisma API through 22 ready-made tools — no custom code or token handling.

How do I connect Prisma to Hermes with ClawLink?

Install the plugin with hermes plugins install ClawLink-HQ/hermes-plugin --enable, then pair once: run hermes clawlink begin, approve the link in your browser, and run hermes clawlink finish. Connect Prisma in the dashboard and Hermes can use it from the next message — no config files, and the Prisma key you paste is stored server-side instead of in your environment.

How long does it take to connect Prisma to Hermes Agent?

About two minutes. Sign in, click Connect next to Prisma in the dashboard, authenticate, and Hermes Agent can use it from the next chat message.

Why use ClawLink instead of wiring Prisma up myself?

The alternative to ClawLink is usually manual API key setup plus your own token handling, permission troubleshooting, and tool plumbing for Hermes Agent. That is fine if you want to build and maintain the integration yourself. Most teams just want Prisma working from chat.

Which Prisma is this, exactly?

Three products share the name and it costs a searcher a real amount of time. This page is the Prisma Data Platform: Prisma's managed Postgres, Accelerate, and the cloud console where projects, databases, and backups live. Palo Alto Networks' Prisma Cloud is a cloud security platform, and it is what Google answers with for "prisma api 401", "prisma api 403", and "prisma api rate limit" queries, none of which describe this integration. Prisme.ai is an unrelated French automation vendor, and ChatGPT's invalid-token answer cites its docs (docs.prisme.ai) three out of three runs. If you arrived looking for either of the other two, neither is this page.

Do I still need database credentials or an Accelerate API key?

The setup search results teach is a connection string with the API key inside it, prisma://accelerate...?api_key=, placed in an environment file, and ChatGPT's no-credentials answer is to build a server-side tool wrapper so the agent "never receives" that string at all. That wrapper is what the hosted flow is: a Prisma Data Platform API key is pasted once into the dashboard and held server-side, and the agent calls the tools instead of holding a connection string. You still own the account and the key, you just do not manage the key's journey to the agent.

Can the agent write to my database?

Only through one specific tool, and it is important to know which. prisma_execute_sql_query is SELECT-only, which is the tool for every read question. prisma_execute_sql_command executes SQL that modifies database data or structure, and it is a write: it goes through the confirmation gate like other writes in ClawLink, so the agent stops and you approve the exact statement before anything changes. The rest of the toolset is management reads and writes: creating databases and projects, restoring backups, transferring project ownership, all real changes with the same gate.

Is it safe to connect a database platform to an AI agent?

The mainstream answer to this shape is "don't give the agent real database access", and the tool split here is the practical version of that advice. Reads are the default: the agent lists, inspects, and runs SELECT queries, which covers the questions people actually ask (what tables exist, what the schema says, what is in this table). Writes exist but are narrow and gated: prisma_execute_sql_command for modifying SQL, plus create, restore, and transfer tools, all of which require confirmation. The hosted layer adds the credential benefit, one key held server-side and revoked from the dashboard, and the honest caveat: a SELECT-only agent can still read everything the connected account can read, so connect with the account whose access you actually want the agent to have.

Hermes paired but still can't use Prisma

Pairing is a two-step handshake: run hermes clawlink begin, approve the link in your browser, then run hermes clawlink finish. If you ran finish before approving, or the approval link expired, run hermes clawlink begin again to get a fresh link. Confirm the plugin was installed with --enable, then verify with hermes clawlink test.