SQLeo



SQLeo is a free open source SQL Graphical Query builder based on SQLeonardo.2009.03.rc1, that permits to create complex sql queries easily as Access (Microsoft query) do.

This GUI with multi connections, supports virtually all JDBC drivers, including ODBC bridge, has been mainly tested with Oracle, Mysql, Firebird, HSQLDB, CsvJdbc ...

The main added feature to SQLeonardo (after bug fixing) is the ability to store all the joins definition in a local csv file, to generate SQL even when the database has no FK implemented or for views.

Can be compared with : FreeQueryBuilder (SQLeonardo ancestor), SQuirreL SQL, Active Query Builder, Flyspeed SQL Query, Oracle SQLdeveloper, Toad for data Analyst, ... or command line utilities like: SQLTools++, PKlite, ..

Features

1. Connexion setup and Metadata explorer
2. Query Builder 3. Content/Preview 4. Command Editor (should be reserved for DDL or DML usage)