WordPress Database Table Prefixes

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

All in One WP Security

• aiowps_events
• aiowps_failed_logins
• aiowps__global_meta
• aiowps__login_activity
• aiowps__login_lockdown
• aiowps__permanent_block

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

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

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

WPDiscuz

• wc_avatars_cache
• wc_comments_subscription
• wc_feedback_forms
• wc_follow_users
• wc_phrases
• wc_users_rated
• wc_users_voted

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

YumPrint

• yumprint_recipe_recipe
• ymprint_recipe_theme
• yumprint_recipe_view