{"slug":"goldt-webmcp-bridge","name":"GoldT WebMCP Bridge","description":"Bridge for 8 AI agents (Claude, ChatGPT, Grok, more) — powered by the Servio Protocol (aka WebMCP) with OAuth 2.0","author":"chagold","active_installs":10,"version":"1.2.4","wp_org_url":"https://wordpress.org/plugins/goldt-webmcp-bridge/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":true},"tables":[{"table_name":"aiconnect_token_registry","full_table_name":"wp_aiconnect_token_registry","description":"Stores access tokens for authentication or API access.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"token_prefix","type":"VARCHAR(16)","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"client_id","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"scope","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"issued_at","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"expires_at","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"last_used_at","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"revoked_at","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"revoked_by","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"source","type":"ENUM('generator','oauth','refresh')","nullable":false,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_aiconnect_token_registry ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, token_prefix VARCHAR(16) NOT NULL, user_id BIGINT(20) UNSIGNED NOT NULL, client_id VARCHAR(80) NOT NULL, scope VARCHAR(255) NOT NULL, issued_at BIGINT(20) UNSIGNED NOT NULL, expires_at BIGINT(20) UNSIGNED NOT NULL, last_used_at BIGINT(20) UNSIGNED DEFAULT NULL, revoked_at BIGINT(20) UNSIGNED DEFAULT NULL, revoked_by BIGINT(20) UNSIGNED DEFAULT NULL, source ENUM('generator','oauth','refresh') NOT NULL DEFAULT 'oauth', ip_address VARCHAR(45) DEFAULT NULL, PRIMARY KEY (id), KEY token_prefix (token_prefix), KEY user_id (user_id), KEY revoked_at (revoked_at) ) $charset_collate;\"; dbDelta( $sql_token_registry );"},{"table_name":"goldtwmcp_oauth_clients","full_table_name":"wp_goldtwmcp_oauth_clients","description":"Stores goldtwmcp oauth clients data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"client_id","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"client_name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"client_type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"redirect_uris","type":"TEXT","nullable":true,"primary_key":false},{"name":"allowed_scopes","type":"TEXT","nullable":true,"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(128)","nullable":false,"primary_key":false},{"name":"client_id","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"redirect_uri","type":"VARCHAR(500)","nullable":true,"primary_key":false},{"name":"code_challenge","type":"VARCHAR(128)","nullable":true,"primary_key":false},{"name":"code_challenge_method","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"scopes","type":"TEXT","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":"token","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"refresh_token","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"client_id","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"scopes","type":"TEXT","nullable":true,"primary_key":false},{"name":"expires_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"refresh_token_expires_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"revoked_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"token_prefix","type":"VARCHAR(16)","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"client_id","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"scope","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"issued_at","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"expires_at","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"last_used_at","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"revoked_at","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"revoked_by","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"source","type":"ENUM('generator','oauth','refresh')","nullable":false,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_goldtwmcp_oauth_clients ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, client_id VARCHAR(80) NOT NULL, client_name VARCHAR(255) NOT NULL, client_type VARCHAR(20) NOT NULL DEFAULT 'public', redirect_uris TEXT DEFAULT NULL, allowed_scopes TEXT DEFAULT NULL, 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;\"; $sql_codes = \"CREATE TABLE IF NOT EXISTS wp_goldtwmcp_oauth_codes ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, code VARCHAR(128) NOT NULL, client_id VARCHAR(80) NOT NULL, user_id BIGINT(20) UNSIGNED NOT NULL, redirect_uri VARCHAR(500) DEFAULT NULL, code_challenge VARCHAR(128) DEFAULT NULL, code_challenge_method VARCHAR(10) DEFAULT NULL, scopes TEXT 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 expires_at (expires_at), KEY client_id (client_id), KEY user_id (user_id) ) $charset_collate;\"; $sql_tokens = \"CREATE TABLE IF NOT EXISTS wp_goldtwmcp_oauth_tokens ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, token VARCHAR(255) NOT NULL, refresh_token VARCHAR(255) DEFAULT NULL, client_id VARCHAR(80) NOT NULL, user_id BIGINT(20) UNSIGNED NOT NULL, scopes TEXT DEFAULT NULL, expires_at DATETIME NOT NULL, refresh_token_expires_at DATETIME DEFAULT NULL, revoked_at DATETIME DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY token (token), UNIQUE KEY refresh_token (refresh_token), KEY user_id (user_id), KEY client_id (client_id), KEY expires_at (expires_at) ) $charset_collate;\"; $sql_token_registry = \"CREATE TABLE IF NOT EXISTS wp_aiconnect_token_registry ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, token_prefix VARCHAR(16) NOT NULL, user_id BIGINT(20) UNSIGNED NOT NULL, client_id VARCHAR(80) NOT NULL, scope VARCHAR(255) NOT NULL, issued_at BIGINT(20) UNSIGNED NOT NULL, expires_at BIGINT(20) UNSIGNED NOT NULL, last_used_at BIGINT(20) UNSIGNED DEFAULT NULL, revoked_at BIGINT(20) UNSIGNED DEFAULT NULL, revoked_by BIGINT(20) UNSIGNED DEFAULT NULL, source ENUM('generator','oauth','refresh') NOT NULL DEFAULT 'oauth', ip_address VARCHAR(45) DEFAULT NULL, PRIMARY KEY (id), KEY token_prefix (token_prefix), KEY user_id (user_id), KEY revoked_at (revoked_at) ) $charset_collate;\"; dbDelta( $sql_clients );"},{"table_name":"goldtwmcp_oauth_codes","full_table_name":"wp_goldtwmcp_oauth_codes","description":"Stores goldtwmcp oauth codes data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"goldtwmcp_oauth_tokens","full_table_name":"wp_goldtwmcp_oauth_tokens","description":"Stores access tokens for authentication or API access.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":4}