CONNECT APP
Build with Xata
Think data, not databases. The serverless, branchable, scalable, consistent, highly available, and searchable database service focused on the developer experience.
Databases
- API key
MCP
Give your agent Xata tools
Every Xata action is exposed as an MCP tool on Pipedream's remote server. Point a client at it with your end user's ID and Connect resolves that user's Xata account for each tool call — you store no tokens.
// 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": "xata",
},
},
},
)
const mcp = new Client({ name: "my-agent", version: "1.0.0" })
await mcp.connect(transport)
const { tools } = await mcp.listTools()
// e.g. run Create Record:
const result = await mcp.callTool({
name: "xata-create-record",
arguments: {
endpoint: "HTTP Endpoint",
workspace: "Workspace ID",
},
})# access_token: mint a short-lived token with the Connect SDK — see the MCP guide
headers = {
"Authorization": f"Bearer {access_token}",
"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": "xata",
}
async with streamablehttp_client("https://remote.mcp.pipedream.net/v3", headers=headers) as (read, write, _):
async with ClientSession(read, write) as session:
await session.initialize()
tools = await session.list_tools()
# e.g. run Create Record:
result = await session.call_tool("xata-create-record", {
"endpoint": "HTTP Endpoint",
"workspace": "Workspace ID",
})API PROXY
Call the Xata API directly
For an endpoint with no pre-built tool, the Connect proxy forwards your request to the Xata API with the connected user's credentials attached. You store no tokens and write no refresh logic.
const resp = await pd.proxy.get({
externalUserId: "{external_user_id}", // any stable ID for this user in your system
accountId: "apn_xxxxxxx",
url: "https://api.xata.io/user",
})
// Any allowed Xata endpoint works here. Pipedream attaches the
// connected account's credentials to the outgoing request.# The path segment is the target URL, URL-safe base64 encoded:
# https://api.xata.io/user
curl "https://api.pipedream.com/v1/connect/{project_id}/proxy/aHR0cHM6Ly9hcGkueGF0YS5pby91c2Vy?external_user_id={external_user_id}&account_id=apn_xxxxxxx" \
-H "Authorization: Bearer {access_token}" \
-H "x-pd-environment: production"SDK
Run Xata actions from your backend
Connect a user's Xata account once, then run Create Record on their behalf from your own code — TypeScript, Python, or plain HTTP.
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 result = await pd.actions.run({
id: "xata-create-record",
externalUserId: "{external_user_id}", // any stable ID for this user in your system
configuredProps: {
xata: { authProvisionId: "apn_xxxxxxx" },
endpoint: "HTTP Endpoint",
workspace: "Workspace ID",
},
})from pipedream import Pipedream
pd = Pipedream(
client_id="{oauth_client_id}",
client_secret="{oauth_client_secret}",
project_id="{project_id}",
project_environment="production",
)
result = pd.actions.run(
id="xata-create-record",
external_user_id="{external_user_id}", # any stable ID for this user in your system
configured_props={
"xata": {"authProvisionId": "apn_xxxxxxx"},
"endpoint": "HTTP Endpoint",
"workspace": "Workspace ID",
},
)curl -X POST https://api.pipedream.com/v1/connect/{project_id}/actions/run \
-H "Content-Type: application/json" \
-H "X-PD-Environment: production" \
-H "Authorization: Bearer {access_token}" \
-d '{
"external_user_id": "{external_user_id}",
"id": "xata-create-record",
"configured_props": {
"xata": { "authProvisionId": "apn_xxxxxxx" },
"endpoint": "HTTP Endpoint",
"workspace": "Workspace ID"
}
}'TOOLS
Xata actions
On-demand operations your product or agent can configure and run on behalf of a connected user.
-
Create Record
actionCreate a new Record in the specified database. See the documentationWritev0.0.2 -
List Branches
actionList branches of the specified database. See the documentationRead-onlyv0.0.2 -
List Workspace ID Options
actionRetrieves available options for the Workspace ID field.Read-onlyv0.0.1 -
Replace Record
actionReplace a record with the specified ID. See the documentationWritev0.0.2 -
Update Record
actionUpdate or create a record with the specified ID. See the documentationWritev0.0.2
No Xata triggers are available yet.
- App slug
- xata
- Authentication
- API key
- Categories
- Databases
- Actions
- 5
- Triggers
- 0
- API proxy
- Available