Database Cleaner – Clean & Optimise Database for Better Site Performance
Database Cleaner Overview showing database size, table count and available database maintenance information.
WPCodeForge Database Cleaner is a lightweight WordPress database maintenance plugin designed to help administrators inspect and remove unnecessary database data safely and efficiently.
Over time, WordPress websites can accumulate database clutter from post revisions, auto-drafts, deleted content, spam comments, expired transients, unused metadata and other temporary or redundant records.
WPCodeForge Database Cleaner provides a straightforward administration interface for inspecting your WordPress database and carrying out targeted maintenance operations without requiring direct access to phpMyAdmin or other database management software.
The plugin provides dedicated tools for inspecting database tables, WordPress options, scheduled cron events, post metadata, user metadata, transient data and registered post types, alongside general database cleanup tools.
Database cleanup operations are performed only after an administrator explicitly requests them.
WPCodeForge Database Cleaner is developed and maintained by James William Steven Parker, creator of WPCodeForge.
Features
Database Overview
The Database Cleaner overview provides information about your WordPress database, including:
- Database table count
- Database size
- WordPress database prefix
- Available cleanup categories
- Available database maintenance tools
The overview provides a central starting point for inspecting and maintaining the database.
General Cleanup
Remove unnecessary WordPress data from common cleanup categories.
Supported cleanup operations include:
- Post revisions
- Auto-drafts
- Trashed posts and pages
- Pending comments
- Spam comments
- Trashed comments
- Pingbacks
- Trackbacks
- Orphaned post meta
- Duplicate post meta
- Orphaned user meta
- Duplicate user meta
- Orphaned comment meta
- Orphaned term meta
- Orphaned term relationships
- Expired transients
- oEmbed cache data
Cleanup information is presented before destructive operations wherever practical so that administrators can review the data available for removal.
Database Tables
Inspect database tables belonging to your WordPress installation.
The Tables interface provides information including:
- Table name
- Row count
- Data size
- Index size
- Total table size
- Storage engine
- Table status
Tables can also be inspected to view their structure and contents.
Where supported by the database server, table optimisation can be requested from the administration interface.
Options
Inspect WordPress options stored in the database.
The Options interface provides information including:
- Option name
- Option value
- Option size
- Autoload status
Option values can be inspected before making changes.
Administrators can change the autoload status of supported options and remove unwanted options.
Critical WordPress options are protected from casual removal to reduce the risk of damaging a WordPress installation.
Always review an option carefully before deleting it.
Cron Jobs
Inspect scheduled WordPress cron events.
The Cron Jobs interface provides information about scheduled events, including:
- Hook or action name
- Next scheduled execution
- Schedule information
- Arguments
Administrators can inspect scheduled events and remove unwanted cron events where appropriate.
Use caution when deleting cron events created by WordPress, themes or plugins. Removing a required scheduled event may prevent the corresponding functionality from working correctly.
Post Meta
Inspect post metadata stored in the WordPress database.
The Post Meta interface provides information including:
- Meta ID
- Post ID
- Meta key
- Meta value
- Metadata size
The plugin can identify post metadata that no longer belongs to an existing post and can identify duplicate metadata entries.
Administrators can review and remove unwanted post metadata.
User Meta
Inspect user metadata associated with WordPress users.
The User Meta interface provides information including:
- Meta ID
- User ID
- Meta key
- Meta value
- Metadata size
The plugin can identify metadata belonging to users that no longer exist and identify duplicate user metadata.
Administrators can review and remove unwanted user metadata.
Transients
Inspect transient data stored by WordPress.
The Transients interface provides information including:
- Transient name
- Transient value
- Size
- Expiration information
- Autoload information where applicable
Expired transients can be identified and removed.
Transient values can be inspected before deletion.
Post Types
View registered WordPress post types and useful information about them.
The Post Types interface provides information including:
- Post type name
- Post count
- Public visibility
- Registration status
The interface helps administrators understand which post types are currently registered on the website.
Database Maintenance
WPCodeForge Database Cleaner is designed to make routine database maintenance easier without requiring administrators to manually write SQL queries.
The plugin uses WordPress APIs and the WordPress database abstraction layer wherever appropriate.
Safety
Database cleaning is inherently destructive.
Before performing significant database cleanup, create a complete and restorable backup of your website and database.
WPCodeForge Database Cleaner is designed to provide administrators with information about data before removal, but no database-cleaning plugin can determine the purpose of every custom database record with absolute certainty.
In particular:
- Do not delete options unless you understand what they are used for.
- Do not delete cron events unless you understand what scheduled functionality they belong to.
- Review metadata before removing unusual or custom records.
- Take a complete database backup before performing substantial cleanup.
- Test cleanup operations on a staging website where possible.
- Do not assume that unused-looking data is necessarily safe to remove.
WPCodeForge Database Cleaner does not guarantee that removing database data will improve website performance.
Database cleanup should be treated as a maintenance operation rather than a substitute for proper website optimisation.
Privacy
WPCodeForge Database Cleaner does not require an external account or remote service for its core functionality.
The plugin processes database information locally within the WordPress installation.
The plugin does not intentionally transmit database contents, database records or website analytics to WPCodeForge.
Support
For plugin information, documentation and support resources, visit:
https://wpcodeforge.com/
Credits
WPCodeForge Database Cleaner was created and developed by James William Steven Parker, creator of WPCodeForge.
Website:
https://wpcodeforge.com/
Copyright © 2026 WPCodeForge. All rights reserved.
License
WPCodeForge Database Cleaner is free software, licensed under the GNU General Public License version 2 or later.
You may redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 2 of the License or any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this plugin. If not, see:
https://www.gnu.org/licenses/gpl-2.0.html