WP Data Access

WP Data Access is a WordPress plugin that gives you access to any database table

Author:Passionate Programmer Peter (profile at wordpress.org)
WordPress version required:
WordPress version tested:6.9
Plugin version:5.5.63
Added to WordPress repository:22-12-2017
Last updated:03-12-2025
Rating, %:98
Rated by:86
Plugin URI:https://wpdataaccess.com/
Total downloads:708 050
Active installs:10 000+
plugin download
Click to start download

WP Data Access transforms your WordPress site into a platform for building data-driven applications — without writing a single line of code.

With the intuitive App Builder, you can create:

  • Interactive Data Tables – manage and display data with ease
  • Custom Data Forms – collect and process input seamlessly
  • Charts & Maps – visualize data beautifully
  • Role-Based Access – control who can view or manage apps
  • Multilingual Support – 35+ languages ready to use

WP Data Access is designed as a true no-code builder: everything works out of the box, intuitive and effortless. For those who want more, a full set of developer hooks makes it possible to fine-tune behavior, extend functionality, or integrate with custom workflows. Hooks are completely optional and invisible to no-code users, but a powerful bonus for developers.

App Builder ❤️

The ultimate data-driven Rapid Application Development tool. Build dynamic, interactive apps in minutes with Builders, Managers, and Wizards — all fully customizable with Hooks.

  • Table Builder – Create powerful, interactive data tables effortlessly
    • Add static and dynamic data table filtering options ????
    • Real-time computed fields and aggregations for instant insights ????
    • A Lookup Wizard to add lookups to your data table ????
    • Inline editing for instant updates ????
    • Integrates with the WordPress media library for rich content ????????
    • Export data tables to PDF, CSV, JSON, XML, SQL, and Excel ????
    • Add charts and maps to your data table header and footer ????
    • JavaScript hooks to customize data table layout and behavior ????
  • Form Builder – Design forms that adapt to your workflow
    • Grid-based layouts for precise control ➕➖
    • Master-detail relationships for multi-level data structures ????
    • Lookup and Computed Field Wizards to add functionality instantly ????
    • Interactive client-side validations tied to your database constraints ✅
    • Full access to the WordPress media library ????????
    • JavaScript hooks to customize business rules, validations and layout ????
  • Chart Builder – Transform your data into visual insights
    • Google Charts integration ????
    • Create charts from SQL queries ????
    • Interactively adjustable chart configurations ✔
    • Print/export charts ????????
  • Map Builder – Visualize your data geographically
    • Google Maps integration for location-based apps ????
    • Query-driven location visualizations ????
    • Interactively adjustable search radius ????
    • Customizable marker content and layout ????
  • Theme Builder – Make your app truly yours
    • Personalize your app’s appearance with ease ????
  • App Manager – Control your apps with confidence
    • Authorization management based on WordPress user and role principles ????
    • Add apps to back-end menus or front-end pages via shortcodes ????????
    • Safe mode to temporarily disable hooks without breaking functionality ????
  • Why App Builder?
    • Build dynamic, data-driven apps for both front-end and back-end ????
    • Connect to local and remote databases ⚡
    • Real-time build and run capabilities ????
    • Run apps in 35+ languages to reach a global audience ????

SQL Query Builder

Run and schedule SQL queries effortlessly from your WordPress dashboard.

  • Schedule queries to run automatically at defined intervals ????
  • Run batch jobs for automated data exchange across multiple databases ????
  • AI Assistant to generate queries and fix common errors ????
  • Tabbed interface for running multiple queries in parallel ▶
  • Save and reuse queries – privately or globally ????
  • Built-in safeguards to protect core WordPress tables and ensure data integrity ????
  • Visual Query Builder to create complex queries without writing SQL ????

Data Explorer

Take full control of your data with a GUI-driven interface.

  • Manage local and remote data ????
  • Perform global search and replace across multiple databases and tables ????
  • Import SQL and CSV files, with ZIP support for handling large datasets ????
  • Export data in various formats, including SQL, CSV, JSON, and XML ????
  • Rename, copy, truncate, drop, optimize, or alter tables ????
  • Advanced table and column options, such as geolocation, and enhanced search ✔

Premium Data Services

Connect, sync, and manage remote databases and data files.

  • Compatible with all plugin features ✅
  • Premium Remote Connection Wizard ????
    • Remote Databases: Connect to SQL Server, Oracle, PostgreSQL, MariaDB, MySQL, and MS Access (file-based) ????
    • Remote Data Files: Sync with CSV, JSON, and XML files for dynamic updates (e.g., Google Sheets sync) ????

Legacy Tools

Will be replaced by the App Builder.

  • Available until at least december 2026 ????
  • Featuring
    • Data Tables ???? – Can be replaced with Data Table app.
    • Data Forms ✅ – Can be replaced with Data Management app or Registration Form.
    • Maps ???? – Can be replaced with Map app.
    • Charts ???? – Can be replaced with Chart app.
    • Dashboards ????️
  • Use to maintain old solutions ????
  • Use App Builder for new projects ????

Dashboards and Widgets

Customizable widgets for dashboards (back-end), webpages (front-end), and external websites. (functionality will be moved to App Builder)

  • Centralized data management
  • Share data widgets anywhere
  • Give specific users and user groups access to locked dashboards
  • Support for user-created dashboards

Useful Links

Screenshots
ChangeLog