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.02: Background color per datasource, Filters populated with values.
2016.01: READ ONLY connections.
2015.12: Better Mac OS integration, "auto-savepoint" to avoid PostgreSQL ERROR: current transaction is aborted.
2015.10: Choose datasource, output format, input script from command editor command line.
2015.08: New translation for Portuguese, Italian translation improved.
2015.07: New translations added: Arabic, Chinese, Hindi, Russian.
2015.05-06: Full support for resize (Fonts and Icons).
2015.04: Serbian translation, PIVOT SQL (db independent) functions, Content window: data modification improvments.
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.