Contecting WP-website to a database with an API

Hello! Have you connected WordPress+Woocommerce with a database via API? Did they do it using a reliable plugin? And finally, when everything above was a success, in the Front-End, are the categories and tags from the database loaded to create search filters that simplify the UX? Thank you!