8 ms·

Show HN: DataRamen, a Fast SQL Explorer with Automatic Joins and Data Navigation

48 points by oleksandr_dem 1y ago

I built DataRamen, a local-first SQL explorer that helps you get the data you need fast, without writing repetitive queries every time. You run it locally from the CLI (no cloud version yet), connect your databases, and you're ready to go. The goal is to let you explore and query data like you would in a spreadsheet: intuitive, fast, and without friction. Key features: - Automatic joins & related data navigation: Right-click any row to instantly see related records in other tables (based on foreign keys or references). - Keyboard-driven UI: Hit N to jump to a table, F to filter, and so on, it’s optimized for speed so you can go from question to insight in seconds (this point is still in progress, I find it confortable, but the goal is to make it even better). - Named tabs with saved queries: Keep multiple tabs open with different queries, useful for comparing or cross-checking data. Tabs are saved, so you can get back to your queries at any time. - Instant edit & insert: One click to edit or add rows, no need to write full queries. - Multi-DB support: Connect several databases and search across all of them. - Search across all columns: Find what you need even if you don't know the exact column. If you've ever felt slowed down by writing the same SQL over and over just to explore your data, this might save you a ton of time. I’d love feedback or suggestions, especially from folks who wrangle data often. Find more information on https://dataramen.xyz https://dataramen.xyz PS. don't be harsh on the logo, I did my best :)

mousetree 1y ago
Screenshots on the website would be very helpful. This sounds interesting, but would like to see what the actual UI is before setting anything up. It would also be good to link to the Github repo for the CLI part - I'm skeptical of giving an unknown tool access to my database without understanding what it's actually doing.
- oleksandr_dem 1y ago
  Totally understandable, your concerns are valid. I will have to figure out the CLI part, I would prefer to keep it private (at least for now), but I get it that people don't want to provide DB access to a completelly new tool. And yes, you're absolutely right about the lack of screenshots. I realize now how important that is for trust and clarity. I’m working on improving the landing page with proper visuals, and I’m also exploring the idea of a live demo using an in-browser SQLite DB — that should let people try it instantly without setup. It’ll take a bit of time, but it’s now high on the priority list. Appreciate the feedback!
  - socks 1y ago
    is this chatgpt? your comments read like chatgpt output
    - yunohn 1y ago
      Honestly, that comment really does not seem very chatGPT-like.
      - socks 1y ago
        it screams it to me - wording such as "your concerns are valid", "yes, you're absolutely right..." and "I realize now how important...", and then usage of em-dash
        BrandoElFollito 1y ago
        What is this obsession with the em-dash? For those who used LaTeX it is second nature, and a -- gets changed to an em-dash by a lot of editors or programs such as AutoHotkey
        oleksandr_dem 1y ago
        As mentioned in another comment, I used ChatGPT to improve grammar and rewrite a bit my messages. I stopped using it since.
        snickerdoodle12 1y ago
        It's okay to be authentically you
        zeroq 1y ago
        Last time I was trying to be authentically me my response triggered a whole sub-thread about me using the word "subvention" and how funny Europeans sounds to Americans. ¯\_(ツ)_/¯
brap 1y ago
>GUI Not a single screenshot on the page
- tiku 1y ago
  Yeah I hate lacking screenshots but now I'm going to try it, so probably a good thing haha
- oleksandr_dem 1y ago
  You're absolutely right, I really dropped the ball on that. This is my first time launching a product like this, and I focused so much on building and writing the post that I overlooked the importance of visuals. The lack of screenshots is definitely hurting the presentation (and I can see it in the bounce rate). I'll prioritize getting some clear screenshots and maybe even a short demo video up soon. Thanks for pointing it out, appreciate the feedback.
  - scoot 1y ago
    "Soon" being tomorrow, next week, next month? Just stating the obvious, but taking 30 minutes to do it now while you have traction on HN seems like a no-brainer.
    - oleksandr_dem 1y ago
      I did a lot of things wrong this time (I should've seen coming all the negative feedback I got). The lesson I learned is not rushing things. I will likely have to get a step back and to rethink some stuff (including landing page).
sunshine-o 1y ago
What a cool name !
- oleksandr_dem 1y ago
  Thanks! I was aiming for something fun and a little memorable — glad it landed well
koolba 1y ago
Where's the code? The NPM page says it is MIT licensed but I do not see any links to a source repo. I think most people would be wary of running random npm modules to which they will be giving database credentials and passing through their actual data.
- oleksandr_dem 1y ago
  You're right, and you're not the only one who's raised this, totally fair concern. As a developer myself, I get why running a CLI tool that touches your databases without access to the source is a hard sell. I hadn’t initially planned to open source it, but this feedback is making me seriously reconsider. At the very least, more transparency is clearly needed, and I’m thinking through the best way to approach that. Curious though, would you feel any more comfortable if it were a packaged desktop app (with no source) instead of a CLI? Or is open code the baseline no matter the form?
  - koolba 1y ago
    There's a big difference between a precompiled app from a company you've possibly heard of (which exists as an entity and could be sued for creating something malicous) v.s. some random guy on the internet. I personally would not run an arbitrary binary from somebody I've never heard of on my local machine. And definitely not give it database credentials or access. I also think anybody that is willing to do so is insane. There's so much garbage and malware on npm, that something that is installed via the @latest on npm is arguably even worse. Even if it's fine now, there's no telling when one of its deps could be compromised too.
    - oleksandr_dem 1y ago
      I see your point. Since it's unlikely that I'll become a trusted entity anytime soon, open-sourcing it is probably the right thing to do to build some credibility.
    - giancarlostoro 1y ago
      Companies have to start somewhere though, lots of software exists that never was open source. I think he needs to get his tool in the hands of people who review dev tools.
gavinray 1y ago
I'd like to know what it looks like before investing my time in using a GUI tool. Neat idea on paper though!
- oleksandr_dem 1y ago
  Yes, a lot of people have complained about this, and I totally get it, I messed up the presentation part. Improving the landing page will likely be my top priority following this post.
kigiri 1y ago
You can find screenshots here: https://dev.to/9zemian5/tired-of-writing-sql-just-to-explore-your-db-me-too-so-i-built-this-5hjj https://dev.to/9zemian5/tired-of-writing-sql-just-to-explore... (might be outdated, didn't test the tool) On my part, I would like to see sqlite support and screenshots on the mainpage, also not a big fan of running an unknown command on my data. Since you run locally, any value of having the frontend loaded from a website instead of just opening it in localhost ?
- oleksandr_dem 1y ago
  Hi, yes, the dev.to post is a bit outdated. > I would like to see sqlite support Indeed, it is something I'm planing to add, but following all the feedback I got so far this will have to wait (landing page needs some work, plus a lot of people are having concerns regarding CLI tool not being open sourced) > any value of having the frontend loaded from a website instead of just opening it in localhost ? I want the CLI package to be as small as possible, and including 600kb React bundle in it is the exact oposite of small. Moreover, the idea in the future is for you to be able to connect to any host (be it cloud, localhost or selfhosted) from the same page (for example I have company self hosted server and a local server for my local databases).
cuuupid 1y ago
Sounds very nice but doesn't seem to support Node v22 :/ ``` Error [ERR_REQUIRE_ESM]: require() of ES Module /Users/cupid/.bun/install/global/node_modules/yargs/index.mjs not supported. ``` Is there a GitHub or similar where issues can be reported?
- oleksandr_dem 1y ago
  Not yet, but following the comments on this post I will likely open source the codebase. It will help to both improve trust in the product and provide a place to report issues publicly. This seems like a yargs compatibility issue (I kind of expected it to be problematic), I will probably switch to commander to handle CLI.
akoculu 1y ago
nice work + cool name, congrats!
747-8F 1y ago
Saving this; may prove its utility in enterprise BU analysis.
googoloid 1y ago
So this uses the local cli tool to allow your hosted code to connect to the db? Sounds a bit sketchy to me
- oleksandr_dem 1y ago
  It uses the CLI to connect to the database. When you start the tool, it creates a server on your localhost (localhost:4466), and acts as: - Local database: it stores some stuff locally, like saved queries or DB configurations - Query runner: when you run a query in the webapp it will call your localhost server, which will connect to the database and execute the SQL statement It is technically possible to host it elsewhere, but I wouldn't recommend it (there is no documentation).
  - googoloid 1y ago
    Your instructions say to go to https://app.dataramen.xyz/ https://app.dataramen.xyz/, which definitely isn't the locally hosted server. You might want to change that (and disclose if the local server makes data available to websites outside localhost, which the current instructions seem to imply)
    - oleksandr_dem 1y ago
      Yeah, the entire presentation is a mess, I should've worked more on this side. I see your concern about running it locally and then visiting a remotely hosted webapp. The way it works is that app.dataramen.xyz will call a localhost server (running on your machine, there is no remote code executed) to connect to the database. So all the data stay on your local machine, plus some webapp stuff stored in browser localstorage. I went for this setup for essentially 2 reasons: - I didn't want to ship webapp as part of the CLI tool due to the webapp size (it uses React, so the bundle is 800kb or so, while the entire local server code is 45kb). - In the long term I want the users being able to connect to multiple servers from one webapp. For example you may have a local server running to interact with your local DB, but at the same time you might have configured a remote self hosted server within your company VPN. It is a weird setup, but you end up doing weird things when you run an app on $0.00 budget
nikita2206 1y ago
A similar and bigger product I am aware of is Directus: https://directus.io/docs/getting-started/overview https://directus.io/docs/getting-started/overview
- oleksandr_dem 1y ago
  This looks closer to something like Retool (an internal tooling builder), but yes, there is an overlap on some features
deleted 1y ago
[deleted]
oleksandr_dem 1y ago
Hi guys, thanks for all the feedback. After reading all the comments, I can see there are two big issues here: - The code is not open-sourced, and some people don't trust running it locally - The landing page does not clearly show/explain what DataRamen is and how it works I should've seen it coming. I will take the following actions to tackle these problems: 1) Open-source the CLI code. There are no super sophisticated algorithms behind it, so no need to keep it private. 2) Improve the landing page with screens and videos to showcase its features. In addition to this, I will keep working on new features. I saw multiple comments mentioning SQLite support. Since it is possible to run SQLite directly in the browser, I might as well use it as a live demo where you can try the tool with a dummy DB without installing it locally (can't promise it, I have to see the feasibility of this project).
- quesera 1y ago
  Check out asciinema for easy creation of CLI demos. https://asciinema.org/ https://asciinema.org/
  - oleksandr_dem 1y ago
    I don't have much to showcase in the CLI department (in case of DataRamen CLI is just to start the local server), but the tool looks great.
adi_hn07 1y ago
[flagged]
- oleksandr_dem 1y ago
  Sure thing, I have to polish it a bit before getting any more exposure, once it is in a presentable state I will push it on Super Launch as well.
  - adi_hn07 1y ago
    Sure, thanks!!

48 points by oleksandr_dem 1y ago

mousetree 1y ago

Screenshots on the website would be very helpful. This sounds interesting, but would like to see what the actual UI is before setting anything up. It would also be good to link to the Github repo for the CLI part - I'm skeptical of giving an unknown tool access to my database without understanding what it's actually doing.

oleksandr_dem 1y ago
Totally understandable, your concerns are valid. I will have to figure out the CLI part, I would prefer to keep it private (at least for now), but I get it that people don't want to provide DB access to a completelly new tool. And yes, you're absolutely right about the lack of screenshots. I realize now how important that is for trust and clarity. I’m working on improving the landing page with proper visuals, and I’m also exploring the idea of a live demo using an in-browser SQLite DB — that should let people try it instantly without setup. It’ll take a bit of time, but it’s now high on the priority list. Appreciate the feedback!
- socks 1y ago
  is this chatgpt? your comments read like chatgpt output
  - yunohn 1y ago
    Honestly, that comment really does not seem very chatGPT-like.
    - socks 1y ago
      it screams it to me - wording such as "your concerns are valid", "yes, you're absolutely right..." and "I realize now how important...", and then usage of em-dash
      - BrandoElFollito 1y ago
        What is this obsession with the em-dash? For those who used LaTeX it is second nature, and a -- gets changed to an em-dash by a lot of editors or programs such as AutoHotkey
      - oleksandr_dem 1y ago
        As mentioned in another comment, I used ChatGPT to improve grammar and rewrite a bit my messages. I stopped using it since.
        snickerdoodle12 1y ago
        It's okay to be authentically you
        zeroq 1y ago
        Last time I was trying to be authentically me my response triggered a whole sub-thread about me using the word "subvention" and how funny Europeans sounds to Americans. ¯\_(ツ)_/¯

brap 1y ago

>GUI Not a single screenshot on the page

tiku 1y ago
Yeah I hate lacking screenshots but now I'm going to try it, so probably a good thing haha
oleksandr_dem 1y ago
You're absolutely right, I really dropped the ball on that. This is my first time launching a product like this, and I focused so much on building and writing the post that I overlooked the importance of visuals. The lack of screenshots is definitely hurting the presentation (and I can see it in the bounce rate). I'll prioritize getting some clear screenshots and maybe even a short demo video up soon. Thanks for pointing it out, appreciate the feedback.
- scoot 1y ago
  "Soon" being tomorrow, next week, next month? Just stating the obvious, but taking 30 minutes to do it now while you have traction on HN seems like a no-brainer.
  - oleksandr_dem 1y ago
    I did a lot of things wrong this time (I should've seen coming all the negative feedback I got). The lesson I learned is not rushing things. I will likely have to get a step back and to rethink some stuff (including landing page).

sunshine-o 1y ago

What a cool name !

oleksandr_dem 1y ago
Thanks! I was aiming for something fun and a little memorable — glad it landed well

koolba 1y ago

Where's the code? The NPM page says it is MIT licensed but I do not see any links to a source repo. I think most people would be wary of running random npm modules to which they will be giving database credentials and passing through their actual data.

oleksandr_dem 1y ago
You're right, and you're not the only one who's raised this, totally fair concern. As a developer myself, I get why running a CLI tool that touches your databases without access to the source is a hard sell. I hadn’t initially planned to open source it, but this feedback is making me seriously reconsider. At the very least, more transparency is clearly needed, and I’m thinking through the best way to approach that. Curious though, would you feel any more comfortable if it were a packaged desktop app (with no source) instead of a CLI? Or is open code the baseline no matter the form?
- koolba 1y ago
  There's a big difference between a precompiled app from a company you've possibly heard of (which exists as an entity and could be sued for creating something malicous) v.s. some random guy on the internet. I personally would not run an arbitrary binary from somebody I've never heard of on my local machine. And definitely not give it database credentials or access. I also think anybody that is willing to do so is insane. There's so much garbage and malware on npm, that something that is installed via the @latest on npm is arguably even worse. Even if it's fine now, there's no telling when one of its deps could be compromised too.
  - oleksandr_dem 1y ago
    I see your point. Since it's unlikely that I'll become a trusted entity anytime soon, open-sourcing it is probably the right thing to do to build some credibility.
  - giancarlostoro 1y ago
    Companies have to start somewhere though, lots of software exists that never was open source. I think he needs to get his tool in the hands of people who review dev tools.

gavinray 1y ago

I'd like to know what it looks like before investing my time in using a GUI tool. Neat idea on paper though!

oleksandr_dem 1y ago
Yes, a lot of people have complained about this, and I totally get it, I messed up the presentation part. Improving the landing page will likely be my top priority following this post.

kigiri 1y ago

You can find screenshots here: https://dev.to/9zemian5/tired-of-writing-sql-just-to-explore-your-db-me-too-so-i-built-this-5hjj https://dev.to/9zemian5/tired-of-writing-sql-just-to-explore... (might be outdated, didn't test the tool) On my part, I would like to see sqlite support and screenshots on the mainpage, also not a big fan of running an unknown command on my data. Since you run locally, any value of having the frontend loaded from a website instead of just opening it in localhost ?

oleksandr_dem 1y ago
Hi, yes, the dev.to post is a bit outdated. > I would like to see sqlite support Indeed, it is something I'm planing to add, but following all the feedback I got so far this will have to wait (landing page needs some work, plus a lot of people are having concerns regarding CLI tool not being open sourced) > any value of having the frontend loaded from a website instead of just opening it in localhost ? I want the CLI package to be as small as possible, and including 600kb React bundle in it is the exact oposite of small. Moreover, the idea in the future is for you to be able to connect to any host (be it cloud, localhost or selfhosted) from the same page (for example I have company self hosted server and a local server for my local databases).

cuuupid 1y ago

Sounds very nice but doesn't seem to support Node v22 :/ ``` Error [ERR_REQUIRE_ESM]: require() of ES Module /Users/cupid/.bun/install/global/node_modules/yargs/index.mjs not supported. ``` Is there a GitHub or similar where issues can be reported?

oleksandr_dem 1y ago
Not yet, but following the comments on this post I will likely open source the codebase. It will help to both improve trust in the product and provide a place to report issues publicly. This seems like a yargs compatibility issue (I kind of expected it to be problematic), I will probably switch to commander to handle CLI.

akoculu 1y ago

nice work + cool name, congrats!

747-8F 1y ago

Saving this; may prove its utility in enterprise BU analysis.

googoloid 1y ago

So this uses the local cli tool to allow your hosted code to connect to the db? Sounds a bit sketchy to me

oleksandr_dem 1y ago
It uses the CLI to connect to the database. When you start the tool, it creates a server on your localhost (localhost:4466), and acts as: - Local database: it stores some stuff locally, like saved queries or DB configurations - Query runner: when you run a query in the webapp it will call your localhost server, which will connect to the database and execute the SQL statement It is technically possible to host it elsewhere, but I wouldn't recommend it (there is no documentation).
- googoloid 1y ago
  Your instructions say to go to https://app.dataramen.xyz/ https://app.dataramen.xyz/, which definitely isn't the locally hosted server. You might want to change that (and disclose if the local server makes data available to websites outside localhost, which the current instructions seem to imply)
  - oleksandr_dem 1y ago
    Yeah, the entire presentation is a mess, I should've worked more on this side. I see your concern about running it locally and then visiting a remotely hosted webapp. The way it works is that app.dataramen.xyz will call a localhost server (running on your machine, there is no remote code executed) to connect to the database. So all the data stay on your local machine, plus some webapp stuff stored in browser localstorage. I went for this setup for essentially 2 reasons: - I didn't want to ship webapp as part of the CLI tool due to the webapp size (it uses React, so the bundle is 800kb or so, while the entire local server code is 45kb). - In the long term I want the users being able to connect to multiple servers from one webapp. For example you may have a local server running to interact with your local DB, but at the same time you might have configured a remote self hosted server within your company VPN. It is a weird setup, but you end up doing weird things when you run an app on $0.00 budget

nikita2206 1y ago

A similar and bigger product I am aware of is Directus: https://directus.io/docs/getting-started/overview https://directus.io/docs/getting-started/overview

oleksandr_dem 1y ago
This looks closer to something like Retool (an internal tooling builder), but yes, there is an overlap on some features

deleted 1y ago

[deleted]

oleksandr_dem 1y ago

Hi guys, thanks for all the feedback. After reading all the comments, I can see there are two big issues here: - The code is not open-sourced, and some people don't trust running it locally - The landing page does not clearly show/explain what DataRamen is and how it works I should've seen it coming. I will take the following actions to tackle these problems: 1) Open-source the CLI code. There are no super sophisticated algorithms behind it, so no need to keep it private. 2) Improve the landing page with screens and videos to showcase its features. In addition to this, I will keep working on new features. I saw multiple comments mentioning SQLite support. Since it is possible to run SQLite directly in the browser, I might as well use it as a live demo where you can try the tool with a dummy DB without installing it locally (can't promise it, I have to see the feasibility of this project).

quesera 1y ago
Check out asciinema for easy creation of CLI demos. https://asciinema.org/ https://asciinema.org/
- oleksandr_dem 1y ago
  I don't have much to showcase in the CLI department (in case of DataRamen CLI is just to start the local server), but the tool looks great.

adi_hn07 1y ago

[flagged]

oleksandr_dem 1y ago
Sure thing, I have to polish it a bit before getting any more exposure, once it is in a presentable state I will push it on Super Launch as well.
- adi_hn07 1y ago
  Sure, thanks!!