wp_directrelay_keys
StaticStores directrelay keys data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| user_id | BIGINT UNSIGNED | NO |
| label | VARCHAR(191) | NO |
| description | TEXT | YES |
| environment | VARCHAR(20) | NO |
| agent_role | VARCHAR(50) | NO |
| daily_limit | INT UNSIGNED | NO |
| posts_today | INT UNSIGNED | NO |
| posts_today_date | DATE | YES |
| restrict_own_posts | TINYINT(1) | NO |
| require_approval | TINYINT(1) | NO |
| scopes | TEXT | NO |
| ip_whitelist | TEXT | YES |
| last_used_at | DATETIME | YES |
| last_used_ip | VARCHAR(45) | YES |
| expires_at | DATETIME | YES |
| total_requests | BIGINT UNSIGNED | NO |
| created_at | DATETIME | NO |
| revoked | TINYINT(1) | NO |
| revoked_at | DATETIME | YES |
CREATE TABLE Statement
CREATE TABLE wp_directrelay_keys ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT UNSIGNED NOT NULL, key_hash VARCHAR(191) NOT NULL, key_prefix CHAR(12) NOT NULL DEFAULT '', label VARCHAR(191) NOT NULL DEFAULT '', description TEXT DEFAULT NULL, environment VARCHAR(20) NOT NULL DEFAULT 'production', agent_role VARCHAR(50) NOT NULL DEFAULT 'full_access', daily_limit INT UNSIGNED NOT NULL DEFAULT 0, posts_today INT UNSIGNED NOT NULL DEFAULT 0, posts_today_date DATE DEFAULT NULL, restrict_own_posts TINYINT(1) NOT NULL DEFAULT 0, require_approval TINYINT(1) NOT NULL DEFAULT 0, scopes TEXT NOT NULL, ip_whitelist TEXT DEFAULT NULL, last_used_at DATETIME DEFAULT NULL, last_used_ip VARCHAR(45) DEFAULT NULL, expires_at DATETIME DEFAULT NULL, total_requests BIGINT UNSIGNED NOT NULL DEFAULT 0, created_at DATETIME NOT NULL, revoked TINYINT(1) NOT NULL DEFAULT 0, revoked_at DATETIME DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY uq_hash (key_hash), KEY idx_uid (user_id), KEY idx_prefix (key_prefix), KEY idx_agent_role (agent_role) ) $c;" );
Safe to delete?
If you have uninstalled DirectRelay – n8n WordPress Plugin: Workflow Automation, REST API, Webhooks & AI Agents, 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_directrelay_keys`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from DirectRelay – n8n WordPress Plugin: Workflow Automation, REST API, Webhooks & AI Agents