[HN Gopher] Show HN: DaLMatian - Text2sql that works
___________________________________________________________________
Show HN: DaLMatian - Text2sql that works
Hey HN, we've built DaLMatian, a text2sql product that meets the
needs of data analysts working with enterprise data. We built this
app because as a data analyst at an enterprise I could not find a
text2sql product that was (1) actually useful for my day-to-day and
(2) easy to set up on my computer. Existing products either fall
apart when tested on gnarly enterprise data/queries or require
going through a sales/integration process that I wasn't in a
position to push for - I just wanted something that I could quickly
set up to help make my job easier. Our goal is to make this a
reality for any data analyst that feels the same. There are many
constraints that make this reality difficult to achieve. The
product needs to scale to databases with millions of columns and
extract business logic from very complex queries. It also needs to
be fast, at least faster than an analyst would take to write the
query. On top of all this, an analyst needs to be allowed to use it
from a security standpoint. Our app meets all the key requirements
of an enterprise data analyst while also being lightweight enough
to run locally on a typical laptop. Here's how it works. To get
started, you simply need to open a file of past queries in our IDE
(try it here: https://www.dalmatian.ai/download) and add a file
with your database schema (instructions here:
https://www.dalmatian.ai/docs#configuration). There is also an
option to connect a database to auto pull your schema (no actual
data is seen by the LLM). We do not see anything you input since
the app is local and the only external connection is with OpenAI.
It's just like asking ChatGPT for help with queries, but in a
streamlined way. If you'd download our free IDE and try to break
it, we'd love to hear what you come up with!
Author : alandu
Score : 26 points
Date : 2024-03-21 17:11 UTC (5 hours ago)
(HTM) web link (www.dalmatian.ai)
(TXT) w3m dump (www.dalmatian.ai)
| pelagicAustral wrote:
| Why make it a full VSCode download instead of a plugin?
| bdcravens wrote:
| Recommendation: your HN post shouldn't tell us more about the
| company and product than your website does.
| swimwiththebeat wrote:
| Is this open-source?
| CharlesW wrote:
| It's not, and the "Talk to Sales" and the ToS
| (https://www.dalmatian.ai/terms) strongly suggest they're
| targeting enterprise customers with bespoke enterprise-y
| pricing.
| laidoffamazon wrote:
| Two notes:
|
| 1) I appreciate that it's said to be local first but the fact
| that it depends on an OpenAI API usage is...kinda a big hole in
| that? The organization I work in wouldn't really accept this for
| approval, and from the title I was hoping that this would be a
| local-first fine tuned (or fine-tunable) LLM.
|
| 2) The about page stating that you met at Princeton is a huge
| bear signal for me. I don't think tools should be adopted based
| on how much of an elite (cognitive or financial or social or
| athletic or whatever) their creators are, and given the use of
| the OpenAI APIs I question why the "top ML conferences" bit is
| here at all.
| moqca wrote:
| Cant get this to work. Instructions are very unclear. Was unable
| to open a snowflake connection. Uploaded schema in a csv file. No
| indication of what needs to be done next. Assume that manage
| context queries is where it pulls info from. Added a query and
| provided a dsecription. Tried Q&A, nothing happened
| l5870uoo9y wrote:
| If you are looking for a text to sql solution, I can in all
| modesty recommend my own https://www.sqlai.ai. Adding schemas
| can be done in any format and it automatically parsed/optimized
| by AI for optimal performance.
___________________________________________________________________
(page generated 2024-03-21 23:01 UTC)