DEV Community

Cover image for Tired of Writing SQL Just to Explore Your DB? Me too. So I Built This.
Oleksandr Demian
Oleksandr Demian

Posted on • Edited on

Tired of Writing SQL Just to Explore Your DB? Me too. So I Built This.

#webdev #postgres #mysql #showdev

As a developer, I've spent way too much time writing throwaway SQL queries just to answer simple questions:

  • "What’s in this table again?"
  • "How many users signed up last week?"
  • "What foreign key links these two tables?"

There are some great database tools out there, but many of them feel either bloated, overly complex, or too cloud-focused for simple day-to-day work.

So I built something that fits how I want to work with databases.

Introducing: Data Ramen

Data Ramen is a lightweight, local-first GUI for exploring your PostgreSQL and MySQL databases.

Key Features

  • Connect to a local or remote DB (PostgreSQL or MySQL)

Connect to a local or remote DB

  • Browse tables, columns, and relationships without SQL. Contrary to many SQL editors, connection works both ways, not only from the table which contains the foreign key

Browse tables, columns, and relationships without SQL

  • Filter, sort, and join data through a point-and-click interface

Filter, sort, and join data through a point-and-click interface

  • Insert and edit rows in-place

Insert and edit rows in-place

  • Drop into raw SQL whenever you want

Drop into raw SQL whenever you want<br>

It’s built to be fast, focused, and doesn’t try to replace your existing tools, just makes common DB tasks a lot easier.

How to Try It

Data Ramen is still in beta, but you can try it today:

npm install -g @dataramen/cli
dataramen start
Enter fullscreen mode Exit fullscreen mode

Then open your browser at: app.dataramen.xyz. Runs entirely on your machine (local-first).

For more info, visit home page at dataramen.xyz.

I’d Love Feedback

This is still early. I’m testing ideas and figuring out what’s most useful.

If you’re working with SQL databases and want to try a different kind of GUI, I’d love for you to check it out.

Questions, bugs, thoughts, or "this is useless because X"? I’m here for it all, feel free to drop a comment

Top comments (0)