Acesso Skype sqlite MacOS

sqlite3 "/Users/{#os_user}/Library/Application Support/Skype/{#skype_user}/main.db"

histórico de mensagens consulta sql

select conversations.id as "chat_id", 
conversations
.displayname as "chater",
messages
.from_dispname as "authoe",
strftime
('%d.%m.%Y %H:%M:%S',messages.timestamp, 'unixepoch', 'localtime') as "created_at",
messages
.body_xml as "message_body"
from conversations
inner
join messages on conversations.id = messages.convo_id
order
by messages.timestamp