MULTI-APP TOOLKIT
Build with OpenAI (ChatGPT) + Supabase
- Multi-app
- One MCP session
- 54 actions
- 6 triggers
- Managed auth
MCP
One MCP session, both toolsets
One session gives your product or agent every OpenAI (ChatGPT) and Supabase tool at once — connect once, list tools, and call them like any single-app session.
// 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": "openai,supabase",
},
},
},
)
const mcp = new Client({ name: "my-agent", version: "1.0.0" })
await mcp.connect(transport)
const { tools } = await mcp.listTools()
// One list, both toolsets: OpenAI (ChatGPT) and Supabase tools arrive
// together, each keyed by its own app's slug.
// e.g. run Chat:
const result = await mcp.callTool({
name: "openai-chat",
arguments: {
modelId: "Model",
userMessage: "User Message",
},
})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 externalUserId = "{external_user_id}" // any stable ID for this user in your system
const [openaiTools, supabaseTools] =
await Promise.all([
pd.components.list({ app: "openai" }),
pd.components.list({ app: "supabase" }),
])
// One external user owns both connected accounts, so either app's tools
// run on their behalf with the same externalUserId.curl "https://api.pipedream.com/v1/connect/{project_id}/components?app=openai" \
-H "X-PD-Environment: production" \
-H "Authorization: Bearer {access_token}"
curl "https://api.pipedream.com/v1/connect/{project_id}/components?app=supabase" \
-H "X-PD-Environment: production" \
-H "Authorization: Bearer {access_token}"
# Connect both accounts to the same external_user_id, then
# configure and invoke either app's tools on that user's behalf.ARCHITECTURE
One user, two connected accounts
Your user connects each account once, under whatever ID they already have in your product. The two stay independent — either can be revoked on its own — and your code reaches both through that one user.
Your product
external_user_id
{external_user_id}Pipedream Connect
Managed identity
Auth · tools · routing
OpenAI (ChatGPT)
Connected account
Supabase
Connected account
TOOLS
OpenAI (ChatGPT) tools
The OpenAI (ChatGPT) tools this pairing puts in reach, each one running on your user's own connected account.
Actions top 8 of 46
-
Chat
actionThe Chat API, using thegpt-3.5-turboorgpt-4model. See the documentationWritev0.3.6 -
Chat using Web Search
actionChat using the web search tool. See the documentationRead-onlyv0.0.10 -
Chat using Functions
actionChat with your models and allow them to invoke functions. Optionally, you can build and invoke workflows as functions. See the documentationWritev0.0.11 -
Chat using File Search
actionChat with your files knowledge base (vector stores). See the documentationRead-onlyv0.0.10 -
Summarize Text
actionSummarizes text using the Chat API. See the documentationRead-onlyv0.1.12 -
Classify Items into Categories
actionClassify items into specific categories using the Chat API. See the documentationRead-onlyv0.1.12 -
Translate Text (Whisper)
actionTranslate text from one language to another using the Chat API. See the documentationRead-onlyv0.1.12 -
Create Transcription
actionTranscribes audio into the input language. See the documentationWritev0.3.6
Triggers
-
New Batch Completed
triggerEmit new event when a new batch is completed in OpenAI. See the documentationv0.0.12 -
New File Created
triggerEmit new event when a new file is created in OpenAI. See the documentationv0.1.2 -
New Fine Tuning Job Created
triggerEmit new event when a new fine-tuning job is created in OpenAI. See the documentationv0.0.17 -
New Run State Changed
triggerEmit new event every time a run changes its status. See the documentationv0.0.13
TOOLS
Supabase tools
The Supabase tools this pairing puts in reach, each one running on your user's own connected account.
Actions
-
Batch Insert Rows
actionInserts new rows into a database. See the documentationWritev0.0.8 -
Count Rows
actionCounts rows in a database table, with optional filtering conditions. See the docs hereRead-onlyv0.0.2 -
Delete Row
actionDeletes row(s) in a database. See the docs hereWritev0.1.6 -
Insert Row
actionInserts a new row into a database. See the docs hereWritev0.1.6 -
Remote Procedure Call
actionCall a Postgres function in a database. See the docs hereWritev0.1.6 -
Select Row
actionSelects row(s) in a database. See the docs hereRead-onlyv0.1.7 -
Update Row
actionUpdates row(s) in a database. See the docs hereWritev0.1.6 -
Upsert Row
actionUpdates a row in a database or inserts new row if not found. See the docs hereWritev0.1.6
Triggers
-
New Row Added
triggerEmit new event for every new row added in a table. See documentation herev0.0.7 -
New Webhook Event (Instant)
triggerEmit new event for everyinsert,update, ordeleteoperation in a table. This source requires user configuration using the Supabase website. More information in the README. Also see documentation hereInstantv0.0.8
MULTI-APP
Works with more apps
The combinations customers connect alongside these two — nothing here is limited to a pair.
REFERENCE
Toolkit details
- x-pd-app-slug
- openai,supabase
- Primary app
- OpenAI (ChatGPT) (openai)
- Second app
- Supabase (supabase)
- Authentication
- API key + API key
- Available actions
- 54
- Available triggers
- 6