use Tfs_Configuration;
select p.DisplayName, p.PublisherName, e.ExtensionName,
e.DisplayName, e.ShortDescription, cast(Content as varchar(max)) as Content
from Gallery.tbl_Asset a
inner join Gallery.tbl_Extension e on a.ReferenceID=e.ExtensionId
inner join Gallery.tbl_Publisher p on e.PublisherId = p.PublisherId
inner join tbl_FileReference r on a.FileId = r.FileId
inner join tbl_Content c on r.ResourceId = c.ResourceId
where AssetType = 'Microsoft.VisualStudio.Services.Manifest'
order by e.ExtensionName, a.Version desc
I can see multiple versions of the same extension there, my TFS instance went through several version upgrades; on a freshly installed copy there would probably be only one.