Agent skill · data analytics · mvanhorn
pp-steam-web
Every Steam Web API endpoint, plus a local SQLite store that turns friend playtimes, achievement progress, and library backlogs into single SQL queries no other tool can answer. Trigger phrases: `what should I play next on steam`, `find friends who own this game`, `easiest steam achievement to unlock`, `audit my steam backlog`, `use steam-web`.
Why this skill is useful
Adds a CLI tool that enables complex SQL queries on Steam data, providing unique insights not available through standard API calls.
What it needs
Requires steam-web-pp-cli installed locally. About 8k tokens when loaded. Last updated 2026-08-06. 1,890 stars on the source repository.
What this skill does
Steam Web — Printing Press CLI Prerequisites: Install the CLI This skill drives the steam-web-pp-cli binary. You must verify the CLI is installed before invoking any command from this skill. If it is missing, install it first: 1. Install via the Printing Press installer. It defaults binaries to $HOME/.local/bin on macOS/Linux and %LOCALAPPDATA%\Programs\PrintingPress\bin on Windows: 2. Verify: steam-web-pp-cli --version 3. Ensure the reported install directory is on $PATH for the agent/runtime that will invoke this skill. If the npx install fails (no Node, offline, etc.), fall back to a direct Go install (requires Go 1.26.6 or newer): If --version reports "command not found" after install, the runtime cannot see the binary directory on $PATH. Do not proceed with skill commands until verification succeeds. When to Use This CLI Pick this CLI when an agent is asked to query Steam profile, library, achievement, or news data and the question crosses entities — anything joining friends with owned games, achievements with global rarity, or news with a date filter. The local SQLite store turns those questions into one SQL query instead of an N+1 fanout. Every other Steam tool is single-shot read-once; this one compounds. For pure single-endpoint reads (one player's profile, one app's news), the per-endpoint MCP tools work too — but the novel commands are where this CLI earns its weight. Unique Capabilities These capabilities aren't available in any other tool for this API. Local state that compounds library audit — Surface never-launched games, paid titles you bounced off in under 2 hours, and where your hours actually went by genre. Use this when an agent is asked to plan what to play next, justify a refund, or summarize the user's gaming spend. review-velocity — Reviews per day and voted-up share over a rolling window for one app — date-bucket aggregation over the cursor-paginated appreviews stream. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills mvanhorn/steam-web