skills.rest
crycriM
crycriMCOMMUNITY
Explore all skills by this author →
GitHub

session-usage-analytics

Analyzes token usage and costs from Hermes session data.

Updated Apr 19, 2026
Search Tags:#analytics#sqlite#cache#session#token#cost#platforms
One-click install
npx skills add https://github.com/crycriM/hermes-skills --skill session-usage-analytics
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: session-usage-analytics
Source: https://github.com/crycriM/hermes-skills/tree/main/mlops/session-usage-analytics
Command: npx skills add https://github.com/crycriM/hermes-skills --skill session-usage-analytics

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Analyze Hermes session token usage, costs, and performance patterns from the SQLite state database.

Core Features & Use Cases

  • Monitor and analyze per-session token usage, costs, and performance metrics across platforms (CLI, Telegram, Discord, Cron)
  • Identify token inefficiencies, cache effectiveness, and platform-specific patterns
  • Produce platform- and model-level summaries to guide optimization and cost control

Quick Start

Run a quick analysis to summarize daily input/output tokens, costs, and cache metrics from the Hermes SQLite state DB for the last 7 days.

Frequently Asked Questions about session-usage-analytics

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

FAQPage Schema
How do I analyze Hermes session token usage and costs from the SQLite state database?▼

Hermes session token usage and costs are analyzed by querying the SQLite state database at ~/.hermes/state.db. This process extracts per-session token metrics, costs, and performance patterns directly from the sessions and messages tables.

Can I monitor token usage and cache effectiveness across Telegram, Discord, and Cron platforms?▼

Yes, you can monitor token usage and cache effectiveness across Telegram, Discord, CLI, and Cron platforms. The analysis generates platform-specific summaries to help identify token inefficiencies and model-level usage patterns.

What is the best way to debug token cost inefficiencies in my Hermes sessions?▼

The best way to debug token cost inefficiencies is to analyze daily input and output tokens alongside cache metrics from the SQLite database. This approach identifies platform-specific patterns and guides optimization for cost control.

Do I need direct access to the SQLite state database to run session usage analytics?▼

Yes, you need direct access to the SQLite state database located at ~/.hermes/state.db. The analytics Skill requires this access to run queries against the sessions and messages tables for token usage analysis.

How do I generate a quick summary of daily token costs and cache metrics for the last 7 days?▼

You generate a quick summary of daily token costs and cache metrics by running a quick analysis against the Hermes SQLite state DB. This summarizes daily input and output tokens, costs, and cache effectiveness for the last 7 days.

Related Skills

Explore More Data & Analytics Skills→
tkerseytkersey
66

cron

Manage Codex automations in a local SQLite database via Python CLI.

Community
Intermediate
StrategicMilkStrategicMilk

Cost Analysis

Analyze token-level LLM costs and generate optimization recommendations.

Community
Intermediate
ToqsickToqsick

messaging-gateway-setup

Configure messaging platforms via Hermes gateway with bot creation and token management.

Community
Intermediate
kitaekattkitaekatt
3

cache-report

Parse cache_report.py output to display prompt-cache hit rates and token consumption.

Community
Intermediate