# sqlite-wal-and-browser-artifact-scripting

sqlite-wal-and-browser-artifact-scripting is a Claude Code skill that writes Python tools for examining SQLite and browser artifacts. It activates for forensic work on Chromium or Firefox history, cookies, and downloads.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, Windsurf (Devin Desktop), Claude.ai · ★ 73 repo stars
- Author: W4L33Dx
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/W4L33Dx/Cyber-Monster/tree/HEAD/blue-team/security-automation-and-tool-development/sqlite-wal-and-browser-artifact-scripting/SKILL.md
- Updated: 2026-11-15
- Security check: automated, 2026-11-17 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/sqlite-wal-and-browser-artifact-scripting

## What it does

The skill builds scripts to extract data from SQLite databases and browser profiles. It hashes the original files, copies the database along with any `-wal` or `-journal` sidecars into a separate snapshot, then reads from that copy. This keeps the source files untouched during analysis of WAL records.

Generated code uses `contextlib.closing` to close database connections and converts WebKit and Unix timestamps with integer arithmetic. Recent-site queries can group results by URL to avoid listing repeat visits separately. Python 3.11 or later is required.

## Requirements
- Works with: Chrome

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add W4L33Dx/Cyber-Monster --skill sqlite-wal-and-browser-artifact-scripting -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/sqlite-wal-and-browser-artifact-scripting/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/sqlite-wal-and-browser-artifact-scripting/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add W4L33Dx/Cyber-Monster --skill sqlite-wal-and-browser-artifact-scripting -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/sqlite-wal-and-browser-artifact-scripting/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add W4L33Dx/Cyber-Monster --skill sqlite-wal-and-browser-artifact-scripting -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/sqlite-wal-and-browser-artifact-scripting/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install W4L33Dx/Cyber-Monster blue-team/security-automation-and-tool-development/sqlite-wal-and-browser-artifact-scripting
```

2. **Manually: put the files in place**
- File: `.github/skills/sqlite-wal-and-browser-artifact-scripting/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add W4L33Dx/Cyber-Monster --skill sqlite-wal-and-browser-artifact-scripting -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/W4L33Dx/Cyber-Monster --path blue-team/security-automation-and-tool-development/sqlite-wal-and-browser-artifact-scripting
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/sqlite-wal-and-browser-artifact-scripting/SKILL.md` — The legacy .windsurf/skills/ path still works

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/W4L33Dx/Cyber-Monster/tree/HEAD/blue-team/security-automation-and-tool-development/sqlite-wal-and-browser-artifact-scripting/SKILL.md

## When to use it
- extract browsing history from Chromium or Firefox SQLite databases
- read WAL records that have not been checkpointed into the main database
- inspect database contents while preserving the original files
- convert WebKit timestamps into UTC dates

## Example prompts
- Write a Python script to extract Chromium history from a SQLite database with a WAL file.
- Parse Firefox cookies and downloads without changing the original database or journal files.
- Group browser history by URL and convert WebKit timestamps to UTC.

## Similar
- [browser-fingerprint-audit](https://affpapa.org/en/nevibecode/skills/browser-fingerprint-audit.md) — skill · 132900 installs
- [browser-exploitation-v8](https://affpapa.org/en/nevibecode/skills/browser-exploitation-v8.md) — skill · 4000 installs
- [analyzing-browser-forensics-with-hindsight](https://affpapa.org/en/nevibecode/skills/analyzing-browser-forensics-with-hindsight.md) — skill · 611 installs
- [browser-automation](https://affpapa.org/en/nevibecode/skills/martinholovsky-browser-automation.md) — skill · 235 installs
- [agent-browser](https://affpapa.org/en/nevibecode/mcp/agent-browser.md) — MCP server · ★ 14 repo stars
- [browser](https://affpapa.org/en/nevibecode/mcp/browser.md) — MCP server · ★ 9 repo stars

From the same set: [w4l33dx/cyber-monster](https://affpapa.org/en/nevibecode/by/w4l33dx/cyber-monster.md) — 61 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
