Integration · Company data

Connect Claude & ChatGPT to Hex

Ask your AI to rerun the weekly revenue project, fetch the latest result of a SQL cell, or pose a data question to Hex's own AI. It can list and run projects, follow runs, read cells, outputs and charts, add or change SQL, code and markdown cells, and look up collections, users and data connections in your workspace.

Connect Hex free

Free plan, no credit card. Takes about a minute.

Try asking

“Run the Weekly revenue project with region set to Nordics.”
The AI runs the latest published version with that input value and returns a run ID it can check.
“Did the last run of the churn dashboard finish?”
It lists the project's runs and reads the status of the latest one, such as RUNNING, ERRORED or COMPLETED.
“Show me the result of the monthly signups SQL cell.”
It finds the cell in the project and reads its latest output.

What your AI can do

Projects and runs

List, create and export projects, run the published version with input values, follow run status and cancel a run.

Cells and outputs

Read cells, SQL results and chart images, and add or change SQL, code and markdown cells.

Hex AI and workspace

Ask Hex AI questions and follow-ups, and look up collections, users, groups and data connections.

“Send me the revenue chart as an image.”
It fetches the chart cell as an image, at a width and height you choose if you want.
“Add a SQL cell to the Marketing project that counts orders per week.”
It appends a SQL cell with the query to the project. You can attach a data connection to it as well.
“Ask Hex which customers had the biggest drop in usage last month.”
It starts a Hex AI thread with the question and reads Hex's answer from the thread when it is ready.

58 tools for Hex

These tools are switched on when you connect. You can switch any of them off, or require your approval before it runs.

archive_userVisible to othersDeactivate a user (user id). Has effects visible outside this system. API summary: DeactivateUser.
ask_followupChanges dataAsk a follow-up question (`prompt`) in an existing Hex AI thread by `thread_id`.
ask_questionChanges dataStart a new Hex AI thread with a data question in `prompt`, optionally against an existing `project_id` or referencing tables, projects or a data connection in `attachments`. Hex answers asynchronously; read the reply with list_thread_messages.
cancel_runDeletesStop a running project run: pass the project as `project_id` and the run ID as `project_id_2`.
create_batchVisible to othersCreate a new batch. Required: project ids. Has effects visible outside this system. API summary: BatchUpdateComputeProfile.
create_categoryChanges dataCreate a new category. Required: name.
create_cellChanges dataAdd a cell to a project (`project_id`): `cell_type` SQL, CODE or MARKDOWN, with `contents` holding the matching sqlCell, codeCell or markdownCell source. Appended at the end unless `location` is given.
create_data_connectionChanges dataCreate a new data connection. Required: connection details, type or name.
create_groupChanges dataCreate a new group. Required: name.
create_projectChanges dataCreate a new, empty project with a `title` and optional description.
create_project_ingest_semantic_projectChanges dataCreate a new project for a project.
create_suggestion_reviewChanges dataCreate a new review for a suggestion. API summary: TriggerSuggestionReview.
delete_cellDeletesPermanently delete a cell by cell id. Destructive action; may require approval. API summary: DeleteCell.
delete_draftDeletesPermanently delete a draft by org guide file id. Destructive action; may require approval.
delete_groupDeletesPermanently delete a group by group id. Destructive action; may require approval.
export_projectChanges dataExport a project by `project_id`, either the current draft or the latest published version (`version`).
get_cellGet one cell by `cell_id`, with its type and source.
get_cell_outputGet the latest result output of a SQL cell by `cell_id`.
get_chart_imageGet a chart cell as an image by `cell_id`, optionally at a given width and height in pixels.
get_collectionGet one collection by its ID (`category_id`).
get_current_userGet the Hex user this connection is signed in as, with name, email and role.
get_data_connectionGet one data connection by data connection id. API summary: GetDataConnection.
get_groupGet one group by group id.
get_projectGet one project by `project_id`, with title, description, owner, status and publish info.
get_run_statusGet the status of one project run: pass the project as `project_id` and the run ID as `project_id_2`.
get_suggestionGet one suggestion by suggestion id. API summary: GetSuggestion.
get_threadGet one Hex AI thread by `thread_id`, with its status.
list_cell_images_get_chart_image_from_runList images for a cell. Optional filters: width, height or include title. API summary: GetChartImageFromRun.
list_cellsList the cells (SQL, code, markdown, charts) in a project by `project_id`.
list_collectionsList the collections projects are organised into.
list_data_connectionsList the data connections (warehouses and databases) available in the workspace.
list_groupsList user groups in the workspace.
list_listsList lists. Optional filters: before or external source. Results are paginated. API summary: ListDraftGuides.
list_project_queried_tablesList queried tables for a project. Optional filters: before. Results are paginated.
list_project_runsList past and current runs of a project by `project_id`, optionally filtered by status (e.g. RUNNING, ERRORED, COMPLETED).
list_projectsList projects in the workspace, optionally filtered by owner email, status or category and sorted by created, edited or published date.
list_suggestionsList suggestions. Optional filters: before, sort by, sort direction or status. Results are paginated. API summary: ListSuggestions.
list_thread_messagesList the messages (questions and Hex's answers) in a thread by `thread_id`.
list_threadsList Hex AI threads (questions asked to Hex's agent), optionally filtered by user, source, type or recent days.
list_topicsList topics. Optional filters: before. Results are paginated. API summary: ListTopics.
list_usersList users in the workspace, optionally filtered by group or user IDs.
run_projectChanges dataRun the latest published version of a project by `project_id`, optionally with `input_params` values or a saved view. Returns a run ID to check with get_run_status; use `dry_run` to only validate.
set_project_statusChanges dataSet a project's `status` label (e.g. an approval or certification status) by `project_id`, or pass null to clear it.
submit_guideVisible to othersPublish a guide. Has effects visible outside this system.
update_categoriesVisible to othersUpdate an existing category identified by project id. Only the fields you pass are changed. Has effects visible outside this system.
update_categoryChanges dataUpdate an existing category identified by category id. Only the fields you pass are changed.
update_cellChanges dataChange a cell's source by `cell_id` via `contents` (sqlCell, codeCell or markdownCell), or attach a data connection to a SQL cell.
update_create_presigned_urlChanges dataUpdate an existing create presigned url identified by project id.
update_data_connectionChanges dataUpdate an existing data connection identified by data connection id. Only the fields you pass are changed.
update_data_connection_schemasVisible to othersUpdate an existing schema identified by data connection id. Only the fields you pass are changed. Has effects visible outside this system.
update_draftsVisible to othersUpdate an existing draft. Has effects visible outside this system.
update_groupChanges dataUpdate an existing group identified by group id. Only the fields you pass are changed.
update_groupsVisible to othersUpdate an existing group identified by project id. Only the fields you pass are changed. Has effects visible outside this system. API summary: EditProjectSharingGroups.
update_projectChanges dataUpdate an existing project identified by semantic project id. Only the fields you pass are changed.
update_suggestionChanges dataUpdate an existing suggestion identified by suggestion id. API summary: UpdateSuggestion.
update_suggestion_changeChanges dataUpdate an existing change identified by change id. API summary: UpdateSuggestionChange.
update_usersVisible to othersUpdate an existing user identified by project id. Only the fields you pass are changed. Has effects visible outside this system. API summary: EditProjectSharingUsers.
update_workspace_and_publicsVisible to othersUpdate an existing workspace and public identified by project id. Only the fields you pass are changed. Has effects visible outside this system. API summary: EditProjectSharingOrgAndPublic.

Set up in three steps

1
Pick the app
Create a free HeyMyApps account and choose Hex from the app list.
2
Paste your key
Paste a Hex API token. In Hex open User settings > API keys, click New Token (needs the Editor role or higher), set a description and expiry, and copy the token (it starts with hxtp_). Workspace admins can instead create a workspace token (hxtw_) with scopes under workspace settings.
3
Add the link to your AI
You get a personal MCP link. Add it to Claude, ChatGPT or Cursor:
1. Click your name, then Settings › Connectors › Add custom connector.
2. Paste your link as the Remote MCP server URL.
3. Switch it on from the + menu in a chat.

Questions

What can the AI do in Hex?

The AI can list, read and export projects, run them and follow or cancel runs, read cells, SQL outputs and chart images, and look up collections, users, groups and data connections. It can create projects, add and change cells, set a project's status and ask Hex AI questions.

Does the AI see my Hex API token?

No. Your Hex API token is encrypted at rest and never shown to the AI. After you save it, it is not shown again, not even to you. The AI only sees the results of the tools it calls.

Can I control what the AI is allowed to do?

Yes. You choose which tools are switched on, so you can start with only reading projects and results. Running a project queries your data connections and cancelling a run stops it, so both can require your approval before they run. Every tool call is logged.

Does it work with ChatGPT?

Yes. In ChatGPT go to Settings › Apps & Connectors › Advanced and turn on Developer mode, then add your HeyMyApps link. Developer mode needs a paid ChatGPT plan: Plus, Pro, Business or Enterprise. The same link also works in Claude (Settings › Connectors › Add custom connector), Cursor and other MCP clients.

What does it cost?

HeyMyApps has a free plan with no credit card required. Paid plans bill per completed task. You also need your own Hex workspace.

Should I use a personal or a workspace token?

Both work. A personal token (hxtp_) acts as you, and you need the Editor role or higher to create one. A workspace admin can create a workspace token (hxtw_) and choose its scopes, which limits what the connection can reach in Hex.