He is the director of the baroque ensemble Concerto Caledonia, whose recordings of 18th century Scottish music have been released on Linn, Hyperion, Marquis and Delphian. In 2001 the Sunday Times chose the Scottish-Italian collection Mungrel Stuff (Linn CKD140) as one of its Records of the Year, and the group performed David’s reconstruction of Allan Ramsay’s ballad opera The Gentle Shepherd at the Edinburgh International Festival. 2003 saw the release of an album with Cape Breton fiddler David Greenberg, which includes Finnish and Hungarian traditional tunes alongside music by Frank Zappa and Fred Frith. The Red Red Rose (2004) includes the première recording of the original version of Burns’s famous song, and Fiddler Tam (Linn CKD240, 2005) is the first recording devoted to the music of Thomas Erskine, 6th Earl of Kellie.
David has appeared as harpsichord soloist with the Scottish Chamber Orchestra and the BBC Scottish Symphony Orchestra, and also plays regularly in the SCO. In the USA, he plays harmonium and melodica as a guest artist with the Chris Norman Ensemble, and in Canada is a member of Suzie LeBlanc’s ensemble Joli Bois. He provided the string arrangements for I trawl the Megahertz by Paddy McAloon of Prefab Sprout, which was voted by Mojo magazine one of the 50 most ‘out there’ albums of all time, and was the featured piano and fortepiano soloist on the soundtrack of Mira Nair’s movie Vanity Fair.