WP Data Access


Manage local and remote data and databases from the WordPress dashboard. Publish local and remote data on web pages.
Write data driven WordPress apps that run in the WordPress dashboard or on web pages without any programming skills.
Build data entry forms that support CRUD as well as parent-child functionality.


WordPress Dashboard

Perform database administration tasks like create, alter, drop, rename, copy, truncate, insert, update, delete, export and import directly from the WordPress dashboard.

Perform data administration tasks like search, insert, update and delete actions directly from the WordPress dashboard.

Use the Data Projects tool to allow your WordPress users to enter data through your own data driven WordPress apps.

Use the Data Publisher to publish database tables on your website. Supports CSS styling as well as pagination, searching and sorting functionality.

Supports local as well as remote database connections.

Data Explorer

  • Create and alter tables and indexes
  • Drop tables, views and indexes
  • Rename tables and views
  • Copy tables
  • Truncate tables
  • Optimize tables
  • View table, view and index structures
  • Explore tables and views
  • Export tables (full table export as well as data selections) (SQL, XML, JSON, Excel, CSV)
  • Export view data to XML, JSON, Excel and CSV
  • Import tables
  • Edit table data (through data entry forms)
  • Delete table data (selections)

Data Designer

  • Reverse engineer tables and indexes
  • Design tables and indexes
  • Create tables and indexes from design
  • Alter tables and indexes from design
  • Generate create table and index scripts

Data Projects

  • Create data driven WordPress apps running in the WordPress dashboard
  • Create WordPress dashboard menus and menu-items
  • Add table based data entry forms to WordPress apps
  • Add parent-child forms to WordPress apps
  • Add static pages to WordPress apps
  • Configure and style table lists, data entry forms and parent-child forms
  • Add role based access control to WordPress apps

Data Publisher

  • Create interactive HTML tables
  • Supports searching, pagination and sorting
  • Generate publication shortcodes
  • Test publication shortcodes
  • Copy publication shortcodes (paste into editor)

Data Menus

  • Add list tables and data entry forms to your own WordPress dashboard menus

Data Backup

  • Create data backup jobs that run unattended in the background
  • Create adhoc data backups that run unattended in the background
  • Allows to create multiple data backup jobs
  • Select the tables to be backed up
  • Save backup files on local or Dropbox folder
  • Run data backups at specified intervals
  • Define the number of backup files te be kept

Manage Plugin

  • Manage plugin behaviour, style and security

WordPress Website

Data Publisher

Publish database tables on your website using shortcodes. Shortcodes can be generated with the Data Publisher or defined manually. Tables are dynamically build using jQuery DataTables. Multiple layouts supported. Allows styling with CSS. Provides pagination, searching and sorting functionality.

Data Explorer

Data Explorer table pages can be added to web pages using shortcodes. This allows you to add data management for specific database tables to your web pages. Allow users to search, view, add, edit, delete, import and export with shortcode parameters.

Use WP Data Access classes in your own PHP code

  • Generate list tables based on the WP_List_Table class to support standard WordPress list table layout and user interaction
  • Write your own code from WP Data Access classes
  • Add menus for generated list tables to your WordPress dashboard, plugin or theme

Plugin Links


Documentation is available from the plugins menu (WP Data Access > Plugin Help).



(1) Upload the WP Data Access plugin to your blog, (2) activate it and (3) navigate to the WP Data Access menu.
1, 2, 3 and you’re done!


February 14, 2020
Nice work, keep it up and add other DB type (SQL Server/Azure) into the mix! Best CRUD Plugin (Free and Paid) I have tested and i have tested almost all. Even thinking of switching few of my existing paid tools to this plugin.
January 18, 2020
Great Plugin, nice support and continuous updates. 🙂
January 16, 2020
Thank you for sharing your work. I was looking for a friendly way to connect to some other plugin's custom database tables and show subsets of data to users in WP admin when I came across this powerful tool. As a non-dev, I was able to do what I needed, and could (will…) do even more, as I just started to grasp the reach of WP Data Access. Tutorials are very thorough and support seems to be top notch. One can see that there is a lot of dedication to this project. Congratulations.
November 10, 2019
I reviewed some other free plugin's to manage and display your own (database) data. This is the best I have seen. I is both easy to manage your database tables and relations, the content of the tables and display the data on your wordpress site!
October 21, 2019
I was looking for such a plugin. Very good support
Read all 14 reviews

Contributors & Developers

“WP Data Access” is open source software. The following people have contributed to this plugin.


Translate “WP Data Access” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.