5 ms·
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
- jstx1 3y agoThe mysql CLI client?
- vgeek 3y agoNot sure on the Docker requirement, but Dbeaver is my go-to for importing and viewing data.
- cuffe 3y agoPM 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 https://retool.com/templates/mysql-admin-panel. You can get started self-hosting with docker here: https://retool.com/self-hosted/ 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 3y agoUse HeidiSQL, It's free and easy to use.
- realityloop 3y agoSequelAce on macOS https://sequel-ace.com https://sequel-ace.com
- nektro 3y agophpMyAdmin
- rnavi 3y agoNocoDB 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#connecting-to-external-database https://docs.nocodb.com/setup-and-usages/dashboard#connectin... (Founder here)
- fuckgoogleplay 3y agoThanks! 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?
- fuckgoogleplay 3y agoDamn 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
- jjice 3y agoDataGrip 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!