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

Project Samples

Project Activity

See All Activity >

Categories

Front-Ends

License

GNU General Public License version 2.0 (GPLv2)

Follow SQLeo Visual Query Builder

SQLeo Visual Query Builder Web Site

You Might Also Like
Our Free Plans just got better! | Auth0 by Okta Icon
Our Free Plans just got better! | Auth0 by Okta

With up to 25k MAUs and unlimited Okta connections, our Free Plan lets you focus on what you do best—building great apps.

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.
Try free now
Rate This Project
Login To Rate This Project

User Ratings

★★★★★
★★★★
★★★
★★
8
0
0
0
0
ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 5 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5

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
    1 user found this review helpful.
  • I have loved the application. It is doing exactly what it is meant to do.
    1 user found this review helpful.
  • 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.
    1 user found this review helpful.
Read more reviews >

Additional Project Details

Intended Audience

Advanced End Users, System Administrators, Developers

User Interface

Java Swing

Programming Language

Java

Database Environment

JDBC, ODBC

Related Categories

Java Front-Ends

Registered

2012-01-20