Hex

Hex is a collaborative platform for analytics and data science that allows you to build, run, and share interactive data projects and notebooks. Hex lets teams work together on data exploration, transformation, and visualization, making it easy to turn analysis into shareable insights.

With Hex, you can:

• Create and run powerful notebooks: Blend SQL, Python, and visualizations in a single, interactive workspace.
• Collaborate and share: Work together with teammates in real time and publish interactive data apps for broader audiences.
• Automate and orchestrate workflows: Schedule notebook runs, parameterize runs with inputs, and automate data tasks.
• Visualize and communicate results: Turn analysis results into dashboards or interactive apps that anyone can use.
• Integrate with your data stack: Connect easily to data warehouses, APIs, and other sources.

The Sim Hex integration allows your AI agents or workflows to:

• List, get, and manage Hex projects directly from Sim.
• Trigger and monitor notebook runs, check their statuses, or cancel them as part of larger automation flows.
• Retrieve run results and use them within Sim-powered processes and decision-making.
• Leverage Hex’s interactive analytics capabilities right inside your automated Sim workflows.

Whether you’re empowering analysts, automating reporting, or embedding actionable data into your processes, Hex and Sim provide a seamless way to operationalize analytics and bring data-driven insights to your team.

Usage Instructions

Integrate Hex into your workflow. Run projects, check run status, manage collections and groups, list users, and view data connections. Requires a Hex API token.

Tools

hex_cancel_run

Cancel an active Hex project run.

Input

Output

hex_create_collection

Create a new collection in the Hex workspace to organize projects.

Input

Output

hex_get_collection

Retrieve details for a specific Hex collection by its ID.

Input

Output

hex_get_data_connection

Retrieve details for a specific data connection including type, description, and configuration flags.

Input

Output

hex_get_group

Retrieve details for a specific Hex group.

Input

Output

hex_get_project

Get metadata and details for a specific Hex project by its ID.

Input

Output

hex_get_project_runs

Retrieve API-triggered runs for a Hex project with optional filtering by status and pagination.

Input

Output

hex_get_queried_tables

Return the warehouse tables queried by a Hex project, including data connection and table names.

Input

Output

hex_get_run_status

Check the status of a Hex project run by its run ID.

Input

Output

hex_list_collections

List all collections in the Hex workspace.

Input

Output

hex_list_data_connections

List all data connections in the Hex workspace (e.g., Snowflake, PostgreSQL, BigQuery).

Input

Output

hex_list_groups

List all groups in the Hex workspace with optional sorting.

Input

Output

hex_list_projects

List all projects in your Hex workspace with optional filtering by status.

Input

Output

hex_list_users

List all users in the Hex workspace with optional filtering and sorting.

Input

Output

hex_run_project

Execute a published Hex project. Optionally pass input parameters and control caching behavior.

Input

Output

hex_update_project

Update a Hex project status label (e.g., endorsement or custom workspace statuses).

Input

Output