Hex
Data science platform for managing projects, runs, collections, groups, users, and data connections.
Categories: Data & Analytics, Notebooks
What you can ask
- Run the
Daily KPIHex project and post the summary in #leadership. - List Hex projects shared with
external@partner.comfor a security review. - Find projects that haven't been opened in 90 days.
Set up
Hex connects with credentials from your Hex account. Have these values ready:
- API token
- Go to Organization > Connectors and find Hex.
- Click Enable and choose which tools to allow.
- Each member enters their own values the first time they use it.
To use one account for the whole organization, turn on Share one connection with everyone. Every member's agents then act as that account, with exactly the access it has.
Tools
Hex offers 41 tools. Admins choose which ones agents can use. See Tool permission groups.
Read (18)
View and search information without changing it.
| Tool | What it does |
|---|---|
get_cell | Get a cell by ID within a project. |
get_collection | Get a collection by ID including name, description, creator, and sharing settings. |
get_current_user | Get the authenticated user's profile including name, email, and workspace role. |
get_data_connection | Get a data connection by ID including configuration, sharing, and schema settings. |
get_group | Get a group by ID including name and creation date. |
get_project | Get metadata for a single project by ID. |
get_queried_tables | Get warehouse tables queried within a project. |
get_run_chart_image | Get a rendered PNG chart image from a completed project run. |
get_run_status | Get detailed status of a specific project run including timing, state events, and notifications. |
list_cells | List cells in a project with pagination. |
list_collections | List collections in the workspace with pagination. |
list_data_connections | List accessible data connections with pagination. |
list_groups | List workspace groups with pagination. |
list_guide_drafts | List guide drafts with pagination. |
list_project_runs | List run history for a project. |
list_projects | List projects in the workspace. |
list_users | List workspace users with pagination. |
validate_credential | Validate Hex API token by retrieving the current user profile. |
Write (6)
Create or send data.
| Tool | What it does |
|---|---|
create_cell | Create a new cell in a project. |
create_collection | Create a new collection to organize projects. |
create_data_connection | Create a new data connection. |
create_group | Create a new workspace group with optional initial members. |
create_project | Create a new project in the workspace with a title and optional description. |
run_project | Trigger a run of a published project. |
Delete or overwrite (17)
Remove or replace existing data.
| Tool | What it does |
|---|---|
cancel_run | Cancel an in-progress project run. |
deactivate_user | Deactivate a workspace user. |
delete_cell | Delete a cell from a project permanently. |
delete_group | Delete a workspace group permanently. |
delete_guide_draft | Delete a guide draft permanently. |
publish_guide_drafts | Publish guide drafts. |
share_project_collections | Add a project to collections with specific access levels (APP_ONLY, CAN_VIEW, CAN_EDIT, FULL_ACCESS, NONE). |
share_project_groups | Share a project with groups. |
share_project_users | Share a project with specific users. |
update_cell | Update a cell's content or configuration within a project. |
update_collection | Update a collection's name or description. |
update_connection_schema | Update a data connection's schema filters to include or exclude databases, schemas, or tables. |
update_data_connection | Update a data connection's name, description, configuration, or sharing settings. |
update_group | Update a group's name and membership. |
update_project | Update a project's status or endorsements. |
update_project_visibility | Update workspace-wide and public web sharing for a project. |
upsert_guide_draft | Create or update a guide draft. |