Cork City F.C.
McSweeney moved back to his hometown club, Cork City F.C., in the League of Ireland in the summer of 2007, where he worked under well renowned Irish manager Damien Richardson . He made his debut in the League Cup Quarter-Final away to Bohemians . He was an instant success at Turners Cross, playing predominantly as a right winger and played a key role in the club's successful 2007 FAI Cup campaign culminating in a 1–0 victory over Longford Town FC. At the end of the Irish 2007 season McSweeney was voted Cork City's "signing of the season" by an online poll at corkcity.ie, but contract talks stalled due to the infamous 'Arkaga' takeover and, despite interest from Bohemians, he crossed the Irish Sea again, signing an 18-month contract with Stockport County under the management of fellow Irishman Jim Gannon .