README · SQLite Schema · n8n-io/n8n · Skills Docs

README · SQLite Schema · n8n-io/n8n · Skills Docs

Name	Columns	Comment	Type
activity_event	11		table
agent_background_job	25		table
agent_budget_applied_call	2		table
agent_budget_spend	4		table
agent_channel_status	11		table
agent_chat_attachments	13		table
agent_chat_subscriptions	6		table
agent_checkpoints	7		table
agent_credential_dependency	3		table
agent_eval_dataset	10		table
agent_eval_rating	8		table
agent_eval_result	16		table
agent_eval_run	14		table
agent_execution	28		table
agent_execution_message_links	5		table
agent_execution_threads	20		table
agent_file_grants	4		table
agent_files	10		table
agent_history	11		table
agent_message_queue	10		table
agent_plan	8		table
agent_plan_history	6		table
agent_publish_history	8		table
agent_skill_dependency	4		table
agent_task_definition	8		table
agent_task_run_lock	6		table
agent_task_snapshot	9		table
agent_thread_grants	4		table
agent_version_skill_dependency	4		table
agent_workflow_dependency	3		table
agents	16		table
agents_memory_entries	13		table
agents_memory_entry_candidates	14		table
agents_memory_entry_locks	6		table
agents_memory_entry_sources	10		table
agents_messages	12		table
agents_observation_cursors	6		table
agents_observation_locks	7		table
agents_observations	11		table
agents_resources	4		table
agents_threads	6		table
ai_builder_temporary_workflow	4		table
ai_preference	8		table
annotation_tag_entity	4		table
app	9		table
app_artifact	8		table
app_version	12		table
auth_identity	5		table
auth_provider_sync_history	11		table
binary_data	9		table
chat_hub_agent_tools	2		table
chat_hub_agents	13		table
chat_hub_messages	17		table
chat_hub_session_tools	2		table
chat_hub_sessions	13		table
chat_hub_tools	9		table
credential_dependency	5		table
credentials_entity	14		table
data_table	5		table
data_table_column	7		table
deployment_key	7		table
dynamic_credential_entry	6		table
dynamic_credential_resolver	6		table
dynamic_credential_user_entry	6		table
evaluation_collection	9		table
evaluation_config	12		table
event_destinations	4		table
execution_annotation_tags	2		table
execution_annotations	6		table
execution_data	4		table
execution_entity	20		table
execution_ledger	16		table
execution_metadata	4		table
folder	6		table
folder_tag	2		table
idempotency_key	9		table
insights_by_period	6		table
insights_metadata	5		table
insights_raw	5		table
installed_nodes	4		table
installed_packages	6		table
instance_ai_checkpoints	9		table
instance_ai_events	7		table
instance_ai_mcp_registry_connections	7		table
instance_ai_messages	8		table
instance_ai_observation_cursors	5		table
instance_ai_observation_locks	6		table
instance_ai_observational_memory	32		table
instance_ai_observations	10		table
instance_ai_pending_confirmations	12		table
instance_ai_resources	5		table
instance_ai_thread_grants	5		table
instance_ai_thread_tabs	5		table
instance_ai_threads	7		table
instance_ai_workflow_snapshots	7		table
instance_credential_assignment	4		table
instance_monitoring_report	10		table
instance_version_history	5		table
invalid_auth_token	2		table
mcp_registry_server	7		table
migration_finding	10		table
migration_finding_sync	3		table
migration_workflow_owner	7		table
oauth_access_tokens	3		table
oauth_authorization_codes	13		table
oauth_clients	10		table
oauth_refresh_tokens	8		table
oauth_user_consents	5		table
poller_state	7		table
processed_data	5		table
project	9		table
project_pool_settings	4		table
project_relation	5		table
project_secrets_provider_access	5		table
promotion_environment	9		table
promotion_environment_project	5		table
promotion_provider	8		table
promotion_review	10		table
promotion_run	8		table
role	7		table
role_mapping_rule	7		table
role_mapping_rule_project	2		table
role_scope	2		table
scheduled_job	26		table
scheduled_task	19		table
scope	3		table
secrets_provider_connection	7		table
self_healing_configuration	8		table
self_healing_configuration_reviewer	2		table
self_healing_configuration_workflow	3		table
self_healing_investigation	13		table
self_healing_result	16		table
service_account_details	4		table
settings	3		table
shared_credentials	5		table
shared_workflow	5		table
skill	8		table
skill_file	5		table
skill_source	13		table
skill_source_link	14		table
skill_version	12		table
tag_entity	4		table
test_case_execution	16		table
test_run	16		table
token_exchange_jti	3		table
trusted_key	4		table
trusted_key_source	8		table
trusted_source	16		table
trusted_source_identity	8		table
type_availability_policy	7		table
type_availability_policy_attachment	6		table
type_availability_policy_scope	8		table
user	16		table
user_api_keys	9		table
user_favorites	4		table
variables	5		table
webhook_entity	6		table
workflow_builder_session	9		table
workflow_dependency	9		table
workflow_entity	20		table
workflow_history	11		table
workflow_publication_outbox	8		table
workflow_publication_retry_state	4		table
workflow_publication_trigger_status	8		table
workflow_publish_history	6		table
workflow_published_version	4		table
workflow_review_activity	7		table
workflow_review_activity_comment	8		table
workflow_review_request	12		table
workflow_review_request_authors	2		table
workflow_review_request_reviewers	2		table
workflow_review_request_workflow	5		table
workflow_statistics	7		table
workflow_suggestion	16		table
workflow_suggestion_activity	7		table
workflows_tags	2		table

erDiagram

"activity_event" }o--|| "project" : "FOREIGN KEY (projectId) REFERENCES project (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"activity_event" }o--o| "user" : "FOREIGN KEY (userId) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"agent_background_job" }o--|| "agents" : "FOREIGN KEY (parentAgentId) REFERENCES agents (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"agent_background_job" }o--o| "agent_execution" : "FOREIGN KEY (sourceExecutionId) REFERENCES agent_execution (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"agent_background_job" }o--o| "agent_plan" : "FOREIGN KEY (planId) REFERENCES agent_plan (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"agent_channel_status" |o--|| "agents" : "FOREIGN KEY (agentId) REFERENCES agents (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"agent_chat_attachments" }o--|| "project" : "FOREIGN KEY (projectId) REFERENCES project (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"agent_chat_attachments" }o--o| "agents" : "FOREIGN KEY (agentId) REFERENCES agents (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"agent_chat_subscriptions" |o--|| "agents" : "FOREIGN KEY (agentId) REFERENCES agents (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"agent_checkpoints" }o--o| "agents" : "FOREIGN KEY (agentId) REFERENCES agents (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"agent_credential_dependency" |o--|| "credentials_entity" : "FOREIGN KEY (credentialId) REFERENCES credentials_entity (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"agent_credential_dependency" |o--|| "agents" : "FOREIGN KEY (agentId) REFERENCES agents (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"