The open-source app everyone uses to manage agents at work
TypeScript acpxagent-orchestrationagent-skillsagentic-aiai-agentsai-engineeringai-governanceai-toolsautonomous-agentsclaudeclaude-codeclaude-skillscodexhermesllmmcpmulti-agentopenclawproject-managementworkflow-automation
import { and, eq, sql } from "drizzle-orm";
import { chatEndpoints, chatSdkState, type Db } from "@paperclipai/db";
import { GITHUB_RECOVERY_STATE_KEY } from "./webhook-ingress.js";
/** Direct callback recovery warnings do not describe Cloud relay delivery. */
export async function githubRecoveryActivity(
db: Db,
endpointId: string,
before?: { createdAt: string; id: string },
) {
const rows = await db
.select({ id: chatSdkState.id, value: chatSdkState.value, updatedAt: chatSdkState.updatedAt })
.from(chatSdkState)
.innerJoin(chatEndpoints, eq(chatEndpoints.id, chatSdkState.endpointId))
.where(and(
eq(chatSdkState.endpointId, endpointId),
eq(chatSdkState.stateKey, GITHUB_RECOVERY_STATE_KEY),
sql`nullif(${chatEndpoints.setup}#>>'{github,cloudRegistrationId}', '') is null`,
before ? sql`(date_trunc('milliseconds', ${chatSdkState.updatedAt}), ${chatSdkState.id}) < (${before.createdAt}::timestamptz, ${before.id}::uuid)` : undefined,
))
.limit(1);
return rows.flatMap((row) => {
const value = row.value as { outcome?: string } | null;
const detail =
value?.outcome === "history_limit_reached"
? "Recent webhook volume exceeded automatic recovery's bounded scan. No partial history was replayed. Check the App's Recent Deliveries for missed messages."
: value?.outcome === "callback_mismatch"
? "The GitHub App's callback no longer matches this connection. Reconnect the App to repair it; repository access will not change."
: value?.outcome === "scan_failed"
? "Paperclip could not check GitHub's failed deliveries. The check will retry with backoff; normal callbacks are still processed."
: null;
return detail
? [
{
id: row.id,
kind: "health" as const,
status: "attention",
summary: "GitHub webhook recovery needs attention",
detail,
createdAt: row.updatedAt.toISOString(),
replayable: false,
resolutionActions: [],
},
]
: [];
});
}