Where SMS are physically stored in Android: path to the database and extraction methods

3. Extracting SMS with root access: full access

If your device has rights root, the process of extracting SMS is simplified. You can directly copy the database file or run SQL queries against it.

To copy the database file, do:

adb shell
su
cp /data/user_de/0/com.android.providers.telephony/databases/telephony.db /sdcard/
exit
exit
adb pull /sdcard/telephony.db

Now the file telephony.db is on your PC. Open it using DB Browser for SQLite or any other app for working with SQLite. To view all messages, run the request:

SELECT address, body, date, type FROM sms ORDER BY date DESC;

If you only need messages from a specific number, use:

SELECT * FROM sms WHERE address LIKE '%79123456789%';

With root-access you can also:

• 🔄 Recover deleted SMS (if they have not yet been overwritten).
• 📊 Export data to .csv for analysis.
• 🔧 Modify the database (for example, delete spam en masse).

To automate the process, you can use scripts on Python with the library sqlite3. Example script for exporting SMS to .csv:

import sqlite3
import csv

conn = sqlite3.connect('telephony.db')
cursor = conn.cursor()
cursor.execute("SELECT address, body, datetime(date/1000, 'unixepoch'), type FROM sms")
with open('sms_export.csv', 'w', newline='') as f:
writer = csv.writer(f)
writer.writerow(['Number', 'Message', 'Date', 'Type'])
writer.writerows(cursor.fetchall())
conn.close()

4. Features of SMS storage on devices from different manufacturers

Not all manufacturers adhere to the standard SMS storage scheme. Some brands modify Android so that the path to the database or its structure is different. Let's consider the key features:

On devices with MIUI (for example, Redmi or POCO) the path to the database may look like this:

/data/user/0/com.android.providers.telephony/databases/telephony.db

If you are working with the device Samsung, please note that some models use Knox a security system that can block access to system files even with rootrights. In such cases, the only reliable way is to use official backup tools.

5. Recovering deleted SMS: is it possible?

If messages have been deleted, their recovery depends on several factors:

• ⏳ Time: The sooner you start recovery, the higher the chances. New data may overwrite deleted SMS.
• 🔄 Backups copies: If automatic backup is enabled (for example, via Google Drive or Samsung Cloud), messages can be restored from there.
• 🛠️ Root access: Without it, the chances are minimal.

C root-with rights, you can try the following methods:

1. 🔍 Use SQLite editor to search for "ghost" records in the database (sometimes the data remains, but is marked as deleted).
2. 💾 Scan the device memory using DiskDigger or GT Recovery (does not work on all devices).
3. 📱 Restore a backup copy telephony.db from an old backup (if there is one).

Without root the only reliable way is to check cloud backups. For example, if you used SMS Backup & Restore, check the export folder on Google Drive or in local storage.

Important: recovery of deleted SMS on modern devices with encryption (for example Samsung Knox or File-Based Encryption v Android 11+) is almost impossible without specialized equipment. In such cases, it is better to contact professionals in the field of digital forensics.

6. Legal and ethical aspects of working with SMS

Access to SMS messages is not only a technical, but also a legal issue. In most countries, viewing other people's messages without consent is considered a violation of the law on confidentiality of correspondence.

What you need to know:

• 📜 Personal information: SMS may contain confidential information (passwords, bank data, personal correspondence). Their distribution without the owner’s consent is punishable by law. data-i="205">Personal data
• ⚖️ Forensic Investigation: If SMS are needed for court, their extraction must be carried out by certified specialists in compliance with the chain of evidence.
• 🔒 Corporate devices: On work phones, access to SMS may be regulated by company policy (for example, through MDM solutions).

If you are developing an application that works with SMS, required:

• 📋 Specify permission AndroidManifest.xml permission android.permission.READ_SMS.
• 🔐 Request explicit consent from the user to access messages.
• 🚫 Do not store SMS on your servers without encryption and consent user.

If you are retrieving SMS for personal use (for example, to save important correspondence), make sure that:

• 📱 The device belongs to you or you have the permission of the owner.
• 🔄 The data will not be used for surveillance or blackmail.
• 🗑️ After extraction, you will delete temporary copies of the database.

7. Alternative ways to store SMS: clouds and instant messengers

Many users do not know that their SMS can be automatically synchronized with cloud services. This simplifies backup, but creates privacy risks.

Where else can your SMS be stored:

• ☁️ Google Messages: If you use the standard application Messages from Google, correspondence can be synchronized with messages.google.com. Available only for devices with Android 8+.
• ☁️ Samsung Cloud: On devices Samsung SMS backups are created automatically (if synchronization is enabled).
• ☁️ iCloud (for those switching from iPhone): When transferring data from iPhone to Android via Move to iOS SMS can be temporarily stored in iCloud.
• 📱 Third-party messengers: Applications like WhatsApp or Telegram do not store SMS, but may contain copies of them if you forwarded messages to chats.

To check if your SMS are synchronized with Google:

1. Open messages.google.com in the browser.
2. Log in under the same account Googleas on the phone.
3. If the correspondence is displayed, synchronization is enabled.

To disable SMS synchronization in Google Messages:

1. Open the application Messages.
2. Go to Settings → Backup and reset.
3. Disable the option Message backup.

FAQ: Frequently asked questions about storing SMS in Android