4 ms·

I have been keeping track of a few products like these including some that are YC backed. Interesting space as I am looking for a solution myself: - Minds DB (

I have been keeping track of a few products like these including some that are YC backed. Interesting space as I am looking for a solution myself: - Minds DB (YC W20) https://github.com/mindsdb/mindsdb https://github.com/mindsdb/mindsdb - Buster (YC W24) https://buster.so https://buster.so - DB Pilot https://dbpilot.io https://dbpilot.io and now this one

markding00 3y ago
also Brewit.ai (YC W23) https://brewit.ai/ https://brewit.ai/
bredren 3y ago
Have you written up any results of your experience with each? I’m interested in a survey of this field so far and would read it.
- codegeek 3y ago
  Not yet but not a bad idea if I can get to test them all soon :)
pylua 3y ago
I don’t fully understand the use of business case after reading the documentation. Is it really a time save?
- MattGaiser 3y ago
  It would be for people who are not that fluent in SQL. Even as a dev, I find ChatGPT to be easier for writing queries than hand coding them as I do it so infrequently.
  - pylua 3y ago
    Yeah, same here. Seems like that approach is much simpler than this. I guess the real benefit here is that you don’t need to understand the schemas so the knowledge is not lost when someone leaves a company. Sort of an abstraction layer for the schemas
    - totalhack 3y ago
      Sounds like you are describing a semantic layer. You don't need AI to achieve that, though it is fun when it works. Example of a semantic layer I made below, but there are others out there with more support behind them. https://github.com/totalhack/zillion https://github.com/totalhack/zillion
- EmilStenstrom 3y ago
  Allow people that don't know SQL to query a database.
- realanswe91 3y ago
  [flagged]
  - pylua 3y ago
    The initial part about sql already being that bridge was my first reaction, too.
refset 3y ago
It's not a public facing product, but there was a talk from a team at Alibaba a couple of months ago during CMU's "ML⇄DB Seminar Series" [0] on how they augmented their NL2SQL transformer model with "Semantics Correction [...] a post-processing routine, which checks the initially generated SQL queries by applying rules to identify and correct semantic errors" [1]. It will be interesting to see whether VC-backed teams can keep up with the state of the art coming out of BigCorps. [0] "Alibaba: Domain Knowledge Augmented AI for Databases (Jian Tan)" - https://www.youtube.com/watch?v=dsgHthzROj4&list=PLSE8ODhjZXjYVdJKka5g3xTKfPBITrxOu&index=11 https://www.youtube.com/watch?v=dsgHthzROj4&list=PLSE8ODhjZX... [1] "CatSQL: Towards Real World Natural Language to SQL Applications" - https://www.vldb.org/pvldb/vol16/p1534-fu.pdf https://www.vldb.org/pvldb/vol16/p1534-fu.pdf
- ignoramous 3y ago
  See also SQLCoder by defog.ai: https://github.com/defog-ai/sqlcoder https://github.com/defog-ai/sqlcoder
kszucs 3y ago
Please add Ibis Birdbrain https://ibis-project.github.io/ibis-birdbrain/ https://ibis-project.github.io/ibis-birdbrain/ to the list. Birdbrain is an AI-powered data bot, built on Ibis and Marvin, supporting more than 18 database backends. See https://github.com/ibis-project/ibis https://github.com/ibis-project/ibis and https://ibis-project.org https://ibis-project.org for more details.
- codyvoda 3y ago
  note that Ibis Birdbrain is very much work-in-progress, but should provide an open-source solution to do this w/ 20+ backends old demo here: https://gist.github.com/lostmygithubaccount/08ddf298987321011a1ef7fffee09e4a https://gist.github.com/lostmygithubaccount/08ddf29898732101... planning to finish it...soon...
  - hatsix 3y ago
    soon like "check back in a month", or "Soon™"?
    - codyvoda 3y ago
      the "check back in a month" soon. I have versions of it that work but I just haven't been satisfied with. also, the major underlying dependency (Marvin) is going through a large refactor for v2. once that stabilizes a bit, I'm going to upgrade to it and that might simplify the code I need a lot
lmeyerov 3y ago
We have been piloting louie.ai with some fairly heavy orgs that may be relevant: Cybersecurity incident responders, natural disaster management, insurance fraud, and starting more regular commercial analytics (click streams, ...) A bit unusual compared to the above, we find operational teams need more than just SQL, but also Python and more operational DBs (Splunk, OpenSearch, graph DBs, Databricks, ...). Likewise, due to our existing community there, we invest a lot more in data viz (GPU, ..) and AI + graph workflows. These have been through direct use, like Python notebooks & interactive dashboards except where code is more opt-in where desired or for checking the AI's work, and new, embedded use for building custom apps and dashboards that embed conversational analytics.
zurfer 3y ago
I would love to bring your attention also to getdot.ai We launched it on Hackernews with an analysis of HN post data. https://news.ycombinator.com/item?id=38709172 https://news.ycombinator.com/item?id=38709172 the main problems we see in the space: 1) good interface design: nobody wants another webapp if they can use Slack or Teams 2) learning enough about the business and usually messy data model to always give correct answers or say I don't know.
sherlock_h 3y ago
Here is one more: https://www.ycombinator.com/companies/patterns https://www.ycombinator.com/companies/patterns

markding00 3y ago

also Brewit.ai (YC W23) https://brewit.ai/ https://brewit.ai/

bredren 3y ago

Have you written up any results of your experience with each? I’m interested in a survey of this field so far and would read it.

codegeek 3y ago
Not yet but not a bad idea if I can get to test them all soon :)

pylua 3y ago

I don’t fully understand the use of business case after reading the documentation. Is it really a time save?

MattGaiser 3y ago
It would be for people who are not that fluent in SQL. Even as a dev, I find ChatGPT to be easier for writing queries than hand coding them as I do it so infrequently.
- pylua 3y ago
  Yeah, same here. Seems like that approach is much simpler than this. I guess the real benefit here is that you don’t need to understand the schemas so the knowledge is not lost when someone leaves a company. Sort of an abstraction layer for the schemas
  - totalhack 3y ago
    Sounds like you are describing a semantic layer. You don't need AI to achieve that, though it is fun when it works. Example of a semantic layer I made below, but there are others out there with more support behind them. https://github.com/totalhack/zillion https://github.com/totalhack/zillion
EmilStenstrom 3y ago
Allow people that don't know SQL to query a database.
realanswe91 3y ago
[flagged]
- pylua 3y ago
  The initial part about sql already being that bridge was my first reaction, too.

refset 3y ago

It's not a public facing product, but there was a talk from a team at Alibaba a couple of months ago during CMU's "ML⇄DB Seminar Series" [0] on how they augmented their NL2SQL transformer model with "Semantics Correction [...] a post-processing routine, which checks the initially generated SQL queries by applying rules to identify and correct semantic errors" [1]. It will be interesting to see whether VC-backed teams can keep up with the state of the art coming out of BigCorps. [0] "Alibaba: Domain Knowledge Augmented AI for Databases (Jian Tan)" - https://www.youtube.com/watch?v=dsgHthzROj4&list=PLSE8ODhjZXjYVdJKka5g3xTKfPBITrxOu&index=11 https://www.youtube.com/watch?v=dsgHthzROj4&list=PLSE8ODhjZX... [1] "CatSQL: Towards Real World Natural Language to SQL Applications" - https://www.vldb.org/pvldb/vol16/p1534-fu.pdf https://www.vldb.org/pvldb/vol16/p1534-fu.pdf

ignoramous 3y ago
See also SQLCoder by defog.ai: https://github.com/defog-ai/sqlcoder https://github.com/defog-ai/sqlcoder

kszucs 3y ago

Please add Ibis Birdbrain https://ibis-project.github.io/ibis-birdbrain/ https://ibis-project.github.io/ibis-birdbrain/ to the list. Birdbrain is an AI-powered data bot, built on Ibis and Marvin, supporting more than 18 database backends. See https://github.com/ibis-project/ibis https://github.com/ibis-project/ibis and https://ibis-project.org https://ibis-project.org for more details.

codyvoda 3y ago
note that Ibis Birdbrain is very much work-in-progress, but should provide an open-source solution to do this w/ 20+ backends old demo here: https://gist.github.com/lostmygithubaccount/08ddf298987321011a1ef7fffee09e4a https://gist.github.com/lostmygithubaccount/08ddf29898732101... planning to finish it...soon...
- hatsix 3y ago
  soon like "check back in a month", or "Soon™"?
  - codyvoda 3y ago
    the "check back in a month" soon. I have versions of it that work but I just haven't been satisfied with. also, the major underlying dependency (Marvin) is going through a large refactor for v2. once that stabilizes a bit, I'm going to upgrade to it and that might simplify the code I need a lot

lmeyerov 3y ago

We have been piloting louie.ai with some fairly heavy orgs that may be relevant: Cybersecurity incident responders, natural disaster management, insurance fraud, and starting more regular commercial analytics (click streams, ...) A bit unusual compared to the above, we find operational teams need more than just SQL, but also Python and more operational DBs (Splunk, OpenSearch, graph DBs, Databricks, ...). Likewise, due to our existing community there, we invest a lot more in data viz (GPU, ..) and AI + graph workflows. These have been through direct use, like Python notebooks & interactive dashboards except where code is more opt-in where desired or for checking the AI's work, and new, embedded use for building custom apps and dashboards that embed conversational analytics.

zurfer 3y ago

I would love to bring your attention also to getdot.ai We launched it on Hackernews with an analysis of HN post data. https://news.ycombinator.com/item?id=38709172 https://news.ycombinator.com/item?id=38709172 the main problems we see in the space: 1) good interface design: nobody wants another webapp if they can use Slack or Teams 2) learning enough about the business and usually messy data model to always give correct answers or say I don't know.

sherlock_h 3y ago

Here is one more: https://www.ycombinator.com/companies/patterns https://www.ycombinator.com/companies/patterns