Adding bulk categories

I am in the same boat at times. I don’t know Ruby or Rails

The data for Discourse resides in a PostgreSQL database base. It seems you have root access so you just need to get root access in the Discourse container and then let your PostgreSQL knowledge be used. If you don’t know PostgreSQL then this won’t help either.

Also you can grab a backup copy of the database at the Discourse admin page, e.g.

https://<site>/admin/backups

and do some trial runs before doing it on a production site. Don’t forget to backup the production site just before doing the SQL update.

Don’t ask me for the SQL details as I have never done this either but if you are comfortable with SQL this gives you another option.

Yes I know others will totally disagree with this but it is your site and your call.