{"actions":{"bootstrapAndRun":{"effect":"installs rote if missing, inspects, prepares, and asks before running","href":"https://play.modiqo.ai/install?play=chetan/posthog-project-dau@0.0.1","method":"GET","rel":"https://rote.dev/rels/bootstrap-and-run","requiresConsent":true,"responseMediaType":"text/x-shellscript"},"inspect":{"command":"rote play inspect https://play.modiqo.ai/chetan/posthog-project-dau@0.0.1","effect":"read-only"},"installCliOnly":{"effect":"installs the rote CLI, nothing else","href":"https://play.modiqo.ai/install","method":"GET","rel":"https://rote.dev/rels/install-cli","requiresConsent":true,"responseMediaType":"text/x-shellscript"},"run":{"command":"rote play run https://play.modiqo.ai/chetan/posthog-project-dau@0.0.1","effect":"executes the play locally after consent","headless":{"approvalAssertion":"--yes","approvalRequiredBeforeInvocation":true,"commandTemplate":"rote play run https://play.modiqo.ai/chetan/posthog-project-dau@0.0.1 <name=value...> --yes","stdinPolicy":"never pipe input to automate the interactive Ready selector"},"requiresConsent":true}},"authenticationPreflight":{"credentialValues":"local_only","enforcedBeforeAdapterCalls":true,"mode":"declared","readiness":"inspect_locally","steps":[{"endpoint":"adapter/posthog-mcp","name":"auth_posthog_mcp","onExpired":"refresh","onMissing":"authorize","onUnreadable":"reauthorize"}]},"description":"Retrieve daily active users (distinct persons per day) for a PostHog project over a lookback window via HogQL.","distribution":{"digest":"sha256:07a4c2ec9648da71913b05638fc8a2690a5984d55beacad9df468dff57cfdfc5","mediaType":"application/vnd.modiqo.rote-flow","size":4584,"verifiedBy":"rote verifies the downloaded archive against this digest before it runs"},"effects":{"credentialsProvidedBy":"runner","credentialsRemainLocal":true,"declaredWrites":[],"publisherReceivesCredentials":false},"id":"https://play.modiqo.ai/chetan/posthog-project-dau@0.0.1","inputPolicy":{"optionalWithDefault":"show_default_and_accept_override","optionalWithoutDefault":"omit_unless_supplied","required":"ask","secrets":"collect_locally_outside_conversation"},"links":{"docs":"https://rote.dev","page":"https://play.modiqo.ai/chetan/posthog-project-dau@0.0.1","protocol":"https://play.modiqo.ai/.well-known/rote","self":"https://play.modiqo.ai/chetan/posthog-project-dau@0.0.1.json"},"name":"posthog-project-dau","owner":{"kind":"user","slug":"chetan"},"parameters":[{"default":"30","description":"Number of trailing days to include (integer, e.g. 30); window is [now - N days, now)","input":{"allowCustom":true,"choices":[],"label":"Days lookback"},"name":"days_lookback","required":false,"type":"string"}],"preparation":[{"action":{"command":"rote play inspect https://play.modiqo.ai/chetan/posthog-project-dau@0.0.1 --json","effect":"read-only"},"step":1,"type":"inspect_local_readiness"},{"references":["/parameters"],"step":2,"type":"collect_parameters"},{"references":["/parameters","/requirements","/effects"],"step":3,"type":"review"},{"consentBoundary":"the user approves the exact play and parameter values","references":["/parameters","/requirements","/effects"],"step":4,"type":"obtain_run_consent"},{"action":{"command":"rote play run https://play.modiqo.ai/chetan/posthog-project-dau@0.0.1","headlessCommandTemplate":"rote play run https://play.modiqo.ai/chetan/posthog-project-dau@0.0.1 <name=value...> --yes"},"preservesAcquisitionBoundaries":["adapter_selection","oauth_dcr","google_discovery","static_token_setup","runtime_security_checks"],"requiresConsent":true,"step":5,"type":"run"}],"producedBy":{"roteVersion":"0.72.0"},"publishedAt":"2026-08-24T22:14:11.736899+00:00","reference":"chetan/posthog-project-dau@0.0.1","requirements":{"adapters":[{"bindingStatus":"resolved","credentialDemand":{"requirements":[{"description":"OAuth token with automatic refresh","kind":"bearer","name":"ADAPTER_POSTHOG_MCP_TOKEN","protocol":"oauth_dcr","protocolSource":"declared","setup":{"drivenBy":"rote","interaction":"browser_or_device","type":"oauth"}}],"status":"required"},"displayName":"PostHog MCP","fingerprint":"mcp_3M5JDhpGsccg4pKGwfTswhSTpwb1","id":"posthog-mcp","purpose":"PostHog v1.0.0 (MCP adapter, reverse-engineered)","requirement":"chetan/posthog-mcp@1.0.0","version":"1.0.0"}],"browser":{"dependencies":[],"runtime":false,"signIn":false},"roteCli":{"minimumVersion":"0.62.0"},"sessions":true},"resolution":"pinned","schema":"rote.play.v1","stats":{"downloads":3,"installs":0},"steps":{"count":3,"names":["dau_by_day","org_context","project_list"]},"title":"posthog-project-dau","type":"play","version":"0.0.1","visibility":"public"}