Virtual Data Analyst
A powerful tool for data analysis, visualizations, and insights
Advanced Analytics
Run SQL queries, perform regressions, and analyze results with ease
Rich Visualizations
Create scatter plots, line charts, pie charts, and more
Automated Insights
Get instant insights and recommendations for your data
Supported Files
This tool allows users to communicate with and query real time data from a SQL DB (postgres for now, others can be added if requested) using natural language and the above features.
Notice: the way this system is designed, no login information is retained and credentials are passed as session variables until the user leaves or refreshes the page in which they disappear. They are never saved to any files. I also make use of the Pandas read_sql_query function to apply SQL queries, which can't delete, drop, or add database lines to avoid unhappy accidents or glitches. That being said, it's probably best to use caution when connecting to a production database to a strange AI tool with an unfamiliar author. This should be for demonstration purposes.
Contact me if this is something you would like built in your organization, on your infrastructure, and with the requisite privacy and control a production database analytics tool requires.
This tool allows users to communicate with and query real time data from a Document DB (MongoDB for now, others can be added if requested) using natural language and the above features.
Notice: the way this system is designed, no login information is retained and credentials are passed as session variables until the user leaves or refreshes the page in which they disappear. They are never saved to any files. I also make use of the PyMongoArrow aggregate_pandas_all function to apply pipelines, which can't delete, drop, or add database lines to avoid unhappy accidents or glitches. That being said, it's probably best to use caution when connecting to a production database to a strange AI tool with an unfamiliar author. This should be for demonstration purposes.
Contact me if this is something you would like built in your organization, on your infrastructure, and with the requisite privacy and control a production database analytics tool requires.
Please be patient while connecting as we need to generate and read a schema before connection can be successful. This process can take a few minutes.
This tool allows users to communicate with and query real time data from a GraphQL API endpoint using natural language and the above features.
Notice: API querying is the most difficult and experimental feature so far. This tool may have variable performance and quality, although it should get better over time as I evaluate use. No login information is retained and credentials are passed as session variables until the user leaves or refreshes the page in which they disappear. They are never saved to any files.
I don't include a function that allows the system to run mutations and I instruct the agent to not alter any data, but it could in theory be possible, although my testing wasn't able to get the system to alter or write to the api. I would be careful to make sure permissions are restricted for the api token being used. And of course, it's probably best to use caution when connecting to a strange AI tool with an unfamiliar author. This should be for demonstration purposes.
Contact me if this is something you would like built in your organization, on your infrastructure, and with the requisite privacy and control a production database analytics tool requires.