WP Data Access – WordPress App, Table and Form Builder plugin

Our data-driven App Builder includes an intuitive Table Builder and a highly customizable Form Builder, with real-time configuration changes. Apps can operate on both the back-end and front-end, with simple authorization management based on WordPress user and role principles. The App Builder supports 35 languages to localize your apps.

App Builder

Build data-driven apps with an intuitive Table Builder and Form Builder

• Experience the simplicity of app building with our App Wizard
• Generate data tables with the Table Builder
• Manage data with the grid-driven Form Builder
• Customize with ease using the Intuitive Theme Builder
• Create (multi-level) master-detail pages with the Relationship Wizard
• Utilize real-time updatable computed fields through inline fields
• Perform real-time aggregations through inline fields
• Create (conditional) lookups with the Lookup Wizard
• Access numerous global and inline filter options
• Edit data inline seamlessly
• Connect to both local and remote databases
• Integrate with the WordPress media library
• Integrate with WordPress users and roles
• Export to PDF, CSV, JSON, XML, SQL, and Excel
• Manage authorizations with the App Manager
• Run apps on both the back-end and front-end
• Experience real-time build and run functionality
• Enjoy a fully responsive design
• Support manual styling options

Data Management

Manage local and remote data and databases directly from the WordPress dashboard

• Manage both local and remote data and databases
• Perform global search and replace across multiple databases and tables
• Import SQL and CSV files, with ZIP support for large files
• Export data in various formats: SQL, CSV, JSON, and XML, with support for large tables
• Execute table operations such as rename, copy, truncate, drop, optimize, and alter
• Access advanced table and column settings including search, geolocation, inline editing, and more

Remote Databases and Remote Data Files

Connect and auto-sync with remote databases and data files

• Compatible with all plugin tools
• Premium remote connection wizard for easy setup:
  • Remote Databases: SQL Server, Oracle, PostgreSQL, MariaDB, MySQL, and MS Access (file-based)
  • Remote Data Files: CSV, JSON, and XML files (e.g., sync with Google Sheets)

SQL Query Builder

Execute SQL queries directly from the WordPress dashboard

• Work on multiple SQL queries using tabs
• Save and reuse queries for data tables and charts
• Protect WordPress table structures and data
• Interactive Visual Query Builder for users with limited SQL knowledge

Dashboards and Widgets

Customizable widgets for dashboards (back-end), webpages (front-end), and external websites

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

Geolocation search

Create searchable geolocation maps from database tables

• Google Maps integration – Seamlessly incorporate Google Maps for geolocation features
• Customizable settings – Tailor map settings for each database table to fit your needs
• DataTables integration – Combine with DataTables for enhanced functionality
• Adjustable radius search map – Enable users to perform searches within a customizable radius

Charts

Build charts from SQL queries

• Seamless integration with Google Charts
• Compatible with both the Query Builder and Visual Query Builder
• Select from a variety of chart types using drop-down menus

Plugin Settings

Detailed settings for managing user interface and behavior

• Tailor your experience with a wide range of detailed settings to control both the user interface and functionality of the plugin

Legacy Tools

Soon replaced by the App Builder

• Available until at least summer 2025
• Use to maintain old solutions
• Use new App Builder for new projects

Data Tables (Legacy Tool)

Create professional data tables for back-end and front-end in minutes

• User-friendly and highly customizable
• Fully responsive design
• Extensive styling options with an intuitive Style Manager
• Various searching and sorting algorithms
• Numerous static and interactive filters including (search panes, search forms, search builder and more)
• Server-side processing for handling large tables
• Client-side processing for fast search and sorting of smaller tables
• Export options: CSV, Excel, PDF, and SQL
• Customizable and programmable buttons
• Integrated geolocation search
• Support of custom queries and custom post types

Data Apps (Legacy Tool)

Build highly customizable data-driven WordPress apps for back-end and front-end

• Automatically generated CRUD pages
• Customizable through Project Templates
• Lookups with drop-down lists and autocomplete fields
• Master-detail pages for comprehensive data management
• Transform Data Projects into responsive apps with Data Forms
• Inline editing capabilities
• Extensive search features
• Integration with WordPress user roles
• Seamless integration with the WordPress media library

Data Designer (Legacy Tool)

Intuitive interface for creating and managing tables and indexes

• Easily create and modify tables and indexes
• Support for reverse engineering and reconciliation

Useful Links

• Plugin Website
• Documentation