Nile Database icon

CONNECT APP

Build with Nile Database

PostgreSQL reengineered for multi-tenant apps

Databases

  • OAuth

MCP

Give your agent Nile Database tools

Every Nile Database 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 Nile Database 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": "nile_database",
      },
    },
  },
)

const mcp = new Client({ name: "my-agent", version: "1.0.0" })
await mcp.connect(transport)

const { tools } = await mcp.listTools()

// e.g. run Create User:
const result = await mcp.callTool({
  name: "nile_database-create-user",
  arguments: {
    workspace: "Workspace",
    database: "Database",
  },
})

API PROXY

Call the Nile Database API directly

For an endpoint with no pre-built tool, the Connect proxy forwards your request to the Nile Database 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://global.thenile.dev/developers/me/full",
})

// Any allowed Nile Database endpoint works here. Pipedream attaches the
// connected account's credentials to the outgoing request.

SDK

Run Nile Database actions from your backend

Connect a user's Nile Database account once, then run Create User 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: "nile_database-create-user",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    nile_database: { authProvisionId: "apn_xxxxxxx" },
    workspace: "Workspace",
    database: "Database",
  },
})

REFERENCE

App details

Reference metadata for the Nile Database connector in the Pipedream registry.

App slug
nile_database
Authentication
OAuth
Categories
Databases
Actions
3
Triggers
2
API proxy
Available

OAuth scopes

These are the scopes Pipedream's managed Nile Database OAuth client requests when one of your users connects an account. Supply your own OAuth client to request a different set.

  • databases
  • workspaces
  • query