{"slug":"born-creative-mcp-server","name":"Born Creative MCP Server","description":"A remote MCP server over HTTP with OAuth 2.1, letting AI assistants like Claude securely create, update, and schedule WordPress content.","author":"jonathansblog","active_installs":0,"version":"0.0.6","wp_org_url":"https://wordpress.org/plugins/born-creative-mcp-server/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"born_mcp_oauth_clients","full_table_name":"wp_born_mcp_oauth_clients","description":"Stores born mcp oauth clients data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"client_id","type":"VARCHAR(128)","nullable":false,"primary_key":false},{"name":"client_secret_hash","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"client_name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"redirect_uris","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"grant_types","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"code","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"client_id","type":"VARCHAR(128)","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"redirect_uri","type":"TEXT","nullable":false,"primary_key":false},{"name":"scope","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"code_challenge","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"code_challenge_method","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"expires_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"used_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"access_token_hash","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"refresh_token_hash","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"client_id","type":"VARCHAR(128)","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"scope","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"access_token_expires_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"refresh_token_expires_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"revoked","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"session_id","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"token_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"last_activity_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"expires_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_born_mcp_oauth_clients` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `client_id` VARCHAR(128) NOT NULL, `client_secret_hash` VARCHAR(255) DEFAULT NULL, `client_name` VARCHAR(255) NOT NULL DEFAULT '', `redirect_uris` LONGTEXT NOT NULL, `grant_types` VARCHAR(255) NOT NULL DEFAULT 'authorization_code,refresh_token', `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `client_id` (`client_id`) ) $charset_collate;\"; // Authorization codes $sql[] = \"CREATE TABLE IF NOT EXISTS `wp_born_mcp_oauth_codes` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `code` VARCHAR(255) NOT NULL, `client_id` VARCHAR(128) NOT NULL, `user_id` BIGINT UNSIGNED NOT NULL, `redirect_uri` TEXT NOT NULL, `scope` VARCHAR(255) NOT NULL DEFAULT '', `code_challenge` VARCHAR(255) DEFAULT NULL, `code_challenge_method` VARCHAR(10) DEFAULT NULL, `expires_at` DATETIME NOT NULL, `used_at` DATETIME DEFAULT NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `code` (`code`), KEY `client_id` (`client_id`) ) $charset_collate;\"; // Access and refresh tokens $sql[] = \"CREATE TABLE IF NOT EXISTS `wp_born_mcp_oauth_tokens` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `access_token_hash` VARCHAR(255) NOT NULL, `refresh_token_hash` VARCHAR(255) DEFAULT NULL, `client_id` VARCHAR(128) NOT NULL, `user_id` BIGINT UNSIGNED NOT NULL, `scope` VARCHAR(255) NOT NULL DEFAULT '', `access_token_expires_at` DATETIME NOT NULL, `refresh_token_expires_at` DATETIME DEFAULT NULL, `revoked` TINYINT(1) NOT NULL DEFAULT 0, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `access_token_hash` (`access_token_hash`), KEY `refresh_token_hash` (`refresh_token_hash`), KEY `client_id` (`client_id`) ) $charset_collate;\"; // MCP sessions $sql[] = \"CREATE TABLE IF NOT EXISTS `wp_born_mcp_sessions` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `session_id` VARCHAR(255) NOT NULL, `user_id` BIGINT UNSIGNED NOT NULL, `token_id` BIGINT UNSIGNED NOT NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `last_activity_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `expires_at` DATETIME NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `session_id` (`session_id`), KEY `user_id` (`user_id`) ) $charset_collate;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ( $sql as $query ) { dbDelta( $query );"},{"table_name":"born_mcp_oauth_codes","full_table_name":"wp_born_mcp_oauth_codes","description":"Stores born mcp oauth codes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"born_mcp_oauth_tokens","full_table_name":"wp_born_mcp_oauth_tokens","description":"Stores access tokens for authentication or API access.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"born_mcp_sessions","full_table_name":"wp_born_mcp_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":4}