內容簡介
WPCodeForge Database Cleaner 是一款輕量級的 WordPress 資料庫維護外掛，旨在幫助管理員安全且有效地檢查和移除不必要的資料庫數據，從而保持網站的整潔與效能。
【主要功能】
• 提供資料庫概覽，顯示表格數量及大小
• 支援多種清理操作，如刪除過期的 transient
• 檢查和管理 WordPress 選項及其狀態
• 檢查排程的 cron 事件及其執行狀態
• 檢查文章及用戶的元數據，移除冗餘資料
外掛標籤
開發者團隊
② 後台搜尋「Database Cleaner – Clean & Optimise Database for Better Site Performance」→ 直接安裝（推薦）
原文外掛簡介
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
