How MTDify stores your data

Last updated: November 2025

Understanding Your MTDify Database (db.sqlite3)

MTDify uses a small, lightweight SQLite database stored directly on your own Windows computer. This keeps everything simple, private, and fully under your control.

A brand-new database file is created automatically the first time you open the application.
You do not run any setup commands — MTDify handles everything behind the scenes.

Where Your Database Is Stored

Inside your MTDify folder, you will see a file named:

db.sqlite3

This single file contains all your bookkeeping data, including:

income
expenses
categories
supplier details
dashboard totals
user accounts
settings

Because everything lives in one file, it is extremely easy to back up, move, or restore.

Do Not Delete db.sqlite3 Unless You Intend to Reset Your App

Removing this file will delete all your bookkeeping data.

If you delete db.sqlite3:

MTDify will create a brand-new empty database the next time you open the EXE
All your income, expenses, categories, and receipts (Local Edition) will be gone
This is useful only when you want a complete reset

If you deleted it accidentally:

Restore one of your backups
Or allow MTDify to create a fresh empty one (this resets everything)

The Database Stays on Your Device Only

MTDify is a local-first application. Your data:

is never uploaded
is never synced
is never sent to MTDify
remains private on your own computer

You have complete control over your records and privacy.

How to Back Up Your Database

Because the database is just one file, you can back it up manually by copying:

db.sqlite3

to any safe location, including:

a USB stick
an encrypted folder
cloud backup (optional)
an external hard drive

This keeps your bookkeeping data protected even if your computer fails.

Updating MTDify Will Not Overwrite Your Database

When a new version of MTDify is released:

you download it
extract it into a new folder
copy your existing db.sqlite3 into the new folder

Your data will instantly appear in the updated version.

The db.sqlite3 file is never replaced automatically — it stays exactly as it is unless you change it.

If You Get Locked Out

Since your login details live inside the database file, you can reset your password locally.

If you forget your password, follow the instructions in the Password Reset documentation.

(Starter and Local Edition both include a default login you can use to regain access.)

Summary

MTDify stores everything in one file: db.sqlite3
It is created automatically the first time you open the app
It is fully private and lives only on your device
You can back it up manually at any time by copying the file
Updating MTDify does not affect your data
Deleting the file resets the app completely