Welcome to SQLite Tools for RootsMagic!

This site is intended to enhance our use of RootsMagic 4 and above with queries and reports not provided from within the program. RootsMagic 4 through 7 use SQLite 3 as their database engine so the .rmgc database files each creates are readable using third party SQLite management and development tools.

We explore collaboratively the RootsMagic 4+ databases with some of these SQLite managers and develop SQL queries that attempt to answer questions that cannot be answered or are difficult to answer using the RM application. Become a Member with full privileges to create and edit pages, discuss them, upload files, and help make our wiki better!

The site has features, such as file storage, essential to such development and not available from the RootsMagic Forums. All other RootsMagic topics should continue there.


  1. The content on this site is not sanctioned by RootsMagic Inc. nor will it provide any support for usage of it.
  2. The content is provided as-is; USE AT YOUR OWN RISK.
  3. Take safety measures when operating on your RootsMagic database with any tool that can modify data. Make a safe copy or backup first.