wp_semantic_analyses
StaticStores semantic analyses data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) UNSIGNED | NO |
| post_id | bigint(20) UNSIGNED | NO |
| phase | varchar(20) | NO |
| status | varchar(20) | NO |
| content_analysis | longtext | YES |
| summary | text | YES |
| citable_snippet | text | YES |
| llm_tags | text | YES |
| author_credentials | text | YES |
| audience | text | YES |
| compact_howto | text | YES |
| summaries | longtext | YES |
| llm_context_block | longtext | YES |
| llm_title | text | YES |
| llm_description | text | YES |
| content_sections | longtext | YES |
| cleaned_content | longtext | YES |
| primary_topic_entity | varchar(255) | YES |
| page_type | varchar(50) | YES |
| primary_intent | varchar(255) | YES |
| secondary_intents | longtext | YES |
| user_stage | varchar(50) | YES |
| difficulty | varchar(50) | YES |
| entity_relationships | longtext | YES |
| external_job_id | varchar(255) | YES |
| error_message | text | YES |
| started_at | datetime | YES |
| finished_at | datetime | YES |
| created_at | datetime | NO |
| updated_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_semantic_analyses ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, post_id bigint(20) UNSIGNED NOT NULL, phase varchar(20) NOT NULL DEFAULT 'full', status varchar(20) NOT NULL DEFAULT 'pending', content_analysis longtext, summary text, citable_snippet text, llm_tags text, author_credentials text, audience text, compact_howto text, summaries longtext, llm_context_block longtext, llm_title text, llm_description text, content_sections longtext, cleaned_content longtext, primary_topic_entity varchar(255), page_type varchar(50), primary_intent varchar(255), secondary_intents longtext, user_stage varchar(50), difficulty varchar(50), entity_relationships longtext, external_job_id varchar(255), error_message text, started_at datetime, finished_at datetime, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY post_id (post_id), KEY status (status) ) $charset;" );
Safe to delete?
If you have uninstalled AI Data Layer – AI SEO & AI Search Optimization: llms.txt, MCP Server, Schema (AEO/GEO), this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_semantic_analyses`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AI Data Layer – AI SEO & AI Search Optimization: llms.txt, MCP Server, Schema (AEO/GEO)