jshossen

<h3>🗄️ What is FlyDB?</h3>
<p><strong>FlyDB</strong> is a lightweight, secure database explorer for WordPress that gives administrators a powerful interface to browse, analyze, and export database data — without writing SQL or leaving wp-admin.</p>
<p>With an intuitive UI inspired by modern data tools like Airtable and Supabase, FlyDB makes database management accessible to everyone while keeping your data safe with read-only access.</p>
<p>👉 <strong><a href="https://github.com/jshossen/flydb" rel="nofollow ugc">View on GitHub</a></strong></p>
<h3>💡 Why FlyDB Stands Out</h3>
<p>FlyDB is not just another database plugin. It’s a complete data exploration tool built for WordPress administrators and developers:</p>
<ul>
<li><strong>Read-only & secure</strong> — browse and export data safely without risk of accidental modifications</li>
<li><strong>No SQL required</strong> — visual filter builder and intuitive interface for non-technical users</li>
<li><strong>Works with any table</strong> — explore WordPress core tables, plugin tables, and custom tables</li>
<li><strong>Modern React UI</strong> — fast, responsive interface built with WordPress components</li>
<li><strong>Smart relationships</strong> — automatically detect and display related data across tables</li>
<li><strong>Powerful exports</strong> — CSV, JSON, Excel, and XML with progress tracking for large datasets</li>
</ul>
<h3>🌟 Key Features</h3>
<p>✅ <strong>Table Explorer</strong> — view all database tables with row counts, sizes, and statistics<br />
🔍 <strong>Advanced Search</strong> — search across all columns with real-time results<br />
🎯 <strong>Filter Builder</strong> — combine multiple filters with operators (=, !=, LIKE, >, <, BETWEEN, IN)<br />
🔗 <strong>Relationship Detection</strong> — automatically find and display related data<br />
� <strong>Visual Query Builder</strong> — drag-and-drop SQL query builder with JOIN, WHERE, GROUP BY support<br />
� <strong>Data Export</strong> — export to CSV, JSON, Excel (XLSX), or XML<br />
📄 <strong>Pagination</strong> — browse large tables with 50/100/200 rows per page<br />
👁️ <strong>Column Toggle</strong> — show/hide columns for focused analysis<br />
🔒 <strong>Secure</strong> — read-only access with capability checks and nonce verification<br />
⚡ <strong>Fast</strong> — optimized queries with LIMIT protection and prepared statements</p>
<h3>🗂️ Database Table Explorer</h3>
<p>Browse your entire WordPress database with ease:</p>
<ul>
<li>View all tables with detailed statistics (row count, size, engine)</li>
<li>Sort and search through tables instantly</li>
<li>See table creation and update timestamps</li>
<li>Monitor database growth over time</li>
<li>Access custom tables created by plugins and themes</li>
</ul>
<p>All without leaving your WordPress admin dashboard.</p>
<h3>📋 Advanced Table Data Viewer</h3>
<p>Explore table records with powerful viewing options:</p>
<ul>
<li><strong>Pagination</strong> — browse 50, 100, or 200 rows per page</li>
<li><strong>Sortable columns</strong> — click any column header to sort</li>
<li><strong>Quick search</strong> — search across all columns in real-time</li>
<li><strong>Column visibility</strong> — toggle columns on/off for cleaner views</li>
<li><strong>Responsive layout</strong> — horizontal scroll for wide tables</li>
</ul>
<p>Perfect for debugging, data analysis, and quick lookups.</p>
<h3>🎯 Powerful Filter Builder</h3>
<p>Build complex queries without writing SQL:</p>
<ul>
<li>Filter by any column with visual controls</li>
<li>Support for 8 operators: <code>=</code>, <code>!=</code>, <code>LIKE</code>, <code>></code>, <code><</code>, <code>>=</code>, <code><=</code>, <code>BETWEEN</code>, <code>IN</code></li>
<li>Combine multiple filters (AND logic)</li>
<li>Save and reuse filter combinations</li>
<li>Real-time results as you build filters</li>
</ul>
<p>Great for finding specific records, analyzing subsets, and debugging data issues.</p>
<h3>🔗 Smart Relationship Detection</h3>
<p>FlyDB automatically detects relationships between tables:</p>
<ul>
<li><strong>Foreign key detection</strong> — finds <code>_id</code> columns linking to other tables</li>
<li><strong>Belongs to relationships</strong> — see parent records (e.g., post author)</li>
<li><strong>Has many relationships</strong> — view child records (e.g., post comments)</li>
<li><strong>Related data panel</strong> — browse related records without leaving the page</li>
</ul>
<p>Makes understanding your database structure effortless.</p>
<h3>📊 Data Export</h3>
<p>Export filtered data in multiple formats:</p>
<ul>
<li><strong>CSV</strong> — for Excel and spreadsheet apps</li>
<li><strong>JSON</strong> — for developers and APIs</li>
<li><strong>Excel (XLSX)</strong> — native Excel format with formatting</li>
<li><strong>XML</strong> — for data interchange</li>
</ul>
<p><strong>Export Features:</strong><br />
– Progress indicator for large datasets (10k+ rows)<br />
– Export current view or entire table<br />
– Include/exclude specific columns<br />
– Save export presets for reuse<br />
– Direct browser download (no server files)</p>
<p>Maximum export limit: 10,000 rows per export.</p>
<h3>🔒 Security & Performance</h3>
<p>FlyDB is built with WordPress best practices:</p>
<p><strong>Security:</strong><br />
– Read-only access (no write/delete operations in v1.0)<br />
– Requires <code>manage_options</code> capability (admin only)<br />
– Nonce verification on all requests<br />
– Prepared statements prevent SQL injection<br />
– All user input sanitized and escaped</p>
<p><strong>Performance:</strong><br />
– Query LIMIT protection prevents database overload<br />
– Pagination prevents loading large datasets at once<br />
– Optimized queries use indexes when available<br />
– No frontend impact (admin-only plugin)</p>
<h3>🎯 Use Cases</h3>
<p><strong>For Site Administrators:</strong><br />
– Debug database issues without phpMyAdmin<br />
– Export user data for reporting<br />
– Monitor database growth and table sizes<br />
– Quick data lookups and verification</p>
<p><strong>For Developers:</strong><br />
– Analyze custom table structures<br />
– Debug plugin data issues<br />
– Understand table relationships<br />
– Export data for development/testing</p>
<p><strong>For Data Analysts:</strong><br />
– Filter and export data for analysis<br />
– Explore relationships between data<br />
– Generate reports from WordPress data</p>
<h3>� Visual Query Builder</h3>
<p>Build complex SQL queries without writing code:</p>
<ul>
<li><strong>Drag-and-drop interface</strong> — add tables to canvas by dragging</li>
<li><strong>Visual JOIN builder</strong> — connect tables with visual relationships</li>
<li><strong>WHERE clause builder</strong> — add filters with multiple conditions</li>
<li><strong>GROUP BY support</strong> — aggregate data visually</li>
<li><strong>ORDER BY controls</strong> — sort results by any column</li>
<li><strong>LIMIT controls</strong> — set row limits for results</li>
<li><strong>Live SQL preview</strong> — see generated SQL in real-time</li>
<li><strong>Save presets</strong> — save and reuse query configurations</li>
<li><strong>Export results</strong> — export query results to CSV or JSON</li>
</ul>
<p>Perfect for building complex queries across multiple tables without SQL knowledge.</p>
<h3>🚀 Coming Soon</h3>
<p>Planned features for future releases:</p>
<ul>
<li><strong>Data Editing</strong> — insert, update, and delete records (with safety controls)</li>
<li><strong>Advanced Query Builder</strong> — subqueries, UNION, and complex expressions</li>
<li><strong>Data Visualization</strong> — charts and graphs for data analysis</li>
<li><strong>AI Integration</strong> — AI-powered data insights and query suggestions</li>
<li><strong>Scheduled Exports</strong> — automate data exports on a schedule</li>
</ul>
<h3>Privacy Policy</h3>
<p>FlyDB does not collect, store, or transmit any data outside of your WordPress installation. All database operations are performed locally on your server. <strong>No data is sent to external services.</strong></p>
<h3>Support</h3>
<p>Need help or have a feature request?</p>
<ul>
<li><strong>GitHub Issues:</strong> https://github.com/jshossen/flydb/issues</li>
<li><strong>Support Forum:</strong> https://wordpress.org/support/plugin/flydb/</li>
<li><strong>Documentation:</strong> https://github.com/jshossen/flydb</li>
</ul>
<h3>Credits</h3>
<p>Developed with ❤️ by Jakir Hossen for the WordPress community.</p>
<p><strong>Special Thanks:</strong><br />
– WordPress Core Team for the amazing platform<br />
– React and WordPress Components teams<br />
– The open-source community</p>
<h3>Technical Details</h3>
<h4>Architecture</h4>
<p>FlyDB follows WordPress coding standards and best practices:</p>
<ul>
<li><strong>Object-oriented PHP</strong> with PSR-4 namespaces</li>
<li><strong>WordPress REST API</strong> for all AJAX operations</li>
<li><strong>Prepared statements</strong> for all database queries</li>
<li><strong>Nonce verification</strong> for security</li>
<li><strong>Capability checks</strong> on all operations</li>
<li><strong>Sanitization and escaping</strong> of all user input</li>
<li><strong>React</strong> for modern, responsive UI</li>
</ul>
<h4>REST API Endpoints</h4>
<ul>
<li><code>GET /wp-json/flydb/v1/tables</code> – List all database tables</li>
<li><code>GET /wp-json/flydb/v1/table-data</code> – Get table data with pagination/filters</li>
<li><code>POST /wp-json/flydb/v1/export</code> – Export table data</li>
<li><code>GET /wp-json/flydb/v1/relationships</code> – Get table relationships</li>
<li><code>POST /wp-json/flydb/v1/query-builder/execute</code> – Execute Query Builder queries</li>
<li><code>GET /wp-json/flydb/v1/query-builder/export</code> – Export Query Builder results</li>
<li><code>GET /wp-json/flydb/v1/query-builder/presets</code> – Get saved query presets</li>
<li><code>POST /wp-json/flydb/v1/query-builder/presets</code> – Save query preset</li>
<li><code>DELETE /wp-json/flydb/v1/query-builder/presets/{id}</code> – Delete query preset</li>
</ul>
<h4>Performance Optimizations</h4>
<ul>
<li>Query results limited to prevent memory issues</li>
<li>Pagination prevents loading large datasets at once</li>
<li>Database indexes used when available</li>
<li>Export operations capped at 10,000 rows</li>
<li>Chunked processing for large exports</li>
</ul>
<h4>Browser Compatibility</h4>
<ul>
<li>Chrome (latest)</li>
<li>Firefox (latest)</li>
<li>Safari (latest)</li>
<li>Edge (latest)</li>
</ul>
<h3>For Developers</h3>
<p>FlyDB is designed to be extensible:</p>
<ul>
<li><strong>Filter system</strong> can be extended with custom operators</li>
<li><strong>Export formats</strong> can be added via the Exporter class</li>
<li><strong>Relationship detection</strong> can be customized</li>
<li><strong>UI</strong> can be themed with custom CSS</li>
<li><strong>REST API</strong> can be extended for custom integrations</li>
</ul>
<p><strong>Contributing:</strong><br />
Pull requests are welcome! Visit our GitHub repository to contribute.</p>
<p><strong>Hooks & Filters:</strong><br />
Documentation for available hooks and filters coming soon.</p>


FlyDB – phpMyAdmin-Like Database Explorer for WordPress

Powerful database explorer with table browser, advanced filters, relationship detection, and data export (CSV, JSON, Excel).

Puvox Software

ttodua

<h4>[ ✅ 𝐒𝐄𝐂𝐔𝐑𝐄 𝐏𝐋𝐔𝐆𝐈𝐍𝐒 𝐵𝓎 𝒫𝓊𝓋𝑜𝓍 ] :</h4>
<blockquote>
<p>• Checked against vulnerability holes.<br />
  • No extra load/slowness to site.<br />
  • Does not collect & share private data.</p>
</blockquote>
<h4>Plugin Description</h4>
<p>The famous database browser & manager (for MySQL & MariaDB) – use it inside WordPress Dashboard without an extra hassle.</p>
<h3>NOTES</h3>
<ul>
<li>This plugin has been started from 2018 year, and we have no connections to the old age’s vulnerable wp-phpMyAdmin plugin (published elsewhere by 3rd party scammers) . So, this current plugin is just a wrapper for official phpMyAdmin release and depends itself on the realiability & security of the <code>phpMyAdmin</code> itself. Also, initially we wanted to put PhpMyAdmin released <code>.zip</code> file untouched (to ensure the checksums are same) and unpack that <code>.zip</code> directly upon plugin’s installation, but unfortunately WordPress Plugin Team didn’t allow to put <code>.zip</code> file in the package (saying that SVN doesn’t like working with <code>.zip</code> files). Thus, we had to submit extracted PMA (but still original & untouched) to the repository.</li>
<li>PHP >= 7.2.5 is required to for <strong>phpMyAdmin</strong> latest version (otherwise you will have option to use older version of PMA, which is not encouraged to be used).</li>
<li>For the reason to make it compact, some unnecessary files (language files, OpenLayer/GIS map lib, extra themes, etc) are removed.</li>
<li>It’s recommended, that you enable the plugin only while you need to use PhpMyAdmin. Otherwise, for longer periods, you can deactivate plugin.</li>
</ul>
<h4>Liability</h4>
<p>We are not developers of PhpMyAdmin itself, neither affiliated with them. We just made this plugin as a wrapper (container) of official PhpMyAdmin, to make it possible to be installed as a WP plugin. However, we don’t monitor PhpMyAdmin package’s source code itself. We take no responsibility about this plugin. Use it at your own responsibility (However, as it’s also visible in stats, thousands of users are using this extendion and only few people have complained about errors).</p>
<h4>Available Options</h4>
<p>See all available options and their description on plugin’s settings page.</p>


WP phpMyAdmin

What a wonderful marriage of two pieces of software,

I work on WordPress sites allllll the time, it's very easy to facilitate access with a client to the dashboard, but I've had no end of trouble in the past trying to facilitate access to phpMyAdmin via the clients respective hosting.

This plugin has saved me an innumerable amount of time!

Supremely useful

I am sure the developer of this plugin will be a lovely guy like the plugin he/she has developed!

a Lovely Plugin

This is a lifesaver plugin when, for some reason, you don't have the database credentials and need to do some database operations.

A lifesaver plugin

Very helpful plugin. Saves a lot of time and hassle in certain circumstances. Thanks!

Very helpful


I love this plugin to debug my client sites.It is very easy and usefull solution


Very Usefull Plugin


I use this plugin on almost all of the WordPress sites I develop with.


Excellent Plugin

[ ✅ 𝐒𝐄𝐂𝐔𝐑𝐄 𝐏𝐋𝐔𝐆𝐈𝐍𝐒 𝐵𝓎 𝒫𝓊𝓋𝑜𝓍 ] phpMyAdmin -  Database Browser & Manager (for MySQL & MariaDB)

FlyDB – phpMyAdmin-Like Database Explorer for WordPress vs WP phpMyAdmin