I'm new to Stored Procedures. Can you please tell me what tools you all use for creating stored procedures? Do you just use text editors or something else? I'm using a MAC and I have MySql workbench installed on my machine. I'm looking for tools that can help me creating stored procedures.

A former admin had created couple of stored procedures. What is the best way to edit and test them?
Any help would be greatly appreciated.

Thank You