sqlMate - a GUI-based local Front-End for the Administration of remote MySQL-Databases
Version 1.3 of Dec.23, 2005

sqlMate makes working with a remote MySQL-database much more easy. As an administrator you perform tasks such as:
Create tables, modify and delete tables
Display row-data, sometimes modify them
Create indexes, modify and delete them
Start queries
and many more.
New in ver. 1.3:
History-Function .

You can do all this with the well-known 'MySQL_Admin'-tool. This is a browser-based application, which is comfortable and powerful. But it is quite difficult to automate jobs or to perform tasks repeatedly.

This is the main-purpose of sqlMate. While with MySQL_Admin you don't need to know much about SQL-syntax this is quite different in sqlMate.
Whatever you want to do to your MySQL-database you must say it in pure SQL-syntax, e.g. CREATE TABLE with all column definitions and keys. In other words, you write a code-sequence of SQL-statements. What sqlMate does is send this code-sequence to the database-server over the internet-connection, which is automatically being established by sqlMate. After remote processing sqlMate receives the returned data, reformates them for easy reading and displays them in a listbox.

How to use it...
When the work is done, i.e. your intended tasks performed you can store your code-sequence as a 'Stored Query' and recall it later whenever you need it.

Auxiliary Edit:

This feature enables you to generate an SQL-statement for UPDATE or INSERT based upon a currently selected database-row (

Look & Feel:

If somebody might want to have the several listboxes in different colors there is any freedom you like (more....).


If you prefer MySQL_Admin or rather sqlMate is just a matter of personal taste.

Most people would find MySQL_Admin more convenient. Others on the other hand like the total control over the database by unlimited use of SQL, which sqlMate gives them.

Anyway, it's up to you!

What you still need:

Before you download the program, please read and accept the following NoWarranty-Clause:


  • Download '' into a newly created directory, e.g. 'c:\sqlMate'
  • In that directory: enter 'unzip sqlMate'
  • enter install.
A re-boot is not required.

Install over an existing version:
  • Simply unzip the download-file '' into your existing directory.

Download: (110 kb)
Furthermore you need... (400 kb)
Vrobj.dll is a DLL which is used by many programs and most probably you already have it somewhere on your system (in the LIBPATH). If not or if the version that you have is older than 06-06-1995 then you must download it here and unzip it into (recommended) x:\os2\dll\.

Send an Email.


Auxiliary Edit:

Generate an SQL-Statement for UPDATE or INSERT from a certain database-row. Proceed as follows:
  1. Edit an SELECT-Statement into the DDML-entryfield
  2. click GO
  3. You receive the SQL-output as a list (listbox bottom lefthand)
  4. Doubleclick on a database-row; that row will be split into single columns and put as a list into the 'Single-Record'-Listbox
  5. In the 'Single-Record'-listbox select a column for the WHERE-clause (optionally)
  6. Invoke the context-menu (right mouse-click)
  7. Select 'Generate SQL-Statement' -> 'Update'
  8. The 'Auxiliary-Edit'-window opens where you can edit (if you like) the SQL-statement.
  9. Invoke the context-menu: select COPY
  10. Turn over to the main-SQL-Edit-window; invoke the context-menu: select PASTE

Determine your own colors:

Proceed as follows:
  1. Open the OS/2-color-palette
  2. To set the background-color: Drag a color into the listbox in question
  3. To set the foreground-color (text): hold down CTRL-key and drag as above
  4. Re-install orginal colors: Main-menu -> Settings -> Reset Color-Settings


Whenever a SQL-command is executed (by means of the 'Go'-button) the command is saved internally. To recall any SQL-command which has been executed before you simply click on the History-button and you can select from a list of already processed commands.
Note: The history-buffer is only valid during program-lifetime, i.e. after sqlMate has terminated the history vanishes also.

So the History-function does not mean that you don't have to save your SQL-command finally before exiting the program.