Xcode 6 does not have a menu item to access provisioning profiles. How can one manage existing provisioning profiles (list, delete, etc)?
For reference purposes, a similar question was asked pertaining to Xcode 5:
Provisioning Profiles menu item missing from Xcode 5
I commented on the selected answer that in Xcode 6 the Accounts tab now shows Repositories. I was encouraged to start a new question to help others find information relevant to Xcode 6.
Adding Apple ID
As Bo A points out, in order to see more than just Repositories, you need to add an Apple ID.
Select Xcode -> Preferences...
On the Accounts tab, click on the + sign in the lower left corner and select Add Apple ID... Fill out the required information and select Add.
This addresses the part of the question that indicates that the Accounts tab just shows Repositories.
Listing provisioning profiles
As Nikos M. points out, you can select an Apple ID and then the View Details... button to see your provisioning profiles (and signing identities).
Deleting provisioning profile
Another part of the question was asking about how to delete a provisioning profile (in addition to listing). It appears that there are two steps to this process:
Right click on a provisioning profile (that you listed from above) and select Show in Finder. You can then move the highlighted item to the trash.
Go to the Member Center on developer.apple.com and follow links to the section on Certificates, Identifiers & Profiles. Find and delete the provisioning profile of interest.
If you only remove the provisioning profile on developer.apple.com, I found that the profile still exists on your computer locally (not sure if it is eventually synced or if there is a way to force sync).
If you only remove the profile locally you may be okay for a while, but deleting and re-adding your Apple ID will cause the profile to reappear on your local machine.
In the accounts tab in Xcode preferences, select the account you want (appleID not repository) and click the view details button at the bottom right corner. There you will see both your certificates (at the top section) and the provisioning profiles for that account (at the bottom section).
The accounts tab shows both Apple IDs and Repositories (as well as "servers"). Make sure you have added your Apple ID by clicking the + icon at the bottom left.