The 38-year-old former lock earned 108 caps for Ireland and featured in seven Tests across three tours with the Lions.
The club confirmed the arrival earlier this afternoon. "Paul will bring his value and experience to our coaching team through his proven leadership abilities and his tactical and technical skills".
O'Connell will be moving to Paris in the coming weeks ahead of Stade Francais' first game of the season at the end of August away to Perpignan.
The club announced the news with a video on Twitter in which the former Ireland captain said, "I'm very happy to be in Paris and working with this great club".
The Irishman joins Meyer, Pieter De Villiers, John McFarland, Julian Dupuy and fellow Limerick man Mike Prendergast in an extensive backroom team at the club.
His new role will see him focus on coaching the Stade Francais forwards.
Stade narrowly escaped relegation from the Top 14 last season but with Swiss billionaire Hans-Peter Wild bankrolling the club, there have been a number of top signings including French internationals Gael Fickou and Yoann Maestri as well as Argentina playmaker Nicolas Sanchez.