Rory McAuley spent two years with Cambridge City after leaving Norwich's academy at the age of 14 where he played in central midfield. He joined Cambridge United's centre of excellence in the summer of 2006. He performed consistently well over the two years of his scholarship and earned himself a third season. He has played in both the Cambridge United's youth team and for Cambridge Regional College in the Ridgeons League. He can play as either right back or central midfield. He made his debut for the Cambridge United first team on 2nd September 2008 at Ebbsfleet.

During the autumn of 2013, he was loaned to Chelmsford City and on 9th January 2014, he joined Dartford on a month's loan.

He made the move to Dartford permanent in the summer of 2014.

He moved to Chelmsford in 2015.

On 2nd June 2016, he signed for Lowestoft newly relegated to the Ryman League.

On 4th July 2018, he left Lowestoft by mutual consent and joined Kings Lynn Town

On 17th June 2020 it was confirmed that Lynn were winners of the National League South, on a points per game basis due to the premature ending of the season because of Covid-19, and would be promoted into the National League.

On 13th May 2021 Rory was among six people arrested after a large quantity of class-A drugs were found in a car and a home in Norwich. In total, three men and three women were arrested in connection with the two drugs stashes seized. Rory McAuley, 31, of George Fox Way in Norwich, who was charged with conspiracy to supply a class-A drug and being in possession of criminal property. Both appeared before Norwich Magistrates' Court on May 15th and were released on conditional bail to appear at Norwich Crown Court on June 14th Kings Lynn suspended him indefinitely.

His contract was cancelled by mutual consent in September 2021 and he joined Bedford Town. They won the Southern League title on 30th April 2022, with McAuley scoring in a 5-3 win over Plymouth Parkway.

His court case came in February 2022 with the prosecution reporting that he was found with half a kilo of cocaine in his possession. He pleaded guilty and will be sentenced later in 2022 with speculation that he could serve 11 years in prison.