CONNECT APP
Build with Prisma Postgres
Databases
- API key
MCP
Give your agent Prisma Postgres tools
Every Prisma Postgres action is exposed as an MCP tool on Pipedream's remote server. Point a client at it with your end user's ID and Connect resolves that user's Prisma Postgres account for each tool call — you store no tokens.
// accessToken: mint a short-lived token with the Connect SDK — see the MCP guide
const transport = new StreamableHTTPClientTransport(
new URL("https://remote.mcp.pipedream.net/v3"),
{
requestInit: {
headers: {
Authorization: `Bearer ${accessToken}`,
"x-pd-project-id": "{project_id}",
"x-pd-environment": "production",
"x-pd-external-user-id": "{external_user_id}", // any stable ID for this user in your system
"x-pd-app-slug": "prisma_management_api",
},
},
},
)
const mcp = new Client({ name: "my-agent", version: "1.0.0" })
await mcp.connect(transport)
const { tools } = await mcp.listTools()
// e.g. run Create Database:
const result = await mcp.callTool({
name: "prisma_management_api-create-database",
arguments: {
name: "Project Name",
region: "Region",
},
})# access_token: mint a short-lived token with the Connect SDK — see the MCP guide
headers = {
"Authorization": f"Bearer {access_token}",
"x-pd-project-id": "{project_id}",
"x-pd-environment": "production",
"x-pd-external-user-id": "{external_user_id}", # any stable ID for this user in your system
"x-pd-app-slug": "prisma_management_api",
}
async with streamablehttp_client("https://remote.mcp.pipedream.net/v3", headers=headers) as (read, write, _):
async with ClientSession(read, write) as session:
await session.initialize()
tools = await session.list_tools()
# e.g. run Create Database:
result = await session.call_tool("prisma_management_api-create-database", {
"name": "Project Name",
"region": "Region",
})SDK
Run Prisma Postgres actions from your backend
Connect a user's Prisma Postgres account once, then run Create Database on their behalf from your own code — TypeScript, Python, or plain HTTP.
import { PipedreamClient } from "@pipedream/sdk"
const pd = new PipedreamClient({
projectId: process.env.PIPEDREAM_PROJECT_ID!,
clientId: process.env.PIPEDREAM_CLIENT_ID!,
clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
projectEnvironment: "production",
})
const result = await pd.actions.run({
id: "prisma_management_api-create-database",
externalUserId: "{external_user_id}", // any stable ID for this user in your system
configuredProps: {
prisma_management_api: { authProvisionId: "apn_xxxxxxx" },
name: "Project Name",
region: "Region",
},
})from pipedream import Pipedream
pd = Pipedream(
client_id="{oauth_client_id}",
client_secret="{oauth_client_secret}",
project_id="{project_id}",
project_environment="production",
)
result = pd.actions.run(
id="prisma_management_api-create-database",
external_user_id="{external_user_id}", # any stable ID for this user in your system
configured_props={
"prisma_management_api": {"authProvisionId": "apn_xxxxxxx"},
"name": "Project Name",
"region": "Region",
},
)curl -X POST https://api.pipedream.com/v1/connect/{project_id}/actions/run \
-H "Content-Type: application/json" \
-H "X-PD-Environment: production" \
-H "Authorization: Bearer {access_token}" \
-d '{
"external_user_id": "{external_user_id}",
"id": "prisma_management_api-create-database",
"configured_props": {
"prisma_management_api": { "authProvisionId": "apn_xxxxxxx" },
"name": "Project Name",
"region": "Region"
}
}'TOOLS
Prisma Postgres actions
On-demand operations your product or agent can configure and run on behalf of a connected user.
-
Create Database
actionCreates a new Postgres database project via Prisma Management API. See docs hereWritev1.0.2 -
Create Database Connection String
actionCreates a new connection string for an existing database via Prisma Management API. See docs hereWritev1.0.2 -
Create New Database in Existing Project
actionCreate a new database in an existing Prisma project. Requires Project ID. See docs hereWritev1.0.2 -
Delete Database
actionDeletes a Postgres database project via Prisma Management API. See docs hereWritev1.0.2 -
Delete Database by Database ID
actionDelete a specific database by Database ID via Prisma Management API. This action is irreversible. See docs hereWritev1.0.2 -
Delete Database Connection String
actionDeletes a specific database connection string via Prisma Management API. This action is irreversible. See docs hereWritev1.0.2 -
Get Database details
actionGet database details of a particular Prisma Postgres database via Prisma Management API. See docs hereRead-onlyv1.0.2 -
Get Prisma Postgres Regions
actionRetrieves a list of all available regions where Prisma Postgres databases can be deployed. See docs hereRead-onlyv1.0.2 -
Get Project details
actionGet project details of a particular project in Prisma Workspace via Prisma Management API. See docs hereRead-onlyv1.0.2 -
List Database Connection Strings
actionRetrieves a list of all connection strings for a specific database via Prisma Management API. See docs hereRead-onlyv1.0.2 -
List Databases from Project
actionRetrieves a list of all databases within a specific Prisma project. See docs hereRead-onlyv1.0.2 -
List Projects in Prisma Workspace
actionList Projects in a Prisma Workspace via Prisma Management API. See docs hereRead-onlyv1.0.2
EVENTS
Prisma Postgres triggers
Event sources your backend can deploy for users and receive through a webhook.
No Prisma Postgres triggers are available yet.
MULTI-APP
Use Prisma Postgres with other popular apps
Most products don't stop at one integration. Pair Prisma Postgres with the other apps your users rely on, and ship use cases that span both.
- App slug
- prisma_management_api
- Authentication
- API key
- Categories
- Databases
- Actions
- 12
- Triggers
- 0
- API proxy
- Not available