MULTI-APP TOOLKIT
Build with PostgreSQL + Telegram
- Multi-app
- One MCP session
- 37 actions
- 9 triggers
- Managed auth
MCP
One MCP session, both toolsets
One session gives your product or agent every PostgreSQL and Telegram 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": "postgresql,telegram_bot_api",
},
},
},
)
const mcp = new Client({ name: "my-agent", version: "1.0.0" })
await mcp.connect(transport)
const { tools } = await mcp.listTools()
// One list, both toolsets: PostgreSQL and Telegram tools arrive
// together, each keyed by its own app's slug.
// e.g. run Execute SQL Query:
const result = await mcp.callTool({
name: "postgresql-execute-custom-query",
arguments: {
sql: "PostgreSQL Query",
},
})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 [postgresqlTools, telegramBotApiTools] =
await Promise.all([
pd.components.list({ app: "postgresql" }),
pd.components.list({ app: "telegram_bot_api" }),
])
// 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=postgresql" \
-H "X-PD-Environment: production" \
-H "Authorization: Bearer {access_token}"
curl "https://api.pipedream.com/v1/connect/{project_id}/components?app=telegram_bot_api" \
-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
PostgreSQL
Connected account
Telegram
Connected account
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
TOOLS
Telegram tools
The Telegram tools this pairing puts in reach, each one running on your user's own connected account.
Actions top 8 of 28
-
Create Chat Invite Link
actionCreate an additional invite link for a chat, See the docs for more informationWritev0.0.8 -
Delete a Message
actionDeletes a message. See the docs for more informationWritev0.0.8 -
Download Voice Message
actionDownloads a Telegram voice message to the/tmpdirectory using itsfile_id. Use this after receiving a voice message update to persist the audio locally. See the documentationWritev0.0.3 -
Edit a Media Message
actionEdits photo or video messages. See the docs for more informationWritev0.0.9 -
Edit a Text Message
actionEdits text or game messages. See the docs for more informationWritev0.0.8 -
Export Chat Invite Link
actionGenerate a new primary invite link for a chat, See the docs for more informationWritev0.0.8 -
Forward a Message
actionForwards messages of any kind. See the docs for more informationWritev0.0.8 -
Get the Number of Members in a Chat
actionUse this module to get the number of members in a chat. See the docs for more informationRead-onlyv0.0.8
Triggers
-
New Bot Command Received (Instant)
triggerEmit new event each time a Telegram Bot command is received.Instantv0.0.8 -
New Channel Updates (Instant)
triggerEmit new event each time a channel post is created or updated.Instantv0.1.8 -
New Message Updates (Instant)
triggerEmit new event each time a Telegram message is created or updated.Instantv0.1.9 -
New Updates (Instant)
triggerEmit new event for each new Telegram event.Instantv0.1.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
- postgresql,telegram_bot_api
- Primary app
- PostgreSQL (postgresql)
- Second app
- Telegram (telegram_bot_api)
- Authentication
- API key + API key
- Available actions
- 37
- Available triggers
- 9