Chat with your database using AI
https://insightbase.ai allows you to chat to your database and build analytics using the answers.
You can ask for anything and it will answer with a number a text or a graph.
You can build dashboards with widgets that auto-refresh at specified intervals.
This saves a lot of time and has the advantage that anyone can use it without knowing the database structure & coding.
What do you think about this?
61 comments
[ 3.0 ms ] story [ 104 ms ] threadI think it's a brilliant use-case of AI, but I really don't like this especially considering how much personal info is in that list. Kudos for being transparent about it, though.
[0] https://insightbase.ai/privacy
1. Accuracy needs to be worked upon. I asked "How many total movies are there" in the demo project, it gave me "You are trying to run an unsafe operation" (!!).
2. It asks for database access if you want to run on your database. Until the trust in the tool is developed and value proposition is clear, will be hard to give any database access.
1. Agreed, we're working on this, but for now we just went on the safe side. We don't want people to break things right now and this is why we have tight rules that flag potential dangerous operations.
2. Agreed as well, but you can provide a read-only user, and we store the credentials in an encrypted form. Also, you can whitelist the ips to our ips only.
With that being said, from my vantage, the value of a tool like this is writing the SQL query for me that I can understand, verify, and reuse.
Since it doesn't look you do that, and only return charts or "answers", you're locking users into an analytics solution rather than a tool that provides flexibility to any traditional BI solution.
Perhaps this is explained by a difference in target audience.
However this could be an option and we might add this feature if it would be valuable to our users.
Here are things I think and wonder having watched your video and browsed your website...
It makes a very big claim but offers little information. I suppose it's early days but I would need to know things about the interaction with my database.
You give it a connection string only. Is it your claim that it will figure out my database, as if an embedded training set? With no further guidance on my part?
Considering that most of the world uses SQL, your choice to use Mongo in the video demonstration makes me wonder. Is SQL query generation a future thing? That makes me wonder about the status of the project?
You show nice graphs in the demo. Are there limits to what kinds of graphs it can make? Is it some kind of AI generator tech that would allow me to ask it to make anything?
I think this is a really nice looking and potentially wonderful app. I wish you all the luck.
1. Yes, it will figure out your database structure and reply without any further guidance from your part, you don't have to do anything else.
2. We have MySQL and PostgreSQL support (we will add this info on our website, thanks for the feedback).
3. We support a few basic graphs like pie, bar, line and area graphs. You can also get numbers as replies (like totals, averages, etc.), or a table view (you can ask to see a specific entry from your database).
4. You can ask anything, and almost always you will get a good reply.
Feel free to create an account and play around (you don't have to connect your database, we have a demo database that you can use).
(E.g. a complex question would have '42' as correct return value, but misinterpretation has the engine return '345'.)
Any ideas/suggestions?
but the standard idea would be to make the path-to-solution explicit, verifiable ("also tell us how you got to that"). In other terms, "avoid the black box". Maybe have the generated SQL query output... But this will not impede abuse from lazy users, and errors "may have consequences".
Databases (just think of the testing infrastructure for SQLite) are made to be fully reliable; if the interface were not so, you would have broken the model.
However, I'm sure that we'll find a solution soon enough.
The quickest path could be having a testing environment set to determine a tentative value for your failure rate, declaring it to the public and declaring in your disclaimer the scope of the your product.
Also: https://news.ycombinator.com/item?id=35210093
Go faster of you want to succeed on such an obvious idea.
Do you have cofounders? Are you in SV? What about fund raising? Are the questions i would ask myself. And also you need to hire one of the bests.
Edit: not about microsoft 360, it's just about my comment.
What we did is to implement the idea and make it a reality.
I thought you're going to show us a product that already exists and does what we do.
It's not impossible for you to succeed, you just got to have the right strategy, which is, hit hard extremely fast. Using VCs money and strategical hiring.
2. Privacy is one of our main concerns, we obviously understand that privacy is extremely important when working with data.
3. What exactly do you mean by work with OAuth?
I work in health and I'd be asking something like "how strongly is condition x associated with demographic y". In practice I think I'd still need to give a very detailed 'prompt' listing all the clinical terms or codes to use.
It can filter the results based on some flags, values, dates, etc., and show you your results using specific constraints, you just have to ask.
We might have to do a demo where we show more advanced use cases.
I have an open issue about that here: https://github.com/simonw/datasette-chatgpt-plugin/issues/2
More about my explorations: https://simonwillison.net/2023/Mar/24/datasette-chatgpt-plug...
We're also working on AI assisted initial database generation (aka dump any data and let the AI figure out how to build up a database from it) and AI assisted Charts / Dashboard generation, which will both be released soon!
It's a lot of data processing and manipulation.
[0] https://aihelperbot.com/
[0] https://aihelperbot.com/snippets/clg9n8zgi0000l60fx0yu8cbo
[1] https://aihelperbot.com/snippets/clg9nce140002l60fyf5r5bt0
2. It can make sense sometimes, but you always have the option to specify the table name
What I want from an ai tool is strong "inferences" or some "understanding" of the data. Say I have a table with stock data and for this example it just has the following columns, ticker, close, volume_traded, eps_from_last_report, shares_outstanding. Some questions I should be able to ask are
1. What is the market cap of ticker X?
2. What is the 52 week high of ticker Y?
3. Which week had the most growth for ticker Y compared to the least growth for ticker X?
4. What is the pe ratio for ticker Z end of last quarter?
I hope you get my point, if it's a case where I have to fill in some data/formulas to guide it on what I expect that's fine as well but a pass thru to gpt with a subset of the data in the prompt won't hold up outside of toy cases or limited data. If you can solve that use case reliably then you're miles ahead of the pack.
We'd be happy to run those queries for you if you have a sample database and show you that it's possible.
We'll work on a new demo showing more advanced use cases, not just totals and bar charts.
If you find something that's not working, we'd be happy to take a look at your dataset and questions and figure out how to make it work.
Just contact us through the chat or send an email at dan at insightbase.ai .