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

Other Useful Business Software
Manage your entire team in one app Icon
Manage your entire team in one app

With Connecteam you can manage every aspect of your business on the go, no workstation needed.

Connecteam is an award-winning all-in-one employee management solution for daily operations, communications, and human resource management.
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