SQLeo Visual Query Builder
The SQL tool that stores Joins definition (FKs and more ...)
Screenshots
Description
SQLeo is a free open source SQL Query builder based on SQLeonardo.2009.03.rc1 (used in Jasper Reports and Pentaho), that permits to create complex sql queries easily as Access (Microsoft query) do.
This GUI supports virtually all JDBC drivers, including ODBC bridge, has been tested with Oracle, Mysql, Firebird, HSQLDB, Postgresql, 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, Oracle SQLdeveloper, Toad, DbVisualizer ...
Docs:
- Video http://sqleo.sourceforge.net/video.html
- Online html help http://sqleo.sourceforge.net/guide.html
- Help (en,fr,it) in html, pdf, docx, ... http://svn.code.sf.net/p/sqleo/code/trunk/doc/howtouse
- javadoc http://svn.code.sf.net/p/sqleo/code/trunk/doc
Categories
License
Features
- Connexion setup and Metadata explorer
- Query Builder:
- - create joins with drag and drop, foreign keys or with csv definition
- - supports all types of join: inner, rigth-left-full outer, natural
- - supports group by, order by, subqueries, union ...
- - pack (hidde) or unpack unused columns from a table
- - save query as image, .xlq or .sql
- - reverse SQL syntax to graph (not finished Yet)
- Content/Preview:
- - grid display with data filtering, sorting
- - rowcount
- - jump to parent or child table data
- - insert, update, delete data in grid
- - export data, import data (text or csv)
- Command Editor (should be reserved for DDL or DML usage)
- +
- new 2012.01: store joins definition in a local csv file
- new 2012.07: content / preview window fetch only first rows
- new 2012.07: Undo Redo in Query Editor
- new 2013.02: Reverse subqueries improvments
- new 2013.02: Content rowcount
- and many bug fix
Update Notifications
User Ratings
User Reviews
-
terrific program
-
Muy buen programa, sencillo y muy útil. Solo me complico un poco en la instalación y configuración del mysql driver en Windows Una vez solucionado, todo perfecto!!
-
works great. very easy to use. using it on Mac OS X Mountain Lion and MySQL
-
simple and straight forward to use
-
sqleo works perfectly, thanks