search-shadow-transcripts

Search Shadow.app transcripts in a local SQLite database by keywords and date ranges.

3|1|Updated Jun 20, 2016

Search Tags:#search #sqlite #query #conversations #transcripts #timestamps #shadow

Ready to run

npx skills add https://github.com/paulchiu/dotfiles --skill search-shadow-transcripts

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: search-shadow-transcripts
Source: https://github.com/paulchiu/dotfiles/tree/main/.config/opencode/skills/search-shadow-transcripts
Command: npx skills add https://github.com/paulchiu/dotfiles --skill search-shadow-transcripts

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires sqlite3, and includes scripts (resource) components.

What problem does it solve?

Shadow.app transcripts are stored locally in a SQLite database. This skill enables fast searching and retrieval of transcripts by keywords, date, or conversation metadata.

Core Features & Use Cases

Search transcripts by text content and metadata
Join transcripts with conversations to display titles and timestamps
Output options include formatted results or raw SQL data

Quick Start

Run the search_transcripts.sh script with a search term to retrieve matching transcripts.

Frequently Asked Questions about search-shadow-transcripts

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I search Shadow.app transcripts by keyword?▼

To search Shadow.app transcripts by keyword, run the search_transcripts.sh script. It queries the local SQLite database to retrieve matching text content and outputs formatted results for easy review.

Can I query Shadow.app conversations by date range?▼

Yes, you can query Shadow.app conversations by date range. The script filters transcripts using date constraints within the local SQLite database to locate relevant conversation contexts and timestamps.

Does this transcript search tool require sqlite3?▼

Yes, this transcript search tool requires sqlite3 as a dependency. It relies on sqlite3 to read directly from the local Shadow.app database and execute queries to retrieve conversation metadata.

How do I get raw SQL results instead of formatted text?▼

You can get raw SQL results by selecting the appropriate output options in the search_transcripts.sh script. This bypasses formatted results and directly outputs raw data retrieved from the SQLite database queries.

What is the best way to retrieve conversation titles from Shadow.app transcripts?▼

The best way to retrieve conversation titles is to use this script to join transcripts with conversations in the SQLite database. This query displays associated titles and timestamps alongside the matched transcript content.