Overview
Hex AI is an AI data-analysis tool that lets you query, transform, and visualize data using natural language. It translates questions into SQL or dataframe operations, explains results, generates charts, and handles the back-and-forth of clarifying ambiguous requestsโmaking data accessible to analysts and non-technical users alike.
Getting Started
Get started with Hex AI by connecting a data source (database, warehouse, or CSV/Parquet files). Ask a question in natural language, review the generated query and result, then refine. Use the tool's visualization features to chart results and its explanation feature to understand each step of the generated analysis.
# Install
pip install hex-ai
# Connect and ask (Python example)
from hex_ai import HexAI
ai = HexAI(db_url="postgresql://...")
result = ai.ask("What's the monthly revenue trend for 2025, grouped by region?")
print(result.sql) # the generated query
print(result.data) # the result rows
result.chart() # a visualizationUse Cases
Use cases for Hex AI: (1) ad-hoc analytics without writing SQL by hand; (2) generating and explaining complex joins and window functions; (3) building dashboards from natural-language specs; (4) data cleaning and schema inference for messy CSVs; (5) empowering non-technical stakeholders to self-serve answers.
Tips
Tips for Hex AI: always inspect the generated SQL before trusting the numberโAI can misread schema intent. Grant the tool read-only access with row limits to prevent expensive queries. Provide schema descriptions and sample rows as context for better queries. Validate surprising results with a second, independent query.
Ready to try Hex AI?
Visit the official site for the latest version and full documentation.
Visit Hex AI