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!
2016.09: Unlimited edition free for educational purpose.
2016.08: New Russian translation.
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.
Here are various screenshots and videos featuring SQLeo.
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.
SQLeo Visual Query Builder is a desktop Java Swing Application (small < 1MB) which can run on any platform which has JDK 1.6+.
Check the beginners and advanced user guides.