mastodon-to-sqlite

Save data from Mastodon to a SQLite database.

Install

foo@bar:~$ pip install mastodon-to-sqlite

Authentication

First you will need to create an application on your Mastodon server. You can find that on your Mastodon serer.

foo@bar:~$ mastodon-to-sqlite auth
Mastodon domain: mastodon.social

Create a new application here: https://mastodon.social/settings/applications/new
Then navigate to newly created application and paste in the following:

Your access token: xxx

This will write an auth.json file to your current directory containing your access token and Mastodon domain. Use -a other-file.json to save those credentials to a different location.

That -a option is supported by all other commands.

You can verify your authentication by running mastodon-to-sqlite verify-auth.

Retrieving Mastodon followers

The followers command will retrieve all the details about your Mastodon followers.

foo@bar:~$ mastodon-to-sqlite followers mastodon.db

Retrieving Mastodon followings

The followings command will retrieve all the details about your Mastodon followings.

foo@bar:~$ mastodon-to-sqlite followings mastodon.db

Retrieving Mastodon statuses

The statuses command will retrieve all the details about your Mastodon statuses.

foo@bar:~$ mastodon-to-sqlite statuses mastodon.db

Retrieving Mastodon bookmarks

The bookmarks command will retrieve all the details about your Mastodon bookmarks.

foo@bar:~$ mastodon-to-sqlite bookmarks mastodon.db

Retrieving Mastodon favourites

The favourites command will retrieve all the details about your Mastodon favourites.

foo@bar:~$ mastodon-to-sqlite favourites mastodon.db