See a full list of database table prefixes for WordPress and popular plugins.
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
Zip Recipes
- amd_zlrecipe_recipes
Bad Behavior
- bad_behavior
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
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
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
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
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
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
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
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
Want to contribute to this project?
Contact me with your plugin name, link, and database table names or leave your comments below.
