Hex.tech
AI features in Hex speed up everyday data workflows, so the best data teams can focus on turning insights into impact for the business.
Last verified:
What is Hex.tech?
Hex.tech Hex Magic is an AI-powered analytics assistant integrated directly into the Hex notebook platform, designed to help data teams write queries, build charts, and fix bugs faster. It uses leading large language models (LLMs) like GPT-4 that are trained on your specific data model, database schemas, and SQL habits, enabling it to generate accurate, context-aware SQL queries and Python code. The tool is fully integrated into every SQL, Python, Chart, and Markdown cell in your Hex workspace, providing AI assist right where you're already working.
Hex.tech pricing
Pricing model: Freemium
Hex Magic is included with no extra charge in Professional and Team plans. The Community plan is free but limited to 100 Magic actions per Editor per month. Professional Plan costs $36 per Editor/month and includes unlimited Magic actions, save personal reusable components, and restore versions up to 30 days. Team Plan costs $75 per Editor/month, includes all Professional features plus restore projects from unlimited version history, and offers a 14-day free trial. Enterprise plans also include Magic AI. Magic was free during beta while pricing was being determined, but now requires Professional or Team subscription.
Hex.tech pros
- Writes accurate SQL queries using database schema context
- Auto-completes SQL joins and complex date filters
- Generates Python scripts from natural language prompts
- Creates charts and visualizations instantly
- Debugs and fixes code errors automatically
- Explains and documents existing code
- Supports multi-cell analysis chaining SQL, Python, and Charts
- Works with GPT-4 for better completions and lower error rates
- Streams responses for faster code review during generation
- Understands project context and execution graph
- @mention feature points Magic to specific tables and dataframes
- Keyboard shortcuts for quick editing, fixing, and generating
- Ask Magic enables conversational self-serve analytics for non-coders
- No extra charge for AI features on Professional and Team plans
- Does not train on customer data for data privacy
- Metadata stored securely inside Hex architecture
- SOC 2 Type II compliant security practices
- Live connections to major cloud warehouses without export
- Published apps turn notebooks into stakeholder reports
- Version control and scheduled runs for production use
Hex.tech cons
- Still in beta and not perfect, will make significant errors
- Generated code must be carefully reviewed by humans
- Only supports SQL and Python (limited language support)
- Monthly AI usage limits on paid plans restrict heavy users
- SQL accuracy depends on well-documented schema names
- Too much or irrelevant metadata can confuse the AI
- Requires database access to get full value
- Only available on Professional plan and above
- Community plan limited to 100 Magic actions per Editor/month
- Technical users must audit agent-generated code
- Context Studio administration limited to admin roles
- Platform still evolving with pricing changes planned
- Only useful for existing Hex platform users
- Not available for EU or HIPAA stacks yet
- Python environment has package limitations compared to local Jupyter
Frequently asked questions about Hex.tech
What is Hex Magic?
Hex Magic is a powerful set of AI-driven features fully integrated into your Hex workspace that puts AI assist into every SQL, Python, Chart, and Markdown cell. It uses leading LLMs like GPT-4 that understand your data schemas and project context to help you write queries, build charts, fix bugs, and get more done with data faster.
Is Hex Magic accurate enough to rely on?
No, Hex Magic is still in beta and should not be relied on for accurate, complete, or bias-free code. Like any AI system, it isn't perfect and will make significant errors. You should plan to carefully review all generated code and treat Magic as an accelerant—not a replacement—for human judgement and insight.
What languages does Hex Magic support?
Hex Magic primarily supports SQL and Python. It helps with generating, editing, debugging, and documenting SQL queries and Python scripts. It does not currently support other programming languages like R for scripting tasks.
Which Hex plans include Magic AI?
Magic AI is available on Professional, Teams, and Enterprise plans. The Community plan is limited to 100 Magic actions per Editor per month. There is no extra charge for AI-powered capabilities on Professional and Team plans—they are included in the subscription without additional AI-specific fees.
Does Hex train on customer data?
No, Hex does not and does not allow any third-party partners to train models using customer data, reducing risk of IP leakage. However, Hex does use schema information and project code as model context, so sensitive information in table/column names or code could be passed to a model. Hex does not send underlying customer data like row values to the models.
How do I turn on Magic in Hex?
Anyone on Pro, Teams, or Enterprise plans can turn on Magic by flipping the switch on their settings page. You can also get started with Magic by selecting the 'use Magic' button or hitting Command+Shift+M to open the prompt bar. Account administrators can opt-out of Magic for members of their organization in settings if needed.
What are the five Magic tools?
Hex Magic introduces five tools accessible from any SQL or Python cell: Magic Generate (create code from natural language), Magic Edit (modify existing queries), Magic Fix (debug errors), Magic Explain (document code), and Magic Complete (auto-complete joins and date filters). Additional features include Magic CTE Explode and Magic Cell Title.
How does Ask Magic work?
Ask Magic lets you type questions in natural language from the Home page of your Hex workspace. Magic will surface relevant published data apps or create a first draft of analysis from scratch, automatically generate insight summaries, highlight what data was used, and explain how the analysis was generated. You can also mention @Hex in Slack channels to ask questions directly.
Can I use Magic with my warehouse tables?
Yes, you can use the @mention feature to point Magic at specific resources like warehouse tables and dataframes. Magic has context on your tables and schemas, so you can ask natural language questions and Magic will map to the most relevant tables. You can also chain together SQL, Python, and Charts for multi-cell analysis.
Is Magic available in EU or HIPAA stacks?
No, Magic is not yet available for EU or HIPAA stacks. Hex is holding off on rolling it out to those environments until they can work with those customers on specific considerations for data privacy and compliance requirements.