Hi,

There are few modules available in the Odoo app store for cleaning the database(removing data), you can try those modules to remove the existing data in the database.

1. Database Cleanup: https://apps.odoo.com/apps/modules/12.0/database_cleanup/

2. Odoo Customize: https://apps.odoo.com/apps/modules/13.0/app_odoo_customize/

3. Data Clear: https://apps.odoo.com/apps/modules/12.0/clear_data/

All are free modules and different versions are available. Also, have a look at this video: How to Clean the Database in Odoo After testing without lose of configuration

Thanks

Hi Suhaib,

There is an oca module named clear data where you can select models and delete the entire data.

Otherwise you can connect to your database in pstgresql and use this sql query

TRUNCATE public.relation_name CASCADE;

Hope it helps