Subscribe to our news:
![](/i/subscribe-bottom.gif)
![](/i/arr-open.gif) Partners
![](/i/arr-open.gif) Testimonials
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".
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".
More
Add your opinion
![](/i/arr-open.gif) Customers
|
SQLite Maestro online Help
Shortcut keys
The following table describes the default shortcut keys in SQLite Maestro.
Interface
|
|
Window list
|
Alt+0
|
Previous Window
|
F6
|
Next Window
|
Ctrl+F6
|
Show Database Explorer
|
F11
|
Refresh
|
F5
|
Exit
|
Alt+F4
|
SQLite Maestro help
|
F1
|
Clipboard
|
|
Cut
|
Ctrl+X
|
Copy
|
Ctrl+C
|
Paste
|
Ctrl+V
|
Select all
|
Ctrl+A
|
Find
|
Ctrl+F
|
Replace
|
Ctrl+H
|
Search again
|
F3
|
Undo
|
Ctrl+Z
|
Redo
|
Shift+Ctrl+Z
|
SQL Editors
|
|
Open SQL Editor
|
Ctrl+E
|
Open SQL Script Editor
|
Ctrl+R
|
Open Visual Query Builder
|
Ctrl+Q
|
Execute query
|
(F9) or (F8)
|
Execute query as script
|
(Shift+F9) or (Shift+F8)
|
Execute selected only
|
(Alt+F9) or (Alt +F8)
|
Go to line
|
Ctrl+G
|
Format selected SQL
|
Ctrl+Alt+F
|
Create new query
|
Ctrl+N
|
Delete current query
|
Ctrl+Alt+D
|
Load script from file
|
Ctrl+O
|
Database management
|
|
Create a new database profile
|
Shift+Ctrl+P
|
Edit an existing database profile
|
Shift+Ctrl+E
|
Rename a database profile (object)
|
F2
|
Remove database profile
|
Shift+Ctrl+R
|
Connect to the database
|
Shift+Ctrl+C
|
Disconnect from the database
|
Shift+Ctrl+D
|
Create a database object
|
Shift+Ctrl+N
|
Object Browser
|
Shift+Ctrl+O
|
Open BLOB Viewer
|
Ctrl+B
|
|
![](/i/arr-open.gif) Company news ![](/i/rss.gif)
May 5, 2021
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
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
New version comes with support of user authentication and management, read-only database connections, colored tabs, and some other new features.
![](/i/arr-open.gif) Feature of the day
SQLite Maestro: You can save frequently used queries to the database profile and use them as usual database objects.
Two modes of viewing data are available in SQLite Maestro: as a grid and as info cards.
|
|