A natural language interface to query and analyze your WhatPulse computer usage statistics using a local SQLite database.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install whatpulse-ai-agent-skill
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install whatpulse-ai-agent-skill using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is WhatPulse Statistics Analyst?
The WhatPulse Statistics Analyst is a sophisticated tool designed to help users unlock the value of their personal computing data. By leveraging Openclaw Skills, this agent provides a conversational bridge to the WhatPulse SQLite database, allowing for deep dives into keystrokes, mouse activity, network bandwidth, and application uptime.
Built with a focus on data integrity, the skill operates in a strict read-only mode. It enables developers and power users to identify productivity trends, monitor hardware usage, and generate comprehensive reports without manually navigating complex database schemas or external dashboards.
WhatPulse Statistics Analyst Use Cases
- Tracking daily keystroke counts and mouse distance to monitor physical typing load.
- Analyzing application screen time to identify focus-drainers or peak productivity windows.
- Monitoring network bandwidth consumption across specific applications or interfaces.
- Generating automated daily briefings that compare current activity against historical averages.
- Identifying unusual late-night activity or shifts in application usage patterns.
How WhatPulse Statistics Analyst Works
- The user triggers the skill using natural language keywords such as keystrokes, app usage, or bandwidth.
- The agent locates the local WhatPulse SQLite database based on the host operating system (macOS, Windows, or Linux).
- It constructs a secure SQL query using a heredoc pattern to ensure safe execution via the sqlite3 CLI.
- The agent executes the query in read-only mode to retrieve specific metrics like input frequency, uptime, or data transfers.
- Results are processed, converting raw units like milliseconds and bytes into human-readable formats such as hours and gigabytes.
- The data is presented back to the user in a structured, conversational format with added insights and trends.
WhatPulse Statistics Analyst Setup
To get started with this skill, ensure you have WhatPulse installed and the sqlite3 CLI available on your system. For environments where the database is in a non-standard location, you can define the path using an environment variable:
export WHATPULSE_DB="/path/to/your/whatpulse.db"
For remote access or synced setups, it is recommended to create a safe snapshot of the database to avoid lock issues:
sqlite3 ~/Library/Application\ Support/WhatPulse/whatpulse.db ".backup '~/path/to/synced/whatpulse.db'"
WhatPulse Statistics Analyst Data Schema & Taxonomy
The skill organizes data into several logical categories based on the WhatPulse schema:
| Category | Key Tables | Metrics Captured |
|---|---|---|
| Input | keypresses, mouseclicks, mousedistance |
Total counts, frequencies, and distances |
| Applications | applications, application_uptime |
App names, active duration, and paths |
| Network | network_interface_bandwidth, country_bandwidth |
Upload/download bytes by interface or region |
| System | uptimes, profiles, computer_info |
System boot sessions, active profiles, and hardware specs |
| Websites | website_time_series, website_domains |
Active seconds per domain and click counts |
WhatPulse Statistics Analyst Advanced Features
- Automated Qt Key Code mapping to translate raw numeric codes into human-readable key names.
- Proactive insight generation that highlights anomalies, usage streaks, and record-breaking activity.
- Support for profile-based filtering to distinguish between different work contexts or users.
- Integrated unit conversion logic for distance (miles/km), data (MB/GB), and time (hours/days).
- Daily briefing mode that provides a snapshot of activity versus personal averages when no specific question is asked.
SKILL.md
Loading
Related Openclaw Skills
Secure Skill Installer
A security-focused gateway that scans and validates Openclaw Skills using the ClawDex API before allowing installation.
Xiaohongshu Video Downloader & Summarizer
A comprehensive automation tool for downloading Xiaohongshu videos and generating full resource packs including transcripts and AI summaries.
Jina Reader Content Extractor
A powerful content extraction tool that converts complex web pages into clean, AI-ready markdown using the Jina Reader API.
Upbit Trading Bot
An AI-driven cryptocurrency trading bot for Upbit featuring real-time monitoring, GLM-4.7 analysis, and automated execution.
n8n Monitor
A lightweight monitoring tool designed to track the health, logs, and resource performance of n8n instances running in Docker containers.
ClawLaunch AI Token Launchpad
ClawLaunch is a specialized token launchpad on the Base network designed for AI agents to deploy tokens, trade on bonding curves, and graduate to Uniswap V4.
Featured*
