skills.rest
paulchiu
paulchiuCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/paulchiu/dotfiles --skill search-shadow-transcripts
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
OpenCovenOpenCoven
20

sqlite

Run read-only SQL queries on SQLite databases with Python's sqlite3 library.

Official
Basic
aws-samplesaws-samples
90

file-processing

Process and analyze CSV, JSON, and text data files with automated cleaning and transformation.

Official
Advanced
JoeyJoziahJoeyJoziah

session-logs

Search JSONL session logs with jq and rg to recover conversation context.

Community
Intermediate
BSteffaniakBSteffaniak

session-history

Query a local SQLite database to retrieve past conversation sessions and transcripts.

Community
Intermediate