Spreadsheet-like frontend to read database (airtable, nocodb,
dynobase, mongodb compass)
reddit / selfhosted

----------------------------------------------------------------------
gebbissimo · 2023-10-07 11:03

I'd like our internal users to easily explore our PostgreSQL or
MongoDB databases with some filtering and groupby features, maybe even
custom SQL queries.

The desired solution should...

- ... be web-based (not desktop-tools like dynobase, mongodb compass)
- ... provide easy filtering and grouping
- ... feature database reading (CRUD is really not required like in
airtable or nocodb)
- ... support SQL and noSQL databases (nocodb only supports SQL AFAIK)

I thought such a tool should be pretty straightforward and definitely
exist already but so I couldn't find anything?!

----------------------------------------------------------------------
autisticit · 2023-10-07 12:25

Adminer?

----------------------------------------------------------------------
dazchad · 2023-10-07 15:06

There are a few tools for that. Depends mostly on how advanced you
want the UI to be.

You may want to browse the awesome-selfhosted repo:
https://github.com/awesome-selfhosted/awesome-selfhosted#database-
management and see if there's something that catches your eyes. I
don't think that list is exhaustive, but ought to have something for
you.

----------------------------------------------------------------------
inrego · 2023-10-07 16:38

CloudBeaver?
It's not free if you want to use it with noDB databases like Mongo,
though

----------------------------------------------------------------------
Interesting_Toe_5482 · 2023-10-07 18:18

Metabase is worth a look.

----------------------------------------------------------------------
Open_Resolution_1969 · 2023-10-07 18:29

Metabase is the thing you are looking for

----------------------------------------------------------------------
SigmaSixShooter · 2023-10-07 21:20

Budibase?

----------------------------------------------------------------------
gebbissimo · 2023-10-07 21:26

thanks, this looks super promising and even ticks some of the optional
features!