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/YTRI9S8 ) and add a file with your database schema (instructions here: https://ift.tt/c45UiAB ). 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/YTRI9S8 March 21, 2024 at 10:41PM
Show HN: DaLMatian – Text2sql that works https://ift.tt/9qRrGAS
Related Articles
Show HN: An app store just for installable web apps https://ift.tt/7sImtJ1Show HN: An app store just for installable web apps https://store.app … Read More
Show HN: Userscript that removes all recommendations from your Reddit frontpage https://ift.tt/YnpKEo1Show HN: Userscript that removes all recommendations from your Reddit … Read More
Show HN: An image generator that embeds headline text for X / Twitter Cards https://ift.tt/pn7CBgjShow HN: An image generator that embeds headline text for X / Twitter … Read More
Show HN: Smartphone haptics for inducing calm, an alternative to meditation https://ift.tt/Q3OyMtzShow HN: Smartphone haptics for inducing calm, an alternative to medit… Read More
Show HN: Using File System as Database https://ift.tt/gyEjLdQShow HN: Using File System as Database https://ift.tt/xwOief8 October … Read More
Show HN: Dittofeed v0.5.0 – Self-host SMS and email customer messaging https://ift.tt/1x6ynRkShow HN: Dittofeed v0.5.0 – Self-host SMS and email customer messaging… Read More
Show HN: Go from code –> database catalog with AI https://ift.tt/LF9SEnQShow HN: Go from code –> database catalog with AI Sonar crawls your… Read More
Show HN: Running LLMs in one line of Python without Docker https://ift.tt/iDwaHbjShow HN: Running LLMs in one line of Python without Docker Hello Hacke… Read More
0 Comments: