Show HN: DaLMatian – Text2sql that works https://ift.tt/mnJi2Pb

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://ift.tt/Vx4qhKU ) and add a file with your database schema (instructions here: https://ift.tt/OKkS6Fw ). 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! https://ift.tt/Vx4qhKU March 21, 2024 at 10:41PM