Skype sqlite access MacOS

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

message history sql query

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

#sqlite

#macos

#skype