How do I install the Osascript Data skill?

Run npx skillmds@latest add damionrashford/osascript-data in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Osascript Data safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Osascript Data?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Osascript Data free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Osascript Data?

damionrashford (@damionrashford) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Osascript Data by damionrashford — Agent Skill

Name: Osascript Data
Author: damionrashford

Osascript Data

Read macOS app SQLite databases directly. Use when reading iMessage chat history, Chrome browsing history, Safari history, or any local app SQLite DB. Always copy the DB before querying — most apps lock the file while running.

damionrashford 18343d1 6 files · 13.3 KB Updated Sep 17, 2026

File contents

osascript-data

Direct SQLite access to macOS app databases. No API, no auth — plain file reads. All scripts are pure Python using stdlib only (sqlite3, shutil).

The Universal Rule

Always copy before querying. Most apps (Chrome, Messages) lock their DB while running.

shutil.copy2(db_path, "/tmp/copy.db")
conn = sqlite3.connect("/tmp/copy.db")

Key Databases

App	Path	Permission needed
iMessage + SMS	`~/Library/Messages/chat.db`	Full Disk Access
Chrome History	`~/Library/Application Support/Google/Chrome/Default/History`	Full Disk Access
Safari History	`~/Library/Safari/History.db`	Full Disk Access
TCC permissions	`~/Library/Application Support/com.apple.TCC/TCC.db`	Full Disk Access

Scripts

Run a raw SQL query against any DB (copy-first):

uv run scripts/sqlite-query.py ~/Library/Messages/chat.db "SELECT * FROM message LIMIT 10"

Read recent iMessages with sender, timestamp, and direction:

uv run scripts/imessage-read.py
uv run scripts/imessage-read.py 50
uv run scripts/imessage-read.py 20 "John"

Read Chrome browsing history (Windows epoch → UTC):

uv run scripts/chrome-history.py
uv run scripts/chrome-history.py 50 github

Read Safari browsing history (CoreData epoch → UTC):

uv run scripts/safari-history.py
uv run scripts/safari-history.py 50 github

Audit TCC.db — see all app privacy permission grants:

uv run scripts/permissions-audit.py
uv run scripts/permissions-audit.py --service kTCCServiceCamera
uv run scripts/permissions-audit.py --allowed

Reference

reference/06-sqlite.md — All app DB paths, Chrome cookie auth, iMessage agent loop pattern
reference/09-tcc-permissions.md — Full TCC service map, what requires Full Disk Access

iMessage Agent Loop Pattern

chat.db (SQLite) → read new message → Python/Claude reasons → osascript → Messages app → sends reply

See reference/06-sqlite.md for the full pattern with WatchPaths trigger.

---name: osascript-datadescription: Read macOS app SQLite databases directly. Use when reading iMessage chat history, Chrome browsing history, Safari history, or any local app SQLite DB. Always copy the DB before querying — most apps lock the file while running.---# osascript-dataDirect SQLite access to macOS app databases. No API, no auth — plain file reads.All scripts are pure Python using stdlib only (`sqlite3`, `shutil`).## The Universal Rule**Always copy before querying.** Most apps (Chrome, Messages) lock their DB while running.```pythonshutil.copy2(db_path, "/tmp/copy.db")conn = sqlite3.connect("/tmp/copy.db")```## Key Databases| App | Path | Permission needed || --------------- | ------------------------------------------------------------- | ----------------- || iMessage + SMS | `~/Library/Messages/chat.db` | Full Disk Access || Chrome History | `~/Library/Application Support/Google/Chrome/Default/History` | Full Disk Access || Safari History | `~/Library/Safari/History.db` | Full Disk Access || TCC permissions | `~/Library/Application Support/com.apple.TCC/TCC.db` | Full Disk Access |## ScriptsRun a raw SQL query against any DB (copy-first):```bashuv run scripts/sqlite-query.py ~/Library/Messages/chat.db "SELECT * FROM message LIMIT 10"```Read recent iMessages with sender, timestamp, and direction:```bashuv run scripts/imessage-read.pyuv run scripts/imessage-read.py 50uv run scripts/imessage-read.py 20 "John"```Read Chrome browsing history (Windows epoch → UTC):```bashuv run scripts/chrome-history.pyuv run scripts/chrome-history.py 50 github```Read Safari browsing history (CoreData epoch → UTC):```bashuv run scripts/safari-history.pyuv run scripts/safari-history.py 50 github```Audit TCC.db — see all app privacy permission grants:```bashuv run scripts/permissions-audit.pyuv run scripts/permissions-audit.py --service kTCCServiceCamerauv run scripts/permissions-audit.py --allowed```## Reference- [reference/06-sqlite.md](reference/06-sqlite.md) — All app DB paths, Chrome cookie auth, iMessage agent loop pattern- [reference/09-tcc-permissions.md](reference/09-tcc-permissions.md) — Full TCC service map, what requires Full Disk Access## iMessage Agent Loop Pattern```chat.db (SQLite) → read new message → Python/Claude reasons → osascript → Messages app → sends reply```See [reference/06-sqlite.md](reference/06-sqlite.md) for the full pattern with WatchPaths trigger.

Frequently asked questions