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
Categories
Front-EndsLicense
GNU General Public License version 2.0 (GPLv2)Follow SQLeo Visual Query Builder
You Might Also Like
Our Free Plans just got better! | Auth0 by Okta
You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your secuirty. Auth0 now, thank yourself later.
Rate This Project
Login To Rate This Project
User Reviews
-
Anyone writing SQL queries by hand will appreciate the UI of this program. It takes a bit of getting used to, but 20 minutes should see you working efficiently. The power is to be able to write simple, but large queries by using a click'n'point interface, similar to MS-Access, removing the the tedium of getting the syntax correct and spelling errors. Support for a lot of backends completes what is a very useful utility. Oh, and it's standalone java, so it runs on any platform! What's not to like?
-
Easy to use
-
I have loved the application. It is doing exactly what it is meant to do.
-
Really easy to use. You can achieve good results with SQLeo also. And last but not least - SQLeo is multi platform tool. SQLeo is great and well made. Thank you.
-
This is the only small footprint visual query builder that 1. actually works as advertised 2. does everything you'll need 3. doesn't cost an arm and a leg 4. doesn't have kitchen sink feature bloat and 4. is well supported. My only criticism is that it is not better known and more widely used. It should be.