MySQLWorkbench allows to design database model easily and also provides an option to generate the SQL script. By default script is generated for MySQL, but, what if you need to generate a SQL script for FirebirdSQL?.
Using Python you cand create custom plugins to access to model properties (table and columns definitions for example) please visit this link for more info Scripting and Plugin Development
So, I decided to write a plugin to generate a SQL Script for FirebirdSQL. My goal it's just to show how can we access to schemas, tables and columns properties using classes already defined by MySQLWorkbench.
Script can be downloaded from github: https://github.com/tmsanchez/workbenchscripts/blob/master/mysqlToFB_grt.py
Once script is downloaded do following:
1. Go to menu: Script / Install Plugin Module...
3. Clic on OK button on Plugin Installed dialog and Restart MySQL
6. Once script was generated clic OK button on following dialog
That's all, I hope this can help you to generate Firebird scripts and to write your own plugins.