SQLeo Visual Query Builder

The SQL tool that displays joins definition (FKs and much more ...)

5.0 Stars (5)
275 Downloads (This Week)
Last Update:
Download SQLeoVQB.2014.04.rc1.zip
Browse All Files
Windows Mac Linux

Screenshots

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 Web Site

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
  • and many bug fix

Update Notifications





User Ratings

★★★★★
★★★★
★★★
★★
5
0
0
0
0
ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
Write a Review

User Reviews

  • clacs
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    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!!

    Posted 03/13/2013
  • wyattbiker
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    works great. very easy to use. using it on Mac OS X Mountain Lion and MySQL

    Posted 02/27/2013
  • dillonbutler
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    simple and straight forward to use

    Posted 02/17/2013
  • blakenelson
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    sqleo works perfectly, thanks

    Posted 01/23/2013
  • elirodrigues
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    terrific program

    Posted 09/20/2012
Read more reviews

Additional Project Details

Intended Audience

Advanced End Users, Developers, System Administrators

User Interface

Java Swing

Programming Language

Java

Registered

2012-01-20
Screenshots can attract more users to your project.
Features can attract more users to your project.

Icons must be PNG, GIF, or JPEG and less than 1 MiB in size. They will be displayed as 48x48 images.