Archive for the ‘Plugins’ Category

MySQL Workbench Administrator Plugin

Wednesday, October 7th, 2009

Recently we have released Workbench 5.2.4 Alpha. This version has some new features, and amongst them there is Workbench Administrator plugin or WBA plugin for short. The plugin aims to ease the managing process of server instances. What we offer with WBA is a simple way to check status, configure and ...

Auto-create relationships for MyISAM tables in MySQL Workbench

Thursday, July 16th, 2009

Over a chat on the #workbench IRC channel, Collin Cusce has written a handy little Lua script to automatically create relationships (through foreign keys) for his reverse engineered database. Reverse engineering the DB to import tables into a diagram was easy, but their database used no "hard" foreign keys and an ER ...

MySQL Workbench speaks SQLite

Wednesday, May 13th, 2009

As many of you already know, MySQL Workbench offers powerful scripting support and a plugin interface that allows anybody to extend the application or add new functionality. The latest addition to the WB plugin family has been written by Thomas Henlich. It features SQLite compatible SQL export of your Workbench models. Download ...

Python Scripting in Workbench

Sunday, March 8th, 2009

Python support has been added to the latest version of MySQL Workbench. In addition to Lua, you can now write scripts and modules or interact with the GRT shell using the Python language. The integration allows you to use GRT objects and modules mostly in the same way you would ...

MySQL Workbench – LUA-Script For Batch Renaming Of Foreign Keys

Tuesday, January 27th, 2009

Yesterday there was a short discussion on our public IRC channel (#workbench on freenode). It was about how Workbench handles Foreign-Key-Names. Especially if you intend to use Synchronization feature (available in SE edition only) its good to have names for FKs (and their coresponding Indices). Workbench does that by default if ...

Workbench Plugin Tutorial: Load INSERTs from a File

Friday, December 12th, 2008

A couple of people have asked for a means to set the list of INSERT statements of a table from data already in an external file. While we haven't implemented that feature in Workbench as of now, that's something that can be easily added as a Lua plugin. The plugin is ...

A Utility Library for MySQL Workbench

Friday, November 7th, 2008

Here is a small library with various helpful Lua functions for scripts and plugins for Workbench, making it easier to write your own plugins for exporting to some external format, generating reports etc. The library is meant for Workbench 5.0, but it will be ported to 5.1 as well, which ...

Automate Figure Arrangement In Workbench

Thursday, October 30th, 2008

Initiated by a question on the forum I took some time to exercise my Workbench-Scripting-Knowledge. The question was, if it's possible to do some figure-arrangement/organizing via scripts. To be more precise, the task I had to master was to get tables that have names starting with a given prefix moved ...

Pimp My Workbench

Friday, September 5th, 2008

Some weeks ago there was a request about adding a feature that keeps (or gets) datatypes of colums, which are connected via foreign keys, in sync. While we have added this to our ToDo list, I thought of doing some simple LUA exercises to give the user at least a ...

MySQL Workbench: Lua Plugin Support

Tuesday, January 8th, 2008

The Lua plugin support has been finally fixed and will be working in the next release. Together with a few other improvements, it's now possible to write your own commands to do all kinds of tasks. Documentation for the plugin system is not yet written (and the previous one is ...