Overview
At Fractal, we recognize this disparity and have been working to unlock the emergent reasoning abilities of generative models specifically to work with structured data. By steering AI models through specialized tools and carefully crafted natural language prompts, we find that these models can be surprisingly successful in providing insights from structured data using only natural language conversation.
Avalok.ai has been made generally available to Fractal employees, and our business analysts, data scientists, and data engineers have been testing Avalok.ai. We have seen enough success from an alpha release to publish these findings.
The tool has three modules designed to enhance data analysis and drive invaluable insights.
Avalok is built using Amazon RDS, Amazon Dynamo DB, Amazon Neptune, AWS Lambda, and AWS S3.
Along with highlights, each module also supports:,
- Error recovery at the code generation step – if the code generation step fails, the agent automatically captures the stack trace and reattempts, knowing what failed the last time.
- Invoking LLMs to detect if user questions are toxic, inappropriate, or irrelevant based on the data.
- Figuring out whether it should respond with an inline text, a markdown table, or a file download depending on the output size generated.
- Retaining the context of the conversation and building on earlier queries (with mixed success in our current testing).
- Providing the users with a tracing of its thought process and tool use – often offering the exact hint necessary to improve a failing query to make it successful.
- Saving and resuming a conversation later.
We have integrated user feedback into our data collection process, including prompts, responses, and thought traces. This data can be used to fine-tune the LLMs in the future.
Highlights
- IntelliSql: Enables users to query and explore relational and tabular data using natural language. This tool can query over a database, disambiguating between the relevant tables and columns within a table to write queries matching the user intent. It can also quickly generate joins between tables, rename column transformations on the fly, and make the code and results available for users to download and use elsewhere
- IntelliPlot: Allows users to generate expressive and interactive JS plots using natural language. The bot can figure out which columns are necessary for plotting, it can be prompted to deal with missing values, generate aggregates and transforms before plotting, and even label the axes and color the plots per the user’s liking. For BI analysts, generating plots quickly to their liking without referring to dense and long manuals for plotting libraries for a considerable boost in productivity
- IntelliGraph: This model provides the same capabilities as IntelliSql but over a Neo4j graph database, generating Cypher queries instead of SQL
Details
Pricing
Custom pricing options
How can we make this page better?
Legal
Content disclaimer
Resources
Vendor resources
Support
Vendor support
Contact us: alliance.aws@fractal.ai