MULTI-APP TOOLKIT
Build with Jira + Snowflake
- Multi-app
- One MCP session
- 48 actions
- 18 triggers
- Managed auth
MCP
One MCP session, both toolsets
One session gives your product or agent every Jira 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": "jira,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: Jira and Snowflake tools arrive
// together, each keyed by its own app's slug.
// e.g. run Add Attachment To Issue:
const result = await mcp.callTool({
name: "jira-add-attachment-to-issue",
arguments: {
cloudId: "Cloud ID",
issueIdOrKey: "Issue ID or Key",
},
})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 [jiraTools, snowflakeTools] =
await Promise.all([
pd.components.list({ app: "jira" }),
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=jira" \
-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
Jira
Connected account
Snowflake
Connected account
TOOLS
Jira tools
The Jira tools this pairing puts in reach, each one running on your user's own connected account.
Actions top 8 of 39
-
Add Attachment To Issue
actionAdds an attachment to an issue. See the documentationWritev1.0.18 -
Add Comment To Issue
actionAdds a new comment to an issue. See the documentationWritev0.1.25 -
Add Multiple Attachments To Issue
actionAdds multiple attachments to an issue. See the documentationWritev1.0.18 -
Add Watcher To Issue
actionAdds a user as a watcher of an issue by passing the account ID of the user, For example,5b10ac8d82e05b22cc7d4ef5, If no user is specified the calling user is added. See the documentationWritev0.0.25 -
Assign Issue
actionAssigns an issue to a user. See the documentationWritev0.0.24 -
Check Issues Against JQL
actionChecks whether one or more issues would be returned by one or more JQL queries. See the documentationRead-onlyv0.0.11 -
Count Issues Using JQL
actionProvide an estimated count of the issues that match the JQL. See the documentationRead-onlyv0.0.11 -
Create Custom Field Options (Context)
actionCreate a context for custom field options. See the documentation.Writev0.0.17
Triggers
-
New Event
triggerEmit new event when an event with subscribed event source triggered, See the documentationv0.0.25 -
New Issue Created Event (Instant)
triggerEmit new event when an issue is created. Note that Jira supports only one webhook, if more sources are needed please useNew Eventsource and select multiple events.v0.0.25 -
New Issue Deleted Event (Instant)
triggerEmit new event when an issue is deleted. Note that Jira supports only one webhook, if more sources are needed please useNew Eventsource and select multiple events.v0.0.25 -
New Issue Updated Event (Instant)
triggerEmit new event when an issue is updated. Note that Jira supports only one webhook, if more sources are needed please useNew Eventsource and select multiple events.v0.0.25
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
- jira,snowflake
- Primary app
- Jira (jira)
- Second app
- Snowflake (snowflake)
- Authentication
- OAuth + API key
- Available actions
- 48
- Available triggers
- 18