MULTI-APP TOOLKIT
Build with Bitbucket + Snowflake
- Multi-app
- One MCP session
- 13 actions
- 25 triggers
- Managed auth
MCP
One MCP session, both toolsets
One session gives your product or agent every Bitbucket and Snowflake 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": "bitbucket,snowflake",
},
},
},
)
const mcp = new Client({ name: "my-agent", version: "1.0.0" })
await mcp.connect(transport)
const { tools } = await mcp.listTools()
// One list, both toolsets: Bitbucket and Snowflake tools arrive
// together, each keyed by its own app's slug.
// e.g. run Create Snippet Comment:
const result = await mcp.callTool({
name: "bitbucket-create-snippet-comment",
arguments: {
workspaceId: "Workspace",
snippetId: "Snippet",
},
})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 [bitbucketTools, snowflakeTools] =
await Promise.all([
pd.components.list({ app: "bitbucket" }),
pd.components.list({ app: "snowflake" }),
])
// 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=bitbucket" \
-H "X-PD-Environment: production" \
-H "Authorization: Bearer {access_token}"
curl "https://api.pipedream.com/v1/connect/{project_id}/components?app=snowflake" \
-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
Bitbucket
Connected account
Snowflake
Connected account
TOOLS
Bitbucket tools
The Bitbucket tools this pairing puts in reach, each one running on your user's own connected account.
Actions
-
Create Snippet Comment
actionCreates a new snippet comment. See docs hereWritev0.4.5 -
Get File From Repository
actionGets the actual file contents of a download artifact and not the artifact's metadata. See docs hereRead-onlyv0.1.5 -
Get snippet
actionGet a snippet. See docs hereRead-onlyv0.0.4 -
List Workspace Options
actionRetrieves available options for the Workspace field.Read-onlyv0.0.2
Triggers top 4 of 11
-
New Commit (Instant)
triggerEmit new event when a new commit is pushed to a branch. See docs hereInstantv0.0.6 -
New Pull Request (Instant)
triggerEmit new event when a new pull request is created in a repository. See docs hereInstantv0.0.5 -
New Branch (Instant)
triggerEmit new event when a new branch is created. See docs hereInstantv0.0.5 -
New Commit Comment (Instant)
triggerEmit new event when a commit receives a comment. See docs hereInstantv0.0.5
TOOLS
Snowflake tools
The Snowflake 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 Snowflake query. See our docs to learn more about working with SQL in Pipedream.Writev0.2.4 -
Execute SQL Query In Session
actionExecute a Snowflake query inside a session started by the Start SQL Session action, so it shares that session's state — temporary tables,USEcontext, and session parameters — with the other queries in the same session. Pass the serialized session from Start SQL Session to the Session prop. Note: to preserve the session this query runs on a direct connection and therefore does NOT egress from the shared static IP (use_pd_sql_proxy); if your Snowflake network policy allowlists only the static IP, use Execute SQL Query instead. See our docs to learn more about working with SQL in Pipedream.Writev0.0.2 -
Insert Multiple Rows
actionInsert multiple rows into a tableWritev0.1.7 -
Insert Single Row
actionInsert a row into a tableWritev1.1.6 -
List Database Options
actionRetrieves available options for the Database field.Read-onlyv0.0.2 -
List User Name Options
actionRetrieves available options for the User Name field.Read-onlyv0.0.2 -
List Warehouse Name Options
actionRetrieves available options for the Warehouse Name field.Read-onlyv0.0.2 -
Query SQL Database
actionExecute a SQL Query. See our docs to learn more about working with SQL in Pipedream.Writev0.0.5
Triggers top 4 of 14
-
New Row
triggerEmit new event when a row is added to a tablev0.2.5 -
New Query Results
triggerRun a SQL query on a schedule, triggering a workflow for each row of resultsv0.2.5 -
Failed Task in Schema
triggerEmit new events when a task fails in a database schemav0.1.5 -
New Database
triggerEmit new event when a database is createdv0.1.5
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
- bitbucket,snowflake
- Primary app
- Bitbucket (bitbucket)
- Second app
- Snowflake (snowflake)
- Authentication
- OAuth + API key
- Available actions
- 13
- Available triggers
- 25