First-party app
Hex

Hex

Run Hex projects, poll or cancel runs, and read projects, users, groups, collections and data connections.

stable Analytics & BIData Warehousing & ETL

About

Hex ships in the w6w first-party pack. It declares 15 actions, 2 health checks, and the host runs its code in a sandbox that never sees the credential.

App id
io.w6w.hex
Version
0.1.0
Author
w6w
Licence
MIT
Categories
Analytics & BI · Data Warehousing & ETL

Overview

Hex is a collaborative analytics workspace where notebooks and data apps run SQL and Python against a team’s warehouse. This app lets a workflow trigger a published Hex project on demand, hand it input parameters, poll the run until it reaches a terminal state, and cancel it if it should not finish.

Around that core it reads the workspace itself: projects and their metadata, the runs of each project filtered by status or trigger, the warehouse tables a project queries, and the users, groups, collections and data connections that organise access.

A run always executes the latest published version of a project and answers with a run handle rather than a result, so a workflow starts a run, polls its status, and reads results where the project publishes them. Health checks track Hex’s status page, reading the components the API and runs depend on.

Build with Hex

Three routes to the same 15 actions. The Workflow tab is generated from Hex's own manifest and carries its real ids, so it is copy-pasteable; the Code and CLI examples are the same call for any action on any app, so every app-specific value in them is a blank you fill in.

Get Collection

collection-get

Fetch one collection by id.

List Collections

collection-list

List the workspace's collections.

Get Data Connection

data-connection-get

Fetch one data-warehouse connection by id.

List Data Connections

data-connection-list

List the workspace's data-warehouse connections.

Get Group

group-get

Fetch one user group by id.

List Groups

group-list

List the workspace's user groups.

Get Current User

me-get

Fetch the user the token belongs to, the workspace id and the token's expiry. A workspace token returns no user fields.

Get Project

project-get

Fetch one project's metadata: title, owner, status, categories and view analytics.

List Projects

project-list

List Hex projects the token can view, with optional status, owner and collection filters.

List Project Queried Tables

project-queried-tables-list

List the data-warehouse tables a project queries.

Run Project

project-run

Trigger a run of a project's latest published version and return the run handle immediately.

List Project Runs

project-runs-list

List runs of a project, optionally filtered by status and trigger type.

Cancel Run

run-cancel

Cancel a project run that is pending or running.

Get Run Status

run-get

Fetch the status of one project run: state, trigger, timings and run URL.

List Users

user-list

List workspace users, optionally restricted to a group or a set of user ids.

A workflow step names the app and the action, and the editor fills in the connection when you pick one. This is the Step shape from the workflow spec, carrying Hex's real ids.

{
  "manifestVersion": "2",
  "name": "hex-example",
  "steps": [
    {
      "id": "collection-get",
      "uses": {
        "app": "io.w6w.hex",
        "action": "collection-get",
        "connection": "conn_YOUR_CONNECTION_ID"
      },
      "with": {
        "collectionId": "<collectionId>"
      }
    }
  ]
}

Here are some of the things you can do

  • Get Collection

    read
    collection-get
  • List Collections

    search
    collection-list
  • Get Data Connection

    read
    data-connection-get
  • List Data Connections

    search
    data-connection-list
  • Get Group

    read
    group-get

+10 more actions available

Every app-specific value here is a blank you have to fill in. An app action is reached through the connection that authenticates it, so the address is a connection id, not the app id — and connections belong to your account, so a public page cannot know yours. Create one for Hex, then fill in the three blanks: conn_YOUR_CONNECTION_ID, the action key, and the parameters that action declares. The call itself is real — the shape is transcribed from the studio's own snippet builder, which prints the same kind of blanks — but nothing in it is specific to Hex. The Workflow tab is where this app's real ids are.

Install
npm install @w6w/sdk
yarn add @w6w/sdk
pnpm add @w6w/sdk
deno add npm:@w6w/sdk
Code
import { W6wClient, isActionRun } from "@w6w/sdk";

// Reads W6W_BASE_URL and W6W_TOKEN from the environment when omitted.
const client = new W6wClient();

const envelope = await client.run({
  urn: "conn_YOUR_CONNECTION_ID",
  action: "collection-get",
  payload: {
    collectionId: "<value>",
  },
});

if (isActionRun(envelope)) console.log(envelope.value);
Install the CLI
npm install -g @w6w/cli
CLI
w6w run conn_YOUR_CONNECTION_ID --action collection-get --payload '{"collectionId":"<value>"}'

Give an AI agent Hex — without giving it Hex's credentials. One MCP endpoint exposes every app, function and workflow the caller is entitled to, as tools it can discover and run. Access is granted per team while we onboard.

One tool call
{
  "name": "w6w_invoke",
  "arguments": {
    "ref": "app:io.w6w.hex#collection-get",
    "input": {
      "collectionId": "<collectionId>"
    }
  }
}

Every tool names its target with a single ref. The app: form above doesn't name a connection at all — the host resolves which of the caller's Hex connections to sign with, and refuses rather than guesses when the answer is ambiguous.

What the agent gets

Credentials it can't read

The token is attached host-side, at the moment of the call. It is never a tool argument, never in the model's context, and never in a transcript — so a prompt injection has nothing to exfiltrate.

A tool surface scoped to the caller

Tools are derived per end user from what that person has actually connected and is entitled to — not one shared bot identity carrying the union of everyone's access.

A durable workflow in one call

Multi-step work runs on the workflow engine and returns a run handle the agent can poll — retries, branching and state survive the conversation that started them.

Health-aware discovery

Hex's declared health checks are on the surface too, so an agent can tell "the vendor is down" from "your credential expired" before it burns a retry on either.

The MCP surface is part of the hosted platform. Hex itself is MIT, and the runtime that executes it is source-available (FSL).

Request MCP access

Health checks

Hex declares its own checks, so its health is a property of the app rather than something the host guesses at.

service

Hex platform status

Component status from status.hex.tech. Main site (hosts the API), Kernels and Data Connections decide the verdict; Login and Single tenant stacks are shown as detail.

quota

API rate-limit headroom