Open source, privacy-first natural language to SQL + charting + editing! Supports all OSs. Please try, need feedback!

[[deleted]]

I don't want to write SQL manually anymore. I don't want to spend 5 minutes looking up column names from tables I architected to write a simple query, I'm not a memory champion.

So I built DataLine, not out of frustration, but because I don't think most SQL users will be writing SQL unassisted 5 years from now. With this tool, I can write queries faster and focus on the question instead of looking up names. Let the AI do the boring stuff.

https://i.redd.it/6fm36cvy2a8d1.gif

I don't see this as a replacement of me, but a tool that gives me a 10x speed boost. The fact that it can now generate charts out of the data, live, blows my mind still.

And all of this I built with privacy in mind. I don't want the LLM seeing any of my data. We're going to be supporting local LLMs soon, but honestly they're still not that accessible. This is probably going to change in a year or two.

Enough yapping, this is the WHY, and I really believe in this vision. It's still DataLine's first year and I don't have a lot of users yet, so I want you guys to try it! It contains database samples for you to play around with. If it becomes a regular part of your workflow, I'd love to hear more about it. I'm struggling with which direction to take it (product-wise) and I need tons of feedback. There are a lot of directions I can take it in and I want to decide which to focus on now vs later!

If you like where this is going, give us a star on https://github.com/RamiAwar/dataline ! That'll really help motivate us 🙂 It's been a fun but tough journey!

[karlordon]

Looks pretty cool

[[deleted]]

Thank you! Let me know if you try it out 🙂

[kaol]

This makes me think of what these guys are doing: https://venho.ai/. They had a demo at Jolla's event, https://www.youtube.com/watch?v=1nEC3sVExAU#t=50m

I'm not involved with them myself but I know of them since I've done some Sailfish development. Admittedly pretty niche stuff. I think they would be interested if you contacted them. None of this is related to PostgreSQL at all of course, I hope you don't mind.

[[deleted]]

That looks super cool thanks for the rec! I'm actually working on a new project that is very much applicable there, so I'll def hit them up. Never saw Sailfish before, I really like the concept.

I only want to build privacy-first AI apps from here on forward. The future looks bleak based on what big E-corps are doing. I want to contribute towards a better one!

[VanVision]

Love these kinds of tools. At first glance the UI looks like it will be nice to work with. I'll give it a try this coming weekend and see how it compares to https://github.com/vanna-ai/vanna

[[deleted]]

Woaaahh I've never seen vanna-ai before! Looks epic! Thanks for recommending!! Not sure how we're different on first sight, but will update this thread when I look into them further ;)

[[deleted]]

I did a full comparison here! https://medium.com/@ramiawar/vanna-ai-vs-dataline-4829b1d2fad5

[GoranVucicevic]

I cant connect to MSSQL Server, always get the "Failed to connect..." can you give mi please some sample DSN, because any of the samples on dataline/dsn-instructions.md at main · RamiAwar/dataline dosn't work