Lists and logs all database tables including name, size and rows.
Displays an overview of all database tables, showing table name, total size, number of rows and a preview of the data stored in each table. You can review this data historically by selecting a past date, providing useful insights into your database.
In addition to listing all database tables, it also displays the name, total size and number of rows of the entire database. The premium version also includes automatic daily logging, email reports, print and export.
Features
- List of all database tables including name, size and rows
- Preview a record from a specific table
- Search and sort the data
- Shows the database name, total size and rows
- Clear logs greater than 1, 3, 6, 12 months or all
- Manual logging of tables each time the dashboard is accessed
- Automatic daily logging (Premium)
- Daily email reports to one or more recipients (Premium)
- Print an overview of database tables (Premium)
- Export an overview of database tables (Premium)
Usage
From the WordPress dashboard menu navigate to Database Table Overview and Logs. By default the data shown is for today, you can view historic data using the date picker.
Donate
If this product has helped you, please consider making a donation.
Screenshots
Dashboard
Selecting a date to view historic data
Table information and random row preview
Email report
FAQ
How often are the database tables logged?
The logs are updated each time the dashboard is accessed, with the premium version logs are automatically generated every day.
Can I view historic logs of the database tables?
Yes, use the date picker. Data is only available from the date this plugin was activated. Logging is done each time the dashboard is accessed, the premium version automatically logs the data every day.
Can I search/sort the list of database tables, size, rows?
Yes, use the search field to search and click a column heading to sort.
Can I view the data stored in a table?
Yes, if you click a database table name a modal appears which includes a random row from the database table, to view every row you will need to use a database management tool such as phpMyAdmin.
Can I get an email report of the data?
Yes, the premium version sends an email report daily to the email report recipient(s) set.
Can I print/export the data?
Yes, the premium version includes print and export functionality, just click the buttons.
ChangeLog
1.2.0 – 2024-04-10
- Add: Translation information in readme.txt
- Update: Table size column to include (MB) suffix
- Update: Freemius SDK
- Update: WordPress tested up to 6.5.2
- Fix: Table size column does not sort correctly
1.1.5 – 2024-03-08
- Add: BETA functionality information to readme.txt
- Add: Caching information to readme.txt
- Add: Donation information to readme.txt
- Add: Works with information to readme.txt
- Update: Screen sizes information in readme.txt
- Update: WordPress tested up to 6.4.3
1.1.4 – 2024-01-17
- Update: Changelog consistency
- Update: Freemius SDK
1.1.3 – 2023-12-15
- Update: Code consistency
- Update: Development assets
- Update: Screen sizes typo in readme.txt
- Update: Freemius SDK
- Update: WordPress requires at least 6.3.0
- Update: WordPress tested up to 6.4.2
- Fix: Log data not inserted in database if MySQL config has NO_AUTO_VALUE
1.1.2 – 2023-09-19
- Update: Freemius SDK
- Update: WordPress tested up to 6.3.1
1.1.1 – 2023-08-04
- Update: Development assets
- Update: PHP requires at least 7.4.0
- Update: WordPress requires at least 6.1.0
1.1.0 – 2023-07-06
- Update: Freemius SDK
- Update: WordPress tested up to 6.2.2
1.0.0 – 2023-03-07