Where are SMS and MMS stored?
Solution 1:
SMS are stored in ~/.local/share/history-service/history.sqlite which you can edit with the sqlite3 tool. I would avoid manipulating this database directly though, as it is not documented whether manipulating this file directly will cause it to lose sync with state that might be stored elsewhere.