Table: mastodon_my_follower - Query Mastodon Followers using SQL

Mastodon is a decentralized, open-source social network. It allows users to publish anything they want: links, pictures, text, video. Mastodon is ad-free and does not use algorithms to decide what users see and don't see.

Table Usage Guide

The mastodon_my_follower table provides insights into the followers of a Mastodon user. As a social media manager, explore follower-specific details through this table, including follower IDs, usernames, and associated metadata. Utilize it to uncover information about followers, such as their display names, statuses, and the verification of follower profiles.

Examples

List followers

Explore which users are following you on Mastodon, including their usernames and display names, and gain insights into their social activity such as the number of users they follow and the number of statuses they have posted. This can help you understand your follower demographics and their engagement levels.

select
  acct,
  username,
  display_name,
  followers_count,
  following_count,
  statuses_count
from
  mastodon_my_follower;

select
  acct,
  username,
  display_name,
  followers_count,
  following_count,
  statuses_count
from
  mastodon_my_follower;

Count my followers by the servers they belong to

Determine the distribution of your followers across different servers, enabling you to understand where your audience is primarily located. This can be particularly useful for tailoring your content or outreach strategy based on server-specific audience size.

select
  server,
  count(*)
from
  mastodon_my_follower
group by
  server
order by
  count desc;

select
  server,
  count(*)
from
  mastodon_my_follower
group by
  server
order by
  count(*) desc;

Schema for mastodon_my_follower

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The account ID.
acct	text		username@server for the account.
created_at	timestamp with time zone		Timestamp when the account was created.
display_name	text		Display name for the account.
followers_count	bigint		Number of followers for the account.
following_count	bigint		Number of accounts this account follows.
id	text		ID of the account.
instance_qualified_account_url	text		Account URL prefixed with my instance.
note	text		Description of the account.
server	text		Server for the account.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
statuses_count	bigint		Toots from this account.
url	text		URL for the account.
username	text		Username for the account.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- mastodon

You can pass the configuration to the command with the --config argument:

steampipe_export_mastodon --config '<your_config>' mastodon_my_follower