HACKER Q&A
📣 fuckgoogleplay

Simple MySQL admin tool that can import CSV?


Hi. I'm basically looking for Adminer for MySQL, which looks and feels more modern and can run from Docker (which is why phpmyadmin doesn't fit). Don't need schema, just need to be able to add/edit/delete rows, and import them from CSV.

I've tried:

* Get Motor Admin: No CSV import

* Busibase: This one is the best of what I've tried. But when there is any issue with the CSV it just gives you a generic "Something went wrong", and you have to fish for the actual reason in dev console, which isn't very user-friendly.

* Nocodb: Doesn't connect to an existing DB

* Directus: Doesn't connect to an existing DB

* AppSmith: Doesn't import CSV

* OpenBlocks: Doesn't import CSV

There's definitely 2-3 more that I forgot about and I'm a bit of a mess rn after trying this for the entire day so the issues I've specified might be a little off. But I could not find a simple tool, that looks reasonably modern, where I can just tell it where my MySQL DB is, have it display tables, have it import stuff from a CSV, have it run in Docker. Is there anything out there? Thanks

  👤 jstx1 Accepted Answer ✓
The mysql CLI client?
👤 vgeek
Not sure on the Docker requirement, but Dbeaver is my go-to for importing and viewing data.
👤 cuffe
PM at Retool here. Built this template that should have most of what you need for the MySQL admin panel: https://retool.com/templates/mysql-admin-panel. You can get started self-hosting with docker here: https://retool.com/self-hosted/. We have a CSV upload component but let me know if you get stuck and happy to help answer questions here or jamie at retool dot com.
👤 sheunl
Use HeidiSQL, It's free and easy to use.
👤 realityloop
SequelAce on macOS https://sequel-ace.com
👤 nektro
phpMyAdmin
👤 rnavi
NocoDB does connect to external database - below is how you do it. And it does allow to import csv.

https://docs.nocodb.com/setup-and-usages/dashboard#connectin...

(Founder here)

👤 jjice
DataGrip can do this. Used it for a lot of CSV imports about four years ago. It had a lot of customization on the import. If you don't want to pay for it you can use the free trial. I moved away from it for years but came crawling back. DataGrip has just been the best SQL client I've used.

If you can work around requiring docker this will work. If you're hosting this and need users to dump the CSV, then I may have wasted your time. Sorry!