WP Data Access – App Builder for Tables, Forms, Dashboards, Charts & Maps

By Passionate Programmer Peter

★ 4.9/5 (88 ratings)10,000+ active installationsVersion 5.5.93

Turn your data into WordPress apps. No code required. Tables, forms, dashboards, charts, maps, optional hooks for developers, 35+ languages.

Description

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
  • Dashboards, Charts & Maps – visualize data beautifully
  • Role-Based Access – control who can view or manage your data
  • 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.
* 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 🌍

  • 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 📌
  • Dashboard Builder – Centralize insights with customizable widgets
    • Combine all app types into cohesive dashboards ✅
    • Customize dashboard layouts with flexible positioning and sizing ➕➖
    • Customizable widgets presenting dynamic and static data
    • Mix real-time data with fixed information for comprehensive overviews 📊
  • 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 🔧

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.

  • Featuring
    • Data Tables 🔍 – Replace with Data Table app.
    • Data Forms ✅ – Replace with Data Management app or Registration Form.
    • Maps 🌎 – Replace with Map app.
    • Charts 📊 – Replace with Chart app.
    • Dashboards 🎛️ – Replace with Dashboard app.
  • Use to maintain old solutions 🙏
  • Use App Builder for new projects 🚀
  • You can continue to use the legacy tools by staying on the latest Version 5.x (Read more →)

Useful Links

Installation

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

And you’re all set! 🚀

Screenshots

Changelog

5.5.93

  • Released 2026-11-12
  • Fixed: Apply environment variable to default where only
  • Fixed: Generated value not escaped properly
  • Fixed: Dashboard remembers last activated user mode
  • Fixed: Modal not draggable
  • Fixed: State changed when selecting maps menu in Table Builder
  • Fixed: Dynamic hyperlinks no longer shown in legacy data tables
  • Fixed: Text overflow in editor
  • Improved editor user interface

5.5.92

  • Released 2026-11-06
  • Added: Option to disable WHERE clause check on insert
  • Fixed: Table drop-down list stopped working

5.5.91

  • Released 2026-11-05
  • Fixed: Data Designer missing nonce validation
  • Fixed: Reconcile not processing null values correctly
  • Fixed: Content not properly escaped
  • Fixed: Prepare environment var substitutions
  • Fixed: Verify engine and collation in Dat Designer
  • Fixed: Insert fails when default where is defined

5.5.90

  • Released 2026-10-28
  • Added: Custom logo to PDF table export
  • Fixed: Checkbox clickable area too small
  • Fixed: Invalid row count with row count estimation enabled
  • Fixed: Column filter state not restored correctly
  • Fixed: Function wp_get_schedules() loaded too early
  • Fixed: Numeric values exported as string in export to Excel
  • Fixed: Make wpdadiehard compatible with WordPress 7.2
  • Fixed: Generated values not properly escaped
  • Fixed: Enforce default WHERE clause on transactions
  • Removed legacy tool activation and deactivation

5.5.89

  • Released 2026-10-21
  • Replaced secure documents alert with standard notification
  • Removed old restrict table management options
  • Added: Predefined PDF configuration for data tables
  • Added: Warning shown in App Manager for anonymous data entry configuration
  • Added: Allow order by in lookup
  • Added: Custom events to charts
  • Fixed: Cannot save relation table lookup
  • Fixed: Default where clause overruled
  • Fixed: Button label CSS
  • Fixed: Missing column ID
  • Fixed: Download file link displayed if document is null
  • Patch: Global filter in Data Explorer not working

5.5.88

  • Released 2026-10-14
  • Fixed: Map no longer scrolls
  • Fixed: Unauthorized remote database test usage
  • Updated freemius SDK

5.5.87

  • Released 2026-10-08
  • Added: Images and hyperlinks to PDF export
  • Fixed: Wrong hover column after disabling card view
  • Fixed: Aggregation label translations in PDF export

5.5.86

  • Released 2026-10-01
  • Restructured tool guide page
  • Removed unused code
  • Added: Affiliates program
  • Fixed: Bulk actions drow-down height
  • Fixed: Mobile dashboard menu
  • Fixed: Export to PDF and Excel missing values
  • Fixed: Rendered value missing in detail panel hook

5.5.85

  • Released 2026-09-23
  • Removed unused code
  • Added: Exclude columns from export
  • Added: Aggregation translations
  • Fixed: Default values not applied to M:M relationships
  • Fixed: Enum and set drop-down height
  • Fixed: Removed column still available for export
  • Fixed: Access parameter validation
  • Fixed: Cannot open hooks menu for relation table

5.5.84

  • Released 2026-09-17
  • Restructured table column renderer
  • Removed unsed code
  • Added: Column pinning to data tables
  • Added: Rename database to app menu
  • Added: Class name to lookup popup
  • Added: Data label to lookup items
  • Added: Show hidden columns on tablets and mobiles
  • Fixed: setColumnStyle on lookup columns
  • Fixed: Map markers not working in Data Table and Data Admin apps
  • Fixed: Scheduled tasks deleted on version update

5.5.83

  • Released 2026-09-09
  • Added: Default column name based class names to form fields
  • Removed old Query Builder
  • Removed import from legacy list table
  • Fixed: Query Builder fails rebuilding multiple tabs
  • Fixed: WPDAVAR not working in Query Builder
  • Fixed: Chart legend position top wrapped
  • Fixed: Initial “skip relation table pre-search step” setting not processed correctly
  • Fixed: Auto increment column value missing in insert m:m relationship
  • Fixed: Custom classes not applied in forms
  • Fixed: App not correct exported when regexp is used in a hook
  • Fixed: Confirm dialog alignment
  • Fixed: Unicode characters not imported correct on app transfer
  • Fixed: Lookup value not synchronized on update with client side processing enabled
  • Fixed: Cannot zoom in|out in maps
  • Fixed: Null values added to unselected columns on insert
  • Fixed: CSS Form Editor help link
  • Fixed: Shortcode parameter vulnerability in legacy data tables

5.5.82

  • Released 2026-08-26
  • Added: App context to computed form fields
  • Added: Localize WordPress standard date format
  • Added: Skip relation table pre-search step
  • Changed: Query Builder tab styling
  • Fixed: Class name not added to computed field
  • Fixed: Disable media action buttons for anonymous users
  • Fixed: Media library not launched in fullscreen mode
  • Fixed: Removed unused columns from response
  • Fixed: Reevaluation of already substituted placeholders
  • Fixed: Table settings crash when changing media to secure document
  • Fixed: Theme font size does not size table cells
  • Fixed: Media columns missing class names
  • Fixed: Dynamic lookup over multiple columns not populated in insert mode
  • Fixed: Query not scheduled
  • Fixed: Numeric columns labels not processed correctly in Query Builder
  • Fixed: Numeric columns labels not processed correctly in charts
  • Fixed: Inline editing global save not working

5.5.81

  • Released 2026-08-18
  • Removed old Data Explorer
  • Changed global search & replace
  • Changed tool guide page
  • Added: Secure document storage
  • Added: Form separators with title feature
  • Added: CSS Form Editor
  • Added: Data Explorer documentation
  • Fixed: Allow admins only to configure lookups
  • Fixed: Check authorization for wildcard exports
  • Fixed: Database administration page shows invalid database list
  • Fixed: Missing scale in hint
  • Fixed: Reevaluation of already substituted placeholders
  • Fixed: Cannot add new table design
  • Fixed: Scheduled query not correctly returning rows affected

5.5.80

  • Released 2026-08-06
  • Added: Progressive web apps
  • Fixed: Escaped titles and links in table output and shortcode
  • Fixed: Hide inline editing feature when update is not allowed
  • Fixed: Table incorrectly styled after abandoning card view

5.5.79

  • Released 2026-07-29
  • Added: Legacy tools message (widget and notice)
  • Added: Network errors to app messages for improved troubleshooting
  • Fixed: Cannot disable global filter for columns with client-side processing
  • Fixed: Client-side cascading column filter count
  • Fixed: Styling issues with column filter popup
  • Fixed: Client-side drop-down column filters not showing alternative values
  • Fixed: Clicking the create table design icon returns unauthorized
  • Fixed: Button style overwritten by theme CSS
  • Extended nonce action (Farid)

5.5.77

  • Released 2026-07-17
  • Added: Gutenberg block support for [wpda_app] shortcode
  • Added: Display multiple cards per row
  • Added: Missing parameters for shortcode generation
  • Added: Check for unsaved changes in Visual Query Builder on close
  • Changed: Inline editing now requires update enabled (use option “hide edit icon”)
  • Changed: Cascading column filter behavior
  • Fixed: Cascading column filters with client-side processing
  • Fixed: CSV import button icons alignment
  • Fixed: Lazy loaded lookups not rerendering when open
  • Fixed: Visual Query conversion
  • Fixed: Visual Query Builder column row layout
  • Fixed: Visual Query Builder alias not editable
  • Fixed: Visual Query Builder missing plus icon button
  • CSS Table Editor now available to free users
  • Added css class pp-table-detail-panel-container to detail panel
  • Code review
  • Extended nonce action
  • Updated freemius SDK

5.5.76

  • Released 2026-07-07
  • Added: Extended pagination button support for all data tables
  • Fixed: Column filter popup should only count rows with client-side processing enabled
  • Fixed: Update fails after navigating to other row for 1:1 relationships
  • Fixed: Last pagination button missing
  • Fixed: Search list not updated
  • Fixed: Cross-Site Scripting (XSS) vulnerability – patchstack
  • Fixed: Function setColumnStyle has no effect on first column
  • Fixed: Cascade drop-down lists not taking global filter into account with client-side processing enabled
  • Fixed: Cannot position column filters above
  • Updated freemius SDK

5.5.75

  • Released 2026-06-25
  • Added: New Visual Query Builder
  • Added: Column filters popup positioning
  • Added: Class names to action buttons
  • Updated freemius SDK

5.5.74

  • Released 2026-05-21
  • Fixed: Expand column filters on startup not available for POPUPs
  • Fixed: Must manually enable “show column filters in compact mode” for POPUPs
  • Fixed: Border between column filters on left to fat

5.5.73

  • Released 2026-05-19
  • Added: Feedback to compact column filter buttons
  • Added: Show column filters in popup
  • Added: Single-select search panes
  • Added: Selectable plus|min icons for numeric fields
  • Added: Disable plus|min icons for numeric fields
  • Improved column filters UI
  • Improved bulk actions UI
  • Optimized column filter handling
  • Fixed: Cannot start table with docked chart in fullscreen mode
  • Fixed: Search fields containing two clear icon buttons
  • Fixed: Highlighting fails for wildcards
  • Fixed: Dynamic conditions not available after lookup update
  • Fixed: Default column search fails if URL parameter does not exist
  • Fixed: Dynamic lookup fails with unequal column names
  • Fixed: Column filters not consistently working with async lookups
  • Fixed: Cascading search for search boxes

5.5.72

  • Released 2026-05-04
  • Added: Clear all column filters button to compact vertically placed column filters container
  • Added: Automatically open column filter list when user opens a column filter in compact mode
  • Added: Multiple calculation types to table chart
  • Added: Start app on back-end in fullscreen mode
  • Added: Default column filter via URL parameter
  • Added: Plus and minus buttons to numeric input fields
  • Added: Subtitles to row actions
  • Added: Rename translation
  • Fixed: Column filters interfering on tabs
  • Fixed: Actions column too wide when bulk actions enabled and row actions disabled
  • Fixed: Removed disabled fields from chart popup (free version only)
  • Fixed: Resize chart when popup is resized (free version only)
  • Fixed: Match map and chart popup UIs (free version only)
  • Fixed: Chart returns an error when no data found
  • Fixed: Rows not exporting the correct rows when selected with Bulk Select after filtering
  • Fixed: Table not sorted correctly on lookup column when server-side processing is enabled
  • Fixed: Removed “number of decimals displayed” if field has no decimals
  • Fixed: Scheduled queries don’t send out attachments if queries are written in uppercase

< 5.5.72

  • See changelog.txt