Apple mail database location

The location of the Apple Mail database varies depending on the version of macOS and the type of account you're using. Here are some common locations:

macOS High Sierra (10.13) and later:

• For IMAP accounts: ~/Library/Mail/V2/MailData
• For POP accounts: ~/Library/Mail/V2/MailData
• For Exchange accounts: ~/Library/Mail/V2/Exchange

macOS Sierra (10.12) and earlier:

• For IMAP accounts: ~/Library/Mail/Envelope Index
• For POP accounts: ~/Library/Mail/Envelope Index
• For Exchange accounts: ~/Library/Mail/Exchange

Note: The ~/ symbol represents your user directory, which is usually Users/YourUsername.

The Mail database is a SQLite database file called Mail.db or Envelope Index.db, depending on the version of macOS and the type of account. You can use a SQLite viewer or editor to inspect the database, but be careful not to modify it, as this could cause issues with your email client.

If you're looking to backup or migrate your Apple Mail data, you can use the built-in "Export" feature in Apple Mail or third-party tools like Mail Export or Migrator.