skywatch-accessing-osprey

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

6|Updated Feb 21, 2026
One-click install
npx skills add https://github.com/skywatch-bsky/skywatch-agent-skills --skill skywatch-accessing-osprey
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: skywatch-accessing-osprey
Source: https://github.com/skywatch-bsky/skywatch-agent-skills/tree/main/polytoken/skills/skywatch-accessing-osprey
Command: npx skills add https://github.com/skywatch-bsky/skywatch-agent-skills --skill skywatch-accessing-osprey

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This skill solves the complexity of navigating the Osprey moderation infrastructure, allowing investigators to efficiently query rule execution data and sidecar statistical outputs without needing deep knowledge of the underlying ClickHouse schema.

Core Features & Use Cases

  • Rule Execution Analysis: Query the osprey_execution_results table to identify accounts triggering specific moderation rules.
  • Statistical Anomaly Detection: Access sidecar data for bot-like behavior, coordinated URL sharing, and quote-post amplification.
  • Investigation Workflow: Bridge the gap between automated Osprey detections and manual Ozone labelling decisions.

Quick Start

Use the skywatch-accessing-osprey skill to query the last 24 hours of rule matches for a specific account DID.

Frequently Asked Questions about skywatch-accessing-osprey

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

FAQPage Schema
How do I query Osprey moderation rule execution data in ClickHouse?

Query Osprey moderation rule execution data by accessing the osprey_execution_results table within ClickHouse to identify specific AT Protocol accounts triggering moderation rules.

What is the best way to detect coordinated inauthentic activity on the AT Protocol?

Detect coordinated inauthentic activity by querying statistical sidecar tables for bot-like behavior, coordinated URL sharing, and quote-post amplification metrics within the Osprey infrastructure.

Can I investigate account behavior anomalies using Osprey sidecar data?

Investigate account behavior anomalies using Osprey sidecar statistical outputs that provide anomaly detection metrics for bot-like activity and coordinated URL sharing across AT Protocol entities.

How do I bridge automated Osprey detections with manual Ozone labelling decisions?

Bridge automated Osprey detections with Ozone labelling by querying rule execution results and statistical sidecar data to inform manual moderation workflows through secure read-only SQL access.

Does the Osprey ClickHouse skill support read-only access to moderation logs?

The Osprey ClickHouse skill enables secure read-only querying of moderation logs and anomaly detection metrics for AT Protocol entities without requiring deep schema knowledge.

What are the limitations of querying Osprey statistical sidecar tables?

Querying Osprey statistical sidecar tables is limited to read-only SQL analysis of precomputed anomaly detection metrics, bot-like behavior scores, and coordinated URL sharing statistics within ClickHouse.