It can be frustrating when trying to clean up data from your WordPress database tables. Most of the time, a plugin or theme was removed years ago, and a clean uninstall wasn’t performed or available. This means there are left behind tables, and all you have to go on are vague names when trying to determine if they are safe to remove.
This usually results in hours of Googling. I’ve started this list to save you time narrowing down the source. I’ll make sure to keep adding to it as I work on a lot of WordPress sites, both my own and clients.
Clean up old database tables
Before we dive into the WordPress plugin and theme list, here are some tips on how to clean up old database tables. Make sure to take a backup of your WordPress site before continuing. I use the backup restore points at Kinsta which makes it super easy. This way if anything goes wrong I can roll back with a single click.
Clean uninstall (safest and easiest option)
Once you track down the plugin or theme, the easiest way is to check the developer’s site documentation and see if they have a clean uninstall option. If they do, you can temporarily install the plugin again and enable the option when removing it. This will remove the tables for you.
If it’s a premium-only plugin, you might not have access to it anymore. However, I’ve found that most developers are happy to give you the latest copy (.zip) without the license key if you need to run a clean uninstall.
Manually remove tables
The other alternative is to remove the tables from your WordPress database manually. Just follow the steps below. In this example, I’m removing the Affiliate Link Cloaker plugin’s tables.
Log in to phpMyAdmin at your host and look for the tables.
Select the tables and at the bottom click on “Drop” from the drop-down menu.
Click “Go” on the confirmation.
WordPress plugin or theme database table list
Below is a list of plugin and theme database tables, sorted alphabetically. Many of these are no longer maintained. But that isn’t unusual as plugins and themes come and go over the years.
Affilinker Link Plugin from BlashO
Affilinker was a WordPress plugin developed by BlashO to automatically convert the given keywords into affiliate links. Status: No longer maintained or supported.
Affiliate Link Cloaker
Affiliate Link Cloaker was a WordPress plugin developed by Joe Brewer that generates geo targetted cloaked affiliate links. Status: No longer maintained or supported.
Engagement Grower was a WordPress plugin that created a customizable related post section and allowed you to choose which content was recommended after each post. It performed automated A/B split testing to tell you exactly what was keeping your audience most engaged. Status: No longer maintained or supported.
Database tables (2.3 or higher)
Database 2.3 or below (deprecated)
The following tables were deprecated as of Gravity Forms 2.3 (source).
LifterLMS is a WordPress LMS plugin that makes it easy to create, sell, and protect engaging online courses and training based membership websites. They do have a constant to remove all LifterLMS data on plugin uninstall.
Monarch is a social sharing WordPress plugin developed by Elegant Themes. The following table is part of the statistics it features inside your WordPress dashboard.
NinjaForms is a popular free and premium WordPress contact form plugin. They do have a “Delete All Data” option.
Optin Revolution was a free WordPress Popup plugin that allowed you to customize an unlimited number of optins. It had a premium version with other features like A/B split testing.
Status: This plugin has been closed as of August 4, 2020 and is not available for download. Reason: Guideline Violation.
Redirection is a free WordPress plugin that lets you easily handle 301 redirects, keep track of 404 errors, and more on your site.
SEOPressor is a premium WordPress plugin with a host of customization & optimization features designed for controlling your site’s SEO.
Slider Revolution is a WordPress slider plugin. It helps beginner-and mid-level designers wow their clients with pro-level visuals.
Subscribe to Comments Reloaded
Subscribe to Comments Reloaded is a free robust WordPress plugin that enables commenters to sign up for e-mail notification of subsequent entries. This is developed currently by WPKube. It does have a clean uninstall option.
Thrive Leads is a popular premium lead generation plugin for WordPress developed by Thrive Themes.
WooCommerce is the world’s most popular open-source eCommerce solution for WordPress with over 5 million active installs. This is developed by Automattic. WooCommerce has a constant you can add to do a clean uninstall.
These are just a few of the tables inside of WooCommerce:
WP Email Capture
WP Email Capture allows you to set up a simple, double opt-in mailing list for your site which you control. It’s free but can be extended with premium extensions.
WPNeon GoCodes 2
GoCodes was a free WordPress plugin that let you create shortcut URLs to anywhere on the internet, right from your WordPress Admin. Status: No longer maintained or supported.
Yoast SEO is the most popular free SEO plugin for WordPress with over 5 million active installs. There is also a premium version with additional features.
If you’ve recently tracked down a plugin or theme’s database tables that I don’t have listed, please comment below with the details. I’d be happy to add it to the list.
And if you want to dive even deeper into cleaning up your database, check out how to clean up your wp_options table.