WP Data Access

Description

WP Data Access is a powerful data administration, publication and development tool that allows you to perform database related tasks from your WordPress dashboard. An intuitive user interface helps to create fully responsive publications and data administration pages. No programming skills required!

For advanced users, the plugin support more complex features like remote database access, master-detail pages, lookups, WordPress role integration, WordPress user integration and a layer around your WordPress database which allows you to add database table and view specific functionality like dynamic hyperlinks and WordPress media library integration.

Data Explorer

Data and database administration

  • Manage local and remote databases
  • Database administration (rename, copy, drop, truncate…)
  • Data administration (search, insert, update, delete…)
  • Export to SQL, XML, JSON, CSV and Excel
  • Import SQL and CSV files
  • WordPress Media Library integration
  • Inline editing (PREMIUM)
  • Full-text search (PREMIUM)
  • Individual column search (PREMIUM)
  • Static hyperlinks
  • Dynamic hyperlinks

Query Builder

Execute SQL statements from your WordPress dashboard

  • Execute any SQL command (DCL, DDL, DML) – user must have the necessary privileges
  • Only available for admin users
  • Work on multiple SQL queries simultaneously (using tabs)
  • Allows to access local and remote databases
  • Queries can be saved and reused (saved per WordPress user account)
  • Protects WordPress table structures (no DROP, ALTER and TRUNCATE allowed – not configurable)
  • Protects WordPress table data (can be disabled for INSERT, UPDATE and DELETE)

Data Publisher

Publish responsive tables

  • Responsive HTML tables
  • Supports local and remote databases
  • WordPress Media Library integration
  • Static and dynamic hyperlink integration
  • Easy level: no coding skills required
  • Advanced level: JSON configuration
  • Expert level: add JavaScript functions
  • Export to CSV, Excel, PDF and SQL (PREMIUM)
  • Print publication (PREMIUM)
  • Copy publication to clipboard (PREMIUM)
  • Individual column search (PREMIUM)
  • Full-text search (PREMIUM)

Data Projects

Write your own WordPress apps

  • Supports local and remote databases
  • Auto generated CRUD pages
  • Auto generate parent-child pages
  • WordPress role integration
  • WordPress media library integration
  • Statis and dynamic hyperlink integration
  • Accessible from the WordPress dashboard
  • Add to webpage with shortcode wpdadiehard (FREE)
  • Add to webpage with shortcode wpdadataprojects (PREMIUM)
  • Add to webpage with shortcode wpdadataforms (PREMIUM)
  • Inline editing (PREMIUM)
  • Full-text search (PREMIUM)
  • Individual column search (PREMIUM)

Data Forms (PREMIUM)

State of the art responsive data apps

  • Turns a Data Project into a responsive data app
  • Uses jQuery DataTables to generate list tables
  • Uses AngularJS to generate data entry forms
  • Uses jQuery UI for styling

Geolocation (PREMIUM)

Turn your database table into searchable map

  • Use Google Maps key per table
  • Define map settings per table
  • Editing dynamic marker layout
  • Batch procedure to store latitude and longitude
  • Use static or user location
  • Shortcode to add map to web page (+parameters)
  • Search map within adjustable radius

Data Designer

Create tables and indexes

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

Plugin Settings

Manage plugin behaviour, style and security

  • Many detailed plugin settings
  • User access and permission
  • Integrated WordPress role management

Plugin 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

غشت 26, 2021
This plugin has everything you need to manage tables (wp and your own) and publish them. It allows you to pre-publish data under user role control and then to make it available on your website in different formats using shortcodes. We use it to manage a data which changes on a weekly basis (pickleball ladder tournaments). It is ideal for this project. Truly an environment which allows you to create an application without having to worry about re-inventing the wheel. No hesitation in recommending it to anyone willing to experiment and learn.
ماي 12, 2021
A great plugin served by a hyperactive and sympathetic author who listens to your needs! Clean and rigorous documentation and tutorials. A real academic job! WP Data Access is the only serious solution I have found to meet my need to set up a data management application under WP without coding. To be tested and used without moderation!`
ماي 11, 2021
Works perfectly. It really helped me out with database edits since my client's phpMyAdmin was inaccessible. Thanks again for an amazing plugin!
أبريل 29, 2021
Great for when people come to you with a wordpress problem but can't find their hosting logins.
أبريل 9, 2021
I have several large databases in MySql and wanted to access them using a WordPress plugin. I tried several (Ninja, WPDataTable, etc.) and they claimed to be able to utilize server side processing to speed up table access and even provided an SQL interface; I couldn't get them to work - still too slow. Then comes WP Data Access. As soon as I tried to WP Data Access, it worked and was fast. I can't be happier. In a 1 to 10 rating I give it 11. I purchased the premium as well. I will be having fun learning how to utilized all the options. It may not have all the coloring options as some other plugins have but its functions and options are so much better. I'm glad I discovered this plugin.
Read all 43 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.