SQLeo

A powerful SQL tool to transform or reverse complex queries (generated by OBIEE, Microstrategy, Cognos, Hyperion, Pentaho ...) into diagrams to ease visualization and analysis. A graphical query builder that permits to create complex SQL queries easily. The GUI with multi-connections supports virtually all JDBC drivers, including ODBC bridge, Oracle, MySQL, PostgreSQL, Firebird, HSQLDB, H2, CsvJdbc, SQLite. And top of that, everything is open-source!

Latests Features:

2016.07: Prevent "Out of Memory" error when viewing huge MySQL tables.

2016.05: Cancel Query is working.

2016.02: Background color per datasource, Filters populated with values.

2016.01: READ ONLY connections.

2015.12: Better Mac OS integration.

2015.11: "auto-savepoint" to avoid PostgreSQL ERROR: current transaction is aborted.

2015.10: Choose datasource, output format, input script from command editor command line.

2015.07-08: New translations added: Arabic, Chinese, Hindi, Russian, Portuguese.

All Features »

Screenshots, Videos

Here are various screenshots and videos featuring SQLeo.

View details »

Support, Donate

We are constantly adding new features, fixing bugs. Please support us either by participating in the project development or by donating to the project. We are happy to help and support SQLeo users.

View details »

Downloads

SQLeo Visual Query Builder is a desktop Java Swing Application (small < 1MB) which can run on any platform which has JDK 1.6+.

View details »

Documentation

Check the beginners and advanced user guides.

View details »

Project hosting

Visit us at