GrandPlugins

DB Viewer lets you securely view your WordPress database directly from your website’s dashboard — no need to log in to your hosting account or use phpMyAdmin. Perfect for quick inspections and monitoring.
With the free version, you can:
<ul>
<li>Browse and view any database table </li>
<li>Inspect table structures and content inside WordPress </li>
<li>Safely explore your data without leaving the dashboard </li>
</ul>
🔥 Upgrade to <a href="https://grandplugins.com/product/wp-db-controller/" rel="nofollow ugc">DB Controller PRO</a> to unlock powerful database management features:
<ul>
<li>Empty any table with a single click </li>
<li>Delete tables you no longer need </li>
<li>Rename tables instantly </li>
<li>Search for any value across all columns </li>
<li>Add new rows directly from the dashboard </li>
<li>Edit any existing row inline </li>
</ul>
This makes the PRO version a complete lightweight alternative to phpMyAdmin, built directly into WordPress.

DB Viewer

View your WordPress database directly inside your Dashboard. No need for phpMyAdmin or hosting panels.

jshossen

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

FlyDB – phpMyAdmin-Like Database Explorer for WordPress

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

DB Viewer vs FlyDB – phpMyAdmin-Like Database Explorer for WordPress