Function getMcpServerToolMetadataUsageRows

apps/sim/lib/mcp/tool-limits.ts:129–156

(
  tx: DbOrTx,
  serverId: string,
  excludeToolId?: string
)

}

export async function getMcpServerToolMetadataUsageRows(
  tx: DbOrTx,
  serverId: string,
  excludeToolId?: string
): Promise<McpToolMetadataUsageRow[]> {
  const rows = await tx
    .select({
      id: workflowMcpTool.id,
      toolNameBytes: sql<number>`octet_length(${workflowMcpTool.toolName})`,
      toolDescriptionBytes: sql<number>`coalesce(octet_length(${workflowMcpTool.toolDescription}), 0)`,
      parameterSchemaBytes: sql<number>`octet_length(${workflowMcpTool.parameterSchema}::text)`,
    })
    .from(workflowMcpTool)
    .where(
      and(
        eq(workflowMcpTool.serverId, serverId),
        isNull(workflowMcpTool.archivedAt),
        excludeToolId ? ne(workflowMcpTool.id, excludeToolId) : undefined
      )
    )

  return rows.map((row) => ({
    id: row.id,
    toolNameBytes: Number(row.toolNameBytes) || 0,
    toolDescriptionBytes: Number(row.toolDescriptionBytes) || 0,
    parameterSchemaBytes: Number(row.parameterSchemaBytes) || 0,
  }))
}

export function validateMcpToolMetadataForStorage(metadata: {
  toolName?: string | null