|
64K /Users/lukas/.screenpipe/db.sqlite-shm
16M 64K /Users/lukas/.screenpipe/db.sqlite-shm
16M /Users/lukas/.screenpipe/db.sqlite-wal
24K /Users/lukas/.screenpipe/pipes
132K /Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log
96K /Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log
132K /Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe
1.6G /Users/lukas/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe
1.7G /Users/lukas/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*
4.0K /Users/lukas/.screenpipe/config.json
648M /Users/lukas/.screenpipe/data
1.1G /Users/lukas/.screenpipe/db.sqlite
64K /Users/lukas/.screenpipe/db.sqlite-shm
16M /Users/lukas/.screenpipe/db.sqlite-wal
24K /Users/lukas/.screenpipe/pipes
132K /Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log
96K /Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log
132K /Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ # Size of the DB itself
ls -lh ~/.screenpipe/db.sqlite
# Size of actual data files (videos/images)
du -sh ~/.screenpipe/data/
# Day by day breakdown
du -sh ~/.screenpipe/data/2026-04-*/
# Compare DB vs total
du -sh ~/.screenpipe/
zsh: command not found: #
-rw-r--r-- 1 lukas staff 1.1G 14 Apr 16:12 /Users/lukas/.screenpipe/db.sqlite
zsh: unknown file attribute: v
651M /Users/lukas/.screenpipe/data/
zsh: command not found: #
zsh: no matches found: /Users/lukas/.screenpipe/data/2026-04-*/
zsh: command not found: #
1.7G /Users/lukas/.screenpipe/
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ # See how the DB space is distributed
sqlite3 ~/.screenpipe/db.sqlite "
SELECT name,
SUM(pgsize)/1024/1024 as size_mb
FROM dbstat
GROUP BY name
ORDER BY size_mb DESC
LIMIT 20;"
zsh: command not found: #
^[[A^CError: stepping, interrupted (9)
Program interrupted.
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT name,
SUM(pgsize)/1024/1024 as size_mb
FROM dbstat
GROUP BY name
ORDER BY size_mb DESC
LIMIT 20;"
frames|358
ocr_text|347
elements|146
frames_fts_content|76
idx_elements_source_role_text|23
idx_elements_frame_source_role|23
frames_fts_data|19
elements_fts_data|19
idx_elements_frame_source|16
idx_elements_source|13
idx_elements_frame_id|10
elements_fts_docsize|9
idx_elements_parent_id|8
ui_events|3
idx_ui_events_session_id|1
vision_tags|0
video_chunks|0
ui_events_fts_idx|0
ui_events_fts_docsize|0
ui_events_fts_data|0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
(SELECT COUNT(*) FROM frames) as frames,
(SELECT COUNT(*) FROM ocr_text) as ocr_rows,
(SELECT COUNT(*) FROM ui_monitoring) as ui_rows;"
Error: in prepare, no such table: ui_monitoring
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT MIN(timestamp) FROM frames;"
2026-04-09T16:53:09.043761+00:00
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*
4.0K /Users/lukas/.screenpipe/config.json
691M /Users/lukas/.screenpipe/data
1.1G /Users/lukas/.screenpipe/db.sqlite
64K /Users/lukas/.screenpipe/db.sqlite-shm
9.0M /Users/lukas/.screenpipe/db.sqlite-wal
24K /Users/lukas/.screenpipe/pipes
132K /Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log
96K /Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log
132K /Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe
1.8G /Users/lukas/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe
1.9G /Users/lukas/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT app_name, COUNT(*) as frames
FROM frames
GROUP BY app_name
ORDER BY frames DESC
LIMIT 15;"
|6198
Boosteroid|3593
Firefox|2008
iTerm2|1197
PhpStorm|974
Slack|387
Claude|322
Dia|171
Code|155
Finder|125
Alfred|67
System Settings|59
Activity Monitor|45
Orion|43
CleanShot X|42
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
app_name,
COUNT(*) as rows,
AVG(LENGTH(text)) as avg_text_len,
SUM(LENGTH(text))/1024/1024 as total_mb
FROM ocr_text
JOIN frames ON ocr_text.frame_id = frames.id
GROUP BY app_name
ORDER BY total_mb DESC
LIMIT 15;"
Error: in prepare, ambiguous column name: app_name
SELECT app_name, COUNT(*) as rows, AVG(LENGTH(text)) as avg_text_len,
^--- error here
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
f.app_name,
COUNT(*) as rows,
AVG(LENGTH(o.text)) as avg_text_len,
SUM(LENGTH(o.text))/1024/1024 as total_mb
FROM ocr_text o
JOIN frames f ON o.frame_id = f.id
GROUP BY f.app_name
ORDER BY total_mb DESC
LIMIT 15;"
|6206|2989.91637125363|17
Boosteroid|3593|1169.43362092959|4
Slack|387|3164.1834625323|1
PhpStorm|299|3867.36454849498|1
Firefox|366|3405.68852459016|1
iTerm2|10|2601.1|0
UserNotificationCenter|1|664.0|0
Tailscale|2|3256.5|0
Raycast|2|1539.5|0
QuickTime Player|15|3574.33333333333|0
Preview|1|2829.0|0
Finder|38|2407.44736842105|0
Dia|63|2062.65079365079|0
CoreServicesUIAgent|1|1962.0|0
Control Centre|12|4385.83333333333|0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe
2.6G /Users/lukas/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*
4.0K /Users/lukas/.screenpipe/config.json
1.3G /Users/lukas/.screenpipe/data
1.3G /Users/lukas/.screenpipe/db.sqlite
64K /Users/lukas/.screenpipe/db.sqlite-shm
16M /Users/lukas/.screenpipe/db.sqlite-wal
24K /Users/lukas/.screenpipe/pipes
132K /Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log
96K /Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log
196K /Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cp -r ~/.screenpipe/data/data/2026-04-13 /Volumes/Test/screenpipe/data/
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cp -r ~/.screenpipe/data/data/2026-04-14 /Volumes/Test/screenpipe/data/
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cp ~/.screenpipe/db.sqlite /Volumes/Test/screenpipe/db.sqlite
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cp ~/.screenpipe/db.sqlite /Volumes/Test/screenpipe/db.sqlite
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe
2.7G /Users/lukas/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*
4.0K /Users/lukas/.screenpipe/config.json
1.3G /Users/lukas/.screenpipe/data
1.4G /Users/lukas/.screenpipe/db.sqlite
64K /Users/lukas/.screenpipe/db.sqlite-shm
7.0M /Users/lukas/.screenpipe/db.sqlite-wal
24K /Users/lukas/.screenpipe/pipes
132K /Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log
96K /Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log
160K /Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log
60K /Users/lukas/.screenpipe/screenpipe.2026-04-15.0.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
name,
pgsize * pageno / 1024 / 1024 as size_mb
FROM dbstat
WHERE aggregate = TRUE
ORDER BY pgsize * pageno DESC;"
ocr_text|64681806
frames|47636741
elements|9058218
frames_fts_content|2282176
idx_elements_frame_source_role|270725
idx_elements_source_role_text|264067
elements_fts_data|166311
frames_fts_data|156816
idx_elements_frame_source|136761
idx_elements_source|86289
idx_elements_frame_id|55048
elements_fts_docsize|50120
idx_elements_parent_id|39775
ui_events|4996
idx_ui_events_session_id|438
idx_ui_events_timestamp|353
idx_frames_timestamp_device|315
idx_frames_timestamp|197
ui_events_fts_data|159
idx_ui_events_event_type|35
idx_ui_events_app_name|33
ui_events_fts_docsize|26
frames_fts_docsize|19
idx_ui_events_frame_id|14
idx_ui_events_sync_id|14
idx_ui_events_synced_at|14
idx_ui_events_unsynced|14
idx_frames_video_chunk_id|12
idx_ocr_text_frame_app_window|10
idx_ocr_text_length|7
idx_ocr_text_frame_id|7
idx_frames_elements_ref_frame_id|3
frames_fts_idx|2
elements_fts_idx|1
video_chunks|0
sqlite_schema|0
idx_frames_snapshot_path|0
_sqlx_migrations|0
audio_chunks|0
speakers|0
speaker_embeddings|0
idx_video_chunks_device_name_id|0
idx_video_chunks_device_name|0
sqlite_autoindex__sqlx_migrations_1|0
sqlite_sequence|0
idx_audio_chunks_timestamp|0
tags|0
sqlite_autoindex_tags_1|0
vision_tags|0
sqlite_autoindex_vision_tags_1|0
audio_tags|0
sqlite_autoindex_audio_tags_1|0
idx_vision_tags_vision_id|0
idx_vision_tags_tag_id|0
idx_audio_tags_audio_chunk_id|0
idx_audio_tags_tag_id|0
audio_transcriptions|0
idx_audio_transcriptions_audio_chunk_id_timestamp|0
idx_audio_transcriptions_audio_chunk_id|0
idx_audio_transcriptions_timestamp|0
idx_audio_transcriptions_transcription|0
idx_audio_transcriptions_length|0
ui_events_fts_idx|0
ui_events_fts_config|0
idx_audio_transcription_chunk_text|0
pipe_executions|0
idx_pipe_exec_name_status|0
idx_pipe_exec_running|0
idx_pipe_exec_name_time|0
pipe_scheduler_state|0
sqlite_autoindex_pipe_scheduler_state_1|0
meetings|0
idx_meetings_start|0
idx_meetings_end|0
elements_fts_config|0
audio_transcriptions_fts_data|0
audio_transcriptions_fts_idx|0
audio_transcriptions_fts_docsize|0
audio_transcriptions_fts_config|0
idx_video_chunks_cloud_blob_id|0
idx_frames_cloud_blob_id|0
memories|0
idx_memories_created_at|0
idx_memories_importance|0
idx_memories_source|0
memories_fts_data|0
memories_fts_idx|0
memories_fts_docsize|0
memories_fts_config|0
frames_fts_config|0
idx_memories_frame_id|0
idx_frames_sync_id|0
idx_ocr_text_sync_id|0
idx_audio_transcriptions_sync_id|0
secrets|0
sqlite_autoindex_secrets_1|0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
name,
(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as exists
FROM sqlite_master
WHERE type='table'
ORDER BY name;"
Error: in prepare, near "exists": syntax error
ite_master WHERE type='table' AND name=m.name) as exists FROM sqlite_master W
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'video_chunks' as tbl, COUNT(*) as rows FROM video_chunks
UNION ALL SELECT 'audio_chunks', COUNT(*) FROM audio_chunks
UNION ALL SELECT 'frames', COUNT(*) FROM frames
UNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_text
UNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptions
UNION ALL SELECT 'elements', COUNT(*) FROM elements
UNION ALL SELECT 'memories', COUNT(*) FROM memories
UNION ALL SELECT 'meetings', COUNT(*) FROM meetings
UNION ALL SELECT 'ui_events', COUNT(*) FROM ui_events
UNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"
video_chunks|428
audio_chunks|90
frames|20163
ocr_text|15011
audio_transcriptions|3
elements|1222571
memories|0
meetings|0
ui_events|26965
pipe_executions|0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe
2.7G /Users/lukas/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*
4.0K /Users/lukas/.screenpipe/config.json
1.3G /Users/lukas/.screenpipe/data
1.4G /Users/lukas/.screenpipe/db.sqlite
64K /Users/lukas/.screenpipe/db.sqlite-shm
17M /Users/lukas/.screenpipe/db.sqlite-wal
24K /Users/lukas/.screenpipe/pipes
132K /Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log
96K /Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log
160K /Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log
64K /Users/lukas/.screenpipe/screenpipe.2026-04-15.0.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
name,
SUM(pgsize) / 1024 / 1024 as size_mb
FROM dbstat
GROUP BY name
ORDER BY SUM(pgsize) DESC;
"
ocr_text|503
frames|433
elements|188
frames_fts_content|94
idx_elements_frame_source_role|32
idx_elements_source_role_text|32
elements_fts_data|25
frames_fts_data|24
idx_elements_frame_source|23
idx_elements_source|18
idx_elements_frame_id|14
elements_fts_docsize|14
idx_elements_parent_id|12
ui_events|4
idx_ui_events_session_id|1
idx_ui_events_timestamp|1
idx_frames_timestamp_device|1
idx_frames_timestamp|0
ui_events_fts_data|0
idx_ui_events_event_type|0
idx_ui_events_app_name|0
ui_events_fts_docsize|0
frames_fts_docsize|0
idx_ui_events_unsynced|0
idx_ui_events_synced_at|0
idx_ui_events_sync_id|0
idx_ui_events_frame_id|0
idx_frames_video_chunk_id|0
idx_ocr_text_frame_app_window|0
idx_ocr_text_length|0
idx_ocr_text_frame_id|0
idx_frames_elements_ref_frame_id|0
frames_fts_idx|0
elements_fts_idx|0
video_chunks|0
sqlite_schema|0
idx_frames_snapshot_path|0
speakers|0
speaker_embeddings|0
idx_video_chunks_device_name_id|0
audio_chunks|0
_sqlx_migrations|0
idx_video_chunks_device_name|0
vision_tags|0
ui_events_fts_idx|0
ui_events_fts_config|0
tags|0
sqlite_sequence|0
sqlite_autoindex_vision_tags_1|0
sqlite_autoindex_tags_1|0
sqlite_autoindex_secrets_1|0
sqlite_autoindex_pipe_scheduler_state_1|0
sqlite_autoindex_audio_tags_1|0
sqlite_autoindex__sqlx_migrations_1|0
secrets|0
pipe_scheduler_state|0
pipe_executions|0
memories_fts_idx|0
memories_fts_docsize|0
memories_fts_data|0
memories_fts_config|0
memories|0
meetings|0
idx_vision_tags_vision_id|0
idx_vision_tags_tag_id|0
idx_video_chunks_cloud_blob_id|0
idx_pipe_exec_running|0
idx_pipe_exec_name_time|0
idx_pipe_exec_name_status|0
idx_ocr_text_sync_id|0
idx_memories_source|0
idx_memories_importance|0
idx_memories_frame_id|0
idx_memories_created_at|0
idx_meetings_start|0
idx_meetings_end|0
idx_frames_sync_id|0
idx_frames_cloud_blob_id|0
idx_audio_transcriptions_transcription|0
idx_audio_transcriptions_timestamp|0
idx_audio_transcriptions_sync_id|0
idx_audio_transcriptions_length|0
idx_audio_transcriptions_audio_chunk_id_timestamp|0
idx_audio_transcriptions_audio_chunk_id|0
idx_audio_transcription_chunk_text|0
idx_audio_tags_tag_id|0
idx_audio_tags_audio_chunk_id|0
idx_audio_chunks_timestamp|0
frames_fts_config|0
elements_fts_config|0
audio_transcriptions_fts_idx|0
audio_transcriptions_fts_docsize|0
audio_transcriptions_fts_data|0
audio_transcriptions_fts_config|0
audio_transcriptions|0
audio_tags|0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*
4.0K /Users/lukas/.screenpipe/config.json
1.3G /Users/lukas/.screenpipe/data
1.4G /Users/lukas/.screenpipe/db.sqlite
64K /Users/lukas/.screenpipe/db.sqlite-shm
5.0M /Users/lukas/.screenpipe/db.sqlite-wal
24K /Users/lukas/.screenpipe/pipes
132K /Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log
96K /Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log
160K /Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log
68K /Users/lukas/.screenpipe/screenpipe.2026-04-15.0.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
d.name,
SUM(d.pgsize) / 1024 / 1024 as size_mb,
(SELECT COUNT(*) FROM frames WHERE d.name = 'frames') +
(SELECT COUNT(*) FROM ocr_text WHERE d.name = 'ocr_text') +
(SELECT COUNT(*) FROM elements WHERE d.name = 'elements') +
(SELECT COUNT(*) FROM ui_events WHERE d.name = 'ui_events') +
(SELECT COUNT(*) FROM video_chunks WHERE d.name = 'video_chunks') +
(SELECT COUNT(*) FROM audio_chunks WHERE d.name = 'audio_chunks') +
(SELECT COUNT(*) FROM audio_transcriptions WHERE d.name = 'audio_transcriptions') +
(SELECT COUNT(*) FROM memories WHERE d.name = 'memories') +
(SELECT COUNT(*) FROM meetings WHERE d.name = 'meetings') +
(SELECT COUNT(*) FROM tags WHERE d.name = 'tags') +
(SELECT COUNT(*) FROM pipe_executions WHERE d.name = 'pipe_executions') as row_count
FROM dbstat d
WHERE d.name IN (
'frames','ocr_text','elements','ui_events',
'video_chunks','audio_chunks','audio_transcriptions',
'memories','meetings','tags','pipe_executions'
)
GROUP BY d.name
ORDER BY SUM(d.pgsize) DESC;
"
ocr_text|635|18459
frames|485|24367
elements|220|1531970
ui_events|5|30928
video_chunks|0|523
audio_chunks|0|90
tags|0|0
pipe_executions|0|0
memories|0|0
meetings|0|0
audio_transcriptions|0|3
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT sql FROM sqlite_master
WHERE type='table'
AND name NOT LIKE '%_fts%'
AND name NOT LIKE 'sqlite_%'
AND name NOT LIKE '_sqlx%'
ORDER BY name;
"
CREATE TABLE audio_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, timestamp TIMESTAMP, sync_id TEXT, machine_id TEXT, synced_at DATETIME)
CREATE TABLE audio_tags (
audio_chunk_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (audio_chunk_id, tag_id),
FOREIGN KEY (audio_chunk_id) REFERENCES audio_chunks(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
CREATE TABLE "audio_transcriptions" (
id INTEGER PRIMARY KEY AUTOINCREMENT,
audio_chunk_id INTEGER NOT NULL,
offset_index INTEGER NOT NULL,
timestamp TIMESTAMP NOT NULL,
transcription TEXT NOT NULL,
device TEXT NOT NULL DEFAULT '',
is_input_device BOOLEAN NOT NULL DEFAULT TRUE,
speaker_id INTEGER,
transcription_engine TEXT NOT NULL DEFAULT 'Whisper', start_time REAL, end_time REAL, text_length INTEGER, sync_id TEXT, synced_at DATETIME,
FOREIGN KEY (audio_chunk_id) REFERENCES audio_chunks(id)
)
CREATE TABLE elements (
id INTEGER PRIMARY KEY AUTOINCREMENT,
frame_id INTEGER NOT NULL,
source TEXT NOT NULL, -- 'ocr' | 'accessibility'
role TEXT NOT NULL, -- OCR: 'page','block','paragraph','line','word'
-- AX: 'AXButton','AXTextField','AXStaticText', etc.
text TEXT, -- element text content (NULL for container nodes)
parent_id INTEGER, -- self-referential FK for tree hierarchy (NULL = root)
depth INTEGER NOT NULL DEFAULT 0, -- tree depth (0 = root)
left_bound REAL, -- normalized 0-1 bounding box
top_bound REAL,
width_bound REAL,
height_bound REAL,
confidence REAL, -- OCR confidence (0-100), NULL for AX
sort_order INTEGER NOT NULL DEFAULT 0, properties TEXT, -- sibling order within parent
FOREIGN KEY (frame_id) REFERENCES frames(id),
FOREIGN KEY (parent_id) REFERENCES elements(id)
)
CREATE TABLE "frames" (
id INTEGER PRIMARY KEY AUTOINCREMENT,
video_chunk_id INTEGER DEFAULT NULL,
offset_index INTEGER NOT NULL DEFAULT 0,
timestamp TIMESTAMP NOT NULL,
name TEXT,
app_name TEXT DEFAULT NULL,
window_name TEXT DEFAULT NULL,
focused BOOLEAN DEFAULT NULL,
browser_url TEXT DEFAULT NULL,
device_name TEXT NOT NULL DEFAULT '',
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME,
-- New event-driven capture columns
snapshot_path TEXT DEFAULT NULL,
accessibility_text TEXT DEFAULT NULL,
accessibility_tree_json TEXT DEFAULT NULL,
content_hash INTEGER DEFAULT NULL,
simhash INTEGER DEFAULT NULL,
capture_trigger TEXT DEFAULT NULL,
text_source TEXT DEFAULT NULL, cloud_blob_id TEXT DEFAULT NULL, full_text TEXT DEFAULT NULL, elements_ref_frame_id INTEGER DEFAULT NULL,
FOREIGN KEY (video_chunk_id) REFERENCES video_chunks(id)
)
CREATE TABLE meetings (
id INTEGER PRIMARY KEY AUTOINCREMENT,
meeting_start TEXT NOT NULL,
meeting_end TEXT,
meeting_app TEXT NOT NULL,
title TEXT,
attendees TEXT,
detection_source TEXT NOT NULL DEFAULT 'app',
created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ', 'now'))
, note TEXT)
CREATE TABLE memories (
id INTEGER PRIMARY KEY AUTOINCREMENT,
content TEXT NOT NULL,
source TEXT NOT NULL DEFAULT 'user',
source_context TEXT,
tags TEXT DEFAULT '[]',
importance REAL DEFAULT 0.5,
created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ', 'now')),
updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ', 'now'))
, frame_id INTEGER REFERENCES frames(id) ON DELETE SET NULL)
CREATE TABLE "ocr_text" (
frame_id INTEGER NOT NULL,
text TEXT NOT NULL,
text_json TEXT,
app_name TEXT NOT NULL DEFAULT '',
ocr_engine TEXT NOT NULL DEFAULT 'unknown'
, window_name TEXT, focused BOOLEAN DEFAULT FALSE, text_length INTEGER, sync_id TEXT, synced_at DATETIME)
CREATE TABLE pipe_executions (
id INTEGER PRIMARY KEY AUTOINCREMENT,
pipe_name TEXT NOT NULL,
status TEXT NOT NULL DEFAULT 'queued',
trigger_type TEXT NOT NULL DEFAULT 'manual',
pid INTEGER,
model TEXT,
provider TEXT,
started_at TEXT,
finished_at TEXT,
stdout TEXT DEFAULT '',
stderr TEXT DEFAULT '',
exit_code INTEGER,
error_type TEXT,
error_message TEXT,
duration_ms INTEGER
, session_path TEXT)
CREATE TABLE pipe_scheduler_state (
pipe_name TEXT PRIMARY KEY,
last_run_at TEXT,
last_success_at TEXT,
consecutive_failures INTEGER DEFAULT 0
)
CREATE TABLE secrets (
key TEXT PRIMARY KEY,
value BLOB NOT NULL,
nonce BLOB NOT NULL,
created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ', 'now')),
updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ', 'now')),
expires_at TEXT
)
CREATE TABLE speaker_embeddings (
id INTEGER PRIMARY KEY AUTOINCREMENT,
embedding FLOAT[512] NOT NULL
check(
typeof(embedding) == 'blob'
and vec_length(embedding) == 512
),
speaker_id INTEGER REFERENCES speakers(id)
)
CREATE TABLE speakers (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
metadata JSON
, hallucination BOOLEAN DEFAULT FALSE, centroid FLOAT[512], embedding_count INTEGER DEFAULT 0)
CREATE TABLE tags (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL UNIQUE,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
)
CREATE TABLE ui_events (
id INTEGER PRIMARY KEY AUTOINCREMENT,
timestamp DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
session_id TEXT,
relative_ms INTEGER NOT NULL DEFAULT 0,
event_type TEXT NOT NULL, -- click, move, scroll, key, text, app_switch, window_focus, clipboard
-- Position
x INTEGER,
y INTEGER,
delta_x INTEGER,
delta_y INTEGER,
-- Mouse/key
button INTEGER,
click_count INTEGER,
key_code INTEGER,
modifiers INTEGER,
-- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24392
|
|
64K /Users/lukas/.screenpipe/db.sqlite-shm
16M 64K /Users/lukas/.screenpipe/db.sqlite-shm
16M /Users/lukas/.screenpipe/db.sqlite-wal
24K /Users/lukas/.screenpipe/pipes
132K /Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log
96K /Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log
132K /Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe
1.6G /Users/lukas/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe
1.7G /Users/lukas/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*
4.0K /Users/lukas/.screenpipe/config.json
648M /Users/lukas/.screenpipe/data
1.1G /Users/lukas/.screenpipe/db.sqlite
64K /Users/lukas/.screenpipe/db.sqlite-shm
16M /Users/lukas/.screenpipe/db.sqlite-wal
24K /Users/lukas/.screenpipe/pipes
132K /Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log
96K /Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log
132K /Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ # Size of the DB itself
ls -lh ~/.screenpipe/db.sqlite
# Size of actual data files (videos/images)
du -sh ~/.screenpipe/data/
# Day by day breakdown
du -sh ~/.screenpipe/data/2026-04-*/
# Compare DB vs total
du -sh ~/.screenpipe/
zsh: command not found: #
-rw-r--r-- 1 lukas staff 1.1G 14 Apr 16:12 /Users/lukas/.screenpipe/db.sqlite
zsh: unknown file attribute: v
651M /Users/lukas/.screenpipe/data/
zsh: command not found: #
zsh: no matches found: /Users/lukas/.screenpipe/data/2026-04-*/
zsh: command not found: #
1.7G /Users/lukas/.screenpipe/
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ # See how the DB space is distributed
sqlite3 ~/.screenpipe/db.sqlite "
SELECT name,
SUM(pgsize)/1024/1024 as size_mb
FROM dbstat
GROUP BY name
ORDER BY size_mb DESC
LIMIT 20;"
zsh: command not found: #
^[[A^CError: stepping, interrupted (9)
Program interrupted.
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT name,
SUM(pgsize)/1024/1024 as size_mb
FROM dbstat
GROUP BY name
ORDER BY size_mb DESC
LIMIT 20;"
frames|358
ocr_text|347
elements|146
frames_fts_content|76
idx_elements_source_role_text|23
idx_elements_frame_source_role|23
frames_fts_data|19
elements_fts_data|19
idx_elements_frame_source|16
idx_elements_source|13
idx_elements_frame_id|10
elements_fts_docsize|9
idx_elements_parent_id|8
ui_events|3
idx_ui_events_session_id|1
vision_tags|0
video_chunks|0
ui_events_fts_idx|0
ui_events_fts_docsize|0
ui_events_fts_data|0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
(SELECT COUNT(*) FROM frames) as frames,
(SELECT COUNT(*) FROM ocr_text) as ocr_rows,
(SELECT COUNT(*) FROM ui_monitoring) as ui_rows;"
Error: in prepare, no such table: ui_monitoring
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT MIN(timestamp) FROM frames;"
2026-04-09T16:53:09.043761+00:00
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*
4.0K /Users/lukas/.screenpipe/config.json
691M /Users/lukas/.screenpipe/data
1.1G /Users/lukas/.screenpipe/db.sqlite
64K /Users/lukas/.screenpipe/db.sqlite-shm
9.0M /Users/lukas/.screenpipe/db.sqlite-wal
24K /Users/lukas/.screenpipe/pipes
132K /Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log
96K /Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log
132K /Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe
1.8G /Users/lukas/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe
1.9G /Users/lukas/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT app_name, COUNT(*) as frames
FROM frames
GROUP BY app_name
ORDER BY frames DESC
LIMIT 15;"
|6198
Boosteroid|3593
Firefox|2008
iTerm2|1197
PhpStorm|974
Slack|387
Claude|322
Dia|171
Code|155
Finder|125
Alfred|67
System Settings|59
Activity Monitor|45
Orion|43
CleanShot X|42
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
app_name,
COUNT(*) as rows,
AVG(LENGTH(text)) as avg_text_len,
SUM(LENGTH(text))/1024/1024 as total_mb
FROM ocr_text
JOIN frames ON ocr_text.frame_id = frames.id
GROUP BY app_name
ORDER BY total_mb DESC
LIMIT 15;"
Error: in prepare, ambiguous column name: app_name
SELECT app_name, COUNT(*) as rows, AVG(LENGTH(text)) as avg_text_len,
^--- error here
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
f.app_name,
COUNT(*) as rows,
AVG(LENGTH(o.text)) as avg_text_len,
SUM(LENGTH(o.text))/1024/1024 as total_mb
FROM ocr_text o
JOIN frames f ON o.frame_id = f.id
GROUP BY f.app_name
ORDER BY total_mb DESC
LIMIT 15;"
|6206|2989.91637125363|17
Boosteroid|3593|1169.43362092959|4
Slack|387|3164.1834625323|1
PhpStorm|299|3867.36454849498|1
Firefox|366|3405.68852459016|1
iTerm2|10|2601.1|0
UserNotificationCenter|1|664.0|0
Tailscale|2|3256.5|0
Raycast|2|1539.5|0
QuickTime Player|15|3574.33333333333|0
Preview|1|2829.0|0
Finder|38|2407.44736842105|0
Dia|63|2062.65079365079|0
CoreServicesUIAgent|1|1962.0|0
Control Centre|12|4385.83333333333|0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe
2.6G /Users/lukas/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*
4.0K /Users/lukas/.screenpipe/config.json
1.3G /Users/lukas/.screenpipe/data
1.3G /Users/lukas/.screenpipe/db.sqlite
64K /Users/lukas/.screenpipe/db.sqlite-shm
16M /Users/lukas/.screenpipe/db.sqlite-wal
24K /Users/lukas/.screenpipe/pipes
132K /Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log
96K /Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log
196K /Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cp -r ~/.screenpipe/data/data/2026-04-13 /Volumes/Test/screenpipe/data/
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cp -r ~/.screenpipe/data/data/2026-04-14 /Volumes/Test/screenpipe/data/
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cp ~/.screenpipe/db.sqlite /Volumes/Test/screenpipe/db.sqlite
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ cp ~/.screenpipe/db.sqlite /Volumes/Test/screenpipe/db.sqlite
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe
2.7G /Users/lukas/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*
4.0K /Users/lukas/.screenpipe/config.json
1.3G /Users/lukas/.screenpipe/data
1.4G /Users/lukas/.screenpipe/db.sqlite
64K /Users/lukas/.screenpipe/db.sqlite-shm
7.0M /Users/lukas/.screenpipe/db.sqlite-wal
24K /Users/lukas/.screenpipe/pipes
132K /Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log
96K /Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log
160K /Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log
60K /Users/lukas/.screenpipe/screenpipe.2026-04-15.0.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
name,
pgsize * pageno / 1024 / 1024 as size_mb
FROM dbstat
WHERE aggregate = TRUE
ORDER BY pgsize * pageno DESC;"
ocr_text|64681806
frames|47636741
elements|9058218
frames_fts_content|2282176
idx_elements_frame_source_role|270725
idx_elements_source_role_text|264067
elements_fts_data|166311
frames_fts_data|156816
idx_elements_frame_source|136761
idx_elements_source|86289
idx_elements_frame_id|55048
elements_fts_docsize|50120
idx_elements_parent_id|39775
ui_events|4996
idx_ui_events_session_id|438
idx_ui_events_timestamp|353
idx_frames_timestamp_device|315
idx_frames_timestamp|197
ui_events_fts_data|159
idx_ui_events_event_type|35
idx_ui_events_app_name|33
ui_events_fts_docsize|26
frames_fts_docsize|19
idx_ui_events_frame_id|14
idx_ui_events_sync_id|14
idx_ui_events_synced_at|14
idx_ui_events_unsynced|14
idx_frames_video_chunk_id|12
idx_ocr_text_frame_app_window|10
idx_ocr_text_length|7
idx_ocr_text_frame_id|7
idx_frames_elements_ref_frame_id|3
frames_fts_idx|2
elements_fts_idx|1
video_chunks|0
sqlite_schema|0
idx_frames_snapshot_path|0
_sqlx_migrations|0
audio_chunks|0
speakers|0
speaker_embeddings|0
idx_video_chunks_device_name_id|0
idx_video_chunks_device_name|0
sqlite_autoindex__sqlx_migrations_1|0
sqlite_sequence|0
idx_audio_chunks_timestamp|0
tags|0
sqlite_autoindex_tags_1|0
vision_tags|0
sqlite_autoindex_vision_tags_1|0
audio_tags|0
sqlite_autoindex_audio_tags_1|0
idx_vision_tags_vision_id|0
idx_vision_tags_tag_id|0
idx_audio_tags_audio_chunk_id|0
idx_audio_tags_tag_id|0
audio_transcriptions|0
idx_audio_transcriptions_audio_chunk_id_timestamp|0
idx_audio_transcriptions_audio_chunk_id|0
idx_audio_transcriptions_timestamp|0
idx_audio_transcriptions_transcription|0
idx_audio_transcriptions_length|0
ui_events_fts_idx|0
ui_events_fts_config|0
idx_audio_transcription_chunk_text|0
pipe_executions|0
idx_pipe_exec_name_status|0
idx_pipe_exec_running|0
idx_pipe_exec_name_time|0
pipe_scheduler_state|0
sqlite_autoindex_pipe_scheduler_state_1|0
meetings|0
idx_meetings_start|0
idx_meetings_end|0
elements_fts_config|0
audio_transcriptions_fts_data|0
audio_transcriptions_fts_idx|0
audio_transcriptions_fts_docsize|0
audio_transcriptions_fts_config|0
idx_video_chunks_cloud_blob_id|0
idx_frames_cloud_blob_id|0
memories|0
idx_memories_created_at|0
idx_memories_importance|0
idx_memories_source|0
memories_fts_data|0
memories_fts_idx|0
memories_fts_docsize|0
memories_fts_config|0
frames_fts_config|0
idx_memories_frame_id|0
idx_frames_sync_id|0
idx_ocr_text_sync_id|0
idx_audio_transcriptions_sync_id|0
secrets|0
sqlite_autoindex_secrets_1|0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
name,
(SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name=m.name) as exists
FROM sqlite_master
WHERE type='table'
ORDER BY name;"
Error: in prepare, near "exists": syntax error
ite_master WHERE type='table' AND name=m.name) as exists FROM sqlite_master W
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'video_chunks' as tbl, COUNT(*) as rows FROM video_chunks
UNION ALL SELECT 'audio_chunks', COUNT(*) FROM audio_chunks
UNION ALL SELECT 'frames', COUNT(*) FROM frames
UNION ALL SELECT 'ocr_text', COUNT(*) FROM ocr_text
UNION ALL SELECT 'audio_transcriptions', COUNT(*) FROM audio_transcriptions
UNION ALL SELECT 'elements', COUNT(*) FROM elements
UNION ALL SELECT 'memories', COUNT(*) FROM memories
UNION ALL SELECT 'meetings', COUNT(*) FROM meetings
UNION ALL SELECT 'ui_events', COUNT(*) FROM ui_events
UNION ALL SELECT 'pipe_executions', COUNT(*) FROM pipe_executions;"
video_chunks|428
audio_chunks|90
frames|20163
ocr_text|15011
audio_transcriptions|3
elements|1222571
memories|0
meetings|0
ui_events|26965
pipe_executions|0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe
2.7G /Users/lukas/.screenpipe
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*
4.0K /Users/lukas/.screenpipe/config.json
1.3G /Users/lukas/.screenpipe/data
1.4G /Users/lukas/.screenpipe/db.sqlite
64K /Users/lukas/.screenpipe/db.sqlite-shm
17M /Users/lukas/.screenpipe/db.sqlite-wal
24K /Users/lukas/.screenpipe/pipes
132K /Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log
96K /Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log
160K /Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log
64K /Users/lukas/.screenpipe/screenpipe.2026-04-15.0.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
name,
SUM(pgsize) / 1024 / 1024 as size_mb
FROM dbstat
GROUP BY name
ORDER BY SUM(pgsize) DESC;
"
ocr_text|503
frames|433
elements|188
frames_fts_content|94
idx_elements_frame_source_role|32
idx_elements_source_role_text|32
elements_fts_data|25
frames_fts_data|24
idx_elements_frame_source|23
idx_elements_source|18
idx_elements_frame_id|14
elements_fts_docsize|14
idx_elements_parent_id|12
ui_events|4
idx_ui_events_session_id|1
idx_ui_events_timestamp|1
idx_frames_timestamp_device|1
idx_frames_timestamp|0
ui_events_fts_data|0
idx_ui_events_event_type|0
idx_ui_events_app_name|0
ui_events_fts_docsize|0
frames_fts_docsize|0
idx_ui_events_unsynced|0
idx_ui_events_synced_at|0
idx_ui_events_sync_id|0
idx_ui_events_frame_id|0
idx_frames_video_chunk_id|0
idx_ocr_text_frame_app_window|0
idx_ocr_text_length|0
idx_ocr_text_frame_id|0
idx_frames_elements_ref_frame_id|0
frames_fts_idx|0
elements_fts_idx|0
video_chunks|0
sqlite_schema|0
idx_frames_snapshot_path|0
speakers|0
speaker_embeddings|0
idx_video_chunks_device_name_id|0
audio_chunks|0
_sqlx_migrations|0
idx_video_chunks_device_name|0
vision_tags|0
ui_events_fts_idx|0
ui_events_fts_config|0
tags|0
sqlite_sequence|0
sqlite_autoindex_vision_tags_1|0
sqlite_autoindex_tags_1|0
sqlite_autoindex_secrets_1|0
sqlite_autoindex_pipe_scheduler_state_1|0
sqlite_autoindex_audio_tags_1|0
sqlite_autoindex__sqlx_migrations_1|0
secrets|0
pipe_scheduler_state|0
pipe_executions|0
memories_fts_idx|0
memories_fts_docsize|0
memories_fts_data|0
memories_fts_config|0
memories|0
meetings|0
idx_vision_tags_vision_id|0
idx_vision_tags_tag_id|0
idx_video_chunks_cloud_blob_id|0
idx_pipe_exec_running|0
idx_pipe_exec_name_time|0
idx_pipe_exec_name_status|0
idx_ocr_text_sync_id|0
idx_memories_source|0
idx_memories_importance|0
idx_memories_frame_id|0
idx_memories_created_at|0
idx_meetings_start|0
idx_meetings_end|0
idx_frames_sync_id|0
idx_frames_cloud_blob_id|0
idx_audio_transcriptions_transcription|0
idx_audio_transcriptions_timestamp|0
idx_audio_transcriptions_sync_id|0
idx_audio_transcriptions_length|0
idx_audio_transcriptions_audio_chunk_id_timestamp|0
idx_audio_transcriptions_audio_chunk_id|0
idx_audio_transcription_chunk_text|0
idx_audio_tags_tag_id|0
idx_audio_tags_audio_chunk_id|0
idx_audio_chunks_timestamp|0
frames_fts_config|0
elements_fts_config|0
audio_transcriptions_fts_idx|0
audio_transcriptions_fts_docsize|0
audio_transcriptions_fts_data|0
audio_transcriptions_fts_config|0
audio_transcriptions|0
audio_tags|0
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/*
4.0K /Users/lukas/.screenpipe/config.json
1.3G /Users/lukas/.screenpipe/data
1.4G /Users/lukas/.screenpipe/db.sqlite
64K /Users/lukas/.screenpipe/db.sqlite-shm
5.0M /Users/lukas/.screenpipe/db.sqlite-wal
24K /Users/lukas/.screenpipe/pipes
132K /Users/lukas/.screenpipe/screenpipe.2026-04-09.0.log
96K /Users/lukas/.screenpipe/screenpipe.2026-04-11.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-12.0.log
72K /Users/lukas/.screenpipe/screenpipe.2026-04-13.0.log
160K /Users/lukas/.screenpipe/screenpipe.2026-04-14.0.log
68K /Users/lukas/.screenpipe/screenpipe.2026-04-15.0.log
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
d.name,
SUM(d.pgsize) / 1024 / 1024 as size_mb,
(SELECT COUNT(*) FROM frames WHERE d.name = 'frames') +
(SELECT COUNT(*) FROM ocr_text WHERE d.name = 'ocr_text') +
(SELECT COUNT(*) FROM elements WHERE d.name = 'elements') +
(SELECT COUNT(*) FROM ui_events WHERE d.name = 'ui_events') +
(SELECT COUNT(*) FROM video_chunks WHERE d.name = 'video_chunks') +
(SELECT COUNT(*) FROM audio_chunks WHERE d.name = 'audio_chunks') +
(SELECT COUNT(*) FROM audio_transcriptions WHERE d.name = 'audio_transcriptions') +
(SELECT COUNT(*) FROM memories WHERE d.name = 'memories') +
(SELECT COUNT(*) FROM meetings WHERE d.name = 'meetings') +
(SELECT COUNT(*) FROM tags WHERE d.name = 'tags') +
(SELECT COUNT(*) FROM pipe_executions WHERE d.name = 'pipe_executions') as row_count
FROM dbstat d
WHERE d.name IN (
'frames','ocr_text','elements','ui_events',
'video_chunks','audio_chunks','audio_transcriptions',
'memories','meetings','tags','pipe_executions'
)
GROUP BY d.name
ORDER BY SUM(d.pgsize) DESC;
"
ocr_text|635|18459
frames|485|24367
elements|220|1531970
ui_events|5|30928
video_chunks|0|523
audio_chunks|0|90
tags|0|0
pipe_executions|0|0
memories|0|0
meetings|0|0
audio_transcriptions|0|3
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT sql FROM sqlite_master
WHERE type='table'
AND name NOT LIKE '%_fts%'
AND name NOT LIKE 'sqlite_%'
AND name NOT LIKE '_sqlx%'
ORDER BY name;
"
CREATE TABLE audio_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, timestamp TIMESTAMP, sync_id TEXT, machine_id TEXT, synced_at DATETIME)
CREATE TABLE audio_tags (
audio_chunk_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (audio_chunk_id, tag_id),
FOREIGN KEY (audio_chunk_id) REFERENCES audio_chunks(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
CREATE TABLE "audio_transcriptions" (
id INTEGER PRIMARY KEY AUTOINCREMENT,
audio_chunk_id INTEGER NOT NULL,
offset_index INTEGER NOT NULL,
timestamp TIMESTAMP NOT NULL,
transcription TEXT NOT NULL,
device TEXT NOT NULL DEFAULT '',
is_input_device BOOLEAN NOT NULL DEFAULT TRUE,
speaker_id INTEGER,
transcription_engine TEXT NOT NULL DEFAULT 'Whisper', start_time REAL, end_time REAL, text_length INTEGER, sync_id TEXT, synced_at DATETIME,
FOREIGN KEY (audio_chunk_id) REFERENCES audio_chunks(id)
)
CREATE TABLE elements (
id INTEGER PRIMARY KEY AUTOINCREMENT,
frame_id INTEGER NOT NULL,
source TEXT NOT NULL, -- 'ocr' | 'accessibility'
role TEXT NOT NULL, -- OCR: 'page','block','paragraph','line','word'
-- AX: 'AXButton','AXTextField','AXStaticText', etc.
text TEXT, -- element text content (NULL for container nodes)
parent_id INTEGER, -- self-referential FK for tree hierarchy (NULL = root)
depth INTEGER NOT NULL DEFAULT 0, -- tree depth (0 = root)
left_bound REAL, -- normalized 0-1 bounding box
top_bound REAL,
width_bound REAL,
height_bound REAL,
confidence REAL, -- OCR confidence (0-100), NULL for AX
sort_order INTEGER NOT NULL DEFAULT 0, properties TEXT, -- sibling order within parent
FOREIGN KEY (frame_id) REFERENCES frames(id),
FOREIGN KEY (parent_id) REFERENCES elements(id)
)
CREATE TABLE "frames" (
id INTEGER PRIMARY KEY AUTOINCREMENT,
video_chunk_id INTEGER DEFAULT NULL,
offset_index INTEGER NOT NULL DEFAULT 0,
timestamp TIMESTAMP NOT NULL,
name TEXT,
app_name TEXT DEFAULT NULL,
window_name TEXT DEFAULT NULL,
focused BOOLEAN DEFAULT NULL,
browser_url TEXT DEFAULT NULL,
device_name TEXT NOT NULL DEFAULT '',
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME,
-- New event-driven capture columns
snapshot_path TEXT DEFAULT NULL,
accessibility_text TEXT DEFAULT NULL,
accessibility_tree_json TEXT DEFAULT NULL,
content_hash INTEGER DEFAULT NULL,
simhash INTEGER DEFAULT NULL,
capture_trigger TEXT DEFAULT NULL,
text_source TEXT DEFAULT NULL, cloud_blob_id TEXT DEFAULT NULL, full_text TEXT DEFAULT NULL, elements_ref_frame_id INTEGER DEFAULT NULL,
FOREIGN KEY (video_chunk_id) REFERENCES video_chunks(id)
)
CREATE TABLE meetings (
id INTEGER PRIMARY KEY AUTOINCREMENT,
meeting_start TEXT NOT NULL,
meeting_end TEXT,
meeting_app TEXT NOT NULL,
title TEXT,
attendees TEXT,
detection_source TEXT NOT NULL DEFAULT 'app',
created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ', 'now'))
, note TEXT)
CREATE TABLE memories (
id INTEGER PRIMARY KEY AUTOINCREMENT,
content TEXT NOT NULL,
source TEXT NOT NULL DEFAULT 'user',
source_context TEXT,
tags TEXT DEFAULT '[]',
importance REAL DEFAULT 0.5,
created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ', 'now')),
updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ', 'now'))
, frame_id INTEGER REFERENCES frames(id) ON DELETE SET NULL)
CREATE TABLE "ocr_text" (
frame_id INTEGER NOT NULL,
text TEXT NOT NULL,
text_json TEXT,
app_name TEXT NOT NULL DEFAULT '',
ocr_engine TEXT NOT NULL DEFAULT 'unknown'
, window_name TEXT, focused BOOLEAN DEFAULT FALSE, text_length INTEGER, sync_id TEXT, synced_at DATETIME)
CREATE TABLE pipe_executions (
id INTEGER PRIMARY KEY AUTOINCREMENT,
pipe_name TEXT NOT NULL,
status TEXT NOT NULL DEFAULT 'queued',
trigger_type TEXT NOT NULL DEFAULT 'manual',
pid INTEGER,
model TEXT,
provider TEXT,
started_at TEXT,
finished_at TEXT,
stdout TEXT DEFAULT '',
stderr TEXT DEFAULT '',
exit_code INTEGER,
error_type TEXT,
error_message TEXT,
duration_ms INTEGER
, session_path TEXT)
CREATE TABLE pipe_scheduler_state (
pipe_name TEXT PRIMARY KEY,
last_run_at TEXT,
last_success_at TEXT,
consecutive_failures INTEGER DEFAULT 0
)
CREATE TABLE secrets (
key TEXT PRIMARY KEY,
value BLOB NOT NULL,
nonce BLOB NOT NULL,
created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ', 'now')),
updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ', 'now')),
expires_at TEXT
)
CREATE TABLE speaker_embeddings (
id INTEGER PRIMARY KEY AUTOINCREMENT,
embedding FLOAT[512] NOT NULL
check(
typeof(embedding) == 'blob'
and vec_length(embedding) == 512
),
speaker_id INTEGER REFERENCES speakers(id)
)
CREATE TABLE speakers (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
metadata JSON
, hallucination BOOLEAN DEFAULT FALSE, centroid FLOAT[512], embedding_count INTEGER DEFAULT 0)
CREATE TABLE tags (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL UNIQUE,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
)
CREATE TABLE ui_events (
id INTEGER PRIMARY KEY AUTOINCREMENT,
timestamp DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
session_id TEXT,
relative_ms INTEGER NOT NULL DEFAULT 0,
event_type TEXT NOT NULL, -- click, move, scroll, key, text, app_switch, window_focus, clipboard
-- Position
x INTEGER,
y INTEGER,
delta_x INTEGER,
delta_y INTEGER,
-- Mouse/key
button INTEGER,
click_count INTEGER,
key_code INTEGER,
modifiers INTEGER,
-- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24393
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24398
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
ls
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
ls...
|
iTerm2
|
-zsh
|
NULL
|
24399
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
ls
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
ls...
|
iTerm2
|
ls
|
NULL
|
24400
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24405
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24406
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
git
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
git...
|
iTerm2
|
-zsh
|
NULL
|
24407
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
git
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
git...
|
iTerm2
|
-zsh
|
NULL
|
24408
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24413
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24414
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
find
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
find...
|
iTerm2
|
find
|
NULL
|
24415
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24420
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24421
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l
526
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24422
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l
526
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24423
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l
526
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24428
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l
526
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24429
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l
526
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24430
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l
526
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1
256K /Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24431
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l
526
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1
256K /Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24436
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l
526
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1
256K /Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24437
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l
526
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1
256K /Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -1
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24438
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l
526
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1
256K /Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -1
2.0M /Users/lukas/.screenpipe/data/data/2026-04-15/compact_monitor_2_1776255640728.mp4
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24439
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l
526
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1
256K /Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -1
2.0M /Users/lukas/.screenpipe/data/data/2026-04-15/compact_monitor_2_1776255640728.mp4
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24440
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l
526
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1
256K /Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -1
2.0M /Users/lukas/.screenpipe/data/data/2026-04-15/compact_monitor_2_1776255640728.mp4
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24453
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l
526
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1
256K /Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -1
2.0M /Users/lukas/.screenpipe/data/data/2026-04-15/compact_monitor_2_1776255640728.mp4
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24454
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l
526
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1
256K /Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -1
2.0M /Users/lukas/.screenpipe/data/data/2026-04-15/compact_monitor_2_1776255640728.mp4
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clea
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24455
|
|
-- Text content
text_content TEXT,
text_le -- Text content
text_content TEXT,
text_length INTEGER,
-- App context
app_name TEXT,
app_pid INTEGER,
window_title TEXT,
browser_url TEXT,
-- Element context (from accessibility APIs)
element_role TEXT,
element_name TEXT,
element_value TEXT,
element_description TEXT,
element_automation_id TEXT,
element_bounds TEXT, -- JSON: {"x":0,"y":0,"width":100,"height":50}
-- Frame correlation
frame_id INTEGER,
-- Sync columns
sync_id TEXT,
machine_id TEXT,
synced_at DATETIME
)
CREATE TABLE video_chunks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
file_path TEXT NOT NULL
, device_name TEXT NOT NULL DEFAULT '', sync_id TEXT, machine_id TEXT, synced_at DATETIME, fps REAL NOT NULL DEFAULT 0.5, cloud_blob_id TEXT DEFAULT NULL)
CREATE TABLE vision_tags (
vision_id INTEGER NOT NULL,
tag_id INTEGER NOT NULL,
PRIMARY KEY (vision_id, tag_id),
FOREIGN KEY (vision_id) REFERENCES frames(id) ON DELETE CASCADE,
FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE
)
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;
"
Error: in prepare, no such column: browser_url
SELECT frame_id, app_name, window_name, browser_url, focused, substr(
error here ---^
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l
526
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1
256K /Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -1
2.0M /Users/lukas/.screenpipe/data/data/2026-04-15/compact_monitor_2_1776255640728.mp4
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24456
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screen lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l
526
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1
256K /Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -1
2.0M /Users/lukas/.screenpipe/data/data/2026-04-15/compact_monitor_2_1776255640728.mp4
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/data/2026-04-15/ | head -40
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24457
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screen lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l
526
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1
256K /Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -1
2.0M /Users/lukas/.screenpipe/data/data/2026-04-15/compact_monitor_2_1776255640728.mp4
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/data/2026-04-15/ | head -40
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24466
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screen lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20
data
pending-transcriptions
screenpipe.db
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30
2026-04-09
2026-04-11
2026-04-12
2026-04-13
2026-04-14
2026-04-15
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l
146
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l
526
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1
256K /Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -1
2.0M /Users/lukas/.screenpipe/data/data/2026-04-15/compact_monitor_2_1776255640728.mp4
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/data/2026-04-15/ | head -40
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24467
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screen lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/data/2026-04-15/ | head -40
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ >....
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_bound
FROM elements
ORDER BY id DESC
LIMIT 5;
"
# ui_events sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, event_type, app_name, window_title,
x, y, text_content, element_role, element_name
FROM ui_events
ORDER BY id DESC
LIMIT 5;
"
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24468
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screen lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/data/2026-04-15/ | head -40
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ >....
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_bound
FROM elements
ORDER BY id DESC
LIMIT 5;
"
# ui_events sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, event_type, app_name, window_title,
x, y, text_content, element_role, element_name
FROM ui_events
ORDER BY id DESC
LIMIT 5;
"
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
zsh: command not found: #
81336 total
3724672 total
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
zsh: command not found: #
24465|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS]
24463|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS]
24461|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24469
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screen lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/data/2026-04-15/ | head -40
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ >....
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_bound
FROM elements
ORDER BY id DESC
LIMIT 5;
"
# ui_events sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, event_type, app_name, window_title,
x, y, text_content, element_role, element_name
FROM ui_events
ORDER BY id DESC
LIMIT 5;
"
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
zsh: command not found: #
81336 total
3724672 total
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
zsh: command not found: #
24465|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS]
24463|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS]
24461|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24470
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screen lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/data/2026-04-15/ | head -40
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ >....
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_bound
FROM elements
ORDER BY id DESC
LIMIT 5;
"
# ui_events sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, event_type, app_name, window_title,
x, y, text_content, element_role, element_name
FROM ui_events
ORDER BY id DESC
LIMIT 5;
"
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
zsh: command not found: #
81336 total
3724672 total
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
zsh: command not found: #
24465|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS]
24463|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS]
24461|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24474
|
|
1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.9 1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.954861104488373|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536005|24468|accessibility|AXButton|3|Close Tab|0.878472208976746|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536004|24468|accessibility|AXRadioButton|2|-zsh|0.874305546283722|0.[CREDIT_CARD]|0.109027780592442|0.[CREDIT_CARD]
1536003|24468|accessibility|AXButton|3|Close Tab|0.769444465637207|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
zsh: command not found: #
31095|2026-04-15T12:22:07.451725+00:00|clipboard|||||# What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_boun...||
31094|2026-04-15T12:22:07.450817+00:00|key|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|||||
31093|2026-04-15T12:22:06.690369+00:00|text|||||clear
||
31092|2026-04-15T12:22:05.009249+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444||AXTextArea|shell
31091|2026-04-15T12:22:04.885067+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444|||
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ >....
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_bound
FROM elements
ORDER BY id DESC
LIMIT 5;
"
# ui_events sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, event_type, app_name, window_title,
x, y, text_content, element_role, element_name
FROM ui_events
ORDER BY id DESC
LIMIT 5;
"
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24476
|
|
1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.9 1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.954861104488373|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536005|24468|accessibility|AXButton|3|Close Tab|0.878472208976746|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536004|24468|accessibility|AXRadioButton|2|-zsh|0.874305546283722|0.[CREDIT_CARD]|0.109027780592442|0.[CREDIT_CARD]
1536003|24468|accessibility|AXButton|3|Close Tab|0.769444465637207|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
zsh: command not found: #
31095|2026-04-15T12:22:07.451725+00:00|clipboard|||||# What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_boun...||
31094|2026-04-15T12:22:07.450817+00:00|key|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|||||
31093|2026-04-15T12:22:06.690369+00:00|text|||||clear
||
31092|2026-04-15T12:22:05.009249+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444||AXTextArea|shell
31091|2026-04-15T12:22:04.885067+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444|||
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ >....
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_bound
FROM elements
ORDER BY id DESC
LIMIT 5;
"
# ui_events sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, event_type, app_name, window_title,
x, y, text_content, element_role, element_name
FROM ui_events
ORDER BY id DESC
LIMIT 5;
"
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24477
|
|
1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.9 1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.954861104488373|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536005|24468|accessibility|AXButton|3|Close Tab|0.878472208976746|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536004|24468|accessibility|AXRadioButton|2|-zsh|0.874305546283722|0.[CREDIT_CARD]|0.109027780592442|0.[CREDIT_CARD]
1536003|24468|accessibility|AXButton|3|Close Tab|0.769444465637207|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
zsh: command not found: #
31095|2026-04-15T12:22:07.451725+00:00|clipboard|||||# What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_boun...||
31094|2026-04-15T12:22:07.450817+00:00|key|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|||||
31093|2026-04-15T12:22:06.690369+00:00|text|||||clear
||
31092|2026-04-15T12:22:05.009249+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444||AXTextArea|shell
31091|2026-04-15T12:22:04.885067+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444|||
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ >....
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_bound
FROM elements
ORDER BY id DESC
LIMIT 5;
"
# ui_events sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, event_type, app_name, window_title,
x, y, text_content, element_role, element_name
FROM ui_events
ORDER BY id DESC
LIMIT 5;
"
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24478
|
|
1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.9 1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.954861104488373|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536005|24468|accessibility|AXButton|3|Close Tab|0.878472208976746|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536004|24468|accessibility|AXRadioButton|2|-zsh|0.874305546283722|0.[CREDIT_CARD]|0.109027780592442|0.[CREDIT_CARD]
1536003|24468|accessibility|AXButton|3|Close Tab|0.769444465637207|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
zsh: command not found: #
31095|2026-04-15T12:22:07.451725+00:00|clipboard|||||# What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_boun...||
31094|2026-04-15T12:22:07.450817+00:00|key|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|||||
31093|2026-04-15T12:22:06.690369+00:00|text|||||clear
||
31092|2026-04-15T12:22:05.009249+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444||AXTextArea|shell
31091|2026-04-15T12:22:04.885067+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444|||
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ # What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_bound
FROM elements
ORDER BY id DESC
LIMIT 5;
"
# ui_events sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, event_type, app_name, window_title,
x, y, text_content, element_role, element_name
FROM ui_events
ORDER BY id DESC
LIMIT 5; <....
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
zsh: command not found: #
84968 total
3724672 total
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
zsh: command not found: #
24475|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $ ls~/.screenpipe/data/ | head -20datapen
24473|||0| iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSprint Review - in 38 mA100% <478Wed 15 Apr 15:22:29T81-zsh-zshDOCK
24472|||0|p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N*
24471|||0|iTerm2ShellEditViewSessionScriptsProfilesWindowHelpalol# Sprint Review - in 38 m-zsh-zshDOCKER• ₴1DEV (-zsh)182APP (-zsh
24465|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24479
|
|
1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.9 1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.954861104488373|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536005|24468|accessibility|AXButton|3|Close Tab|0.878472208976746|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536004|24468|accessibility|AXRadioButton|2|-zsh|0.874305546283722|0.[CREDIT_CARD]|0.109027780592442|0.[CREDIT_CARD]
1536003|24468|accessibility|AXButton|3|Close Tab|0.769444465637207|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
zsh: command not found: #
31095|2026-04-15T12:22:07.451725+00:00|clipboard|||||# What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_boun...||
31094|2026-04-15T12:22:07.450817+00:00|key|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|||||
31093|2026-04-15T12:22:06.690369+00:00|text|||||clear
||
31092|2026-04-15T12:22:05.009249+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444||AXTextArea|shell
31091|2026-04-15T12:22:04.885067+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444|||
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ # What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_bound
FROM elements
ORDER BY id DESC
LIMIT 5;
"
# ui_events sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, event_type, app_name, window_title,
x, y, text_content, element_role, element_name
FROM ui_events
ORDER BY id DESC
LIMIT 5; <....
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
zsh: command not found: #
84968 total
3724672 total
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
zsh: command not found: #
24475|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $ ls~/.screenpipe/data/ | head -20datapen
24473|||0| iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSprint Review - in 38 mA100% <478Wed 15 Apr 15:22:29T81-zsh-zshDOCK
24472|||0|p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N*
24471|||0|iTerm2ShellEditViewSessionScriptsProfilesWindowHelpalol# Sprint Review - in 38 m-zsh-zshDOCKER• ₴1DEV (-zsh)182APP (-zsh
24465|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24480
|
|
1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.9 1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.954861104488373|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536005|24468|accessibility|AXButton|3|Close Tab|0.878472208976746|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536004|24468|accessibility|AXRadioButton|2|-zsh|0.874305546283722|0.[CREDIT_CARD]|0.109027780592442|0.[CREDIT_CARD]
1536003|24468|accessibility|AXButton|3|Close Tab|0.769444465637207|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
zsh: command not found: #
31095|2026-04-15T12:22:07.451725+00:00|clipboard|||||# What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_boun...||
31094|2026-04-15T12:22:07.450817+00:00|key|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|||||
31093|2026-04-15T12:22:06.690369+00:00|text|||||clear
||
31092|2026-04-15T12:22:05.009249+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444||AXTextArea|shell
31091|2026-04-15T12:22:04.885067+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444|||
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ # What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_bound
FROM elements
ORDER BY id DESC
LIMIT 5;
"
# ui_events sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, event_type, app_name, window_title,
x, y, text_content, element_role, element_name
FROM ui_events
ORDER BY id DESC
LIMIT 5; <....
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
zsh: command not found: #
84968 total
3724672 total
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
zsh: command not found: #
24475|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $ ls~/.screenpipe/data/ | head -20datapen
24473|||0| iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSprint Review - in 38 mA100% <478Wed 15 Apr 15:22:29T81-zsh-zshDOCK
24472|||0|p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N*
24471|||0|iTerm2ShellEditViewSessionScriptsProfilesWindowHelpalol# Sprint Review - in 38 m-zsh-zshDOCKER• ₴1DEV (-zsh)182APP (-zsh
24465|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24489
|
|
1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.9 1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.954861104488373|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536005|24468|accessibility|AXButton|3|Close Tab|0.878472208976746|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536004|24468|accessibility|AXRadioButton|2|-zsh|0.874305546283722|0.[CREDIT_CARD]|0.109027780592442|0.[CREDIT_CARD]
1536003|24468|accessibility|AXButton|3|Close Tab|0.769444465637207|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
zsh: command not found: #
31095|2026-04-15T12:22:07.451725+00:00|clipboard|||||# What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_boun...||
31094|2026-04-15T12:22:07.450817+00:00|key|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|||||
31093|2026-04-15T12:22:06.690369+00:00|text|||||clear
||
31092|2026-04-15T12:22:05.009249+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444||AXTextArea|shell
31091|2026-04-15T12:22:04.885067+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444|||
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ # What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_bound
FROM elements
ORDER BY id DESC
LIMIT 5;
"
# ui_events sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, event_type, app_name, window_title,
x, y, text_content, element_role, element_name
FROM ui_events
ORDER BY id DESC
LIMIT 5; <....
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
zsh: command not found: #
84968 total
3724672 total
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
zsh: command not found: #
24475|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $ ls~/.screenpipe/data/ | head -20datapen
24473|||0| iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSprint Review - in 38 mA100% <478Wed 15 Apr 15:22:29T81-zsh-zshDOCK
24472|||0|p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N*
24471|||0|iTerm2ShellEditViewSessionScriptsProfilesWindowHelpalol# Sprint Review - in 38 m-zsh-zshDOCKER• ₴1DEV (-zsh)182APP (-zsh
24465|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24490
|
|
1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.9 1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.954861104488373|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536005|24468|accessibility|AXButton|3|Close Tab|0.878472208976746|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536004|24468|accessibility|AXRadioButton|2|-zsh|0.874305546283722|0.[CREDIT_CARD]|0.109027780592442|0.[CREDIT_CARD]
1536003|24468|accessibility|AXButton|3|Close Tab|0.769444465637207|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
zsh: command not found: #
31095|2026-04-15T12:22:07.451725+00:00|clipboard|||||# What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_boun...||
31094|2026-04-15T12:22:07.450817+00:00|key|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|||||
31093|2026-04-15T12:22:06.690369+00:00|text|||||clear
||
31092|2026-04-15T12:22:05.009249+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444||AXTextArea|shell
31091|2026-04-15T12:22:04.885067+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444|||
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ # What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_bound
FROM elements
ORDER BY id DESC
LIMIT 5;
"
# ui_events sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, event_type, app_name, window_title,
x, y, text_content, element_role, element_name
FROM ui_events
ORDER BY id DESC
LIMIT 5; <....
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
zsh: command not found: #
84968 total
3724672 total
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
zsh: command not found: #
24475|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $ ls~/.screenpipe/data/ | head -20datapen
24473|||0| iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSprint Review - in 38 mA100% <478Wed 15 Apr 15:22:29T81-zsh-zshDOCK
24472|||0|p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N*
24471|||0|iTerm2ShellEditViewSessionScriptsProfilesWindowHelpalol# Sprint Review - in 38 m-zsh-zshDOCKER• ₴1DEV (-zsh)182APP (-zsh
24465|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24491
|
|
1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.9 1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.954861104488373|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536005|24468|accessibility|AXButton|3|Close Tab|0.878472208976746|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536004|24468|accessibility|AXRadioButton|2|-zsh|0.874305546283722|0.[CREDIT_CARD]|0.109027780592442|0.[CREDIT_CARD]
1536003|24468|accessibility|AXButton|3|Close Tab|0.769444465637207|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
zsh: command not found: #
31095|2026-04-15T12:22:07.451725+00:00|clipboard|||||# What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_boun...||
31094|2026-04-15T12:22:07.450817+00:00|key|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|||||
31093|2026-04-15T12:22:06.690369+00:00|text|||||clear
||
31092|2026-04-15T12:22:05.009249+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444||AXTextArea|shell
31091|2026-04-15T12:22:04.885067+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444|||
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ # What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_bound
FROM elements
ORDER BY id DESC
LIMIT 5;
"
# ui_events sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, event_type, app_name, window_title,
x, y, text_content, element_role, element_name
FROM ui_events
ORDER BY id DESC
LIMIT 5; <....
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
zsh: command not found: #
84968 total
3724672 total
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
zsh: command not found: #
24475|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $ ls~/.screenpipe/data/ | head -20datapen
24473|||0| iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSprint Review - in 38 mA100% <478Wed 15 Apr 15:22:29T81-zsh-zshDOCK
24472|||0|p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N*
24471|||0|iTerm2ShellEditViewSessionScriptsProfilesWindowHelpalol# Sprint Review - in 38 m-zsh-zshDOCKER• ₴1DEV (-zsh)182APP (-zsh
24465|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24492
|
|
1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.9 1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.954861104488373|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536005|24468|accessibility|AXButton|3|Close Tab|0.878472208976746|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536004|24468|accessibility|AXRadioButton|2|-zsh|0.874305546283722|0.[CREDIT_CARD]|0.109027780592442|0.[CREDIT_CARD]
1536003|24468|accessibility|AXButton|3|Close Tab|0.769444465637207|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
zsh: command not found: #
31095|2026-04-15T12:22:07.451725+00:00|clipboard|||||# What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_boun...||
31094|2026-04-15T12:22:07.450817+00:00|key|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|||||
31093|2026-04-15T12:22:06.690369+00:00|text|||||clear
||
31092|2026-04-15T12:22:05.009249+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444||AXTextArea|shell
31091|2026-04-15T12:22:04.885067+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444|||
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ # What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_bound
FROM elements
ORDER BY id DESC
LIMIT 5;
"
# ui_events sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, event_type, app_name, window_title,
x, y, text_content, element_role, element_name
FROM ui_events
ORDER BY id DESC
LIMIT 5; <....
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
zsh: command not found: #
84968 total
3724672 total
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
zsh: command not found: #
24475|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $ ls~/.screenpipe/data/ | head -20datapen
24473|||0| iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSprint Review - in 38 mA100% <478Wed 15 Apr 15:22:29T81-zsh-zshDOCK
24472|||0|p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N*
24471|||0|iTerm2ShellEditViewSessionScriptsProfilesWindowHelpalol# Sprint Review - in 38 m-zsh-zshDOCKER• ₴1DEV (-zsh)182APP (-zsh
24465|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24493
|
|
1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.9 1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.954861104488373|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536005|24468|accessibility|AXButton|3|Close Tab|0.878472208976746|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536004|24468|accessibility|AXRadioButton|2|-zsh|0.874305546283722|0.[CREDIT_CARD]|0.109027780592442|0.[CREDIT_CARD]
1536003|24468|accessibility|AXButton|3|Close Tab|0.769444465637207|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
zsh: command not found: #
31095|2026-04-15T12:22:07.451725+00:00|clipboard|||||# What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_boun...||
31094|2026-04-15T12:22:07.450817+00:00|key|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|||||
31093|2026-04-15T12:22:06.690369+00:00|text|||||clear
||
31092|2026-04-15T12:22:05.009249+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444||AXTextArea|shell
31091|2026-04-15T12:22:04.885067+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444|||
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ # What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_bound
FROM elements
ORDER BY id DESC
LIMIT 5;
"
# ui_events sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, event_type, app_name, window_title,
x, y, text_content, element_role, element_name
FROM ui_events
ORDER BY id DESC
LIMIT 5; <....
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
zsh: command not found: #
84968 total
3724672 total
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
zsh: command not found: #
24475|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $ ls~/.screenpipe/data/ | head -20datapen
24473|||0| iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSprint Review - in 38 mA100% <478Wed 15 Apr 15:22:29T81-zsh-zshDOCK
24472|||0|p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N*
24471|||0|iTerm2ShellEditViewSessionScriptsProfilesWindowHelpalol# Sprint Review - in 38 m-zsh-zshDOCKER• ₴1DEV (-zsh)182APP (-zsh
24465|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24494
|
|
1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.9 1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.954861104488373|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536005|24468|accessibility|AXButton|3|Close Tab|0.878472208976746|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536004|24468|accessibility|AXRadioButton|2|-zsh|0.874305546283722|0.[CREDIT_CARD]|0.109027780592442|0.[CREDIT_CARD]
1536003|24468|accessibility|AXButton|3|Close Tab|0.769444465637207|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
zsh: command not found: #
31095|2026-04-15T12:22:07.451725+00:00|clipboard|||||# What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_boun...||
31094|2026-04-15T12:22:07.450817+00:00|key|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|||||
31093|2026-04-15T12:22:06.690369+00:00|text|||||clear
||
31092|2026-04-15T12:22:05.009249+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444||AXTextArea|shell
31091|2026-04-15T12:22:04.885067+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444|||
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ # What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_bound
FROM elements
ORDER BY id DESC
LIMIT 5;
"
# ui_events sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, event_type, app_name, window_title,
x, y, text_content, element_role, element_name
FROM ui_events
ORDER BY id DESC
LIMIT 5; <....
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
zsh: command not found: #
84968 total
3724672 total
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
zsh: command not found: #
24475|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $ ls~/.screenpipe/data/ | head -20datapen
24473|||0| iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSprint Review - in 38 mA100% <478Wed 15 Apr 15:22:29T81-zsh-zshDOCK
24472|||0|p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N*
24471|||0|iTerm2ShellEditViewSessionScriptsProfilesWindowHelpalol# Sprint Review - in 38 m-zsh-zshDOCKER• ₴1DEV (-zsh)182APP (-zsh
24465|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24495
|
|
1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.9 1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.954861104488373|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536005|24468|accessibility|AXButton|3|Close Tab|0.878472208976746|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536004|24468|accessibility|AXRadioButton|2|-zsh|0.874305546283722|0.[CREDIT_CARD]|0.109027780592442|0.[CREDIT_CARD]
1536003|24468|accessibility|AXButton|3|Close Tab|0.769444465637207|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
zsh: command not found: #
31095|2026-04-15T12:22:07.451725+00:00|clipboard|||||# What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_boun...||
31094|2026-04-15T12:22:07.450817+00:00|key|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|||||
31093|2026-04-15T12:22:06.690369+00:00|text|||||clear
||
31092|2026-04-15T12:22:05.009249+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444||AXTextArea|shell
31091|2026-04-15T12:22:04.885067+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444|||
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ # What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_bound
FROM elements
ORDER BY id DESC
LIMIT 5;
"
# ui_events sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, event_type, app_name, window_title,
x, y, text_content, element_role, element_name
FROM ui_events
ORDER BY id DESC
LIMIT 5; <....
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
zsh: command not found: #
84968 total
3724672 total
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
zsh: command not found: #
24475|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $ ls~/.screenpipe/data/ | head -20datapen
24473|||0| iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSprint Review - in 38 mA100% <478Wed 15 Apr 15:22:29T81-zsh-zshDOCK
24472|||0|p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N*
24471|||0|iTerm2ShellEditViewSessionScriptsProfilesWindowHelpalol# Sprint Review - in 38 m-zsh-zshDOCKER• ₴1DEV (-zsh)182APP (-zsh
24465|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24496
|
|
1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.9 1536006|24468|accessibility|AXStaticText|1|⌥⌘1|0.954861104488373|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536005|24468|accessibility|AXButton|3|Close Tab|0.878472208976746|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
1536004|24468|accessibility|AXRadioButton|2|-zsh|0.874305546283722|0.[CREDIT_CARD]|0.109027780592442|0.[CREDIT_CARD]
1536003|24468|accessibility|AXButton|3|Close Tab|0.769444465637207|0.[CREDIT_CARD]|0.[CREDIT_CARD]|0.[CREDIT_CARD]
zsh: command not found: #
31095|2026-04-15T12:22:07.451725+00:00|clipboard|||||# What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_boun...||
31094|2026-04-15T12:22:07.450817+00:00|key|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|||||
31093|2026-04-15T12:22:06.690369+00:00|text|||||clear
||
31092|2026-04-15T12:22:05.009249+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444||AXTextArea|shell
31091|2026-04-15T12:22:04.885067+00:00|click|Code|Getting started with Cla… — screenpipe [SSH: [IP_ADDRESS]]|449|444|||
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clear
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ # What's in one day's folder
ls ~/.screenpipe/data/data/2026-04-15/ | head -40
# Total size of jpg vs mp4
find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1
find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1
# Sample filenames to understand naming pattern
ls ~/.screenpipe/data/data/2026-04-15/ | head -20
# One more query - sample ocr_text correctly
sqlite3 ~/.screenpipe/db.sqlite "
SELECT o.frame_id, o.app_name, o.window_name, o.focused,
substr(o.text, 1, 120) as text_preview
FROM ocr_text o
ORDER BY o.frame_id DESC
LIMIT 5;
"
# And frames sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, app_name, window_name, snapshot_path,
capture_trigger, text_source, content_hash
FROM frames
ORDER BY id DESC
LIMIT 5;
"
# And elements sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, frame_id, source, role, depth,
substr(text,1,80) as text_preview,
left_bound, top_bound, width_bound, height_bound
FROM elements
ORDER BY id DESC
LIMIT 5;
"
# ui_events sample
sqlite3 ~/.screenpipe/db.sqlite "
SELECT id, timestamp, event_type, app_name, window_title,
x, y, text_content, element_role, element_name
FROM ui_events
ORDER BY id DESC
LIMIT 5; <....
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
1776255126801_m1.jpg
1776255126826_m2.jpg
1776255131014_m1.jpg
1776255133998_m1.jpg
1776255137048_m1.jpg
1776255143085_m1.jpg
1776255157610_m2.jpg
1776255161190_m1.jpg
1776255164220_m1.jpg
1776255179372_m1.jpg
1776255185421_m1.jpg
1776255188276_m2.jpg
1776255200500_m1.jpg
1776255206549_m1.jpg
1776255209599_m1.jpg
1776255212613_m1.jpg
1776255215618_m1.jpg
1776255218627_m1.jpg
1776255218823_m2.jpg
1776255224697_m1.jpg
zsh: command not found: #
84968 total
3724672 total
zsh: command not found: #
1776255040486_m1.jpg
1776255046311_m1.jpg
1776255052379_m1.jpg
1776255055390_m1.jpg
1776255058429_m1.jpg
1776255061417_m1.jpg
1776255064483_m1.jpg
1776255066815_m2.jpg
1776255067464_m1.jpg
1776255073530_m1.jpg
1776255088641_m1.jpg
1776255091674_m1.jpg
1776255097425_m2.jpg
1776255097675_m1.jpg
1776255100707_m1.jpg
1776255103751_m1.jpg
1776255106761_m1.jpg
1776255112820_m1.jpg
1776255121875_m1.jpg
1776255124929_m1.jpg
zsh: command not found: #
24475|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $ ls~/.screenpipe/data/ | head -20datapen
24473|||0| iTerm2ShellEditViewSessionScriptsProfilesWindowHelpSprint Review - in 38 mA100% <478Wed 15 Apr 15:22:29T81-zsh-zshDOCK
24472|||0|p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N*
24471|||0|iTerm2ShellEditViewSessionScriptsProfilesWindowHelpalol# Sprint Review - in 38 m-zsh-zshDOCKER• ₴1DEV (-zsh)182APP (-zsh
24465|||0|CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $
DOCKER
Close Tab
DEV (-zsh)
Close Tab
APP (-zsh)
Close Tab
ec2-user@ip-10-30-159-14:~ (nc)
Close Tab
-zsh
Close Tab
-zsh
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
-zsh...
|
iTerm2
|
-zsh
|
NULL
|
24960
|