# Incorta (OAuth) — Pipedream Connect

> Incorta is a governed data and AI platform that lets businesses analyze live, detailed data from operational systems without slow data cleanup steps.

- API slug: `incorta_oauth` (use in MCP headers and tool keys)
- Auth: OAuth (Pipedream-managed)
- Categories: Data Analytics
- Website: https://www.incorta.com/
- Managed OAuth scopes: `openid` · `profile` · `email` · `offline_access`
- This page (HTML): https://pipedream.com/apps/incorta-oauth
- Tools: 4 actions · 0 triggers

## Connect via MCP (recommended)

- Endpoint: `https://remote.mcp.pipedream.net/v3`
- Headers: `Authorization: Bearer <token>` · `x-pd-project-id` · `x-pd-environment` · `x-pd-external-user-id` · `x-pd-app-slug: incorta_oauth`

```ts
import { Client } from "@modelcontextprotocol/sdk/client/index.js"
import { StreamableHTTPClientTransport } from "@modelcontextprotocol/sdk/client/streamableHttp.js"
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 accessToken = await pd.rawAccessToken

const transport = new StreamableHTTPClientTransport(
  new URL("https://remote.mcp.pipedream.net/v3"),
  {
    requestInit: {
      headers: {
        Authorization: `Bearer ${accessToken}`,
        "x-pd-project-id": process.env.PIPEDREAM_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": "incorta_oauth",
      },
    },
  },
)

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

const { tools } = await mcp.listTools()

// e.g. run Execute SQL Query:
const result = await mcp.callTool({
  name: "incorta_oauth-execute-sql-query",
  arguments: {
    sql: "SQL Query",
    maxRows: 10,
  },
})
```

Docs: [MCP guide](https://pipedream.com/docs/connect/mcp/developers.md)

## API proxy

For a Incorta (OAuth) endpoint with no pre-built tool, the proxy forwards your request with the connected user's credentials attached.

```bash
# The path segment is the target URL, URL-safe base64 encoded:
# https://api.example.com/v1/me

curl "https://api.pipedream.com/v1/connect/{project_id}/proxy/aHR0cHM6Ly9hcGkuZXhhbXBsZS5jb20vdjEvbWU?external_user_id={external_user_id}&account_id=apn_xxxxxxx" \
  -H "Authorization: Bearer {access_token}" \
  -H "x-pd-environment: production"
```

Docs: [API proxy guide](https://pipedream.com/docs/connect/api-proxy.md)

## SDK

```ts
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: "incorta_oauth-execute-sql-query",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    incorta_oauth: { authProvisionId: "apn_xxxxxxx" },
    sql: "SQL Query",
    maxRows: 10,
  },
})
```

Docs: [Managed auth guide](https://pipedream.com/docs/connect/managed-auth/quickstart.md) · [Tools guide](https://pipedream.com/docs/connect/components.md)

## Actions (4)

### `incorta_oauth-execute-sql-query` — Execute SQL Query (Write)

Executes a custom Spark SQL query against an Incorta tenant via the Advanced SQL Interface (Advanced SQLi), which exposes the tenant's physical schemas and verified business views as Spark SQL tables. Use this for ad hoc reporting or data exploration. Queries that resolve workflow references to…

Full schema: https://pipedream.com/apps/incorta-oauth/actions/execute-sql-query.md

### `incorta_oauth-list-columns` — List Columns (Read-only)

Lists the columns (name, label, data type, function) of a specific table or view in an Incorta tenant, via the REST API. Requires Schema Name and Table Name — use List Schemas then List Tables first if you don't already know them. Use the returned column names when writing a SELECT list or WHERE…

Full schema: https://pipedream.com/apps/incorta-oauth/actions/list-columns.md

### `incorta_oauth-list-schemas` — List Schemas (Read-only)

Lists the schemas (logical groupings of tables/views) defined in the connected Incorta tenant, via the REST API's List Schemas endpoint. This is the starting point for exploring an Incorta tenant's data model — use the returned schema names with List Tables to see the tables/views inside a schema…

Full schema: https://pipedream.com/apps/incorta-oauth/actions/list-schemas.md

### `incorta_oauth-list-tables` — List Tables (Read-only)

Lists the tables and views ("schema objects") in an Incorta tenant, via the REST API. Provide Schema Name to scope the results to one schema (use List Schemas to find valid names); omit it to list tables across every schema in the tenant. Use the returned table names as the FROM target in Execute…

Full schema: https://pipedream.com/apps/incorta-oauth/actions/list-tables.md

---

- All apps: https://pipedream.com/apps — index: https://pipedream.com/llms.txt
- Pipedream docs for agents: https://pipedream.com/docs/llms.txt
