Create
Query
database.sqlite
—
execution_data
agent_chat_subscriptions
agent_checkpoints
agent_eval_dataset
agent_eval_rating
agent_eval_result
agent_eval_run
agent_execution
agent_execution_threads
agent_files
agent_history
agent_task_definition
agent_task_run_lock
agent_task_snapshot
agents
agents_memory_entries
agents_memory_entry_c...
agents_memory_entry_locks
agents_memory_entry_s...
agents_messages
agents_observation_cursors
agents_observation_locks
agents_observations
agents_resources
agents_threads
ai_builder_temporary_...
annotation_tag_entity
auth_identity
auth_provider_sync_history
binary_data
chat_hub_agent_tools
chat_hub_agents
chat_hub_messages
chat_hub_session_tools
chat_hub_sessions
chat_hub_tools
credential_dependency
credentials_entity
data_table
data_table_column
deployment_key
dynamic_credential_entry
dynamic_credential_re...
dynamic_credential_us...
evaluation_collection
evaluation_config
event_destinations
execution_annotation_tags
execution_annotations
execution_data
execution_entity
execution_metadata
folder
folder_tag
insights_by_period
insights_metadata
insights_raw
installed_nodes
installed_packages
instance_ai_checkpoints
instance_ai_events
instance_ai_iteration_logs
instance_ai_mcp_regis...
instance_ai_messages
instance_ai_observati...
instance_ai_observati...
instance_ai_observati...
instance_ai_observations
instance_ai_pending_c...
instance_ai_resources
instance_ai_run_snapshots
instance_ai_thread_grants
instance_ai_threads
instance_ai_workflow_...
instance_credential_a...
instance_version_history
invalid_auth_token
mcp_registry_server
migrations
oauth_access_tokens
oauth_authorization_codes
oauth_clients
oauth_refresh_tokens
oauth_user_consents
processed_data
project
project_relation
project_secrets_provi...
role
role_mapping_rule
role_mapping_rule_project
role_scope
scheduled_job
scheduled_task
scope
secrets_provider_conn...
settings
shared_credentials
shared_workflow
sqlite_sequence
tag_entity
test_case_execution
test_run
token_exchange_jti
trusted_key
trusted_key_source
user
user_api_keys
user_favorites
variables
webhook_entity
workflow_builder_session
workflow_dependency
workflow_entity
workflow_history
workflow_publication_...
workflow_publication_...
workflow_publish_history
workflow_published_version
workflow_review_request
workflow_review_reque...
workflow_review_reque...
workflow_review_reque...
workflow_statistics
workflows_tags
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Update row 1 in execution_data
executionId
Primary key.
INT NOT NULL
workflowData
{"id":"RMP3uw7IH7WMpofc","name":"My workflow","nodes":[{"parameters":{"notice":""},"type":"n8n-nodes-base.manualTrigger","typeVersion":1,"position":[0,0],"id":"e7061f84-17e9-4157-9ae4-35c82b6f5c24","name":"When clicking ‘Execute workflow’"}],"connections":{},"settings":{"executionOrder":"v1","binaryMode":"separate","availableInMCP":false},"nodeGroups":[]}
TEXT NOT NULL
data
[{"version":1,"startData":"1","resultData":"2","executionData":"3","resumeToken":"4"},{},{"runData":"5","pinData":"6","lastNodeExecuted":"7"},{"contextData":"8","nodeExecutionStack":"9","metadata":"10","waitingExecution":"11","waitingExecutionSource":"12","runtimeData":"13"},"b240f6d226d040e601ad5e65dff3e836c6ecf60663e543003d5d231bccc8aedb",{"When clicking ‘Execute workflow’":"14"},{},"When clicking ‘Execute workflow’",{},[],{},{},{},{"version":1,"establishedAt":1786010492144,"source":"15","triggerNode":"16","redaction":"17","credentials":"18"},["19"],"manual",{"name":"7","type":"20"},{"version":2,"production":false,"manual":false,"source":"21"},"U2FsdGVkX1+5t9k9lsXsXmuChl6nFbdE+hZCrwXpSRX/dk26+rT9kTf+dKvs4LsV4hIqLPmA/MJ8EieoQWYiO3QhFYVhEgPcLQXheEMhrSV8JYsEUak2tcUGF2vLvoz1fQOApCQM/HMDTHLq28gKDzJ62UfobwkZ82rJ9boHn+JihASEfQzYmp8XstxtudwX5udR7BktK6vI3Ex1eHJ5NGBtG5JfLoFm/Ca6SSzxPi9xvRhoICCiKlrbuoDN9S5ARaeqWknrsLFFWPsIPGfngIDoc/e/sCqabDUAkfNsYHaXEgLukMl8OZ4BDxZ5MLFm37gGuWaaVdUO2CtVb3ZO64avztW1zpc94N5JulA0khfPNFPbdacOV11zPzfiYPSwjJsXgw6t4WVrBjxjvCNBt2NRzphoHlfoXwRiG6QfUh3Ev8pFJK3FT8JI/Mkmk8tCK389aC2pjgXErcZQEFQXn/Ft31UxC/hX+5nihVdqH4JNfNdwYsZkC+ZyY/QqqCD4V5QcqDvwSOY42OKxRhJmjw==",{"startTime":1786010492222,"executionIndex":0,"source":"22","hints":"23","executionTime":12,"executionStatus":"24","data":"25"},"n8n-nodes-base.manualTrigger","workflow",[],[],"success",{"main":"26"},["27"],["28"],{"json":"29","pairedItem":"30"},{},{"item":0}]
TEXT NOT NULL
workflowVersionId
VARCHAR(36)
Update
Cancel