skills.rest
skywatch-bsky
skywatch-bskyOFFICIAL
Explore all skills by this author →
WebsiteGitHub

accessing-osprey

Query Osprey rule execution results and sidecar metrics in ClickHouse.

6|Updated Feb 21, 2026
Search Tags:#investigation#analytics#moderation#clickhouse#atproto#osprey
One-click install
npx skills add https://github.com/skywatch-bsky/skywatch-agent-skills --skill accessing-osprey
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: accessing-osprey
Source: https://github.com/skywatch-bsky/skywatch-agent-skills/tree/main/claude-skills/plugins/skywatch-investigations/skills/accessing-osprey
Command: npx skills add https://github.com/skywatch-bsky/skywatch-agent-skills --skill accessing-osprey

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This skill solves the difficulty of navigating complex, high-volume moderation data by providing a structured interface to query Osprey rule execution results and statistical sidecar outputs in ClickHouse.

Core Features & Use Cases

  • Rule Execution Analysis: Query historical rule matches to identify accounts or posts triggering specific moderation criteria.
  • Coordinated Behavior Detection: Access sidecar data for URL/quote co-sharing clusters and account entropy to identify bot-like patterns or coordinated campaigns.
  • Investigation Workflow: Use this to cross-reference automated detection results with manual labelling decisions in Ozone.

Quick Start

Use the accessing-osprey skill to query the osprey_execution_results table for recent matches of a specific rule.

Frequently Asked Questions about accessing-osprey

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

FAQPage Schema
How do I investigate AT Protocol moderation data for coordinated sharing campaigns?▼

Access sidecar data for URL and quote co-sharing clusters along with account entropy metrics to identify bot-like patterns and coordinated campaigns across AT Protocol accounts.

What is the best way to analyze rule execution results for AT Protocol moderation?▼

Cross-reference automated detection results with manual labelling decisions in Ozone to validate moderation rules and ensure data-driven moderation accuracy.

Can I use accessing-osprey to detect bot-like patterns in AT Protocol accounts?▼

Yes, accessing-osprey exposes statistical sidecar outputs including account entropy metrics that help detect bot-like patterns and coordinated sharing behavior in AT Protocol accounts.

Does accessing-osprey support write operations to modify moderation rules in ClickHouse?▼

No, accessing-osprey facilitates investigation through read-only SQL queries against Osprey moderation data stored in ClickHouse, exposing system-wide evaluation results and anomaly detection outputs.

How do I cross-reference automated moderation detection results with manual labels?▼

Cross-reference automated detection results with manual labelling decisions in Ozone by querying Osprey rule execution data to compare system-wide evaluation outputs against human moderation actions.

Related Skills

Explore More Data & Analytics Skills→
skywatch-bskyskywatch-bsky
6

skywatch-accessing-osprey

Query Osprey moderation rule execution data and sidecar statistics in ClickHouse.

Official
Advanced
SufficientDaikonSufficientDaikon
8

content-moderation-pipeline

Design a multi-stage content moderation pipeline with duplicate detection and quality scoring.

Community
Advanced
skywatch-bskyskywatch-bsky
6

querying-ozone

Interact with the Ozone moderation API for queue triage and event analysis.

Official
Intermediate
skywatch-bskyskywatch-bsky
6

assess-account

Aggregate ClickHouse, PDS, and Ozone data to classify AT Protocol accounts.

Official
Advanced