Database tables of 150+ WordPress plugins & themes (incl. cleaning instructions)

 Database tables of 150+ WordPress plugins & themes (incl. cleaning instructions)

        

Would you like to clean up your WordPress database and remove unused database tables?

Then you are right here!

In this article I have compiled the names of the database tables of 150+ plugins and themes.

This makes it easier for you to associate database tables with the respective plugins and themes they belong to or used to belong to and find those that you can delete.

1. How to use the list

So that you can get to your goal faster with the list and free your WordPress database of unnecessary tables, I have put together a small guide for you to use:

1.1 Create a database backup

Before you change anything in your database, you should always create a backup of it or make sure that your automatic backup is up to date!

Because it can always happen that you accidentally delete one or more wrong database tables.

1.2 Open PHPMyAdmin and your plugin list

Once you have created a backup, open your database in PHPMyAdmin and your plugin list in WordPress at the same time.

To open PHPMyAdmin, you need to log into your web host’s customer area and go to your databases. There you will usually also find a link to PHPMyAdmin.

In webgo’s webspace admin, for example, this is possible here:

If your hoster uses Plesk as the administration interface, you can find PHPMyAdmin here:

1.3 Search for the tables or plugins in the list

Next, step through your database tables to find tables that are no longer used.

All database tables that do not belong to WordPress’ own tables (see point 2) are potential candidates for deletion.

Copy out the table name (without the prefix) and search the name with STRG/CMD + Fhere in the article.

For example, in the following example, you could B. ewwwio_imagesSearch for in the list:

And if you are now using an image optimization plugin other than EWWW Image Optimizer, you can delete all the associated tables, i.e. and in our wp_ewww_images example wp_ewwwio_queue.

Alternatively, you can look for plugins at the bottom of the list that you know you once installed and no longer use, and then look in PHPMyAdmin for the appropriate tables.

1.4 Tip: Use Advanced Database Cleaner Pro

Step 1.2 and 1.3 are easier if you use Advanced Database Cleaner Pro . Because with it you can delete database tables directly in WordPress without having to log into PHPMyAdmin:

The plugin can also scan your database tables and assign them to your plugins.

In our example, it recognizes that the EWWW Image Optimizer tables do not belong to any installed plugin:

Please note that Advanced Database Cleaner Pro does not always map all database tables 100% correctly. It happens from time to time that database tables are assigned to the wrong plugin or recognized as “orphan!”, although they are actively used.

However, there is an option to set the mappings yourself using the bulk editing option “Edit categorization”, which can make it easier for you to maintain your database in the future.

For example, for the following three tables from Real Cookie Banner, which the scanner could not assign correctly or with 100% certainty:

2. WordPress native tables

The following tables are created by default with every WordPress installation:

• commentmeta
• comments
• Left
• options
• postmeta
• posts
• termmeta
• terms
• term_relationships
• term_taxonomy
• usermeta
• users

3. Plugin tables

The following database tables are created by WordPress plugins. The list is ordered by plugin name:

plugin	database tables
AAWP	aawp_lists aawp_products
Action Scheduler (standalone tool but also used by Rank Math)	actionscheduler_actions actionscheduler_claims actionscheduler_groups actionscheduler_logs
Affiliate Coupons	affcoups_stats
All-in-one SEO	aioseo_notifications aioseo_posts
All in One WP Security	aiowps_events aiowps_failed_logins aiowps__global_meta aiowps__login_activity aiowps__login_lockdown aiowps__permanent_block
Any comment	anycomment_email_queue anycomment_likes anycomment_rating anycomment_subscriptions anycomment_uploaded_files
Avatar Privacy	avatar_privacy avatar_privacy_hashes
Amazon Super Assistant (ASA 1)	asa_collection asa_collection_item
ASA 2 Pro	asa2_api_stats asa2_associate_id_set asa2_collections asa2_collections_items asa2_feeds asa2_images asa2_log asa2_proxies asa2_ratings asa2_repo_meta asa2_repo_notifications asa2_repo_queue asa2_shop2tax asa2_templates asa2_tpltranslation
Bloom	et_bloom_stats
Borlabs Cookie	borlabs_cookie_blocked_content_types borlabs_cookie_consent_log borlabs_cookie_content_blocker borlabs_cookie_cookies borlabs_cookie_groups borlabs_cookie_script_blocker borlabs_cookie_statistics
Broken link checker	blc_filters blc_instances blc_links blc_synch
Broken link status checker	wplnst_scans wplnst_scans_objects wplnst_urls wplinst_urls_locations wplnst_urls_locations_att wplnst_urls_status
Code snippets	ms_snippets
compliance	cmplz_cookiebanners cmplz_cookies cmplz_dnsmpd cmplz_services cmplz_statistics
Cookie Law Info (CookieYes)	cli_cookie_scan cli_cookie_scan_categories cli_cookie_scan_cookies cli_cookie_scan_url cli_scripts
Crelly Slider	crellyslider_elements crellyslider_nonces crellyslider_sliders crellyslider_slides
CSS & JavaScript Toolbox	cjtoolbox_authors cjtoolbox_backups cjtoolbox_blocks cjtoolbox_block_files cjtoolbox_block_pins cjtoolbox_block_templates cjtoolbox_forms cjtoolbox_form_groups cjtoolbox_form_group_parameters cjtoolbox_form_group_xfields cjtoolbox_packages cjtoolbox_package_objects cjtoolbox_parameters cjtoolbox_parameter_typedef cjtoolbox_parameter_typeparams cjtoolbox_plus_block_pintype cjtoolbox_templates cjtoolbox_template_revisions
Data Tables Generator by Supsystic	supsystic_tbl_columns supsystic_tbl_diagrams supsystic_tbl_rows supsystic_tbl_tables
Digimember	digimember_action digimember_action_out_queue digimember_apilog digimember_autoresponder digimember_config_store digimember_counter digimember_download digimember_exam digimember_exam_answer digimember_exam_certificate digimember_has_preview_cache digimember_ipn_in_log digimember_ipn_out_queue digimember_ip_counter digimember_ip_lock digimember _ip_log digimember_lock digimember_log digimember_loginkey digimember_mail_text digimember_notifier_queue digimember_one_time_login digimember_page_product digimember_payment digimember_product digimember_server_cookie digimember_session_store digimember_timer digimember_user digimember_user_product digimember_user_settings digimember_webhook digimember_webpush_message digimember_webpush_queue digimember_webpush_settings digimember_webpush_subscription
Easy appointments	ea_error_logs
Easy Social Icons	cn_social_icon
Easy Update Manager	eum_logs
Elementor Pro (Forms)	e_submissions e_submissions_actions_log e_submissions_values
Everest Forms	evf_entries evf_entrymeta evf_sessions
EWWW Image Optimizer	ewwwio_images ewwwio_queue
Ez Shape Calculator	ezfc_debug ezfc_files ezfc_forms ezfc_forms_elements ezfc_forms_options ezfc_forms_views ezfc_options ezfc_preview ezfc_submissions ezfc_templates
Ezoic	ezoic_endpoints
Facebook comments importer	fb_comments_image_data
FeedStats de	fs_data fs_visits
Fluent Forms	ff_scheduled_actions fluentform_draft_submissions fluentform_entry_details fluentform_forms fluentform_form_analytics fluentform_form_meta fluentform_logs fluentform_order_items fluentform_submissions fluentform_submission_meta fluentform_subscriptions fluentform_transactions
FooGallery	gallery_albums gallery_pics gallery_settings
Formcraft	formcraft_b_forms formcraft_b_submissions formcraft_b_views
Formidable Forms	frm_fields frm_forms frm_items frm_item_metas
forminator	frmt_form_entry frmt_form_entry_meta frmt_form_views
Shape Maker	formmaker formmaker_backup formmaker_blocked formmaker_cookies formmaker_display_options formmaker_groups formmaker_query formmaker_sessions formmaker_submits formmaker_themes formmaker_views
FV Gravatar Cache	gravatars
FV Player	fv_fp_hls_access_tokens fv_player_players fv_player_videometa fv_player_videos
DG rating system	gdrts_cache gdrts_itemeta gdrts_items gdrts_items_basic gdrts_logmeta gdrts_logs
Gravity Forms	gf_addon_feed gf_draft_submissions gf_entry gf_entry_meta gf_entry_notes gf_form gf_form_meta gf_form_revisions gf_form_view rg_form rg_form_meta rg_form_view rg_incomplete_submissions rg_lead rg_lead_detail rg_lead_detail_long rg_lead_met a rg_lead_notes
Header Footer Code Manager	hfcm_scripts
HTML Forms	hf_submissions
Hustle	hustle_entries hustle_entries_meta hustle_modules hustle_modules_meta hustle_tracking
ImagePress	ip_collectionmeta ip_collections
imageify	imagify_files imagify_folders
Insights from Google PageSpeed	gpi_page_blacklist gpi_page_reports gpi_page_stats
iThemes Security	itsec_lockouts itsec_log itsec_temp
JC Coupon	jcorgcr_categories jcorgcr_coupons
Koko Analytics	koko_analytics_post_stats koko_analytics_referrer_stats koko_analytics_referrer_urls koko_analytics_site_stats
Layer slider	layerslider layerslider_revisions
linkwhisper	wpil_broken_links wpil_click_data wpil_ignore_links wpil_keywords wpil_keyword_links wpil_keyword_select_links wpil_report_links wpil_target_keyword_data wpil_urls wpil_url_links
Login lockdown	lockdowns login_fails
MailChimp for WordPress	mc4wp_log
MailOptin	mo_campaign_log mo_campaign_logmeta mo_conversions mo_email_campaignmeta mo_email_campaigns mo_optin_advance_stat mo_optin_campaignmeta mo_optin_campaigns
MailPoet (including old Wysija tables)	mailpoet_custom_fields mailpoet_dynamic_segment_filters mailpoet_feature_flags mailpoet_forms mailpoet_log mailpoet_mapping_to-external_entities mailpoet_newsletters mailpoet_newsletter_links mailpoet_newsletter_option mailpoet_newsletter_option_fields mailpoet_newsletter_posts mailpoet_newsletter_segment mailpoet_newsletter_templates mailpo et_scheduled_tasks mailpoet_scheduled_task_subscribers mailpoet_segments mailpoet_sending_queues mailpoet_settings mailpoet_statistics_clicks mailpoet_statistics_forms mailpoet_statistics_newsletters mailpoet_statistics_opens mailpoet_statistics_unsubscribes mailpoet_statistic_woocommerce_purchases mailpoet_stats_notifications mailpoet_subscribers mailpoet_subscriber_custom_field mailpoet_subscriber_ips mailpoet_subscriber_segment mailpoet_user_flags wysija_campaign wysija_campaign_list wysija_custom_field wysija_email wysija _email_user_stat wysija_email_user_url wysija_form wysija_list wysija_queue wysija_subscriber_ips wysija_url wysija_url_mail wysija_user wysija_user_field wysija_history wysija_list
MainWP Dashboard	mainwp_action_log mainwp_bulk_settings_manager_entries mainwp_bulk_settings_manager_previews mainwp_bulk_settings_manager_rings mainwp_bulk_settings_manager_rings_to_entry mainwp_client_report mainwp_client_report_client mainwp_client_report_format mainwp_client_report_site_token mainwp_client_report_token mainwp_domain_monitor mainwp_extract_urls_template mainwp_group mainwp_lighthouse mainwp_maintenance_schedule mainwp_pro_reports mainwp_pro_reports_content mainwp_pro_reports_site_token mainwp_pro_reports_token mainwp_request_log mainwp_tips mainwp_uptime_monitor_urls mainwp_uptime_stats_betteruptime mainwp_uptime_stats_nodeping mainwp_uptime_stats_site24x7 mainwp_uptime_stats_uptimerobot mainwp_uptime_url_options mainwp_users mainwp_vulnerability_checker mainwp_wp mainwp_wp_backup mainwp_wp_backup_progress mainwp_wp_group mainwp _wp_options mainwp_wp_settings_backup mainwp_wp_status mainwp_wp_sync
Master Slider	masterslider_options masterslider_sliders
Matomo	matomo_access matomo_archive_invalidations matomo_archive_numeric_2022_04 matomo_brute_force_log matomo_custom_dimensions matomo_goal matomo_locks matomo_logger_message matomo_log_action matomo_log_conversion matomo_log_conversion_item matomo_log_link_visit_action matomo_log_profiling matomo_log_visit matomo_option matomo_plugin_setting matomo_privacy_logdata_anonymizations matomo_report matomo_report_subscriptions matomo_segment matomo_sequence matomo_session matomo_site matomo_site_setting matomo_site_url matomo_tagmanager_container matomo_tagmanager_container_release matomo_tagmanager_container_version matomo_tagmanager_tag matomo_tagmanager_trigger matomo_tagmanager_variable matomo_tracking_failure matomo_twofactor_recovery_code matomo_user matomo_user_dashboard matomo_user_language matomo_user_token_auth
Media Cleaner	mclean_refs mclean_scan
Mediavine Create	mv_creations mv_images mv_nutrition mv_products mv_products_map mv_relations mv_reviews mv_revisions mv_settings mv_shapes mv_supplies
MemberPress	mepr_events mepr_jobs mepr_members mepr_rule_access_conditions mepr_subscriptions mepr_tax_rates mepr_tax_rate_locations mepr_transactions mepr_transaction_meta
monarch	et_social_stats
Multi Rating	mr_rating_item mr_rating_item_entry mr_rating_item_entry_value mr_rating_subject
NextGEN Gallery	ngg_album ngg_gallery ngg_pictures
NextScripts	nxs_log nxs_query
Ninja Forms	nf3_actions nf3_action_meta nf3_chunks nf3_fields nf3_field_meta nf3_forms nf3_form_meta nf3_objects nf3_object_meta nf3_relationships nf3_upgrades
Ninja Tables Pro	ninja_table_items
Novashare	novashare_meta
Opt In Panda	opanda_leads opanda_leads_fields opanda_stats_v2
Portfolio post type	crp_portfolios crp_projects
pretty left	prli_clicks prli_groups prli_links prli_link_metas
ProfilePress	ppress_coupons ppress_customers ppress_forms ppress_formsmeta ppress_meta_data ppress_ordermeta ppress_orders ppress_plans ppress_sessions ppress_subscriptions
Prosodia VGW OS	wpvgw_markers wpvgw_posts_extras
rank math	rank_math_404_logs rank_math_analytics_ga rank_math_analytics_gsc rank_math_analytics_keyword_manager rank_math_analytics_objects rank_math_internal_links rank_math_internal_meta rank_math_redirections rank_math_redirections_cache rank_math_sc_analytics
Rate my post	rmp_analytics
Real cookie banners	rcb_asset_seo_redirect rcb_blocker_thumbnails rcb_consent rcb_presets rcb_revision rcb_revision_independent rcb_scan rcb_scan_markup rcb_stats rcb_tcf_features rcb_tcf_purposes rcb_tcf_special_features rcb_tcf_special_purposes rcb_tcf_ stacks rcb_tcf_vendors real_queue
redirection	redirection_404 redirection_groups redirection_items redirection_logs redirection_modules
ReviewX	reviewx_criterias reviewx_import_history reviewx_process_jobs reviewx_reminder_email
RevSlider	revslider_css revslider_layer_animations revlider_navigations revslider_sliders revslider_slides revslider_static_slides
Simple:Press	sfadversaries sfauthcats sfauths sfbuddies sfcache sfdefpermissions sferrorlog sfforums sfgroups sflog sflogmeta sfmembers sfmemberships sfmeta sfnotices sfoptions sfpermissions sfpmattachments sfpmmessages sfpmrecipients sfpmthreads sfpolls sfpollsanswers sfpollsvoters sfpostattachments sfposts sfroles sfspecialranks sftagmeta sftags sftopics sftrack sfuseractivity sfusergroups sfwaiting sfwarnings
shortpixel	shortpixel_folders shortpixel_meta
Slider revolution	revslider_css revslider_layer_animations revslider_settings revslider_sliders revslider_slides revslider_static_slides
Slider WD	wdslayer wdsslide wdsslider
Smart sliders	nextend2_image_storage nextend2_section_storage nextend2_smartslider3_generators nextend2_smartslider3_sliders nextend2_smartslider3_sliders_xref nextend2_smartslider3_slides
Smash Balloon Instagram Feed	sbi_feeds sbi_feed_caches sbi_instagram_feeds_posts sbi_instagram_feed_locator sbi_instagram_posts sbi_sources
smushit	smush_dir_images
Social Share Buttons by Supsystic	supsystic_ss_networks supsystic_ss_projects supsystic_ss_project_networks supsystic_ss_shares supsystic_ss_views
Spyder Spanker	spyders_ip_cache spyders_live
Subscribe to Comments Reloaded	subscribe_reloaded_subscribers
Survey Slam	svs_submits
Swift Performance	swift_performance_warmup
Tablesome	tablesome_records tablesome_table_0 tablesome_table_827
Thirsty Affiliates	ta_link_clicks ta_link_clicks_meta
Thrive Apprentice	tva_ipn_log tva_orders tva_order_items tva_transactions
Thrive Architect	tcb_api_error_log tcb_lp_templates
ThriveComments	tcm_email_hash tcm_logs
Thrive Headline Optimizer	tho_event_log tho_tests tho_test_items
trip leads	tve_leads_contacts tve_leads_contact_download tve_leads_event_log tve_leads_form_variations tve_leads_group_options tve_leads_saved_group_options tve_leads_split_test tve_leads_split_test_items td_fields td_groups
Thrive ovation	tvo_activity_log
Thrive Quiz Builder	tqb_event_log tqb_results tqb_results_links tqb_tests tqb_tests_items tqb_users tqb_user_answers tqb_variations
Thrive Ultimatum	tve_ult_designs tve_ult_emails tve_ult_events tve_ult_event_log tve_ult-settings_campaign tve_ult_settings_templates
Toolkit for Elementor	toolkit_gtmetrix
Uji countdown	uji_counter uji_subscriptions
Visitor Traffic Real Time Statics	ahc_browsers ahc_countries ahc_daily_visitors_stats ahc_hits ahc_keywords ahc_online_users ahc_recent_visitors ahc_refering_sites ahc_searchng_visits ahc_search_engines ahc_search_engine_crawlers ahc_settings ahc_title_traffic ach_visitors ahc_visits _time
weForms	weforms_entries weforms_entrymeta
WooCommerce	wc_admin_notes wc_admin_note_actions wc_category_lookup wc_customer_lookup wc_download_log wc_order_coupon_lookup wc_order_product_lookup wc_order_stats wc_order_tax_lookup wc_product_attributes_lookup wc_product_download_directories wc_product_meta_lookup wc_rate_limits wc_reserved_stock wc_tax_ rate_classes wc_webhooks woocommerce_api_keys woocommerce_attribute_taxonomies woocommerce_downloadable_product_permissions woocommerce_log woocommerce_order_itemmeta woocommerce_order_items woocommerce_payment_tokenmeta woocommerce_payment_tokens woocommerce_sessions woocommerce_shipping_zones woocommerce_shipping_zone_locations woocommerce_shipping_zone_methods woocommerce_tax_rates woocommerce_tax_rate_locations
Wordfence	wfBlockedIPLog wfBlocks7 wfConfig wfCrawlers wfFileChanges wfFileMods wfHits wfHoover wfissues wfKnownFileList wfLiveTrafficHuman wfLocs wfLogins wfls_2fa_secrets wfls_settings wfNotifications wfPendingIssues wfReverseCache wfSNIPCache wfTrafficRates
WordLift	wl_mapping wl_mapping_property wl_mapping_rule wl_mapping_rule_group wl_relation_instances
WordPress advanced bulk edit	wpmelon_wadvbedit_temp
WordPress file upload	wfu_dbxqueue wfu_log wfu_userdata
WP All Export	pmxe_exports pmxe_google_cats pmxe_posts pmxe_templates
WPBackItUp	wpfm_backup
WP Business Directory Pro	wpbdp_fees wpbdp_form_fields wpbdp_listing_fees wpbdp_payments wpbdp_payments_items wpbdp_submit_state
wpDataTables	wpdatatables wpdatatables_columns wpdatatables_rows wpdatatable_1 wpdatatable_2
wpDiscuz	wc_avatars_cache wc_comments_subscription wc_feedback_forms wc_follow_users wc_phrases wc_users_rated wc_users_voted
WP Download Manager	ahm_assets ahm_country ahm_coupons ahm_download_stats ahm_emails ahm_licenses ahm_orders ahm_order_items ahm_order_renews ahm_payment_methods ahm_refunds ahm_withdraws
wp hosting performance check	webpages_data
WPML	icl_cms_nav_cache icl_content_status icl_core_status icl_flags icl_languages ​​icl_languages_translations icl_locale_map icl_message_status icl_mo_files_domains icl_node icl_reminders icl_strings icl_string_batches icl_string_packages icl_string_pages ic l_string_positions icl_string_status icl_string_translations icl_string_urls icl_translate icl_translate_job icl_translations icl_translation_batches icl_translation_downloads icl_translation_status
WP Optimize	wpai_blocks wpai_settings
WP Recipe Maker	wprm_analytics wprm_ratings
WP Reviews	mts_wp_reviews
WP Rocket	wpr_rucss_resources wpr_rucss_used_css
WP RSS Aggregator	wprss_logs
WP Search Insights	searchinsights_archive searchinsights_single
WP Security Audit	wsal_metadata wsal_occurrences wsal_options
wpSEO	WP_SEO_404_links WP_SEO_Cache WP_SEO_Redirection WP_SEO_Redirection_LOG
WP staging	wpstg_queue
WPStatistics	statistics_exclusions statistics_historical statistics_pages statistics_search statistics_useronline statistics_visit statistics_visitor statistics_visitor_relationships
WP ULike	ulike ulike_activities ulike_comments ulike_forums ulike_meta
XML sitemap generator	xsg_sitemap_meta
Yoast	yoast_indexable yoast_indexable_hierarchy yoast_migrations yoast_primary_term yoast_seo_links yoast_seo_meta
YARPP – Yet Another Related Posts Plugin	yarpp_related_cache
YASR – Yet Another Stars Rating	yasr_log yasr_log_multi_set yasr_multi_set yasr_multi_set_fields yasr_multi_values
YoastSEO	yoast_indexable yoast_indexable_hierarchy yoast_migrations yoast_primary_term yoast_prominent_words yoast_seo_links yoast_seo_meta
YOP Poll	yop2_pollmeta yop2_polls yop2_poll_answermeta yop2_poll_answers yop2_poll_bans yop2_poll_custom_fields yop2_poll_logs yop2_poll_questionmeta yop2_poll_questions yop2_poll_results yop2_poll_templates yop2_poll_vo tes_custom_fields pollsa pollsip pollsq
YumPrint	yumprint_recipe_recipe yumprint_recipe_theme yumprint_recipe_view
Zip Recipes	amd_zlrecipe_recipes

3. Theme Tables

The following database tables are created by WordPress themes:

theme	database tables
affiliatetheme.io	aws_feed at_price_trend
avada	fusion_forms fusion_form_entries fusion_form_fields fusion_form_submissions

FAQ

Here I have compiled answers to frequently asked questions about the WordPress database: