Choose your SQL server:

Customers

Become a customer

Testimonials

Mario Figueiredo:
"I can safely forget all I know about SQL when using SQLite Maestro. It is that easy and intuitive to use. It is also nicely drawn with an easy and appealing interface that makes the sometimes boring tasks of database maintenance and administration more endurable.
The decision to support the non-commercial use of your software with a lower price is absolutely worth mentioning. For that alone, I thank you. For everything else, I say keep up the good work".

Johnattan Badden, Manager:
"The software is easy to work with and most importantly, report management is extremely easy, even for a novice like me! I am able to create and edit my databases with a few clicks and easily maintain them afterwards. I highly recommend SQLite Maestro to educational institutions: it's easy and flexible, it is exactly what can be good for using in schools and colleges".

Ron D.:
"I'm still very happy with SQLite Maestro and Data Wizard; makes my HTPC database much easier to manage".

Jacob Lyohne, Director of Development:
"Regarding implementation, it is pretty self-explanatory and the SQLite Maestro manual is helpful for review and reference. We also found the on-line documentation useful and the software support staff readily available to answer our questions. Reports are very easy and quick to run and can be broken down into any number of statistical combinations".

Add your opinion

SQL Maestro Group / Products / SQLite / SQLite Maestro / Documentation

Download Buy

SQLite Maestro online Help

Return to chapter overview

Visual Query Builder

Visual Query Builder is provided for building queries visually. It allows you to create and edit queries without knowledge of SQL, prepare and execute queries, and view the results of the execution.

To open Visual Query Builder, select the Tools | Query Builder main menu item.

•	Working with diagram area

•	Joining two database objects by fields

•	Setting the selection criteria

•	Setting output fields for selection

•	Setting the grouping criteria

•	Setting parameters of sorting

•	Working with editor area

•	Executing query and viewing results

See also: SQL Editor

Return to chapter overview

New Year Sale!

SQL Maestro Group team wishes you a Happy New Year 2009!

We're glad to grant you a 20% discount for all our products and bundles till January 11!
The offer expires in day(s), so don't wait: act now and start the New Year with great savings on high-quality DBA tools!

Company news

Nov 12, 2008

SQLite Maestro 8.11 released

New version provides support for transparent database encryption, remote database management extensions and some interface improvements.

May 19, 2008

SQLite Maestro 8.5 released

Remote database management via HTTP tunneling, foreign keys support, column reordering and a lot of interface improvements.

Dec 10, 2007

SQLite Maestro 7.12 released

The main feature of this version is Database Designer, a tool to represent your database tables as ER diagrams.

More news

Feature of the day

Data Export

SQLite Maestro provides an ability to export your data to any of 14 available data formats.

Database Queries

SQLite Maestro: You can save frequently used queries to the database profile and use them as usual database objects.