TESTIMONIALS
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! — Martin —
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. — Alvaro —
Great Plugin, nice support and continuous updates. — Marcel —
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. — Sadi —
Peter you are an absolute genius! I can’t tell you how excited I am to have found this plugin. It works like a charm. Thank you for all the work you’ve put into it and for sharing it. I can’t wait to see what will be included in future releases. — Mel —
The only one in the market right now! Thank you so much Peter — Tim —
This plugin is great. Can be a bit hard to figure out intuitively, but the videos and docs are great. I wanted a way to update a few tables from the WP admin interface – tired of going into phpMyAdmin and wanted non techie admins to be able to update data. This worked out perfect. Support is awesome. The developer is really on top of things and answers questions quickly. — Mike —
Plugin Features
Database administration
Available from the WordPress dashboard – TABLES (create, alter, drop, truncate, copy, rename, optimize, export, import), VIEWS (rename, drop) and INDEXES (create, alter, drop)
Data administration
Generates data entry forms and native WordPress list tables on the fly. Supports view (filtered and ordered), insert, update, delete, export (SQL, Excel, CSV, XML and JSON) and import (SQL) data.
Data Designer
Design table and index structures (supports reverse engineering) and generate physical database tables (or table modifications) from design.
Data Publisher
Uses jQuery DataTable to show interactive HTML tables on web pages. No programming skills required for basic usage. Requires JSON and/or JavaScript knowledge for advanced jQuery DataTable options.
Data Projects
Allow your users to work with data driven apps directly from the WordPress dashboard (also available for web pages through shortcodes).
Shortcode support
Use shortcodes to add data management to web pages (Data Projects pages).
Role management
Use WordPress roles to manage user access and filter table data.
Media library integration
Call the WordPress media library directly from your WordPress app (full integration with the Data Publisher and Data Projects).
Execute SQL script files
Execute SQL script files directly from the WordPress dashboard.
Data export and import
Uses streams to support large export and import files. Supports full table exports as well as specific (selected) rows exports. Exports to SQL, XML, JSON, CSV and Excel.
Unattended exports
Supports cron jobs for unattended data exports. Save export files locally or in your Dropbox account.