Reset Katello db

Related to my previous post is there a way to reset the katello db without reinstalling the whole server?
I think my katello instance is fully stuck: troubles to sync repo, to publish content-view, etc…
Expected outcome:
Get back to a fontional installation
Foreman and Proxy versions:
Foreman and Proxy plugin versions:
foreman-tasks 6.0.1
Distribution and version:
CentOS Linux release 7.9.2009 (Core)
Other relevant data:

the katello:correct_repositories rake task list me 107 repositories when I only have 24 “real” repos configured ??

rake katello:reset will destroy all data in Pulp, Candlepin and your Foreman/Katello database.

Thanks for you reply Lucy!
Will it keep my Foreman data safe? (puppet configuration and reporting)

It wipes out all data in your databases.

Last question: will it also reset my puppet CA certificates ? :fearful:

No it will not reset puppet CA cert (unless you have it in the database).