Title: NHR Advanced Options Table Manager & Autoload Optimizer Author: Nazmul Hasan Robin Published: June 26, 2024 Last modified: September 25, 2026 --- Search plugins ![](https://ps.w.org/nhrrob-options-table-manager/assets/banner-772x250.png?rev= 3107726) ![](https://ps.w.org/nhrrob-options-table-manager/assets/icon-256x256.png?rev=3107726) # NHR Advanced Options Table Manager & Autoload Optimizer By [Nazmul Hasan Robin](https://profiles.wordpress.org/nhrrob/) [Download](https://downloads.wordpress.org/plugin/nhrrob-options-table-manager.2.0.0.zip) [Live Preview](https://vec.wordpress.org/plugins/nhrrob-options-table-manager/?preview=1) * [Details](https://vec.wordpress.org/plugins/nhrrob-options-table-manager/#description) * [Reviews](https://vec.wordpress.org/plugins/nhrrob-options-table-manager/#reviews) * [Installation](https://vec.wordpress.org/plugins/nhrrob-options-table-manager/#installation) * [Development](https://vec.wordpress.org/plugins/nhrrob-options-table-manager/#developers) [Support](https://wordpress.org/support/plugin/nhrrob-options-table-manager/) ## Description 🚀 [GitHub Repository](https://github.com/nhrrob/nhrrob-options-table-manager) – Found a bug or have a feature request? Let us know! 💬 [Slack Community](https://join.slack.com/t/nhrrob/shared_invite/zt-2m3nyrl1f-eKv7wwJzsiALcg0nY6~e0Q)– Got questions or just want to chat? Come hang out with us on Slack! Is your `wp_options` table bloated and slowing down your site? You’re not alone! Install this plugin to get a clear view of the table, plus the tools to clean and optimize it. ``` ``` ### 🚀 A Powerful Yet Simple Solution to Manage wp_options Tired of an overloaded `wp_options` table slowing down your WordPress site? **NHR Options Table Manager** provides a clean, organized, and optimized way to view and manage your options table efficiently. Get detailed analytics, edit and delete options, and keep your database lean and performant. ### ✨ Key Features * **Database Health Dashboard** – An at-a-glance scorecard (0–100) summarizing autoload size, transient and orphan counts, and last backup, with prioritized one-click recommendations. * **Activity Log** – A recent-activity summary on the Dashboard plus a dedicated, searchable and filterable Activity tab showing every change and who made it. * **Modern React Interface** – A fast, dashboard-first admin app organized into Dashboard, Browse, Optimize, Tools, Integrations, and Settings. * **Autoload Usage Tracker** – Records which autoloaded options are actually used on real front-end page loads, then flags the ones that are never used so you can safely turn off their autoload; filter the list by usage status and bulk- disable every unused option at once. * **Autoload Health Check** – Analyze total autoloaded data size and identify heavy options that slow down your site. * **Transients Manager** – Dedicated view of every transient with size, expiration, status, and its guessed owner (a plugin, theme, or WordPress core); filter by status or owner, add and edit values (with expiration) directly, and select rows to bulk delete. * **Manage Options** – Add, edit, and delete options with sortable columns, search, pagination, and bulk delete; filter the list by guessed owner (a plugin, theme, or WordPress core). * **Usermeta, Postmeta, Commentmeta & Termmeta Support** – Browse, add, edit, and delete user, post, comment, and term meta entries just like options; narrow usermeta or postmeta to a single user or post by searching its name/title in a type-ahead picker. * **Serialized Data Handling** – Serialized and JSON values open as structured data you can edit safely, and are saved back in their original format. * **Scheduled Backups & Snapshots** – Create restorable snapshots of your `wp_options` table manually or on a daily/weekly schedule, with automatic snapshots taken before Search & Replace and Import. * **Option History & Rollback** – Track all changes to individual options and restore previous versions instantly. * **Orphan Scanner** – Find and clean up leftovers from uninstalled plugins. * **Options Table Analytics** – See every option grouped by its name prefix with a row count, sorted highest first, so you can spot which plugin’s options weigh the most on your `wp_options` table. * **Automated Daily Cleanup** – Schedule automated daily deletion of expired transients via WP Cron. * **Global Search & Replace** – Safely replace strings across the options table with a dry-run preview that lists every matching option. * **Import / Export** – Move settings between sites easily with JSON support. * **Integrations** – Browse third-party plugin tables (WP Recipe Maker, Better Payment) from the same interface when those plugins are installed. * **Core Option Protection** – WordPress core options can’t be deleted by accident. * **WP-CLI Support** – Manage options (wp nhr-options list, wp nhr-options delete) from the command line. ### ⚡ Easy Installation & Instant Setup No complex configurations needed! Just install, activate, and head to **Tools Options Table** for the dashboard-first interface. The previous DataTables view is still one click away via the **Classic view** link at the top of the app. ### 🎯 Optimize Performance & Reduce Bloat Analyze, clean, and optimize your database by removing unnecessary options, improving site performance significantly. ### 🌟 Join Thousands of Happy Users Get started today and take control of your WordPress options like never before! ## Screenshots [⌊Dashboard — database health score, stat cards, and prioritized recommendations⌉⌊ Dashboard — database health score, stat cards, and prioritized recommendations⌉[ Dashboard — database health score, stat cards, and prioritized recommendations [⌊Browse — options with owner filter, sortable columns, and bulk actions⌉⌊Browse— options with owner filter, sortable columns, and bulk actions⌉[ Browse — options with owner filter, sortable columns, and bulk actions [⌊Edit modal — structured editing for serialized and JSON values⌉⌊Edit modal — structured editing for serialized and JSON values⌉[ Edit modal — structured editing for serialized and JSON values [⌊Optimize — autoload health and the Autoload Usage Tracker⌉⌊Optimize — autoload health and the Autoload Usage Tracker⌉[ Optimize — autoload health and the Autoload Usage Tracker [⌊Optimize — Orphan Scanner for leftovers from uninstalled plugins⌉⌊Optimize — Orphan Scanner for leftovers from uninstalled plugins⌉[ Optimize — Orphan Scanner for leftovers from uninstalled plugins [⌊Browse → Transients — size, expiration, status, and owner⌉⌊Browse → Transients— size, expiration, status, and owner⌉[ Browse Transients — size, expiration, status, and owner [⌊Tools — backups & snapshots and Search & Replace with dry run⌉⌊Tools — backups& snapshots and Search & Replace with dry run⌉[ Tools — backups & snapshots and Search & Replace with dry run [⌊Activity — searchable log of every change and who made it⌉⌊Activity — searchable log of every change and who made it⌉[ Activity — searchable log of every change and who made it ## Installation 1. Install the plugin from **Plugins Add New**, or upload the plugin folder to `/ wp-content/plugins/`. 2. Activate it. 3. Go to **Tools Options Table**. That’s it! You’re done. ## FAQ ### Where do I find the plugin after activating it? Go to **Tools Options Table**. The previous DataTables interface is still available through the **Classic view** link at the top of the app. ### Does this plugin require any dependencies? No, it works as a standalone plugin. ### Will it affect my website’s performance? No, but it will help you optimize your database for better performance. The optional Autoload Usage Tracker records which autoloaded options are read on front-end page loads, and stops writing once it has sampled 10,000 page loads. ### Is it safe to delete options? What if I remove something important? WordPress core options are protected and can’t be deleted. Every change is recorded in Option History, so you can roll an option back to a previous value, and you can take a snapshot of the whole `wp_options` table before any cleanup. The plugin also takes one automatically before Search & Replace and Import. ### Can I edit, delete, and add options easily? Absolutely! Add and edit options in a modal, or select rows to bulk delete. The same works for usermeta, postmeta, commentmeta, termmeta, and transients. ### Does it support serialized data? Yes! Serialized and JSON values open as structured data for editing and are saved back in their original format. ### Can I delete expired transients? Yes. Delete them manually from Optimize Cleanup or the Transients tab, or turn on the automated daily cleanup in Settings. ### Can it find and remove leftover options from plugins I’ve already uninstalled? Yes, the Orphan Scanner cross-references `wp_options` prefixes against your installed plugins and flags anything left behind so you can clean it up safely. ### Does it help with autoloaded data specifically? Yes. The Autoload Health Check shows total autoload size and your heaviest autoloaded options, and the Autoload Usage Tracker flags autoloaded options that are never read on the front end so you know which ones are safe to turn off. ### How long should I let the Autoload Usage Tracker run? Let it collect data across normal traffic for a few days, so rarely visited pages are covered too. An option marked “Unused” was never read during that period, which makes it a good candidate. Review the name before you turn off autoload. ### Can I back up my options table before making changes? Yes. You can create manual snapshots or schedule daily/weekly backups, and the plugin automatically snapshots before Search & Replace and Import operations. ### Is there a command-line interface? Yes, WP-CLI is supported (`wp nhr-options list`, `wp nhr-options delete`). ### I used the menu capability filter in 1.x. Do I need to change anything? Yes. In 2.0.0 the filter was renamed from `nhrotm-options-table-manager/menu/capability` to `nhrotm_menu_capability`. Update your callback to use the new name. ### What happens to my data when I delete the plugin? Deleting the plugin removes its own settings, history, and backup tables. It never touches the options you managed with it. ## Reviews ![](https://secure.gravatar.com/avatar/c53e633620e8636d39508c0804dac1df32328e30300fe13b39d2b3fc233c866d? s=60&d=retro&r=g) ### 󠀁[An excellent tool](https://wordpress.org/support/topic/an-excellent-tool-11/)󠁿 [gerarde](https://profiles.wordpress.org/gerarde/) May 13, 2026 1 reply Probably the best Wordpress options editor out there, and the developer is super responsive to requests. He'd probably be an asset to any team he's on!! ![](https://secure.gravatar.com/avatar/2caa29980e7088baf00d62a1b65ebfc5568179618e9f28b121a90c949e6a55d5? s=60&d=retro&r=g) ### 󠀁[Simple & Effective!](https://wordpress.org/support/topic/simple-effective-225/)󠁿 [Akash Mia](https://profiles.wordpress.org/seakashdiu/) September 24, 2025 This plugin is super easy to use and does exactly what it promises. Clean interface, smooth performance, and really handy for managing options tables. Highly recommend! ![](https://secure.gravatar.com/avatar/eb5de3db5bfc8ef5845b4173265bf3d079f460fb99c9e346380b04d07bea8f05? s=60&d=retro&r=g) ### 󠀁[Useful Plugin](https://wordpress.org/support/topic/useful-plugin-1033/)󠁿 [Mehraz Morshed](https://profiles.wordpress.org/mehrazmorshed/) June 26, 2024 Useful for exploring Options Table without entering into the database! [ Read all 3 reviews ](https://wordpress.org/support/plugin/nhrrob-options-table-manager/reviews/) ## Contributors & Developers “NHR Advanced Options Table Manager & Autoload Optimizer” is open source software. The following people have contributed to this plugin. Contributors * [ Nazmul Hasan Robin ](https://profiles.wordpress.org/nhrrob/) [Translate “NHR Advanced Options Table Manager & Autoload Optimizer” into your language.](https://translate.wordpress.org/projects/wp-plugins/nhrrob-options-table-manager) ### Interested in development? [Browse the code](https://plugins.trac.wordpress.org/browser/nhrrob-options-table-manager/), check out the [SVN repository](https://plugins.svn.wordpress.org/nhrrob-options-table-manager/), or subscribe to the [development log](https://plugins.trac.wordpress.org/log/nhrrob-options-table-manager/) by [RSS](https://plugins.trac.wordpress.org/log/nhrrob-options-table-manager/?limit=100&mode=stop_on_copy&format=rss). ## Changelog #### 2.0.0 – 25/09/2026 * New: Complete React interface rewrite — a dashboard-first admin app with Dashboard, Browse, Optimize, Tools, Integrations, and Settings sections. The previous DataTables view stays available via the “Classic view” link. * New: Database Health Dashboard with a 0–100 score, stat cards, prioritized recommendations, and a recent-activity summary. * New: Activity tab — a searchable, filterable log of every change and who made it. * New: Unified Browse view for options, usermeta, postmeta, commentmeta, termmeta, and transients with sortable columns, owner filter, add, inline edit (structured serialized/JSON editing), bulk delete, and search. * New: Filter Browse’s postmeta/usermeta tabs to a single post or user via a type- ahead picker. * New: Autoload Usage Tracker — flags autoloaded options never used on front-end page loads; filter by usage and bulk-disable autoload for every unused option. * New: Transients Manager — size, expiration, status, and guessed owner for every transient; add, edit, and bulk delete. * New: Scheduled Backups & Snapshots of the wp_options table (manual, daily/weekly cron) with restore; automatic snapshot before Search & Replace and Import. * New: Options Table Analytics panel — every option grouped by name prefix with a row count. * New: Integrations tab for WP Recipe Maker and Better Payment tables. * New: REST API backend (nhrotm/v1) with centralized settings. * Improved: Search & Replace dry run now lists every matching option, and WordPress core cache/transient data is excluded by default. * Improved: Owner attribution and the Orphan Scanner are more accurate — real WordPress core options are no longer flagged as orphans, and hyphenated plugin prefixes are recognized. * Improved: Tools Import has a drag-and-drop file dropzone. * Fixed: The Orphan Scanner no longer flags data from active plugins it couldn’t match by folder name (WooCommerce’s `wc_`/`product_` options, Yoast SEO’s `wpseo_`/` yoast_`, the bundled Action Scheduler and Jetpack packages) or WordPress core’s` fresh_site`/`recovery_keys` as orphans. * Fixed: “Last backup” on the Dashboard showed the wrong age (measured from midnight of the backup day). * Improved: The plugin’s own settings no longer autoload on every front-end page load. * Fixed: Uninstall now removes every option the plugin creates. * Security: The Classic view’s orphan scan now requires a valid nonce and the ` manage_options` capability; it previously returned option-name prefixes to any logged-in user. * Security: Import skips WordPress core options and rejects values containing serialized PHP objects (other than plain stdClass), so a crafted import file can’t plant an object-injection payload. * Security: Search & Replace and snapshot/history restore no longer instantiate PHP classes when reading serialized option values. * Fixed: Searching the WP Recipe Maker ratings table in the Classic view caused a fatal error. * Security: The Classic view’s table queries now build sorting and search SQL only from whitelisted values and single prepared statements. * Developer: The whole PHP codebase now passes WordPress Coding Standards. * Developer: Renamed the menu capability filter from `nhrotm-options-table-manager/ menu/capability` to `nhrotm_menu_capability` to follow WordPress hook naming. If you filtered the old name, update your callback. #### 1.4.3 – 14/05/2026 * Enhancement: Add GitHub Actions workflow for automated plugin checks * Improvement: Improve input sanitization * Updated: Settings description for HTML preservation option #### 1.4.2 – 09/05/2026 * Fixed: Database error when history table was missing; added lazy table creation logic. #### 1.4.1 – 09/05/2026 * Few minor bug fixes & improvements #### 1.4.0 – 09/05/2026 * Added: “Allow HTML in Option Values” setting to preserve HTML tags when adding or editing options * Few minor bug fixing & improvements #### 1.3.0 – 30/01/2026 * Added: Export/Import feature allowing JSON configuration portability * Added: Global Search & Replace utility with safe serialization handling and Dry Run mode * Added: Orphaned Options Scanner to identifying bloat from uninstalled plugins * Added: Option History Pruning (Automated via Cron & Manual control) * Added: WP-CLI Support (`nhr-options list`, `nhr-options delete`) #### 1.2.0 – 19/01/2026 * Added: Option History & Rollback system with change tracking * Added: Autoload Health Check (Optimizer) with size analysis * Added: Automated Daily Cleanup for expired transients (via settings) * Rebuilt: Scalable Tab Architecture for robust third-party integration * Improved: Modern UI with toggle switches and polished card layouts * Fixed: Resolved empty results bug in Autoload Optimizer * Performance: Enhanced server-side DataTables processing #### 1.1.9 – 05/01/2026 * Added: Bulk delete options feature #### 1.1.8 – 30/11/2025 * WordPress tested up to version is updated to 6.9 * Few minor bug fixing & improvements #### 1.1.7 – 28/03/2025 * Added: Column search feature * Added: Filter by option type – option or transient * Added: Delete all expired transients button and functionality * Added: WP Recipe Maker tables (ratings, analytics, changelog) added. Props @abidhasan112 * Revamped: Codebase updated for better performance * WordPress tested up to version is updated to 6.8 * Few minor bug fixing & improvements #### 1.1.6 – 15/03/2025 * Fixed: Fatal error due to composer dev files * Few minor bug fixing & improvements #### 1.1.5 – 14/03/2025 * Added: Protected option and usermeta now having tooltip on edit and delete button * Added: Toast notification added replacing alert messages * Fixed: Fatal error due to PHPUnit vendor file missing * Fixed: Usermeta table pagination issue * Few minor bug fixing & improvements #### 1.1.4 – 12/03/2025 * Few minor bug fixing & improvements #### 1.1.3 – 09/03/2025 * Added: Security improvements * Few minor bug fixing & improvements #### 1.1.2 – 05/01/2025 * Added: Serialize data edit support. Props @mdnahidhasan * Few minor bug fixing & improvements * Happy New Year 2025! #### 1.1.1 – 13/11/2024 * Added: Usermeta table support added * Added: Modal close when clicked outside. Props @mdnahidhasan * Added: Edit, delete feature for usermeta table * Few minor bug fixing & improvements #### 1.1.0 – 30/10/2024 * Added: Serialize data support * Added: Showing all options regardless their autoload status * Revamped: Full DataTable revamped. Props @scriptertoufiq * Revamped: Add/Edit option using modal * Revamped: Options usage analytics * Few minor bug fixing & improvements #### 1.0.7 – 18/10/2024 * WordPress tested up to version is updated to 6.7 * Few minor bug fixing & improvements #### 1.0.6 – 26/07/2024 * WordPress tested up to version is updated to 6.6 * Few minor bug fixing & improvements #### 1.0.5 – 09/07/2024 * Added: Add new option feature. Now adding option becomes much easier directly from Dashboard. * Improved: JSON data are being saved now correctly without adding extra slashes. Props @hrrarya * Few minor bug fixing & improvements #### 1.0.4 – 07/07/2024 * Added: Edit feature to update existing options. Props @arrasel403 and @obayedmamur * Added: Delete feature to delete existing options. Props @mehrazmorshed * Few minor bug fixing & improvements #### 1.0.3 – 05/07/2024 * Added: Author URI updated using org profile. Props @jakariaistauk * Added: GitHub and Slack community links in readme. * Improved: Scroll bar added for very long contents in the table. Props @jakariaistauk * Improved: Table UI fully revamped. Now prefix count is shown using a table too. * Fixed: Settings page not shown as active after clicking from plugins page * Fixed: Menu design breaks for some plugins due to conflict with tailwind css. Props Md Toufiqul Islam (scriptertoufiq) * Fixed: Pagination select box spacing issue. Props Md Toufiqul Islam (scriptertoufiq) * Few minor bug fixing & improvements #### 1.0.2 – 30/06/2024 * Added: Settings page link on plugins page. Props @himadree12 * Fixed: Long text breaks design. Props @mehrazmorshed * Few minor bug fixing & improvements #### 1.0.1 – 26/06/2024 * Prefix updated * Few minor bug fixing & improvements #### 1.0.0 – 12/04/2024 * Initial beta release. Cheers! ## Meta * Version **2.0.0** * Last updated **4 days ago** * Active installations **100+** * WordPress version ** 6.0 or higher ** * Tested up to **7.1.2** * PHP version ** 7.4 or higher ** * Language * [English (US)](https://wordpress.org/plugins/nhrrob-options-table-manager/) * Tags * [autoload](https://vec.wordpress.org/plugins/tags/autoload/)[cleanup](https://vec.wordpress.org/plugins/tags/cleanup/) [database](https://vec.wordpress.org/plugins/tags/database/)[transients](https://vec.wordpress.org/plugins/tags/transients/) [wp_options](https://vec.wordpress.org/plugins/tags/wp_options/) * [Advanced View](https://vec.wordpress.org/plugins/nhrrob-options-table-manager/advanced/) ## Ratings 5 out of 5 stars. * [ 3 5-star reviews ](https://wordpress.org/support/plugin/nhrrob-options-table-manager/reviews/?filter=5) * [ 0 4-star reviews ](https://wordpress.org/support/plugin/nhrrob-options-table-manager/reviews/?filter=4) * [ 0 3-star reviews ](https://wordpress.org/support/plugin/nhrrob-options-table-manager/reviews/?filter=3) * [ 0 2-star reviews ](https://wordpress.org/support/plugin/nhrrob-options-table-manager/reviews/?filter=2) * [ 0 1-star reviews ](https://wordpress.org/support/plugin/nhrrob-options-table-manager/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/nhrrob-options-table-manager/reviews/#new-post) [See all reviews](https://wordpress.org/support/plugin/nhrrob-options-table-manager/reviews/) ## Contributors * [ Nazmul Hasan Robin ](https://profiles.wordpress.org/nhrrob/) ## Support Got something to say? Need help? [View support forum](https://wordpress.org/support/plugin/nhrrob-options-table-manager/)