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 query (filtered and ordered), insert, update, delete, export (SQL, Excel, CSV, XML and JSON) and import (SQL and CSV) data.
Data Designer
Design table and index structures (supports reverse engineering) and generate physical database tables (or table modifications) from design. Supports reconciliation.
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 publications and data management to web pages (Data Projects pages). Premium shortcodes available to generated AngularJS apps.
Role management
Supports WordPress roles integration 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. Imports SQL and CSV.
Unattended exports
Supports cron jobs for unattended data exports. Save export files locally or in your Dropbox account.
Geolocation support
Configure latitude and longitude columns to auto generate searchable maps from database tables using a static or the users position.
Local and remote database support
WP Data Access supports local and remote databases (with and without SSL) for all features. Developers can use WP Data Access libraries to connect to remote databases from their own PHP code as well.
Facts
PREMIUM FEATURES AND PRICING
The premium version of the plugin contains many additional features, like geolocation, Data Forms, ful-text search, inline editing, invidual column search, standard and custom publication buttons and much more…
TESTIMONIALS
WP Data Access makes me easy to show and manage MySQL's tables. — epbook —
I like this plugin because it can execute the queries that I need for my data to be displayed on our website. — Speransa —
This tool set offers features and methods familiar to those with database experience. We were able to set up significant data management in a short time. The progress on feature enhancement is very good. I look forward to expanding our utilization of this professional quality tool. — Mark —
WP Data Access is a simple yet powerful plugin which solves a problem I was trying to solve for months. It´s easy interface and excellent tutorials made me go through all my lacks of knowledge. Besides that, the service from Peter is awesome. I absolutely recommend. — Lucas —
This is excellent software and well worth paying for the Pro version. Support is top notch as well. — Steve —
I use it to edit/view custom tables/databases in the WordPress admin dashboard. — Michael —
Been looking for something like this for years. Great support from Peter! — Art —
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 —
Customers











