MULTI-APP TOOLKIT
Build with HubSpot + PostgreSQL
- Multi-app
- One MCP session
- 117 actions
- 32 triggers
- Managed auth
MCP
One MCP session, both toolsets
One session gives your product or agent every HubSpot 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": "hubspot,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: HubSpot and PostgreSQL tools arrive
// together, each keyed by its own app's slug.
// e.g. run Add Comment:
const result = await mcp.callTool({
name: "hubspot-add-comment",
arguments: {
inboxId: "Inbox ID",
channelId: "Channel ID",
},
})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 [hubspotTools, postgresqlTools] =
await Promise.all([
pd.components.list({ app: "hubspot" }),
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=hubspot" \
-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
HubSpot
Connected account
PostgreSQL
Connected account
TOOLS
HubSpot tools
The HubSpot tools this pairing puts in reach, each one running on your user's own connected account.
Actions top 8 of 108
-
Add Comment
actionAdds a comment to a thread. See the documentationWritev0.0.8 -
Add Contact to List
actionAdds a contact to a specific static list. See the documentationWritev0.1.4 -
Add Note to Contact
actionMCP and AI agents: Prefer this action when the user wants to leave a note on a HubSpot contact using a contact ID and note text. Exposes onlyhubspot,contactId, andnoteBody(no engagement-type step, noreloadProps, no dynamic HubSpot schema fields). Do not use Create Engagement for this workflow. For every writable note property or non-contact associations, use Create Note instead. See the documentationWritev0.0.6 -
Archive Thread
actionArchives a thread (soft delete). The thread is hidden from active views but can be restored via the HubSpot UI or by listing archived threads. See the documentationWritev0.0.5 -
Batch Create Companies
actionCreate a batch of companies in Hubspot. See the documentationWritev0.0.18 -
Batch Create or Update Contact
actionCreate or update a batch of contacts by its ID or email. See the documentationWritev0.0.32 -
Batch Update Companies
actionUpdate a batch of companies in Hubspot. See the documentationWritev0.0.18 -
Batch Upsert Companies
actionUpsert a batch of companies in Hubspot. See the documentationWritev0.0.17
Triggers top 4 of 27
-
Deleted Blog Posts
triggerEmit new event for each deleted blog post.v0.0.45 -
New Company Property Change
triggerEmit new event when a specified property is provided or updated on a company. See the documentationv0.0.38 -
New Contact Added to List
triggerEmit new event when a contact is added to a HubSpot list. See the documentationv0.0.17 -
New Contact Property Change
triggerEmit new event when a specified property is provided or updated on a contact. See the documentationv0.0.41
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
- hubspot,postgresql
- Primary app
- HubSpot (hubspot)
- Second app
- PostgreSQL (postgresql)
- Authentication
- OAuth + API key
- Available actions
- 117
- Available triggers
- 32