AI-native knowledge base & Evernote/Obsidian alternative with instant sync & native MCP. Free on Cloudflare or self-hosted via Docker.
HTML ai-agentcloudflarecloudflare-d1cloudflare-r2cloudflare-workersdockerelectronevernoteevernote-alternativeknowledge-basemcpnote-takingobsidian-alternativeoffline-firstpersonal-knowledge-basepwaself-hostedsqlitetiptapweb-clipper
ALTER TABLE sessions ADD COLUMN device_id TEXT;
UPDATE sessions
SET device_id = CASE
WHEN user_agent IS NULL OR trim(user_agent) = '' THEN 'legacy-session:' || id
ELSE 'legacy-ua:' || user_agent
END
WHERE device_id IS NULL;
CREATE INDEX idx_sessions_user_device
ON sessions(user_id, device_id, revoked_at, expires_at);