SQLeo is a professional lightweight SQL Query tool that permits to create or display complex sql queries (from OBIEE, Microstrategy, SSRS, Cognos, Hyperion, Pentaho ...) and permits to reverse engineer database models as db designers do.
This SQL GUI supports all JDBC drivers: Oracle, MySQL, MSSQL, Firebird, HSQLDB, H2, PostgreSQL, CsvJdbc, SQLite, UCanAccess, MonetDB ... (but MySQL jdbc and CsvJdbc are the only driver included in the package)
Can be compared with : FreeQueryBuilder (SQLeonardo ancestor), SQuirreL SQL, Active Query Builder, Flyspeed, Oracle SQL developer, Toad, DbVisualizer, MySQL Workbench, DBeaver, Aqua Data Studio ...
Features
- Metadata explorer
- Command Editor
- Query Builder
- Read Only connections
- Background color per connection
- Content/Preview
- Export (html, insert, text or csv), import data
- SQL history
- Data comparer
- PIVOT function
- Mac OSX native integration
- Export to Html PivotTable.js
- Schema comparer



