# Hex

Hex is a collaborative data workspace that combines SQL, Python, and R notebooks for analytics and data science

- **Category:** analytics
- **Auth:** API_KEY
- **Composio Managed App Available?** N/A
- **Tools:** 31
- **Triggers:** 0
- **Slug:** `HEX`
- **Version:** 00000000_00

## Tools

### Cancel Run

**Slug:** `HEX_CANCEL_RUN`

Tool to cancel a project run that is in progress. Use when you need to stop a currently executing Hex project run before it completes.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `run_id` | string | Yes | Unique ID for a run of a Hex project in UUID format. This identifies the specific run to cancel. |
| `project_id` | string | Yes | Unique ID for a Hex project in UUID format. This identifies the project that contains the run to cancel. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Create Cell

**Slug:** `HEX_CREATE_CELL`

Tool to create a new cell in the draft version of a Hex project. Use when adding CODE or SQL cells to a project. Only CODE and SQL cell types are supported. Requires EDIT_PROJECT_CONTENTS permission.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `label` | string | No | Optional label for the cell to make it easier to identify |
| `cellType` | string ("CODE" | "SQL") | Yes | Type of cell to create. Only CODE and SQL types are supported. |
| `contents` | object | Yes | Cell contents. Must include codeCell.source for CODE type or sqlCell for SQL type. |
| `location` | object | No | Model for specifying where to place the cell in the project. |
| `projectId` | string | Yes | Unique ID for the Hex project (UUID format) |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Create Collection

**Slug:** `HEX_CREATE_COLLECTION`

Tool to create a new collection in the Hex workspace. Use when you need to organize projects and resources into a collection.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `name` | string | Yes | Name for the collection |
| `sharing` | object | No | Model for collection sharing configuration. |
| `description` | string | No | Description of the collection |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Create Group

**Slug:** `HEX_CREATE_GROUP`

Tool to create a new group in the Hex workspace. Use when you need to organize users into groups for collaboration and access control.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `name` | string | Yes | Name for the new group (must be non-empty) |
| `members` | object | No | Model for group members. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Deactivate User

**Slug:** `HEX_DEACTIVATE_USER`

Deactivates a user in the Hex workspace. Use this when you need to deactivate a user by their ID.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `user_id` | string | Yes | Unique ID for a user in UUID format (e.g., 019cd222-074d-7003-a83e-56a40e97b60b) |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete Cell

**Slug:** `HEX_DELETE_CELL`

Permanently delete a cell from the draft version of a project. Requires EDIT_PROJECT_CONTENTS permission. Use when you need to remove a cell from a Hex project's draft.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `cellId` | string | Yes | Unique identifier for the cell to delete. Must be in UUID format (e.g., '019cd2fb-8a0d-7007-9870-c3999f91e95b'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete Group

**Slug:** `HEX_DELETE_GROUP`

Deletes a group from the Hex workspace. Use this when you need to permanently remove a group by its ID.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `group_id` | string | Yes | Unique ID for a group in UUID format (e.g., 019cd2fb-44c5-7007-a1d5-8fbe7aa7dbf3) |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete Guide Draft

**Slug:** `HEX_DELETE_GUIDE_DRAFT`

Deletes a guide draft by ID from Hex. Use this when you need to permanently remove a draft guide.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `orgGuideFileId` | string | Yes | Unique ID for a guide file in UUID format |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Edit Collection

**Slug:** `HEX_EDIT_COLLECTION`

Tool to edit a collection's name, description, and sharing settings in Hex. Use when you need to update collection metadata or change sharing permissions.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `name` | string | No | New name for the collection (must be non-empty if provided) |
| `sharing` | object | No | Sharing configuration for users, groups, or workspace. |
| `description` | string | No | Description of the collection |
| `collectionId` | string | Yes | Unique ID for the collection to edit (UUID format) |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Edit Group

**Slug:** `HEX_EDIT_GROUP`

Tool to edit a group's name and/or members in Hex. Use when you need to update group details, add users to a group, or remove users from a group.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `name` | string | No | New name for the group. Must be non-empty if provided. |
| `members` | object | No | Model for group members configuration. |
| `group_id` | string | Yes | Unique ID for a group in UUID format (e.g., 019cd2fb-0a06-7006-a522-d36b008968c7) |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Edit Project Sharing Collections

**Slug:** `HEX_EDIT_PROJECT_SHARING_COLLECTIONS`

Tool to add a project to collections or remove it from collections. Use when you need to update project sharing by adding or modifying collection access. Workspace tokens need Collections -> Write access scope in addition to Projects -> Write access scope.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `sharing` | object | Yes | Sharing configuration with collections to add or remove |
| `projectId` | string | Yes | Unique ID for the Hex project (UUID format) |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Edit Project Sharing Groups

**Slug:** `HEX_EDIT_PROJECT_SHARING_GROUPS`

Tool to edit project sharing settings for groups in Hex. Use when you need to add or modify group access to a project. Supports up to 25 groups per request.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `sharing` | object | Yes | Sharing configuration specifying which groups to add or modify and their access levels |
| `projectId` | string | Yes | Unique ID for the Hex project in UUID format |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Edit Project Sharing Settings

**Slug:** `HEX_EDIT_PROJECT_SHARING_ORG_AND_PUBLIC`

Tool to edit project sharing settings for workspace members and public web access. Use when you need to control who can access a Hex project and what permissions they have.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `sharing` | object | Yes | Sharing configuration with publicWeb and workspace access levels. Both fields are required. |
| `projectId` | string | Yes | Unique ID for a Hex project (UUID format). This is the project whose sharing settings will be updated. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Edit Project Sharing Users

**Slug:** `HEX_EDIT_PROJECT_SHARING_USERS`

Tool to edit project sharing settings for individual users in Hex. Add or modify user access to a project by specifying access levels (NONE, APP_ONLY, CAN_VIEW, CAN_EDIT, FULL_ACCESS). Use when you need to grant or update project permissions for specific users. Maximum 25 users per request.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `sharing` | object | Yes | Sharing configuration with upsert.users array containing user access settings |
| `projectId` | string | Yes | Unique ID for the Hex project in UUID format (e.g., '019cd222-4c60-7003-9f01-f6d33d4be59f') |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Cell

**Slug:** `HEX_GET_CELL`

Tool to get a single cell by ID from the draft version of a Hex project. Use when you need to retrieve cell details including source contents for CODE and SQL cells. Returns complete cell information including cell type, contents, and associated metadata.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `cellId` | string | Yes | Unique ID for a cell in UUID format (e.g., '019cd222-7c1d-7003-97d6-b5fd42e48784') |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get collection

**Slug:** `HEX_GET_COLLECTION`

Tool to get information about a specific collection in Hex. Returns collection details including name, description, creator, and sharing settings. Use when you need to retrieve metadata about a collection by its ID.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `collectionId` | string | Yes | Unique ID for a collection (UUID format). Example: 019cd222-11e7-7111-b40b-f40d81aba29b |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Group

**Slug:** `HEX_GET_GROUP`

Tool to retrieve information about a specific Hex group. Use when you need to get details about a group including its ID, name, and creation date.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `group_id` | string | Yes | Unique ID for a group in UUID format (e.g., 019cd2fb-0a06-7006-a522-d36b008968c7) |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Project

**Slug:** `HEX_GET_PROJECT`

Tool to get metadata about a single Hex project. Use when you need to retrieve project details including title, description, creator, owner, status, categories, analytics, schedules, and sharing information.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `project_id` | string | Yes | Unique ID for a Hex project in UUID format |
| `include_sharing` | boolean | No | Include sharing information in the response (default: false) |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Project Runs

**Slug:** `HEX_GET_PROJECT_RUNS`

Tool to retrieve the status of API-triggered runs for a specific Hex project. Use when you need to check the execution status, timing, or history of project runs. Returns a paginated list of runs with detailed status information.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `limit` | integer | No | Number of results per page. Must be between 1 and 100. Default is 25 if not specified. |
| `offset` | integer | No | Offset for pagination. Use this to skip a certain number of results. Default is 0 if not specified. |
| `projectId` | string | Yes | Unique ID for a Hex project (UUID format). This is the project whose runs you want to retrieve. |
| `statusFilter` | string ("PENDING" | "RUNNING" | "ERRORED" | "COMPLETED" | "KILLED" | "UNABLE_TO_ALLOCATE_KERNEL") | No | Enum for run status values. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Run Status

**Slug:** `HEX_GET_RUN_STATUS`

Tool to retrieve the status of a specific Hex project run. Use when you need to check the current state, timing, or completion status of a project execution. Returns detailed information including start/end times, elapsed time, status, and notification details.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `runId` | string | Yes | Unique ID for a run of a Hex project (UUID format) |
| `projectId` | string | Yes | Unique ID for a Hex project (UUID format) |
| `enable_expanded_stats` | string | No | Enable expanded statistics in the response |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Cells

**Slug:** `HEX_LIST_CELLS`

Tool to list all cells from the draft version of a Hex project. Use when you need to retrieve cells with source code for SQL and CODE cells. Returns paginated results with cell details including type, label, and contents.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `after` | string | No | Pagination cursor for next page |
| `limit` | integer | No | Number of results per page (1-100, default: 25) |
| `before` | string | No | Pagination cursor for previous page |
| `projectId` | string | Yes | Unique ID for a Hex project (UUID format) |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Collections

**Slug:** `HEX_LIST_COLLECTIONS`

Tool to retrieve all collections in the workspace with pagination support. Use when you need to list or discover available collections.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `after` | string | No | Pagination cursor for retrieving the next page of results |
| `limit` | integer | No | Maximum number of collections to return per page (1-100, default: 25) |
| `before` | string | No | Pagination cursor for retrieving the previous page of results |
| `sortBy` | string ("NAME") | No | Sort field enumeration for collections. |
| `sortDirection` | string ("ASC" | "DESC") | No | Sort direction enumeration. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Data Connections

**Slug:** `HEX_LIST_DATA_CONNECTIONS`

Tool to list all data connections in the Hex workspace with pagination support. Use when you need to retrieve, browse, or audit data connections configured in Hex. Supports filtering by sort criteria and cursor-based pagination for large result sets.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `after` | string | No | Pagination cursor for retrieving the next page of results. Obtained from the pagination object in the previous response. |
| `limit` | integer | No | Number of results to return per page. Must be between 1 and 100. Default is 25. |
| `before` | string | No | Pagination cursor for retrieving the previous page of results. Obtained from the pagination object in the previous response. |
| `sortBy` | string ("CREATED_AT" | "NAME") | No | Enum for sort field options. |
| `sortDirection` | string ("DESC" | "ASC") | No | Enum for sort direction options. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List groups

**Slug:** `HEX_LIST_GROUPS`

Tool to list all groups in the Hex workspace with pagination support. Use when you need to retrieve groups with optional sorting and pagination.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `after` | string | No | Pagination cursor to retrieve the next page of results. Use the 'after' value from the previous response's pagination object. |
| `limit` | integer | No | Number of results to return per page. Must be between 1 and 500. Defaults to 25 if not specified. |
| `before` | string | No | Pagination cursor to retrieve the previous page of results. Use the 'before' value from the previous response's pagination object. |
| `sortBy` | string ("CREATED_AT" | "NAME") | No | Sort field options for groups listing. |
| `sortDirection` | string ("DESC" | "ASC") | No | Sort direction options for groups listing. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Hex Projects

**Slug:** `HEX_LIST_PROJECTS`

Tool to list all viewable Hex projects with pagination and filtering support. Use when you need to retrieve projects sorted by creation date or filter by status, categories, creator, owner, or collection.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `after` | string | No | Pagination cursor for fetching the next page of results |
| `limit` | integer | No | Number of results per page (1-100, default: 25) |
| `before` | string | No | Pagination cursor for fetching the previous page of results |
| `sortBy` | string ("CREATED_AT" | "LAST_EDITED_AT" | "LAST_PUBLISHED_AT") | No | Sort field options for project listing. |
| `statuses` | array | No | Filter projects by one or more statuses |
| `categories` | array | No | Filter projects by one or more categories |
| `ownerEmail` | string | No | Filter projects by owner email address |
| `collectionId` | string | No | Filter projects by collection ID |
| `creatorEmail` | string | No | Filter projects by creator email address |
| `sortDirection` | string ("DESC" | "ASC") | No | Sort direction options. |
| `includeSharing` | boolean | No | Include sharing information for each project (default: false) |
| `includeTrashed` | boolean | No | Include trashed projects in the results (default: false) |
| `includeArchived` | boolean | No | Include archived projects in the results (default: false) |
| `includeComponents` | boolean | No | Include component projects in the results (default: false) |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Users

**Slug:** `HEX_LIST_USERS`

Tool to list all users in the Hex workspace with pagination support. Returns user details including names, emails, roles, and last login dates. Use when you need to retrieve users, filter by group, or paginate through large user lists.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `after` | string | No | Pagination cursor for fetching the next page of results. Use the cursor value returned in the previous response's pagination object. |
| `limit` | integer | No | Number of results per page. Must be between 1 and 500. Default is 25. |
| `before` | string | No | Pagination cursor for fetching the previous page of results. Use the cursor value returned in the previous response's pagination object. |
| `sortBy` | string ("NAME" | "EMAIL") | No | Sort field options for user listing. |
| `groupId` | string | No | Filter users by group ID. When provided, returns only users that belong to the specified group. |
| `sortDirection` | string ("DESC" | "ASC") | No | Sort direction options for user listing. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Publish Guide Drafts

**Slug:** `HEX_PUBLISH_GUIDE_DRAFTS`

Tool to publish all currently drafted guides or specific guides by ID. Use when you need to make draft guides publicly available. Specify either publishAllDraftGuides=true or provide specific guide IDs.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `orgGuideFileIds` | array | No | List of specific guide IDs to publish. Ignored if publishAllDraftGuides is true. |
| `publishAllDraftGuides` | boolean | No | Set to true to publish all draft guides. When true, the orgGuideFileIds parameter is ignored. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Run Project

**Slug:** `HEX_RUN_PROJECT`

Tool to trigger a run of the latest published version of a Hex project. Use when you need to execute a project programmatically. Rate limited to 20 requests per minute and 60 requests per hour.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `dry_run` | boolean | No | Perform dry run without executing project. Useful for validating inputs without running the project (default: false) |
| `view_id` | string | No | SavedView viewId to use for project run inputs. Allows running with a specific saved view configuration |
| `project_id` | string | Yes | Unique ID for the Hex project (UUID format) |
| `input_params` | object | No | Input parameters for project run as key/value pairs matching variable names defined in the project |
| `notifications` | array | No | List of notification details for Slack/users/groups to notify when the run completes |
| `flag_config_override` | string | No | Flag configuration override for feature flags |
| `use_cached_sql_results` | boolean | No | Use cached SQL results from previous runs when available (default: true) |
| `update_published_results` | boolean | No | Update cached state of published app after successful run (default: false) |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Update Cell

**Slug:** `HEX_UPDATE_CELL`

Tool to update a cell's source code and/or data connection in Hex. Use when you need to modify the contents of a code cell or SQL cell. Requires EDIT_PROJECT_CONTENTS permission.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `cellId` | string | Yes | Unique identifier for the cell to update (UUID format) |
| `contents` | object | No | Model for cell contents with either code or SQL cell data. |
| `dataConnectionId` | string | No | Data connection ID for SQL cells (UUID format or null to remove connection) |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Update Project Status

**Slug:** `HEX_UPDATE_PROJECT`

Tool to add or remove a status (including endorsements) from a Hex project. Use when you need to update the project's status or remove an existing status by setting it to null.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `status` | string | No | Status name to apply to the project (including endorsements). Set to null to remove the current status from the project. |
| `project_id` | string | Yes | Unique ID for the Hex project in UUID format (e.g., '019cd222-4c60-7003-9f01-f6d33d4be59f') |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Upsert Guide Draft

**Slug:** `HEX_UPSERT_GUIDE_DRAFT`

Tool to update or create guide drafts by filePath. Creates a new guide if it doesn't exist, creates a draft if the guide exists without a draft, or updates an existing draft. Use when you need to programmatically manage guide content in Hex.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `files` | array | Yes | Array of guide files to create or update. Each file must have a filePath and contents |
| `forceWrite` | boolean | No | If true, overwrites existing guides even if they were synced from a different external source. Use with caution as this may overwrite content (default: false) |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |