devrel-analystlisted

# devrel-analyst > Skill: DevRel Analytics Querier > Context: work/ only ([Company] DevRel) > Phase V — Part D (AC-13, AC-16) > > Refs: docs/specs/devrel-analytics-stack.md ## What this skill does Queries the `walter_devrel_analytics` Postgres database and returns structured insights about DevRel content performance. Used: 1. Directly from CLI: `walter-os analyst <query> [args]` 2. By the `devrel-writer` agent before drafting content (AC-16 feedback loop) 3. By the weekly digest workflow (AC-14) 4. By the anomaly detection workflow (AC-15) It reads only — never writes to the analytics DB. ## Supported queries ### `top_threads(since, limit)` Returns the top N content pieces by total engagement since a given date. ``` $ python3 skills/devrel-analyst/scripts/query.py top_threads --since 30d --limit 5 ``` Output (markdown): ```markdown ## Top 5 Threads — Last 30 Days | Rank | Title | Platform | Engagement | Has Code | Has Image | |------|-------|----------|------------|----------|-----------| | 1 | How we cut RPC latency by 40%... | twitter | 2847 | yes | no | | 2 | Yellowstone gRPC streaming guide | youtube | 1203 | yes | yes | ... ``` ### `optimal_hours(platform)` Returns the hour-of-day × day-of-week heatmap with best engagement windows. ``` $ python3 skills/devrel-analyst/scripts/query.py optimal_hours --platform twitter ``` ### `pattern_match(topic)` Finds what hooks, formats, and attributes correlated with high engagement for content about a given topic. `