Take a look at this image:
This is how you should use the MyGeneration Desktop. The MyMeta browse is on the left, it is actually walking all of the MyMeta meta-data just like templates do, if you click on an item in the tree the MyMeta Properties window will show you all of the meta data properties. There is even a contact sensitive help link in the bottom right hand corner for more information.
Drill into your stored procedures and you'll see we have meta data for them.
Also, there is a template that generates code necessary to call a stored procedure for dOOdads, you could easily customize it or use it directly.
Open the Template Browser dockable window in MyGeneration and browse to:
==> dOOdads - Invoke a Stored Procedure