Hex

Hex is a notebook-based data workspace where analysts and data scientists combine SQL, Python and no-code cells to explore data, build interactive apps/dashboards and share them as conversational 'Threads' for self-serve Q&A. Its Notebook Agent writes queries, charts and full analyses from natural-language prompts grounded in a semantic model, used by data teams at companies like Notion and Loom.

What you get: SQL + Python + no-code notebook cells, Notebook Agent (AI writes full analyses), Threads conversational self-serve BI, Semantic model layer for grounded answers, Scheduled runs and alerts, Published interactive data apps, Version history, REST API.

Typical jobs: build interactive data app without frontend code; ask data questions in natural language grounded in company metrics; collaborative sql python notebook for data team; self-serve analytics for non-technical stakeholders.

Worth knowing: Full AI agent + self-serve Threads require the $75/editor/month Team tier or above; Community/Professional tiers have limited AI credits.

What users complain about: Once a notebook grows to 70+ cells, editing becomes painful. Ctrl-F stops jumping to the right cell and scrolling gets difficult. (G2 Hex pros and cons)