MULTI-APP TOOLKIT
Build with Google Drive + PostgreSQL
- Multi-app
- One MCP session
- 59 actions
- 22 triggers
- Managed auth
MCP
One MCP session, both toolsets
One session gives your product or agent every Google Drive and PostgreSQL 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": "google_drive,postgresql",
},
},
},
)
const mcp = new Client({ name: "my-agent", version: "1.0.0" })
await mcp.connect(transport)
const { tools } = await mcp.listTools()
// One list, both toolsets: Google Drive and PostgreSQL tools arrive
// together, each keyed by its own app's slug.
// e.g. run Add Comment:
const result = await mcp.callTool({
name: "google_drive-add-comment",
arguments: {
drive: "Drive",
fileId: "File",
},
})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 [googleDriveTools, postgresqlTools] =
await Promise.all([
pd.components.list({ app: "google_drive" }),
pd.components.list({ app: "postgresql" }),
])
// 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=google_drive" \
-H "X-PD-Environment: production" \
-H "Authorization: Bearer {access_token}"
curl "https://api.pipedream.com/v1/connect/{project_id}/components?app=postgresql" \
-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
Google Drive
Connected account
PostgreSQL
Connected account
TOOLS
Google Drive tools
The Google Drive tools this pairing puts in reach, each one running on your user's own connected account.
Actions top 8 of 50
-
Add Comment
actionAdd an unanchored comment to a Google Doc (general feedback, no text highlighting). See the documentationWritev0.1.14 -
Copy File
actionCreate a copy of the specified file. See the documentation for more informationWritev0.1.29 -
Create Folder
actionCreate a new empty folder. See the documentation for more informationWritev0.1.30 -
Create New File From Template
actionCreate a new Google Docs file from a template. Optionally include placeholders in the template document that will get replaced from this action. See documentationWritev0.1.32 -
Create New File From Text
actionCreate a new file from plain text. See the documentation for more informationWritev0.2.22 -
Create Shared Drive
actionCreate a new shared drive. See the documentation for more informationWritev0.1.30 -
Create Text File
actionCreate a new Google Doc from text content in Google Drive. The file is created as a Google Docs document, which can be viewed and edited in the browser. Use this when the user asks to create a document, write a file, or save text to Drive. To place the file in a specific folder, pass theparentId— use Search Files withmimeType = 'application/vnd.google-apps.folder'to find the folder ID first. Supported content formats: plain text, Markdown, HTML, Rich Text, CSV. See the documentationWritev0.0.8 -
Delete Comment
actionDelete a specific comment (Requires ownership or permissions). See the documentationWritev0.0.18
Triggers top 4 of 17
-
Changes to Files in Drive
triggerEmit new event when a change is made to one of the specified files. See the documentationv0.0.17 -
Changes to Specific Files
triggerWatches for changes to specific files, emitting an event when a change is made to one of those files. To watch for changes to shared drive files, use the Changes to Specific Files (Shared Drive) source instead.v0.3.15 -
Changes to Specific Files (Shared Drive)
triggerWatches for changes to specific files in a shared drive, emitting an event when a change is made to one of those filesv0.3.17 -
New Access Proposal
triggerEmit new event when a new access proposal is requested in Google Drivev0.0.20
TOOLS
PostgreSQL tools
The PostgreSQL tools this pairing puts in reach, each one running on your user's own connected account.
Actions top 8 of 9
-
Execute SQL Query
actionExecute a custom PostgreSQL query. See our docs to learn more about working with SQL in Pipedream.Writev3.0.5 -
Delete Row(s)
actionDeletes a row or rows from a table. See the documentationWritev2.0.9 -
Find Row
actionFinds a row in a table via a lookup column. See the documentationRead-onlyv2.0.9 -
Find Row With Custom Query
actionFinds a row in a table via a custom query. See the documentationRead-onlyv2.0.9 -
Insert Row
actionAdds a new row. See the documentationWritev2.0.9 -
List Schema Options
actionRetrieves available options for the Schema field.Read-onlyv0.0.1 -
Query SQL Database
actionExecute a SQL Query. See our docs to learn more about working with SQL in Pipedream.Writev0.0.5 -
Update Row
actionUpdates an existing row. See the documentationWritev2.0.9
Triggers top 4 of 5
-
New Column
triggerEmit new event when a new column is added to a table. See the documentationv2.0.8 -
New or Updated Row
triggerEmit new event when a row is added or modified. See the documentationv2.0.9 -
New Row
triggerEmit new event when a new row is added to a table. See the documentationv3.0.8 -
New Row Custom Query
triggerEmit new event when new rows are returned from a custom query that you provide. See the documentationv2.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
- google_drive,postgresql
- Primary app
- Google Drive (google_drive)
- Second app
- PostgreSQL (postgresql)
- Authentication
- OAuth + API key
- Available actions
- 59
- Available triggers
- 22