Wispr Flow Analytics

•
35
•

Analyzes and manages Wispr Flow voice dictation data to provide usage insights, advanced search, and automated exports.

The Wispr Flow skill empowers users to unlock insights from their voice dictation history by connecting directly to the Wispr Flow SQLite database. It provides comprehensive tools for tracking word counts across different applications, searching through historical dictations with date filters, and exporting data to formats like JSON or Obsidian daily notes. Whether you're monitoring productivity trends or looking for a specific spoken thought, this skill offers both high-level visualizations and deep-dive SQL query capabilities within the Claude Code environment, making it an essential tool for voice-first workflows.

Key Features

01Flexible data exporting to portable JSON or Obsidian-ready formats for personal knowledge management.
02Detailed usage statistics and word count analytics categorized by application and time period.
03Automated generation of interactive HTML dashboards for visual exploration of dictation habits.
04Advanced search functionality across historical dictations with app-specific and date-range filtering.
05Direct SQL access for performing custom queries against the Wispr Flow local database.
0635 GitHub stars

Use Cases

01Archiving voice-to-text history into Obsidian daily notes for a permanent, searchable personal knowledge base.
02Finding specific information or ideas previously dictated into various applications using keyword search.
03Tracking daily writing and dictation productivity goals to monitor output volume.
name description
wispr-flow
Analyze Wispr Flow voice dictation data. Stats, search, export, visualizations. Use when user says "dictation history", "word counts", "voice analytics", "how much did I dictate", "search my dictation".

Wispr Flow Skill

Access and analyze your Wispr Flow voice dictation history.

Quick Stats

# Overall stats
{baseDir}/scripts/get-stats.py

# Today only
{baseDir}/scripts/get-stats.py --period today

# This week
{baseDir}/scripts/get-stats.py --period week

# JSON output
{baseDir}/scripts/get-stats.py --json

Search

# Search all dictations
{baseDir}/scripts/search-history.py "keyword"

# Filter by app
{baseDir}/scripts/search-history.py "keyword" --app ghostty

# Date range
{baseDir}/scripts/search-history.py "keyword" --from 2026-01-01 --to 2026-01-10

Export

# JSON backup (text only, portable)
{baseDir}/scripts/export-data.py -o ~/Downloads/wispr-backup.json

# Obsidian daily notes format
{baseDir}/scripts/export-data.py --format obsidian -o ~/vault/Voice/

Visualization

# Generate interactive HTML dashboard
{baseDir}/scripts/create-dashboard.py -o ~/Downloads/wispr-dashboard.html
open ~/Downloads/wispr-dashboard.html

Quick Queries (Direct SQL)

# Recent dictations (EST timezone)
sqlite3 ~/Library/Application\ Support/Wispr\ Flow/flow.sqlite "
SELECT datetime(timestamp, '-5 hours') as time, app, substr(formattedText, 1, 80)
FROM History ORDER BY timestamp DESC LIMIT 10
"

# Words by app
sqlite3 ~/Library/Application\ Support/Wispr\ Flow/flow.sqlite "
SELECT app, SUM(numWords) as words FROM History
WHERE app IS NOT NULL GROUP BY app ORDER BY words DESC LIMIT 10
"

# Today's word count
sqlite3 ~/Library/Application\ Support/Wispr\ Flow/flow.sqlite "
SELECT SUM(numWords) FROM History
WHERE date(timestamp, '-5 hours') = date('now', '-5 hours')
"

Database

Location: ~/Library/Application Support/Wispr Flow/flow.sqlite

Key tables:

  • History - all dictations (timestamp, app, formattedText, numWords, duration, audio blob)

Timezone: Database stores UTC. Use -5 hours for EST.

Space Management

See docs/space-management.md for cleaning up audio blobs.

Troubleshooting

See docs/troubleshooting.md for common issues.