|
24460
|
iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKE iTerm2ShellEditViewSessionScriptsProfiles•• 0DOCKERO ₴1DEV (-zsh)H82lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny1776255040486_m1. jpg1776255046311_m1.jpg1776255052379_m1.jpg1776255055390_m1. jpg1776255058429_m1.jpg1776255061417_ml. jpg1776255064483_m1. jpg1776255066815_m2.jpg1776255067464_m1.jpg1776255073530_m1.jpg1776255088641_m1.jpg1776255091674_m1.jpg1776255097425_m2.jpg1776255097675_m1. jpg1776255100707_m1.jpg1776255103751_ml.jpg1776255106761_m1. jpg1776255112820_m1. jpg1776255121875_m1.jpg1776255124929_m1.jpg1776255126801_m1.jpg1776255126826_m2.jpg1776255131014_m1.jpg1776255133998_m1. jpg1776255137048_m1.jpg1776255143085_m1.jpg1776255157610_m2. jpg1776255161190_m1.jpg1776255164220_m1.jpg1776255179372_m1.jpg1776255185421_m1.jpg1776255188276_m2.jpg1776255200500_m1.jpg1776255206549_m1. jpg1776255209599_m1.jpg1776255212613_m1.jpg1776255215618_m1.jpg1776255218627_m1.jpg1776255218823_m2.jpg1776255224697_m1.jpglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 0WindowHelp(ah)Sprint Review - in 39 m100% <478-zshWed 15 Apr 15:21:59T81APP (-zsh)83ec2-user@ip-10-... 884-zsh*5-zsh~/.screenpipe $ ls~/.screenpipe/data/data/2026-04-15/ | head-4086-zshO ₴7.* Unable to a...O 88-zsh...
|
NULL
|
NULL
|
NULL
|
24460
|
|
24459
|
p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SASl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5", 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam— New |aoViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $ ls~/.screenpipe/data/| head-20datapending-transcriptionsscreenpipe.dblukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls~/.screenpipe/data/$(Is ~/.screenpipe/data/ | head -1)/ | head -302026-04-09Show moreRun a few more to complete the picture:bashReply +# What's in one day'Is -/.screenpipe/data/data/2026-04-15/ | head -# Total size of jpg vs mp4find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1find ~/.screenpipe/data -name "*.mp4" -exec du -c (} + 2>/dev/null | [ail -1# sample Tirehames to understand haming pattert1s ~-/.screenpipe/data/data/2026-04-15/ | head -20# One more query - sample ocr_text correctlysqlite3 ~/. screenpipe/db.sqlite "SELECT o.frame_id, o.app_name, o.window_name,o. focused,substr(o.text, 1, 120) as text_previewFROM ocr_text oORDER BY o.frame_id DESCLIMIT 5;# And frames samplesqlite3 ~/.screenpipe/db.sqlite "SELECT id, timestamp, app_name, window_name,snapshot_path,capture_trigger, text_source,content_hashFROM framesORDER BY id DESCLIMIT 5;# And elements sampleReply...+Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24459
|
|
24458
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp<lthlSprint Review - in 39 m100% (<47-zshDOCKER• ₴1DEV (-zsh)₴82lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny1776255040486_m1. jpg1776255046311_m1.jpg1776255052379_m1.jpg1776255055390_m1. jpg1776255058429_m1.jpg1776255061417_ml.jpg1776255064483_m1. jpg1776255066815_m2.jpg1776255067464_m1.jpg1776255073530_m1.jpg1776255088641_m1.jpg1776255091674_m1.jpg1776255097425_m2.jpg1776255097675_m1. jpg1776255100707_m1.jpg1776255103751_ml.jpg1776255106761_m1. jpg1776255112820_m1. jpg1776255121875_m1. jpg1776255124929_m1.jpg1776255126801_m1.jpg1776255126826_m2.jpg1776255131014_m1.jpg1776255133998_m1. jpg1776255137048_m1.jpg1776255143085_m1.jpg1776255157610_m2. jpg1776255161190_m1.jpg1776255164220_m1.jpg1776255179372_m1.jpg1776255185421_m1.jpg1776255188276_m2.jpg1776255200500_m1.jpg1776255206549_m1. jpg1776255209599_m1.jpg1776255212613_m1.jpg1776255215618_m1.jpg1776255218627_m1.jpg1776255218823_m2.jpg1776255224697_m1.jpglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $APP (-zsh)83ec2-user@ip-10-... 884-zsh~/.screenpipe $ ls~/.screenpipe/data/data/2026-04-15/*5-zshhead-4086-zshO ₴7.* Unable to a...88Wed 15 Apr 15:21:59-zshT81+...
|
NULL
|
NULL
|
NULL
|
24458
|
|
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
|
24457
|
|
24456
|
-- 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
|
|
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 $ 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
|
|
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 $
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
|
|
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
|
24453
|
|
24452
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹→0 ll 0Sprint Review - in 39 m•• 0-zsh|DOCKER0 ₴1DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-... 884-zshLukas@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_previewFROM ocr_textORDER BY frame_id DESCLIMIT 5;*5-zsh86-zshError: in prepare, no suchcolumn: browser_urlSELECT frame_id, app_name, window_name, browser_url, focused,substrCerror here ---^lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clearlukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20datapending-transcriptionsscreenpipe.dblukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/S(ls ~/.screenpipe/data/ | head -1)/ | head -302026-04-092026-04-112026-04-122026-04-132026-04-142026-04-15lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc - 1146lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -1526lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh (} + 2>/dev/null | tail -1256K/Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2. jpglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -12.0M/Users/lukas/.screenpipe/data/data/2026-04-15/compact_monitor_2_1776255640728.mp4compact-_monitor -2_1776255640728.mpa /devnutt tarl -2lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $100% C8Wed 15 Apr 15:21:52181O ₴7.* Unable to a...O 88-zsh...
|
NULL
|
NULL
|
NULL
|
24452
|
|
24451
|
CaudeFileEditViewWindowHelp• Not Secure | [URL_WIT CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $ ls~/.screenpipe/data/| head-20datapending-transcriptionsscreenpipe.dblukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls~/.screenpipe/data/$(Is ~/.screenpipe/data/ | head -1)/ | head -302026-04-09Show moreRun a few more to complete the picture:bash# What's in one day's folder1s ~/.screenpipe/data/data/2026-04-15/ | head -40# Total size of jpg vs mp4find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1# sample Tirehames to understand haming patteri1s ~/.screenpipe/data/data/2026-04-15/ | head -20# One more query - sample ocr_text correctlysqlite3 ~/ . screenpipe/db.sqlite "SELECT o.frame_id, o.app_name, o.window_name,o. focused,substr(o.text, 1, 120) as text_previewFROM ocr_text oORDER BY o.frame_id DESCLIMIT 5;# And frames samplesqlite3 ~/.screenpipe/db.sqlite "SELECT id, timestamp, app_name, window_name,snapshot_path,capture_trigger, text_source,content_hashFROM framesORDER BY id DESCLIMIT 5;# And elements sampleReply...+Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24451
|
|
24450
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹→0 ll 0Sprint Review - in 39 m•• 0-zsh|DOCKER0 ₴1DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-... 884-zshLukas@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_previewFROM ocr_textORDER BY frame_id DESCLIMIT 5;*5-zsh86-zshError: in prepare, no suchcolumn: browser_urlSELECT frame_id, app_name, window_name, browser_url, focused,substrCerror here ---^lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clearlukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20datapending-transcriptionsscreenpipe.dblukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/S(ls ~/.screenpipe/data/ | head -1)/ | head -302026-04-092026-04-112026-04-122026-04-132026-04-142026-04-15lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc - 1146lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -1526lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh (} + 2>/dev/null | tail -1256K/Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2. jpglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -12.0M/Users/lukas/.screenpipe/data/data/2026-04-15/compact_monitor_2_1776255640728.mp4compact-_monitor -2_1776255640728.mpa /devnutt tarl -2lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $100% C8Wed 15 Apr 15:21:51181O ₴7.* Unable to a...O 88-zsh...
|
NULL
|
NULL
|
NULL
|
24450
|
|
24449
|
CaudeFileEditViewWindowHelp• Not Secure | [URL_WIT CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $ ls~/.screenpipe/data/| head-20datapending-transcriptionsscreenpipe.dblukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls~/.screenpipe/data/$(Is ~/.screenpipe/data/ | head -1)/ | head -302026-04-09Show moreRun a few more to complete the picture:bash# What's in one day's folder1s ~/.screenpipe/data/data/2026-04-15/ | head -40# Total size of jpg vs mp4find ~/.screenpipe/data -name "*.jpg" -exec du -c {} + 2>/dev/null | tail -1find ~/.screenpipe/data -name "*.mp4" -exec du -c {} + 2>/dev/null | tail -1# sample Tirehames to understand haming patteri1s ~/.screenpipe/data/data/2026-04-15/ | head -20# One more query - sample ocr_text correctlysqlite3 ~/ . screenpipe/db.sqlite "SELECT o.frame_id, o.app_name, o.window_name,o. focused,substr(o.text, 1, 120) as text_previewFROM ocr_text oORDER BY o.frame_id DESCLIMIT 5;# And frames samplesqlite3 ~/.screenpipe/db.sqlite "SELECT id, timestamp, app_name, window_name,snapshot_path,capture_trigger, text_source,content_hashFROM framesORDER BY id DESCLIMIT 5;# And elements sampleReply...+Sonnet 40claude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24449
|
|
24448
|
CaudeFileEditViewWindowHelp• Not Secure | [URL_WIT CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $ ls~/.screenpipe/data/| head-20datapending-transcriptionsscreenpipe.dblukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls~/.screenpipe/data/$(Is ~/.screenpipe/data/ | head -1)/ | head -302026-04-09'0A-04-1"Show moreRun a few more to complete the picture:bash# What's in one day's folder1s ~/.screenpipe/data/data/2026-04-15/ | head -40# Total size of jpg vs mp4find ~/.Reply...+Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24448
|
|
24447
|
CaudeFileEditViewWindowHelp• Not Secure | [URL_WIT CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $ ls~/.screenpipe/data/| head-20datapending-transcriptionsscreenpipe.dblukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ Is~/.screenpipe/data/$(Is ~/.screenpipe/data/ | head -1)/ | head -302026-04-09'0A-04-1"Show moreSonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24447
|
|
24446
|
CaudeFileEditViewWindowHelp• Not Secure | [URL_WIT CaudeFileEditViewWindowHelp• Not Secure | [URL_WITH_CREDENTIALS] ~/.screenpipe $ find ~/.screenpipe/data -name"*jpg" | wc-l146lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name"*.mp4" | wc-1526lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name"*jpg" -exec du -sh f} + 2>/dev/null | tail -1256K /Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2.jpglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe$ du -sh~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -12.0M /Users/lukas/.screenpipe/data/data/2026-04-15/compact_monitor_2_1776255640728.mp4lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $+Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24446
|
|
24445
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹→0 ll 0Sprint Review - in 39 m•• 0-zsh|DOCKER0 ₴1DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-... 884-zshLukas@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_previewFROM ocr_textORDER BY frame_id DESCLIMIT 5;*5-zsh86-zshError: in prepare, no suchcolumn: browser_urlSELECT frame_id, app_name, window_name, browser_url, focused,substrCerror here ---^lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clearlukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20datapending-transcriptionsscreenpipe.dblukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/S(ls ~/.screenpipe/data/ | head -1)/ | head -302026-04-092026-04-112026-04-122026-04-132026-04-142026-04-15lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc - 1146lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -1526lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh (} + 2>/dev/null | tail -1256K/Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2. jpglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -12.0M/Users/lukas/.screenpipe/data/data/2026-04-15/compact_monitor_2_1776255640728.mp4compact-_monitor -2_1776255640728.mpa /devnutt tarl -2lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $100% C8Wed 15 Apr 15:21:35181O ₴7.* Unable to a...O 88-zsh...
|
NULL
|
NULL
|
NULL
|
24445
|
|
24444
|
CaudeFileEditViewWindowHelp• Not Secure | http://[ CaudeFileEditViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminip! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam- New laomenoe c ne crmmial vommmialleIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2do.scllte Trames_tts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_audio_transcriptions_…audio_transcriptions_.elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, pg•..n<+ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso…..Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ..Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaravel issue troubleshootingLukas KovalikPro nian, 0ChatCoworklablCodeSprint Review • in 39 m100%C4Linux SQLite Ul for NAS vSELECT sql FROM sqlite_masterWHERE type='table'AND name NOT LIKEAND name NOT LIKE"%_fts%"AND name NOT LIKE'sqlite_%'_sq1x%'ORDER BY name;Query 3 - what does actual data look like:sqlSELECT frame_id, app_name, window_name, browser_url,Tecuseosubstr text. 1. 100) as text previewFROM ocr_textORDER BY frame_id DESCLIMIT 5;And from terminal, check the data folder structure:bash# What's in data/1s ~/.screenpipe/data/ | head -20# One day's folder contentsls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30# Count JPGs vs MP4sfind ~/.screenpipe/data -name "*.jpg" | wc -1find ~/.screenpipe/data -name "*.mp4" | wC -1*oilze or cacn cyotfind ~/.screenpipe/data -name "*.jpg" -exec du -sh 1} + 2>/dev/null | tail -1du -sh ~/. screenpipe/data/**/*.mp4 2>/dev/null | tail -1Paste all outputs and I'll give you the full picture — both DB and filesystem side — with acomplete explanation of the capture pipeline.Wed 15 Apr 15:21:33024 / 1024 as size, mb...PASTEDReply...+Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24444
|
|
24443
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp‹→0 ll 0Sprint Review - in 39 m•• 0-zsh|DOCKER0 ₴1DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-... 884-zshLukas@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_previewFROM ocr_textORDER BY frame_id DESCLIMIT 5;*5-zsh86-zshError: in prepare, no suchcolumn: browser_urlSELECT frame_id, app_name, window_name, browser_url, focused,substrCerror here ---^lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clearlukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20datapending-transcriptionsscreenpipe.dblukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/S(ls ~/.screenpipe/data/ | head -1)/ | head -302026-04-092026-04-112026-04-122026-04-132026-04-142026-04-15lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc - 1146lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -1526lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh (} + 2>/dev/null | tail -1256K/Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2. jpglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -12.0M/Users/lukas/.screenpipe/data/data/2026-04-15/compact_monitor_2_1776255640728.mp4compact-_monitor -2_1776255640728.mpa /devnutt tarl -2lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $100% C8Wed 15 Apr 15:21:33T81- 87* Unable to a...O 88-zsh...
|
NULL
|
NULL
|
NULL
|
24443
|
|
24442
|
p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam— New |aoViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminimenoe c ne crmmial vommmialleIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2 db.sqlite frames_fts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_.audio_transcriptions_…audio_transcriptions_.elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, po+ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso…..Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ..Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niormaron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaraver issue troublesnootingLukas KovalikPro nian> 0.ChatCoworkloblCodeSprint Review • in 39 m100%4]Linux SQLite Ul for NAS vSELECT sql FROM sqlite_masterWHERETvoe='taole'AND name NOT LIKEAND name NOT"%_fts%"AND name NOT LIKE'sqlite_%'_sq1x%'ORDER BY name;Query 3 - what does actual data look like:sqlSELECT frame id. app name, window name, browser url,Tecuseosubstr(text. 1. 100) as text previewFROM ocr_textORDER BY frame_id DESCLIMIT 5;And from terminal, check the data folder structure:bash# What's in data/1s ~/.screenpipe/data/ | head -20# One day's folder contentsls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30# Count JPGs vs MP4sfind ~/.screenpipe/data -name "*.jpg" | wc -1find ~/.screenpipe/data -name "*.mp4" | wc -1# Size of each typefind ~/.screenpipe/dataReply +jpg" -exec du -sh {} + 2>/dev/null | tail -1du -sh ~/ . screenpipe/data/**/*.mp4 2>/dev/nu1l | tail -1Paste all outputs and I'll give you the full picture — both DB and filesystem side — with acomplete explanation of the capture pipeline.Wed 15 Apr 15:21:32024 / 1024 as size, mb...PASTEDReply...+Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24442
|
|
24441
|
iterm2ShellEditViewSessionScriptsProfilesWindowHel iterm2ShellEditViewSessionScriptsProfilesWindowHelp‹ →0 ll 0§ Sprint Review - in 39 mA100% (<47-zshDOCKERO $1DEV (-zsh)₴82APP (-zsh)83ec2-user@ip-10-... 884-zshlukas@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_previewFROM ocr_textORDER BY frame_id DESCLIMIT 5;*5-zsh86-zshError: in prepare, no such column: browser_urlSELECT frame_id, app_name, window_name, browser_url, focused,substrCerror here ---^lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ clearlukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/ | head -20datapending-transcriptionsscreenpipe.dblukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/S(ls ~/.screenpipe/data/ | head -1)/ | head -302026-04-092026-04-112026-04-122026-04-132026-04-142026-04-15lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc - 1146lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -1526lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" -exec du -sh (} + 2>/dev/null | tail -1256K/Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2. jpglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -12.0M/Users/lukas/.screenpipe/data/data/2026-04-15/compact_monitor_2_1776255640728.mp4lukas®Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $* Unable to a...O 88Wed 15 Apr 15:21:32-zshT81+...
|
NULL
|
NULL
|
NULL
|
24441
|
|
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
|
24440
|
|
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
|
24439
|
|
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
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
|
|
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 $
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
|
|
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
|
24436
|
|
24435
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpallSprint Review • in 39 m100% <478-zshDOCKERO $1DEV (-zsh)H82APP (-zsh)83ec2-user@ip-10-... 284-zshlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ ls~/.screenpipe/data/1 head -20*5-zsh86-zshO ₴7.datapending-transcriptionsscreenpipe.dblukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/S(ls ~/.screenpipe/data/ | head -1)/ | head -302026-04-092026-04-112026-04-122026-04-132026-04-142026-04-15lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l146lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -1526lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find~/.screenpipe/data-name "*.jpg"-exec du -sh {} + 2>/dev/null | tail -1256K/Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2. jpglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ 0* Unable to a...О 88Wed 15 Apr 15:21:22-zshT81+...
|
NULL
|
NULL
|
NULL
|
24435
|
|
24434
|
CaudeFileEditViewWindowHelp• Not Secure | http://[ CaudeFileEditViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminip! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam- New laomenoe c ne crmmial vommmialleIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2do.scllte Trames_tts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_audio_transcriptions_…audio_transcriptions_..elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, pg•..n<+ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso…..Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ..Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaravel issue troubleshootingLukas KovalikPro oian, 0ChatCoworklablCodeSprint Review • in 39 mLinux SQLite Ul for NAS vSELECT sql FROM sqlite_masterWHERETvoe='taole'AND name NOT LIKEAND name NOT LIKE'%_fts%'AND name NOT LIKE'sqlite_%'_sq1x%'ORDER BY name;Query 3 - what does actual data look like:sqlSELECT frame_id, app_name, window_name, browser_url,Tecuseosubstr text. 1. 100) as text previewFROM ocr_textORDER BY frame_id DESCLIMIT 5;And from terminal, check the data folder structure:bash# What's in data/1s ~/.screenpipe/data/ | head -20# One day's folder contents1s ~/.screenpipe/data/$(ls ~/.screenpipe/data/ head -1)/ | head -30# Count JPGs vs MP4sfind ~/.screenpipe/data -name "*.jpg" | wc -1find ~/.screenpipe/data -name "*.mp4" | wc -1Reply +# Size of each typefind ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1du -sh hy. screenpipe/data/**/*.mp4 2>/dev/null | tail -1|Paste all outputs and I'll give you the full picture — both DB and filesystem side — with acomplete explanation of the capture pipeline.100%C4Wed 15 Apr 15:21:21024 / 1024 as size, mb...PASTEDReply...+Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24434
|
|
24433
|
p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam- New laoViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminimenoe c ne crmmial vommmialleIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2 db.sqlite frames_fts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_.audio_transcriptions_…audio_transcriptions_.elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, po+ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso…..Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ..Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaraver issue troublesnootingLukas KovalikPro nian> 0.ChatCoworkloblCodeSprint Review • in 39 mLinux SQLite Ul for NAS vSELECT sql FROM sqlite_masterWHERETvoe='taole'AND name NOT LIKEAND name NOT"%_fts%"AND name NOT LIKE'sqlite_%'_sq1x%'ORDER BY name;Query 3 - what does actual data look like:sqlSELECT frame_id, app_name, window_name, browser_url,Tecuseosubstr text. 1.100) as text previewFROM ocr_textORDER BY frame_id DESCLIMIT 5;And from terminal, check the data folder structure:bash# What's in data/1s ~/.screenpipe/data/ | head -20# One day's folder contents1s ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ head -30# Count JPGs vs MP4sfind ~/.screenpipe/data -name "*.jpg" | wc -1find ~/.screenpipe/data -name "*.mp4" | wc -1Reply +# Size of each typefind ~/.screenpipe/data -name "*.jpg" -exec du -sh 1} + 2>/dev/null | tail -1du -sh ~/.screenpipe/data/**/*.mp4 2>/dev/null | tail -1Paste all outputs and I'll give you the full picture — both DB and filesystem side — with acomplete explanation of the capture pipeline.100%4]Wed 15 Apr 15:21:20024 / 1024 as size, mb...PASTEDReply...+Sonnet 46claude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24433
|
|
24432
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpaholSprint Review - in 39 m100% (C47Wed 15 Apr 15:21:20-zshT&1DOCKERO 81DEV (-zsh)$82APP (-zsh)83ec2-user@ip-10-.. 884-zshlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ ls~/.screenpipe/data/1 head -20*5-zsh86-zshO ₴7.datapending-transcriptionsscreenpipe.dblukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/S(ls ~/.screenpipe/data/ | head -1)/ | head -302026-04-092026-04-112026-04-122026-04-132026-04-142026-04-15lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l146lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -1526lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find~/.screenpipe/data-name "*.jpg"-exec du -sh {} + 2>/dev/nullI tail -1256K/Users/lukas/.screenpipe/data/data/2026-04-15/1776255157610_m2. jpglukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ |* Unable to a...88-zsh...
|
NULL
|
NULL
|
NULL
|
24432
|
|
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
|
24431
|
|
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
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
|
|
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 $
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
|
|
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
|
24428
|
|
24427
|
CaudeFileEditViewWindowHelp• Not Secure | http://[ CaudeFileEditViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminip! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam- New laomenoe c ne crmmial vommmialleIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2do.scllte Trames_tts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_audio_transcriptions_…audio_transcriptions_.elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, pg•..n<+ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso…..Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ..Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaravel issue troubleshootingLukas KovalikPro nian, 0ChatCoworklablCodeSprint Review • in 39 mLinux SQLite Ul for NAS vSELECT sql FROM sqlite_masterWHEREtype-"tadle"AND name NOT LIKEAND name NOT LIKE'%_fts%'AND name NOT LIKE'sqlite_%'_sq1x%'ORDER BY name;Query 3 - what does actual data look like:sqlSELECT frame_id, app_name, window_name, browser_url,Tecuseosubstr(text. 1. 100) as text previewFROM ocr_textORDER BY frame_id DESCLIMIT 5;And from terminal, check the data folder structure:bash# What's in data/1s ~/.screenpipe/data/ | head -20# One day's folder contents1s ~/.screenpipe/data/$(ls ~/.screenpipe/data/ head -1)/ | head -30# Count JPGs vs MP4sfind ~/.screenpipe/data -name "*.jpg" | wc -1find ~/.screenpipe/data -name "*.mp4" | wC -1*oilze or cacn cyotfind ~/.screenpipe/data -name "*.jpg" -exec du fsh 1} + 2>/dev/null | tail -1du -sh ~/. screenpipe/data/**/*.mp4 2>/dev/null | tail -1Paste all outputs and I'll give you the full picture — both DB and filesystem side — with acomplete explanation of the capture pipeline.100% C4Wed 15 Apr 15:21:15024 / 1024 as size, mb...PASTEDReply...+Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24427
|
|
24426
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp(al]Sprint Review - in 39 mA100% <478-zshDOCKERO $1DEV (-zsh)H82APP (-zsh)83ec2-user@ip-10-.. 884-zshlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ ls ~/.screenpipe/data/ | head -20*5-zsh86-zshdatapending-transcriptionsscreenpipe.dblukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/S(ls ~/.screenpipe/data/ | head -1)/ | head -302026-04-092026-04-112026-04-122026-04-132026-04-142026-04-15lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l146lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -1526lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ПO 87* Unable to a...О 88Wed 15 Apr 15:21:14-zshT81+...
|
NULL
|
NULL
|
NULL
|
24426
|
|
24425
|
p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam— New |aoViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminimenoe c ne crmmial vommmialleIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2 db.sqlite frames_fts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_.audio_transcriptions_…audio_transcriptions_.elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, po+ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projecthecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso…..Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ..Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niorm.ron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaraver issue troublesnootingLukas KovalikPro nian> 0.ChatCoworkloblCodeSprint Review • in 39 m100%4]Linux SQLite Ul for NAS vSELECT sql FROM sqlite_masterWHERETvoe='taole'AND name NOT LIKE"%_fts%"AND name NOTAND name NOT LIKE'sqlite_%'_sq1x%'ORDER BY name;Query 3 - what does actual data look like:sqlSELECT frame_id, app_name, window_name, browser_url,ecuseosubstr text. 1. 100) as text previewFROM ocr_textORDER BY frame_id DESCLIMIT 5;And from terminal, check the data folder structure:bash# What's in data/1s ~/.screenpipe/data/ | head -20# One day's folder contentsls ~/.screenpipe/data/$(ls ~/.screenpipe/data/ | head -1)/ | head -30# Count JPGs vs MP4sfind ~/.screenpipe/data -name "*.jpg" | wc -1find ~/. screenpipe/data -name*oilze o cacn cyotfind ~/.screenpipe/data -name "*.jpg" -exec du -sh + 2>/dev/null | tail -1du -sh ~/. screenpipe/data/**/*.mp4 2>/dev/null | tail -1Paste all outputs and I'll give you the full picture — both DB and filesystem side — with acomplete explanation of the capture pipeline.Wed 15 Apr 15:21:14024 / 1024 as size, mb...PASTEDReply...+Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24425
|
|
24424
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelpalalSprint Review - in 39 m100% (C47Wed 15 Apr 15:21:14-zshT81DOCKERO 81DEV (-zsh)$82APP (-zsh)83ec2-user@ip-10-.. 884-zshlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ ls ~/.screenpipe/data/ | head -20*5-zsh86-zshdatapending-transcriptionsscreenpipe.dblukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/S(ls ~/.screenpipe/data/ | head -1)/ | head -302026-04-092026-04-112026-04-122026-04-132026-04-142026-04-15lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -l146lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ find ~/.screenpipe/data -name "*.mp4" | wc -l526lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $|O ₴7.* Unable to a...88-zsh...
|
NULL
|
NULL
|
NULL
|
24424
|
|
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
|
24423
|
|
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
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
|
|
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 $
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
|
|
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
|
24420
|
|
24419
|
CaudeFileEditViewWindowHelp• Not Secure | http://[ CaudeFileEditViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminip! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam- New laomenoe c ne crmmiar vommmalteIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2do.scllte Trames_tts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_.audio_transcriptions_…audio_transcriptions_.elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, pg....++ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso…..Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ..Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niormaron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaraver issue troublesnootingLukas KovalikPro nian, 0ChatCoworklablCodeSprint Review • in 39 m100%C4Wed 15 Apr 15:21:06Linux SQLite Ul for NAS vWHERE d.name IN ('frames', 'ocr_text', 'elements', 'ui_events','video_chunks','audio_chunks','audio_transcriptions','memories', 'meetings', 'tags', 'pipe_executions'GROUP BY d. nameORDER BY SUM(d.pgsize) DESC;Query 2 - sample from each key table (schemas):SELECT sql FROM sqlite_masterWHERE type='table'AND name NOT LIKE "%_fts%'AND name NOT LIKE 'sqlite_%'AND name NOT LIKE '_sq1x%'ORDER BY name;Query 3 - what does actual data look like:sqlSELECT frame_id, app_name, window_name, browser_url, focused,substr(text, 1, 100) as text_previewFROM ocr_textORDER BY frame_id DESCLIMIT 5;And from terminal, check the data folder structure:# What's in data/1s ~/.screenpipe/data/ | head -20* ulie lay s loruel cuncells1s ~/.screenpipe/data/$(1s ~/.screenpipe/data/ | head -1)/ | head -30Reply +# Count JPGs vs MFfind ~/.screenpipe/data -name "*.jpg" | wc -find ~/.screenpipe/data -name "*.mp4" | wc -]find ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1du -ch ~ ccreenninecata***.mn4 2>dey/null ta1 -1024 / 1024 as size, mb...PASTEDReply...+Sonnet 46claude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24419
|
|
24418
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplallSprint Review - in 39 mA100% <478-zshDOCKERO $1DEV (-zsh)H82APP (-zsh)83ec2-user@ip-10-.. 884-zshlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ ls ~/.screenpipe/data/ | head -20*5-zsh86datapending-transcriptionsscreenpipe.db2026-04-092026-04-112026-04-122026-04-132026-04-142026-04-15146lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/S(ls ~/.screenpipe/data/ | head -1)/ | head -30lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -1lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ D-zshO ₴7.* Unable to a...О 88Wed 15 Apr 15:21:07-zshT81+...
|
NULL
|
NULL
|
NULL
|
24418
|
|
24417
|
p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB p! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam— New |aoViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminimenoe c ne crmmiar vommmalteIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2 db.sqlite frames_fts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_.audio_transcriptions_…audio_transcriptions_.elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, po+ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application..Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso…..Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ..Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niormaron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaraver issue troublesnootingLukas KovalikPro nian$0.ChatCoworkloblCodeSprint Review • in 39 m100% C42Linux SQLite Ul for NAS vWHERE d.name IN ('frames', 'ocr_text', 'elements', 'ui_events','video_chunks','audio_chunks','audio_transcriptions','memories', 'meetings', 'tags', 'pipe_executions'GROUP BY d. nameORDER BY SUM(d.pgsize) DESC;Query 2 - sample from each key table (schemas):SELECT sql FROM sqlite_masterWHERE type='table'AND name NOT LIKE "%_fts%'AND name NOT LIKE 'sqlite_%'AND name NOT LIKE '_sqlx%'ORDER BY name;Query 3 - what does actual data look like:sqlSELECT frame_id, app_name, window_name, browser_url, focused,substr(text, 1, 100) as text_previewFROM ocr_textORDER BY frame_id DESCLIMIT 5;And from terminal, check the data folder structure:bash# What's in data/1s ~/.screenpipe/data/ | head -20* ulie lay s loruel cuncells1s ~/.screenpipe/data/$(1s ~/.screenpipe/data/ | head -1)/ | head -30Reply +# Count JPGs vs MFfind ~/.screenpipe/data -name "*jpg" |Avc -1find ~/.screenpipe/data -name "*.mp4"IwC -1find ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1du -ch ~ ccreenninecata***.mn4 2>dey/null ta1 -1024 / 1024 as size, mb...PASTEDReply...+Sonnet 46 vWed 15 Apr 15:21:05claude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24417
|
|
24416
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelp>0 llSprint Review - in 39 m100% (<47Wed 15 Apr 15:21:05-zshT&1DOCKERO 81DEV (-zsh)$82APP (-zsh)83ec2-user@ip-10-... 884-zshlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ ls ~/.screenpipe/data/ | head -20*5-zsh86datapending-transcriptionsscreenpipe.db2026-04-092026-04-112026-04-122026-04-132026-04-142026-04-15146lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/S(ls ~/.screenpipe/data/ | head -1)/ | head -30lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ find ~/.screenpipe/data -name "*.jpg" | wc -1lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $-zsh* $7* Unable to a...88-zsh...
|
NULL
|
NULL
|
NULL
|
24416
|
|
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
find
Close Tab
-zsh
Close Tab
✳ Unable to access screenpipe activity data (claude)
Close Tab
-zsh
Close Tab
⌥⌘1
find...
|
iTerm2
|
find
|
NULL
|
24415
|
|
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 $
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
|
|
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
|
24413
|
|
24412
|
CaudeFileEditViewWindowHelp• Not Secure | http://[ CaudeFileEditViewWindowHelp• Not Secure | http://[IP_ADDRESS]:8767/frames_fts_data/~ Google Geminip! Western Digital Red Plus 3.5 6TB 5400rpm 256MB SAiSl I SeneticТвърд диск, Western Digital Red 6TB Plus ( 3.5". 256N* SQLite Web: db.sqlitew Screenpipe DashboardV Welcome to Steam- New laomenoe c ne crmmiar vommmalteIf you already have Terminal open, or preferusing it, you can command Finder to open thefolder for you.1. Open the Terminal app (you can find itby pressing Command + Space to openSpotlight and typing "Terminal").2. Type the following command: open~/. screenpipe3. Press Return. A new Finder window willimmediately pop up showing thecontents of the folder.Method 3: Unhide All Files in Your HomeDirectoryIf you want to be able to see the folderalongside your normal files so you can clickinto it manually.1. Open Finder.2. Go to your Home folder by pressingCommand + Shift + H (this is what the~ symbol represents).3. Press Command + Shift + . (Command,Shift, and the Period key at the sametime).4. You will see all your hidden files andfolders fade into view. Scroll down to findthe .screenpipe folder and double-click5. Note: You can press Command + Shift +• again to hide the files when you aredone to keep your folders looking clean.Eс :Ask GeminiPro vGemini is Al and can make mistakes, including about people.Your privacy and GeminiSummarize pagesqlite-web 0.7.2do.scllte Trames_tts_datatable name…saix miarationsaudio_chunksaudio_tagsaudio_transcriptionsaudio_transcriptions_fts (v)audio_transcriptions_.audio_transcriptions_…audio_transcriptions_.elementselements_fts (v)elements_fts_configelements_fts_dataelements_fts_idxframesframes_fts (v)frames_fts_configframes_fts_dataframes_fts_idxmeetingsmemoriesmemories_fts (v)memories_fts_configmemories_fts_datamemories_fts_idxocr_textpipe_executionspipe_scheduler_statespeaker_embeddingsspeakerssqlite_sequencetagsui_eventsui_events_fts (v)ui_events_fts_configui_events_fts_dataui_events_fts_idxViceo cnunksIvision laosToggle helper tablesStructureContentSQLCREATE TABLE 'frames_fts_daid INTEGER PRIMARY KEY,block BLOBColumnsColumnblockIndexesnamesulite database browser vo./.L, pg....++ New chatQ Search= CustomizeQ ChatsProjects88 ArtifactsStarredBulgarian citizenship application...Dawarich location tracking projectHecentsLinux SQLite Ul for NASClaude API 500 internal server e...Screenpipe query capabilities a...eGPU compatibility with Mac mi...Understanding OpenRouter API...Screenpipe 14-day retention exp...Reddit homepage feed overviewDocker container not visible in c..DIA browser RAM configurationScreenpipe company backgroundDSK Bank Bulgaria secure invest...Building a comprehensive perso…..Importing Google Timeline data t...Chromecast remote volume butt...Screenpipe free version guideSelf-hosted LLM alternatives to ..Screenpipe database query setupRunning screenpipe for freeMac Studio network switch setupClaude extension in Vivaldi brow...General niormaron realestRed dots on neck causesChange approvalQuerying Screenpipe with Claud...Setting up daily backups in Ugre...Upcoming remindersAccessing tools in Open WebUlLaraver issue troublesnootingLukas KovalikPro nian, 0ChatCoworklablCodeSprint Review • in 40m(A]100%C4Wed 15 Apr 15:20:58Linux SQLite Ul for NAS vWHERE d.name IN ('frames', 'ocr_text', 'elements', 'ui_events','video_chunks','audio_chunks','audio_transcriptions','memories', 'meetings', 'tags', 'pipe_executions'GROUP BY d. nameORDER BY SUM(d.pgsize) DESC;Query 2 - sample from each key table (schemas):SELECT sql FROM sqlite_masterWHERE type='table'AND name NOT LIKE "%_fts%'AND name NOT LIKE 'sqlite_%'AND name NOT LIKE '_sq1x%'ORDER BY name;Query 3 - what does actual data look like:sqlSELECT frame_id, app_name, window_name, browser_url, focused,substr(text, 1, 100) as text_previewFROM ocr_textORDER BY frame_id DESCLIMIT 5;And from terminal, check the data folder structure:bash# What's in data/1s ~/.screenpipe/data/ | head -20* ulie uays loruel cuncchlsReply1s ~/. screenpipe/data/$(1s ~/.screenpipe/data/ | head -1)/ | head -3(# Count JPGs vs MP4sfind ~/. screenpipe/data -name "*.jpg" | wc -1find ~/.screenpipe/data -name "*.mp4" | WC -1 Lfind ~/.screenpipe/data -name "*.jpg" -exec du -sh {} + 2>/dev/null | tail -1diecha cereonnine datarxxx.mn4doynuiian=t024 / 1024 as size, mb...PASTEDReply...+Sonnet 46 vclaude is Al and can make mistakes. rlease double-cneck responses....
|
NULL
|
NULL
|
NULL
|
24412
|
|
24411
|
iTerm2ShellEditViewSessionScriptsProfilesWindowHel iTerm2ShellEditViewSessionScriptsProfilesWindowHelplallSprint Review - in 40 m100% <478-zshDOCKERO $1DEV (-zsh)182APP (-zsh)83ec2-user@ip-10-... 884-zshlukas@Lukas-Kovaliks-MacBook-Pro-Jiminny~/.screenpipe $ ls ~/.screenpipe/data/ | head -20*5-zsh86datapending-transcriptionsscreenpipe.db2026-04-092026-04-112026-04-122026-04-132026-04-142026-04-15Lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ llukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ ls ~/.screenpipe/data/S(ls ~/.screenpipe/data/ | head -1)/ | head -30-zshO ₴7.* Unable to a...О 88Wed 15 Apr 15:20:58-zshT81+...
|
NULL
|
NULL
|
NULL
|
24411
|