The WP Data Access plugin allows you to manage and interact with your WordPress database directly from the dashboard. It provides tools for exploring tables, running queries, importing/exporting data, and designing database structures. On ruachost.com, this plugin is supported and can be installed easily.
Why Use WP Data Access?
-
Manage database tables without needing phpMyAdmin.
-
Create, edit, and delete records directly from WordPress.
-
Run SQL queries safely from the dashboard.
-
Import/export data in multiple formats (CSV, JSON, SQL).
-
Design and modify tables with a visual interface.
Steps to Install and Configure WP Data Access
-
Log in to WordPress with an administrator account.
-
In the dashboard, go to Plugins → Add New.
-
Search for WP Data Access.
-
Click Install Now, then Activate.
-
In the dashboard, go to WP Data Access.
-
Explore the available sections:
-
Data Explorer → Browse, add, edit, delete, and export tables.
-
Query Builder → Create, execute, and save SQL queries.
-
Data Designer → Add new tables, define columns, and set data types.
-
Data Projects → Manage grouped database projects for easier organization.
-
✅ You can now manage your WordPress database directly from the admin panel.
Important Notes
-
Always back up your database before making changes.
-
Use caution when running SQL queries, incorrect queries can break your site.
-
Limit access to trusted administrators only.
-
For large imports/exports, ensure your hosting plan supports sufficient resources.
