Function buildWorkspaceMdData

apps/sim/lib/copilot/chat/workspace-context.ts:324–524

(
  workspaceId: string,
  userId: string
)

// the typed VFS snapshot are built from this single fetch. Returns null when the
// workspace is unavailable or a fetch fails.
async function buildWorkspaceMdData(
  workspaceId: string,
  userId: string
): Promise<WorkspaceMdData | null> {
  try {
    await assertActiveWorkspaceAccess(workspaceId, userId)
    const wsRow = await getWorkspaceWithOwner(workspaceId)
    if (!wsRow) {
      return null
    }

    const [
      members,
      workflows,
      folderRows,
      kbs,
      tables,
      files,
      credentials,
      customTools,
      mcpServerRows,
      skillRows,
      jobRows,
    ] = await Promise.all([
      getUsersWithPermissions(workspaceId),

      db
        .select({
          id: workflow.id,
          name: workflow.name,
          description: workflow.description,
          isDeployed: workflow.isDeployed,
          lastRunAt: workflow.lastRunAt,
          folderId: workflow.folderId,
        })
        .from(workflow)
        .where(and(eq(workflow.workspaceId, workspaceId), isNull(workflow.archivedAt))),

      db
        .select({
          id: workflowFolder.id,
          name: workflowFolder.name,
          parentId: workflowFolder.parentId,
        })
        .from(workflowFolder)
        .where(and(eq(workflowFolder.workspaceId, workspaceId), isNull(workflowFolder.archivedAt))),

      db
        .select({
          id: knowledgeBase.id,
          name: knowledgeBase.name,
          description: knowledgeBase.description,
        })
        .from(knowledgeBase)
        .where(and(eq(knowledgeBase.workspaceId, workspaceId), isNull(knowledgeBase.deletedAt))),

      db
        .select({