# Adding bulk categories

**URL:** <https://meta.discourse.org/t/adding-bulk-categories/161823>\
**Category:** Product Support\
**Created:** [August 23, 2020, 1:52pm UTC](https://meta.discourse.org/t/adding-bulk-categories/161823 "2020-08-23T13:52:31Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![EricGT](https://avatars.discourse-cdn.com/v4/letter/e/f1d935/32.png) [@EricGT](https://meta.discourse.org/u/EricGT)\
**Post date:** [August 23, 2020, 4:35pm UTC](https://meta.discourse.org/t/adding-bulk-categories/161823/5 "2020-08-23T16:35:43Z")

</div>

> [@SpaceIgniter](#):
>
> Would I need to install rails and do the process?  
> Or do I need to use something specific to do it on the API?
> 
> I’ve never worked on an API before. It’s actually really confusing to me.

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.

---

_[View the full topic](https://meta.discourse.org/t/adding-bulk-categories/161823)._
