I would like to know how to bulk delete posts from a specific category using the WP-CLI, any tip?
This should delete all posts in your category:
wp post delete $(wp post list --cat=your_category_ID --format=ids)
wp db query [<your_sql_query>]
For more info:
wp post delete --help wp post list --help wp db query --help