jelenacvijic

Looking for the easiest way to manage your data? 
We are here to help. 😉 
And our AI Assistant!
Black-Desk is a comprehensive WordPress plugin that helps you create and manage custom database tables and data directly from your WordPress dashboard.
The plugin provides an intuitive interface that lets you create, update, and query your data in the simplest way possible, without requiring deep technical knowledge.
* Creating tables just became even more simple with the help of our AI Assistant!
Save queries and reuse them quickly.
Black-Desk plugin shortcodes let you display selected data on your WordPress pages or posts, as well as easily create input forms directly connected to your tables.
Key Features:
<ul>
<li>Create custom tables with various column types</li>
<li>Create tables using natural language with the help of the AI Assistant</li>
<li>Manage table data with an easy-to-use interface</li>
<li>View and edit table data</li>
<li>Create and save custom queries, including joins (across multiple related tables)</li>
<li>Soft delete support with trash management</li>
<li>Shortcodes for data display</li>
<li>Shortcodes for input form generation</li>
</ul>
<h3>Usage</h3>
After installation, look for the ‘Tables’ menu item in your WordPress dashboard/admin panel.
<h4>Creating Tables</h4>
Using our AI Assistant: 
0. Set up AI in Black-Desk “Settings” 
1. Select “AI Assistant” 
2. Choose “Create table assistant” 
3. Enter table name and description in natural language 
4. You can add another column manually or just 
5. Preview and save your table structure
Or manually: 
1. Go to Tables > Add Table 
2. Enter table name and description 
3. Add columns with their respective names, types and properties 
4. Preview and save your table structure
Available Column Types:
<ul>
<li>Short text – varchar(255)</li>
<li>Number – int(11)</li>
<li>Big number – bigint(20)</li>
<li>Currency – decimal(15,2)</li>
<li>Date time – datetime</li>
<li>Yes no – bit(1)</li>
<li>Lookup – varchar(100)</li>
<li>Rich text – mediumtext</li>
<li>Long text – longtext</li>
<li>Attachment – longblob</li>
<li>Hyperlink – varchar(1024)</li>
<li>ENUM – ENUM (your list of options)</li>
</ul>
<h4>Managing Data</h4>
<ol>
<li>Navigate to Tables > All Tables</li>
<li>Click on a table to view/edit its data or its structure</li>
<li>Add, edit, or delete records (edit by clicking the field itself)</li>
<li>Use bulk actions for multiple records</li>
<li>Restore deleted records from trash</li>
<li>Display data in your WordPress page or post using shortcodes</li>
</ol>
<h4>Creating Queries</h4>
<ol>
<li>Go to Tables > All Queries > Select</li>
<li>Choose tables and fields to include</li>
<li>Add conditions and aliases</li>
<li>Preview and save your query</li>
<li>Display the query results in your WordPress page or post using shortcodes</li>
</ol>
If you want to view data from related, joined tables you can create and save a query by setting one of its conditions so that the value from the first table column is equal to the second table column/field (effectively indicating a foreign key column and pointing it to another table’s primary key).
Example of such query condition: 
[<code>review.product_id</code>] [equal to] [FIELD] [<code>product.id</code>]
<h4>View Query Results</h4>
<ol>
<li>Go to Tables > All Queries</li>
<li>View specific query</li>
</ol>
<h4>Deleting Data</h4>
There are three options for deleting data:
<ol>
<li>Deleting rows while viewing a table, one by one or in bulk; soft delete, reversible</li>
<li>Truncate – delete all data in a table; irreversible</li>
<li>Delete the whole table; irreversible</li>
</ol>
<h4>Shortcodes</h4>
Shortcodes are a powerful feature of Black-Desk that let you seamlessly connect your data tables to any of your WordPress pages or posts, in one of the two directions:
<ul>
<li>Display data from your tables directly on your page or post;</li>
<li>Create custom data entry forms to store user input directly into your data tables.</li>
</ul>
Using shortcodes, you can easily:
<ul>
<li>Display data from your table or query result – <code>[bdds-view-table]</code></li>
<li>Display specific field – <code>[bdds-view-field]</code></li>
<li>Display specific field data for each row of your table or query result – <code>[bdds-view-repeat]</code></li>
<li>Create an input form using shortcodes: 
- <code>[bdds-form-start]</code> – to start a form 
- <code>[bdds-form-field]</code> – to add form field 
- <code>[bdds-form-stop]</code> – to end a form</li>
</ul>
Detailed shortcodes usage instructions are provided in dashboard > Tables > Shortcodes.
<h4>AI Assistant</h4>
To enable the use of AI Assistant features, you need to first set up your preferred AI Service Provider and securely store your corresponding API key* in Black-Desk “Settings”.
* Your API key will be stored on your own server. While we take reasonable precautions to store it securely, we have no control over your hosting environment and cannot be held liable for any loss, exposure, or misuse resulting from a server breach or other unforeseen event.

Black-Desk

WordPress plugin for easier data management.

Freemius

Passionate Programmer Peter

WP Data Access

Kim L

Passionate Programmer Max

Leeberty

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:
<ul>
<li>Interactive Data Tables – manage and display data with ease</li>
<li>Custom Data Forms – collect and process input seamlessly</li>
<li>Charts, Maps & Dashboards – visualize data beautifully</li>
<li>Role-Based Access – control who can view or manage your data</li>
<li>Multilingual Support – 35+ languages ready to use</li>
</ul>
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.
<h3>App Builder ❤️</h3>
<blockquote>
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 🌍
</blockquote>
<ul>
<li>Table Builder – Create powerful, interactive data tables effortlessly
<ul>
<li>Add static and dynamic data table filtering options 🔍</li>
<li>Real-time computed fields and aggregations for instant insights 📈</li>
<li>A Lookup Wizard to add lookups to your data table 🧙</li>
<li>Inline editing for instant updates 📝</li>
<li>Integrates with the WordPress media library for rich content 📷🎞</li>
<li>Export data tables to PDF, CSV, JSON, XML, SQL, and Excel 📄</li>
<li>Add charts and maps to your data table header and footer 📊</li>
<li>JavaScript hooks to customize data table layout and behavior 🔧</li>
</ul>
</li>
<li>Form Builder – Design forms that adapt to your workflow
<ul>
<li>Grid-based layouts for precise control ➕➖</li>
<li>Master-detail relationships for multi-level data structures 🔄</li>
<li>Lookup and Computed Field Wizards to add functionality instantly 🧙</li>
<li>Interactive client-side validations tied to your database constraints ✅</li>
<li>Full access to the WordPress media library 📷🎞</li>
<li>JavaScript hooks to customize business rules, validations and layout 🔧</li>
</ul>
</li>
<li>Chart Builder – Transform your data into visual insights
<ul>
<li>Google Charts integration 📊</li>
<li>Create charts from SQL queries 📑</li>
<li>Interactively adjustable chart configurations ✔</li>
<li>Print/export charts 🖨📄</li>
</ul>
</li>
<li>Map Builder – Visualize your data geographically
<ul>
<li>Google Maps integration for location-based apps 🌎</li>
<li>Query-driven location visualizations 📍</li>
<li>Interactively adjustable search radius 🔍</li>
<li>Customizable marker content and layout 📌</li>
</ul>
</li>
<li>Dashboard Builder – Centralize insights with customizable widgets
<ul>
<li>Combine all app types into cohesive dashboards ✅</li>
<li>Customize dashboard layouts with flexible positioning and sizing ➕➖</li>
<li>Customizable widgets presenting dynamic and static data</li>
<li>Mix real-time data with fixed information for comprehensive overviews 📊</li>
</ul>
</li>
<li>Theme Builder – Make your app truly yours
<ul>
<li>Personalize your app’s appearance with ease 🎨</li>
</ul>
</li>
<li>App Manager – Control your apps with confidence
<ul>
<li>Authorization management based on WordPress user and role principles 🔒</li>
<li>Add apps to back-end menus or front-end pages via shortcodes 🔽🌐</li>
<li>Safe mode to temporarily disable hooks without breaking functionality 🔧</li>
</ul>
</li>
</ul>
<iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/j0MJvuMG7k8?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe>
<h3>SQL Query Builder</h3>
<blockquote>
Run and schedule SQL queries effortlessly from your WordPress dashboard.
</blockquote>
<ul>
<li>Schedule queries to run automatically at defined intervals 🕝</li>
<li>Run batch jobs for automated data exchange across multiple databases 🤝</li>
<li>AI Assistant to generate queries and fix common errors 🤖</li>
<li>Tabbed interface for running multiple queries in parallel ▶</li>
<li>Save and reuse queries – privately or globally 🔄</li>
<li>Built-in safeguards to protect core WordPress tables and ensure data integrity 🔒</li>
<li>Visual Query Builder to create complex queries without writing SQL 🎨</li>
</ul>
<h3>Data Explorer</h3>
<blockquote>
Take full control of your data with a GUI-driven interface.
</blockquote>
<ul>
<li>Manage local and remote data 🗺</li>
<li>Perform global search and replace across multiple databases and tables 🔍</li>
<li>Import SQL and CSV files, with ZIP support for handling large datasets 📄</li>
<li>Export data in various formats, including SQL, CSV, JSON, and XML 📄</li>
<li>Rename, copy, truncate, drop, optimize, or alter tables 👤</li>
<li>Advanced table and column options, such as geolocation, and enhanced search ✔</li>
</ul>
<h3>Premium Data Services</h3>
<blockquote>
Connect, sync, and manage remote databases and data files.
</blockquote>
<ul>
<li>Compatible with all plugin features ✅</li>
<li>Premium Remote Connection Wizard 🧙
<ul>
<li>Remote Databases: Connect to SQL Server, Oracle, PostgreSQL, MariaDB, MySQL, and MS Access (file-based) 💻</li>
<li>Remote Data Files: Sync with CSV, JSON, and XML files for dynamic updates (e.g., Google Sheets sync) 📄</li>
</ul>
</li>
</ul>
<h3>Legacy Tools</h3>
<blockquote>
Will be replaced by the App Builder.
</blockquote>
<ul>
<li>Available until at least december 2026 🕝</li>
<li>Featuring
<ul>
<li>Data Tables 🔍 – Can be replaced with Data Table app.</li>
<li>Data Forms ✅ – Can be replaced with Data Management app or Registration Form.</li>
<li>Maps 🌎 – Can be replaced with Map app.</li>
<li>Charts 📊 – Can be replaced with Chart app.</li>
<li>Dashboards 🎛️ – Can be replaced with Dashboard app.</li>
</ul>
</li>
<li>Use to maintain old solutions 🙏</li>
<li>Use App Builder for new projects 🚀</li>
</ul>
<h3>Useful Links</h3>
<ul>
<li><a href="https://wpdataaccess.com/" rel="nofollow ugc">Plugin Website</a></li>
<li><a href="https://docs.rad.wpdataaccess.com/" rel="nofollow ugc">App Builder Documentation</a></li>
<li><a href="https://www.youtube.com/@wpdataaccess" rel="nofollow ugc">Video Tutorials</a></li>
<li><a href="https://docs.sql.wpdataaccess.com/" rel="nofollow ugc">SQL Query Builder Documentation</a></li>
<li><a href="https://docs.settings.wpdataaccess.com/" rel="nofollow ugc">Plugin Settings Documentation</a></li>
<li><a href="https://docs.wpdataaccess.com/" rel="nofollow ugc">Tool Guide Documentation</a></li>
<li><a href="https://docs.legacy.wpdataaccess.com/" rel="nofollow ugc">Legacy Documentation</a></li>
</ul>

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

The free version of the plugin worked like a charm for me. Thank you very much, highly recommended!

Excellent

Turn your data into WordPress apps with tables, forms, charts & maps — no code required, with optional hooks for developers. Supports 35+ languages.

Black-Desk vs WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards