A powerful SQL tool to transform or reverse complex queries 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, CsvJdbc, SQLite. And top of that, everything is open-source!
One of the main features of SQLeo is the ability to store all the joins definitions in a local CSV file to generate SQL even when the database has no foreign key implemented or for views. SQLeo can be compared with : FreeQueryBuilder (SQLeonardo ancestor), SQuirreL SQL, Active Query Builder, Flyspeed SQL Query, Oracle SQLdeveloper, Toad for data Analyst, or command line utilities like: SQLTools++, PKlite.
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.
Check the beginners and advanced user guides.