DavidROliverBA/.claude/skills/q
.claude/skills/q/SKILL.md
Fast SQLite-based vault search using FTS5 full-text search index
$ install --global
skillsauthnpx skillsauth add DavidROliverBA/ArchitectKB .claude/skills/qInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 16, 2026, 6:24 PM10.8s1 file scanned
SKILL.md
- description:
- Fast SQLite-based vault search using FTS5 full-text search index
- context:
- normal
- model:
- haiku
/q - Quick SQLite Search
Fast vault search using the SQLite FTS5 index. Returns results in milliseconds instead of seconds.
Prerequisites
The SQLite index must be built first:
npm run vault:index
Usage Patterns
Full-text Search
/q architecture patterns
/q "event driven" # Phrase search
/q kafka integration # Multiple terms (AND)
Type Filter
/q type:Adr # All ADRs
/q type:Project status:active
/q type:Task priority:high
Tag Search
/q tag:technology/aws
/q tag:project/your-project
Recent Notes
/q recent # Modified in last 7 days
/q recent:30 # Modified in last 30 days
Backlinks
/q backlinks:"Project - Your Project"
/q backlinks:"System - Your System"
Orphans
/q orphans # Notes with no backlinks
Implementation
Execute the appropriate SQLite query based on the search pattern.
Full-text Search Query
sqlite3 .data/vault.db -markdown "
SELECT n.path, snippet(fts_content,1,'→','←','...',40) as match
FROM fts_content
JOIN notes n ON fts_content.rowid = n.id
WHERE fts_content MATCH '<search_terms>'
ORDER BY rank
LIMIT 20
"
Type Filter Query
sqlite3 .data/vault.db -markdown "
SELECT path, title, status, priority
FROM notes
WHERE type = '<Type>'
ORDER BY modified DESC
LIMIT 20
"
Tag Search Query
sqlite3 .data/vault.db -markdown "
SELECT n.path, n.title, n.type
FROM notes n
JOIN tags t ON n.id = t.note_id
WHERE t.tag = '<tag>'
ORDER BY n.modified DESC
LIMIT 20
"
Recent Notes Query
sqlite3 .data/vault.db -markdown "
SELECT path, title, type, modified
FROM notes
WHERE modified >= date('now', '-<days> days')
ORDER BY modified DESC
LIMIT 30
"
Backlinks Query
sqlite3 .data/vault.db -markdown "
SELECT n.path, n.title, n.type
FROM notes n
JOIN links l ON n.id = l.source_id
WHERE l.target_path LIKE '%<note_name>%'
ORDER BY n.modified DESC
"
Orphans Query
sqlite3 .data/vault.db -markdown "
SELECT n.path, n.title, n.type
FROM notes n
LEFT JOIN links l ON n.id = l.target_id
WHERE l.target_id IS NULL
AND n.type NOT IN ('DailyNote', 'MOC', 'Dashboard', 'Query')
ORDER BY n.modified DESC
"
Performance
| Query Type | Grep/Glob | SQLite | Improvement | | ----------- | --------- | ------ | ----------- | | Full-text | 5-15 sec | 0.01s | ~1000x | | Type filter | 3-5 sec | 0.007s | ~500x | | Tag search | 2-5 sec | 0.007s | ~500x | | Backlinks | 10+ sec | 0.01s | ~1000x |
Rebuilding the Index
The index should be rebuilt when vault content changes significantly:
npm run vault:index # Full rebuild
npm run vault:stats # View current statistics
Tips
- Combine filters:
/q type:Adr status:proposed technology/aws - Use phrases:
/q "data platform"for exact matches - Wildcards: SQLite FTS5 supports
*wildcards:/q architect* - Present results: Format output as markdown table for readability
Related Skills
DavidROliverBA/.claude/skills/youtube
tools
VerifiedTrustedCommunity
--- context: fork --- # /youtube Save a YouTube video as both a Weblink (quick reference) and a detailed Page (full analysis). ## Usage ``` /youtube <url> /youtube <url> <optional title override> ``` ## Examples ``` /youtube https://www.youtube.com/watch?v=0TpON5T-Sw4 /youtube https://youtu.be/abc123 AWS re:Invent Keynote ``` ## Prerequisites This skill uses the MCP Docker YouTube tools: - `mcp__MCP_DOCKER__get_video_info` - Video metadata - `mcp__MCP_DOCKER__get_transcript` - Full trans
41SKILL.mdUpdated Apr 16, 2026
DavidROliverBA/worktree
data-ai
VerifiedTrustedCommunity
Create and manage git worktrees for parallel agent sessions
41SKILL.mdUpdated Apr 16, 2026
DavidROliverBA/.claude/skills/wipe
testing
VerifiedTrustedCommunity
--- context: fork --- # /wipe Generate a context handoff summary, clear the session, and resume in a fresh conversation. Detects environment and provides automated (tmux) or manual workflow. ## Usage ``` /wipe /wipe quick # Minimal handoff, just essentials /wipe detailed # Comprehensive handoff with full context ``` ## Instructions When the user invokes `/wipe`: ### Phase 1: Detect Environment First, check the terminal environment: ```bash echo "Environment Detection:"
41SKILL.mdUpdated Apr 16, 2026
DavidROliverBA/.claude/skills/weekly-summary
data-ai
VerifiedTrustedCommunity
--- context: fork --- # /weekly-summary Generate comprehensive weekly summary from daily notes, meetings, tasks, and project updates using parallel sub-agents. ## Usage ``` /weekly-summary /weekly-summary --last-week /weekly-summary --from 2026-01-01 --to 2026-01-07 /weekly-summary --output page # Create Page note instead of just outputting ``` ## Instructions This skill uses **5 parallel sub-agents** to gather data concurrently from different vault areas, then synthesizes a comprehensi
41SKILL.mdUpdated Apr 16, 2026