Show HN: DataRamen, navigate your DB without a single line of SQL (no AI)
DataRamen is designed to simplify and make it more accessible navigating your database by removing SQL and replacing it with UI to query, join and jump from one record to another. The core idea was to make it feel like you are using a spreadsheet, but with live data in your DB (currently supports MySQL and Postgres).
Smart anchors let you move from one record to another with a simple click. Most of the current SQL clients have this feature but it usually works just one way: it allows you to open referenced records, but not vice versa. DataRamen goes further by allowing you to navigate both ways.
Let's say you have a table User, and each user can have multiple Document (Document.userId references User.id). Classic SQL clients allow you to go from Document to User, but DataRamen allows you to go from User to Document as well (multiple documents in this case).
Besides what is described above, it supports all the basics necessary to access your data: - Filters: both plain text and SQL if needed. - Joins: it automatically suggest what tables can be joined and on what column - Ordering and pagination. - Aggregations: this part still needs some UX improvements, but it works. - Multiple databases connected at once. - Self hosting: deploy it once on your infrastructure and let your team use it via web interface (no more sharing credentials or everyone configuring DB for itself). - Queries history and saved queries.
For full disclosure, this is the second time I'm posting about DataRamen. The first one was 9 months ago and it did receive a lot of criticism for not being open sourced and not having a landing page (landing page was just an installation process). Both things I've addressed since, plus a huge amount of UX rework, documentation and stability improvements. The landing page is still rough, but at least it should be clear now what it does and how it works.
Find more information on https://dataramen.xyz/.