specifically, an AI that I let loose on a large db and can offer insights out of the box "here are top <n> things you need to know" etc, and can be customized etc.
DataGems (https://datagems.ai/) could be a good fit for what you’re looking for. You can plug in your data sources without deep technical expertise. Then it has customizable templates to help analyze your large datasets and highlight the most relevant insights using AI. You can start with a simple prompt or your data, and let the AI generate insights that can inform critical decisions and enhance your data storytelling. It will also generate an output (slides, video, voice note) based on your needs.
We're taking a proactive approach to our "chat with your database" product. We begin by inspecting your db, building a knowledge base, then AI will recommend relevant insights to you depending on your query history... tinder for data if you will!
To follow up just create a new request and it'll kickoff a chat
Yes, I've done this for my clients. Any of the leading LLMs can power the natural language part. But SQL is typically too open-ended to integrate into a product. You'll need a more constrained query interface to hit 100% accuracy and deal with access control.
Basically, instead of text-to-SQL you do text-to-function-arguments, where that function does the analysis and the LLM translates natural language to your DSL instead of SQL or raw DB queries.
Shoot me an email if you want to explore this further (website in profile).
Code: https://github.com/wgryc/phasellm/tree/main/demos-and-produc...