See a full list of database table prefixes for WordPress and popular plugins.
Want to contribute to this project?
Contact me with your plugin name, link, and database table names.
Standard WordPress Tables
The following tables are created during a new WordPress installation.
- commentmeta
- comments
- links
- options
- postmeta
- posts
- termmeta
- terms
- term_relationships
- term_taxonomy
- usermeta
- users
Plugin Tables
Following are the tables created by popular plugins.
They are listed in alphabetical order according to the table prefix name, not the plugin name.
Visitors 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
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
Zip Recipes
- amd_zlrecipe_recipes
Bad Behavior
- bad_behavior
Contact Form 7
(only prefix listed at this time, not full list of tables)
- contact_form_7
Portfolio Post Type
- crp_portfolios
- crp_projects
Easy Appointments
- ea_error_logs
Easy Updates Manager
- eum_logs
EWWW
- ewwwio_images
Formidable
- frm_fields
- frm_forms
- frm_items
- frm_item_metas
FooGallery
- gallery_albums
- gallery_pics
- gallery_settings
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
- icl_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
ImagePress
- ip_collectionmeta
- ip_collections
iThemes Security
- itsec_lockouts
- itsec_log
- itsec_temp
Login Lockdown
- lockdowns
- login_fails
MailPoet (also see wysija below)
- 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
- mailpoet_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
MainWP
- mainwp_client_report
- mainwp_client_report_client
- mainwp_client_report_format
- mainwp_client_report_site_token
- mainwp_client_report_token
- mainwp_group
- mainwp_request_log
- mainwp_tips
- mainwp_users
- mainwp_wp
- mainwp_wp_backup
- mainwp_wp_backup_progress
- mainwp_wp_group
- mainwp_wp_options
- mainwp_wp_settings_backup
- mainwp_wp_sync
Media Cleaner
- mclean_ref
- mclean_scan
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
Code Snippets
- ms_snippets
WP Reviews
- mts_wp_reviews
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
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
WP All Export
- pmxe_exports
- pmxe_google_cats
- pmxe_posts
- pmxe_templates
Pretty Links
- prli_clicks
- prli_groups
- prli_links
- prli_link_metas
Redirection
- redirection_404
- redirection_groups
- redirection_items
- redirection_logs
Redirections
- redirection_modules
RevSlider
- revslider_css
- revslider_layer_animations
- revlider_navigations
- revslider_sliders
- revslider_slides
- revslider_static_slides
Smash Balloon Instagram Feed
- sbi_instagram_feeds_posts
- sbi_instagram_posts
SmushIt
- smush_dir_images
Subscribe to Comments Reloaded
- subscribe_reloaded_subscribers
Social Share Buttons by Supsystic
- supsystic_ss_networks
- supsystic_ss_projects
- supsystic_ss_project_networks
- supsystic_ss_shares
- supsystic_ss_views
Swift Performance
- swift_performance_warmup
Thrive Architect
- tcb_api_error_log
- tcb_lp_templates
Thrive Comments
- tcm_email_hash
- tcm_logs
Thrive Quiz Builder (TGE)
(Note: this plugin uses 2 different database table prefixes. See the TQB tables below)
- Tge_answers
- tge_questions
Thrive Headline Optimizer
- tho_event_log
- tho_tests
- tho_test_items
Thank Me Later
(only prefix listed at this time, not full list of tables)
- tml_xxx
Thrive Quiz Builder (TQB)
(Note: this plugin uses 2 different database table prefixes. See the TGE tables above)
- tqb_event_log
- tqb_results
- tqb_results_links
- tqb_tests
- tqb_tests_items
- tqb_users
- tqb_user_answers
- tqb_variations
Thrive Apprentice
- tva_ipn_log
- tva_orders
- tva_order_items
- tva_transactions
Thrive 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
Thrive Ultimatum
- tve_ult_designs
- tve_ult_emails
- tve_ult_events
- tve_ult_event_log
- tve_ult-setings_campaign
- tve_ult_settings_templates
Thrive Ovation
- tvo_activity_log
Toolkit for Elementor
- toolkit_gtmetrix
Uji Countdown
- uji_counter
- uji_subscriptions
Wordfence
- wfBlockedIPLog
- wfBlocks7
- wfConfig
- wfCrawlers
- wfFileChanges
- wfFileMods
- wfHits
- wfHoover
- wfissues
- wfKnownFileList
- wfLiveTrafficHuman
- wfLocs
- wfLogins
- wfls_2fa_secrets
- wfls_settings
- wfNotifications
- wfPendingIssues
- wfReverseCache
- wfSNIPCache
- wfTrafficRates
WP Optimize
- wpai_blocks
- wpai_settings
WP Business Directory Pro
- wpbdp_fees
- wpbdp_form_fields
- wpbdp_listing_fees
- wpbdp_payments
- wpbdp_payments_items
- wpbdp_submit_state
WPRC – old installer for WPML
- wprc
WP RSS Aggregator
- wprss_logs
WYSIJA (from MailPoet, see above)
- 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
Broken Link Status Checker
- wplnst_scans
- wplnst_scans_objects
- wplnst_urls
- wplinst_urls_locations
- wplnst_urls_locations_att
- wplnst_urls_status
WP Security Audit
- wsal_metadata
- wsal_occurrences
- wsal_options
Yoast SEO – free version
- yoast_indexable
- yoast_indexable_hierarchy
- yoast_migrations
- yoast_primary_term
- yoast_se_links
- yoast_seo_meta
WordPress developers gonna love this.
I hope so!!! Help me spread the word that it’s available. And maybe they can also contribute a list of the tables they come across too.
Thank You Very Much. Lord it’s nice to have this is one place. Please grow the list!
I have all sorts of things like this available for my Webmaster Training members.
Made this one public to encourage more devs to contribute to it and help all of us!