Create
Query
database.sqlite
—
user
annotation_tag_entity
auth_identity
auth_provider_sync_history
chat_hub_agents
chat_hub_messages
chat_hub_sessions
credentials_entity
data_table
data_table_column
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
invalid_auth_token
migrations
oauth_access_tokens
oauth_authorization_codes
oauth_clients
oauth_refresh_tokens
oauth_user_consents
processed_data
project
project_relation
role
role_scope
scope
settings
shared_credentials
shared_workflow
sqlite_sequence
tag_entity
test_case_execution
test_run
user
user_api_keys
variables
webhook_entity
workflow_dependency
workflow_entity
workflow_history
workflow_statistics
workflows_tags
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Update row f4b109cc-78c4-485f-9f8e-24b5c87c0250 in user
id
Primary key.
varchar
email
varchar(255)
firstName
varchar(32)
lastName
varchar(32)
password
varchar
personalizationAnswers
{"version":"v4","personalization_survey_submitted_at":"2025-11-29T20:34:22.133Z","personalization_survey_n8n_version":"1.121.3","companySize":"<20","companyType":"systems-integrator","role":"business-owner","reportedSource":"other","reportedSourceOther":"The Real World"}
TEXT
createdAt
datetime(3) NOT NULL (default STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')
updatedAt
datetime(3) NOT NULL (default STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')
settings
{"userActivated":false,"easyAIWorkflowOnboarded":true}
TEXT
disabled
boolean NOT NULL (default FALSE
mfaEnabled
boolean NOT NULL (default FALSE
mfaSecret
NULL
TEXT
mfaRecoveryCodes
NULL
TEXT
lastActiveAt
date
roleSlug
varchar(128) NOT NULL (default 'global:member'
Update
Cancel