WP Data Access

Description

WP Data Access is a powerful data administration, publication and development tool. An intuitive interface helps to create responsive tables and charts for back-end and front-end usage in just minutes. Highly customizable CRUD pages are generated on the fly. No programming skills required.

The plugin supports more complex features for advanced users, including remote database and file access, master-detail pages, lookups, inline editing, advanced search options, dynamic hyperlinks, WordPress media library integration, WordPress role management integration and many more. Programmers can also benefit from the WP Data Access API, which can be used to access remote databases and data files directly from their PHP code.

Data Tables

Use the Data Publisher to create professional data tables for back-end and front-end usage.

  • Global searching and sorting
  • Many static and interactive filters
  • Many ways of styling [demo]
  • Server-side processing (default)
  • Client-side processing [demo]
  • Export to CSV, Excel, PDF and SQL, Print and Copy buttons (PREMIUM) [demo]
  • Integrated geolocation search (PREMIUM) [demo]
  • Multiple advanced search options (PREMIUM)
  • Interactive Search Builder (PREMIUM) [demo]
  • Interactive Search Panes (PREMIUM) [demo]
  • Custom queries and custom post types (PREMIUM)

Data Apps

Use Data Projects to create data driven WordPress apps that can be executed on the back-end and front-end. Projects are highly customizable using templates.

  • Auto generated CRUD pages
  • Parent-child relationships
  • Lookups
  • Remote and local databases
  • WordPress role integration
  • WordPress media library integration
  • Accessible from the WordPress dashboard and public pages
  • DataForms – fully responsive apps for back-end and front-end (PREMIUM) [demo]
  • Inline editing (PREMIUM)
  • Full-text search (PREMIUM)
  • Multiple advanced search options (PREMIUM)

Data Management

The Data Explorer helps WordPress users to manage local and remote data and databases directly from the WordPress dashboard.

  • Manage local and remote data and databases
  • Global search and replace on multiple databases and tables
  • Import SQL and CSV files (supports ZIP for large import files)
  • Exports to SQL, CSV, JSON and XML (supports extremely large table exports)
  • Rename, copy, truncate, drop, optimize and alter tables
  • Change table and column settings (advanced search, geolocation, inline editing and more)
  • Enable WordPress Media Library integration for specific table columns
  • Enable inline editing for specific table columns (PREMIUM)
  • Multiple advanced search options (PREMIUM)

Query Builder

Execute SQL queries directly from the WordPress dashboard.

  • Work on multiple SQL queries simultaneously (using tabs)
  • Save and reuse queries (for publications and charts)
  • Protects WordPress table structures and data
  • Interactive Visual Query Builder for user with limited or no SQL knowledge (PREMIUM)

Geolocation search

Create a searchable geolocation map from a database table.

  • Google Maps integration (PREMIUM)
  • Supports seamless integration with Data Publisher tables (PREMIUM)
  • Define map settings per table (PREMIUM)
  • Dynamic marker layout configuration (PREMIUM)
  • Use static or user location (PREMIUM)
  • Search map within adjustable radius (PREMIUM) [demo]

Charts

Create charts from SQL queries. The Query Builder is available to manage and test your SQL queries.

  • Google Charts integration
  • Bar, column, line and pie charts, histograms, gauges and data tables are supported [demo]
  • The Visual Query Builder is a helpful premium feature for users with little or no SQL knowledge.

Dashboards and Widgets

Dashboards are designed for back-end usage. Widgets are highly customizable and can be shown on dashboards (back-end), webpages (front-end), and external websites.

  • Manage all your data in one location
  • Share your data widgets anywhere (PREMIUM)
  • Give specific users and user groups access to locked dashboards (PREMIUM)
  • Allow users to create their own dashboards (PREMIUM)

Data Designer

Create tables and indexes using an intuitive user interface.

  • Create tables and indexes
  • Modify tables and indexes
  • Supports reverse engineering and reconciliation

Plugin Settings

WP Data Access is highly customizable. Many detailed plugin settings are available to manage the plugin user interface and behavior.

Useful Links

Screenshots

Installation

(1) Upload the WP Data Access plugin to your blog
(2) Activate it
(3) Navigate to the WP Data Access menu

1, 2, 3 and you’re done!

Reviews

November 7, 2022
Fantastic plugin, it allows you to turn your WordPress site into an app factory. Incomparable, there is no such thing in the WordPress universe. The Premium version is packed with great features and the price is absolutely affordable. Last but not least, the support is stellar !! I recommend buying it. Bob
October 29, 2022
This plugin has allowed me to fix the Coupon management has moved! notice in WooCommerce that has driven me (and from the forums, many others) nuts for nearly two weeks!! This superb plugin allowed me to access my Wordpress database from Wordpress backend and locate the entry "wp_wc_admin_notes". Within there is "wc-admin-coupon-page-moved" (on last page for me) and I could change the setting "unactioned" to "actioned". Click submit and the issue has gone. Whoo hoo! Really recommend this plugin!
October 6, 2022
WP Data Access puts an easy-to-use “front end” on using a database in a Word Press site. I found it easy to configure and it works perfectly. FIVE STARS for sure!
October 1, 2022
I'm a classic dev starting in the years when a dev needed to be fluent in SQL as well as the code language(s) and tools for front ends, been coding the web since before it was called the web and so the fundamental of Wordpress (data munged into displays) is just 'duh.' But Wordpress itself has never been more than a quickie system because running real RDBMS database features alongside the WP core but in discreate data stores had been a pain. But recently I had a group that was most comfortable with Wordpress and wanted something "real" along with their blog posts and pages AND they didn't have time enough for a full new system. I looked at PeachPie and was very impressed for getting the advantages of .Net Core compiled code instead of script, but it's alpha level at best and while great on Azure the group doesn't have the money for Azure. So tested Participants and was very impressed at the ease of hooking data results - but the multi-table option is in need of updates for WP6x. That lead to Formidable but while it advertises with the term "RDBM", it isn't - it is very, very pretty but the relational limitation and no hooks for obfuscating the internal ids set it aside. Then... I spotted WPDA. Bad searching on my part, I had never seen it before. Ahhhh. It took a few days to get the muscle memory of the system and Peter was IMMEDIATE on answering my noob questions and my somewhat less noob questions. He speaks the language of an Oracle/Sql Server developer. A week after my test install, I bought the full pro package for unlimited sites. As the title of this review says, having a tool that lets me do what I think a website should be able to do while retaining the ease of the Wordpress blog-based core has changed my view of Wordpress itself. I am still keeping PeachPie on my back burner because - you know, COMPILED CORE CODE and full .Net Core abilities - but until that is ready for trusting for releases, WPDA is going to be a fundamental tool for projects for my Wordpress loving organizations.
Read all 66 reviews

Contributors & Developers

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

Contributors

“WP Data Access” has been translated into 1 locale. Thank you to the translators for their contributions.

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.