How to manage WordPress database using the WP Data Access plugin

Installing and configuring WP Data Access Plugin

To use WP Data Access Plugin in your WordPress website, follow these steps:

1. Log in to WordPress as the administrator.
2. On the Dashboardin the left sidebar, click Plugin, and then click Add New:
3. Search for “WP Data Access Plugin,” then click Install Now. Click Activate to activate the plugin:
   
4. On the Dashboard in the left sidebar, click WP Data Access.The Data Explorer section lists out the tables and allows you to add, delete, edit, export  these tables:
   
5. Query Builder section allows you to create, execute, and save queries in your database:
   
6. Data Designer allows you to add tables to your database, as well as their names, data types, and other details:
   
7. Data Project displays the projects and allows you to manage them via the dashboard:
   

Know more – How to stop WordPress from generating different image sizes without plugin