How to manage WordPress database using the WP Data Access plugin

WP Data Access is a data administration and development plugin that lets you perform database-related tasks directly from your WordPress dashboard. It enables data management from the WordPress dashboard, including JSON configuration, the addition of custom JavaScript functions, the management of local and remote databases, the import and export of multiple formats, the query builder, data project management, and the creation and modification of tables and indexes.This article will show you how to install a WP Data Access Plugin on your WordPress-powered website.

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 Dashboard in 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:
   

   

More Information

For more information about the WP Data Access, please visit https://wordpress.org/plugins/wp-data-access/