SQLeo Visual Query Builder download

SQLeo Visual Query Builder

SQLeo Visual Query Builder Description
SQLeo is a (small < 1MB) SQL Query builder that permits to create or display complex sql queries as Access (Microsoft query) do and permits to reverse engineer database models as db designers do.

This GUI supports virtually all JDBC drivers: tested with ODBC bridge, Oracle, Mysql, Firebird, HSQLDB, Postgresql, CsvJdbc, SQLite, UCanAccess, MonetDB ...

Starting with version 2014.01, public executable of query builder is limited to 3 tables per graph. Full featured version will be reserved for donators.

Can be compared with : FreeQueryBuilder (SQLeonardo ancestor), SQuirreL SQL, Active Query Builder, Flyspeed, Oracle SQLdeveloper, Toad, DbVisualizer, brio query, SQLyog, MySQL Workbench, Navicat, Aqua Data Studio, RazorSQL ...

Docs:
- Online html help and Videos 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
SQLeo Visual Query Builder 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 (Hyperion, Microstrategy, Cognos, Analytics ...)

Content/Preview:

- grid display with data filtering, sorting

- rowcount

- jump to parent or child table data

- insert, update, delete data in grid

- export (html, insert, text or csv), import data

- format SQL text

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 2013.02: Reverse subqueries improvments

new 2013.04: Filter icon in graph for predicates

new 2013.05: auto arrange Entities in graph using spring force model

new 2013.07: java 7 on linux and java web start compatibility

new 2013.08: auto complete sql text

new 2013.10: SQLite support

new 2013.11: full support for reversing subqueries to graph

new 2014.01: data (content) window merged in designer

new 2014.01: PL/SQL and other procedural languages support

new 2014.03: export/import in unicode (UTF-8)

new 2014.04: display (joins) graph even when not connected

new 2014.04: better syntax formatting for subqueries

new 2014.04: support for MySQL queries on multi schemas

new 2014.06: font size can be increased for high resolution screens

and many bug fix

Download:Click Here