Orca is the place for working with a fleet of agents (e.g. Grok Bot, Claude Code). Run any coding agent with your own subscription. Available on desktop, mobile and remote runtime.
TypeScript adeagent-ideai-agentsautomationbotclaude-codecodexghosttygrok-bothermes-agentmobile-appmuseopenclawopencodeorchestrationpiruntimeterminalworktreesyc-backed
import type { CloudDatabase } from '@orca-cloud/cloud-database'
import { openSecret, sealSecret } from './slack-sealing.js'
// appId is null for a workspace installed before apps were rows: only the legacy env-secret route
// reaches it, until the operator binds it to its app.
export type SlackInstall = {
teamId: string
appId: string | null
botUserId: string
paused: boolean
}
// One row per Slack workspace: its bot, and which Orca app it is installed through. A workspace has
// at most one Orca app. Bot tokens are sealed under the team id.
export class SlackInstalls {
constructor(private readonly tokenKey: Buffer) {}
async find(database: CloudDatabase, teamId: string): Promise<SlackInstall | null> {
const [row] = await database.query(
'SELECT app_id, bot_user_id, paused FROM connector_slack_installs WHERE team_id = ?',
[teamId]
)
return row
? {
teamId,
appId: row.app_id === null ? null : String(row.app_id),
botUserId: String(row.bot_user_id),
paused: Number(row.paused) === 1
}
: null
}
async botToken(database: CloudDatabase, teamId: string): Promise<string | null> {
const [row] = await database.query(
'SELECT bot_token FROM connector_slack_installs WHERE team_id = ?',
[teamId]
)
if (!row) {
return null
}
// Sealed under another key or corrupted: as good as no install.
try {
return openSecret(this.tokenKey, teamId, String(row.bot_token))
} catch {
return null
}
}
// False when the workspace already belongs to a different Orca app. The same app reinstalling, or
// a pre-apps install being bound to its app, updates the row in place.
async save(
database: CloudDatabase,
install: { teamId: string; appId: string; botUserId: string; botToken: string },
now: number
): Promise<boolean> {
const [result] = await database.query(
`INSERT INTO connector_slack_installs
(team_id, app_id, bot_user_id, bot_token, paused, installed_at)
VALUES (?, ?, ?, ?, 0, ?)
ON CONFLICT (team_id) DO UPDATE SET app_id = excluded.app_id,
bot_user_id = excluded.bot_user_id, bot_token = excluded.bot_token,
installed_at = excluded.installed_at
WHERE connector_slack_installs.app_id IS NULL
OR connector_slack_installs.app_id = excluded.app_id`,
[
install.teamId,
install.appId,
install.botUserId,
sealSecret(this.tokenKey, install.teamId, install.botToken),
now
]
)
return Number(result?.changes ?? 0) > 0
}
async setPaused(database: CloudDatabase, teamId: string, paused: boolean): Promise<boolean> {
const [result] = await database.query(
'UPDATE connector_slack_installs SET paused = ? WHERE team_id = ?',
[paused ? 1 : 0, teamId]
)
return Number(result?.changes ?? 0) > 0
}
}