Choose your database:

Partners

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".

Ephraim Stevens : "I just wanted to re-iterate what a wonderful job your developers have done and what a wonderful product SQLite Maestro is. There are so many great things to say about it that I won't go into here. It saves an end user a lot of time on repetitive tasks. Keep up the excellent work over there".

Add your opinion

Customers

Become a customer

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

Download

Buy

SQLite Maestro online Help

Return to chapter overview

To manage an existing database with SQLite Maestro, you have to create the according database profile first. A profile stores database connection settings, and some additional options to customize the way the software works with the database. After the creation database profiles appear as nodes in the Explorer tree on the left (profile properties can be later changed with Database Profile Editor).

When the profile is created you can connect to the database. To do so, select the database in the Explorer tree, or either select the Database | Connect to Database main menu item or use the Connect to Database item of the popup menu. You can also double click the database node in the explorer tree. If connection succeeds, the database node expands displaying the tree of database objects (tables, views, procedures, etc). The database becomes ready for your activities.

How can I disconnect from a database?

In order to disconnect from a database you should first select the database in the explorer tree, then either

•	select the Database \| Disconnect from Database main menu item

•	use the Disconnect from Database item of the popup menu.

See also: Connection parameters

Return to chapter overview

SQL Maestro Group wishes you a happy Thanksgiving!

We are pleased to grant you a 20% discount for all our products and bundles till the end of November!

Company news

May 5, 2021

SQLite Maestro 21.5 released

New version introduces new database encryption algorithms, support for generated columns, support for renaming and dropping columns using ALTER TABLE statement, and some other enhancements.

Nov 14, 2016

SQLite Maestro 16.11 released

New version introduces support for FTS5 extension and expression-based indexes, new encryption algorithms in data grids, updated data export and data import tools, and some other useful things.

Jan 12, 2015

SQLite Maestro 15.1 released

New version comes with support of user authentication and management, read-only database connections, colored tabs, and some other new features.

More news

Feature of the day

Code Folding

All editors of SQLite Maestro provide a customizable ability to divide text into logical parts (regions). Each part can be collapsed and extended.

Object Duplicating

You can make a copy of a database object by dragging it from one database to another in SQLite Maestro.

SQLite Maestro online Help

Connect to a database

Thanksgiving Sale