The most iconic mouse detective is Basil of Baker Street, star of Disney's 1986 animated film The Great Mouse Detective (based on Eve Titus's Basil of Baker Street novels). A direct Sherlock Holmes pastiche, Basil solves crimes with brilliant deduction, violin-playing, and a loyal companion (Dr. Dawson = Watson).
From Beverly Cleary's The Mouse and the Motorcycle series (Runaway Ralph, Ralph S. Mouse). While not a professional detective, Ralph investigates mysteries around the Mountain View Inn—missing items, strange noises, human secrets—using his motorcycle mobility and human friendship (Keith).
Mary Norton's tiny people who "borrow" from humans. They often solve problems and uncover secrets to survive—functioning as amateur sleuths in their own right. The Borrowers (1952) and sequels; Studio Ghibli's The Secret World of Arrietty (2010).
"Greatest" is subjective, but these are the most beloved murine mystery-solvers in literature and film. Basil remains the definitive mouse detective archetype.