Hex Magic

Converts natural language queries into executable SQL by analyzing the connected data warehouse schema, table relationships, and column metadata. The system maintains awareness of the user's data context (tables, columns, data types) and generates contextually appropriate queries that reference actual schema elements rather than generic placeholders. Uses LLM-based code generation with schema-aware prompt engineering to produce valid, executable SQL across multiple database backends.

Generates executable Python code snippets within Hex notebooks by understanding the notebook's execution context, previously defined variables, imported libraries, and data frames in scope. The code generator maintains awareness of what's already been computed in the notebook and generates code that builds on existing state rather than requiring full re-implementation. Uses LLM-based generation with execution context injection to produce code that runs correctly on first execution within the notebook environment.

Analyzes uploaded or connected datasets to automatically generate exploratory data analysis (EDA) code, identify statistical patterns, detect anomalies, and suggest relevant visualizations. The system profiles data distributions, cardinality, missing values, and correlations, then uses LLM reasoning to translate these profiles into natural language insights and recommended analytical directions. Generates executable code (SQL or Python) that implements the suggested analyses without requiring manual specification.

Enables multi-turn conversation where users can ask follow-up questions, request modifications, or refine queries based on results. The system maintains conversation history and context, allowing users to say things like 'filter that to just Q4' or 'show me the top 10' without re-specifying the full query. Uses conversation state management to track the current query context and incrementally modify generated code or SQL based on natural language refinements.

Analyzes data characteristics (dimensionality, cardinality, data types, distributions) and automatically recommends appropriate visualization types, then generates executable code to render those visualizations. The system understands visualization semantics (scatter plots for correlation, histograms for distributions, time series for temporal data) and maps data columns to appropriate visual encodings. Generates code using Hex's visualization libraries (or standard Python libraries like matplotlib, plotly) that can be executed directly in the notebook.

Generates Python or SQL code for common data transformation operations (filtering, grouping, joining, pivoting, aggregating) by understanding the input data schema and validating that generated transformations produce expected output schemas. The system infers transformation intent from natural language descriptions, generates code, and validates that column names, data types, and cardinality match expectations before execution. Uses schema-aware code generation with post-generation validation to catch common transformation errors.

Converts natural language descriptions of desired dashboards into executable specifications that render interactive dashboards in Hex. The system understands dashboard composition (multiple charts, filters, layout), maps natural language descriptions to specific visualization types and data queries, and generates the code or configuration needed to render the dashboard. Supports interactive elements like filters and drill-downs that are automatically wired to underlying data queries.

Automatically generates documentation, docstrings, and inline comments for data analysis code by analyzing the code's intent, data transformations, and outputs. The system understands what the code does (not just syntactic structure) and generates human-readable explanations that describe the business logic, data flow, and expected outputs. Uses LLM-based code understanding to produce documentation that explains 'why' the code exists, not just 'what' it does.

Analyzes failed code execution, error messages, and execution context to diagnose root causes and suggest code repairs. The system understands common data analysis errors (schema mismatches, type errors, missing values, query timeouts) and generates corrected code that addresses the underlying issue. Uses error message parsing combined with code analysis to produce targeted fixes rather than generic suggestions.

Generates natural language explanations of notebook cells, analyses, and results that can be shared with non-technical stakeholders. The system analyzes code, data outputs, and visualizations to produce summaries that explain what was analyzed, what was found, and what the implications are. Supports annotation of specific cells or entire analyses to create shareable explanations without requiring manual documentation writing.