Ask HN: 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

cuffe · 3 years ago

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.

jjice · 3 years ago

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!

rnavi · 3 years ago

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)

fuckgoogleplay · 3 years ago

Thanks! Works great, not sure how I missed it the first time. Just one question - is it possible to not have it create its own tables in my database?

Damn I'm a moron. Had NC_DB set to something, it created its own tables. Then I was testing eleventy different options to get rid of the tables, but never deleted the tables created during the first run. Thanks again, NocoDB is awesome

realityloop · 3 years ago

SequelAce on macOS https://sequel-ace.com

vgeek · 3 years ago

Not sure on the Docker requirement, but Dbeaver is my go-to for importing and viewing data.

jstx1 · 3 years ago

The mysql CLI client?

sheunl · 3 years ago

Use HeidiSQL, It's free and easy to use.

nektro · 3 years ago

phpMyAdmin