# Managing WordPress database using the WP Data Access plugin

> Explore tables, run queries and import or export data in your WordPress database from the dashboard with the WP Data Access plugin.

Source: https://helpcenter.ruachost.com/wordpress/guides/managing-wordpress-database-using-the-wp-data-access-plugin/

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

1. **Log in to WordPress** with an administrator account.
2. In the dashboard, go to **Plugins → Add New**.
3. Search for **WP Data Access**.
4. Click **Install Now**, then **Activate**.
5. In the dashboard, go to **WP Data Access**.
6. 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.