DiscordRustScraper

---

Description

DiscordRustScraper is a powerful Discord data scraper built in Rust, designed to extract and format channel data for further analysis. It efficiently pulls message history from specified channels and outputs it in a clean JSON format for easy processing. Optional features include creating backups of messages and storing data in a SQL database for improved performance and organization.

Table of Contents

• About
• Commands & Usage
  • Scrape
  • Convert-to-json
  • sql
    • Schema

Disclaimer
DiscordRustScraper is an open-source tool for ethical use, provided "as is." Users must comply with Discord's terms and laws. Not affiliated with Discord.

---

Commands & Usage

Scrape

• Usage : cargo run -- scrape --bot_token <BOT_TOKEN> --channel_ids [CHANNEL_IDS]
• Example : cargo run -- scrape --bot_token "your_bot_token" --channel_ids 659069446438125570 806378740917469234

convert-to-json

• Usage: cargo run -- convert-to-json <INPUT_FILE>

• Example: cargo run -- convert-to-json on-topic.jsonl

• --personal is now removed due to Discord's Terms of Service. Using user account tokens for automation is against Discord policy and may lead to account bans.

sql (optional)

The SQL argument provides an optional feature that enables the use of a SQL database to store messages instead of the default storage method, by passing through a connection string. This is a more efficient way of storing data compared to JSONs.

• Usage : cargo run -- scrape --bot_token <BOT_TOKEN> --channel_ids [CHANNEL_IDS] --sql <CONNECTION_STRING>
• Example : cargo run -- scrape --bot_token "your_bot_token" --channel_ids 659069446438125570 806378740917469234 --sql mysql://username:password@127.0.0.1:3306/database

Schema

You'll have to create the database yourself so i've attached the schema below.

CREATETABLEmessages (
channel_id BIGINT UNSIGNED NOT NULL,
channel_name VARCHAR(100) NOT NULL DEFAULT '',
author_id BIGINT UNSIGNED NOT NULL,
author_name VARCHAR(64) NOT NULL DEFAULT '',
message_id BIGINT UNSIGNED NOT NULL,
message TEXTNOT NULL,
has_media BOOLEANNOT NULL,
timestampVARCHAR(64) NOT NULL DEFAULT '',
edited_timestamp VARCHAR(64) NULL,
reply_to_message_id BIGINT UNSIGNED NULL,
message_type TINYINT UNSIGNED NOT NULL DEFAULT 0,
pinned BOOLEANNOT NULL DEFAULT 0,
attachment_urls TEXTNULL,
embed_count INT UNSIGNED NOT NULL DEFAULT 0,
reactions TEXTNULL,
PRIMARY KEY (message_id)
);

To migrate an existing table:

ALTERTABLE messages
ADD COLUMN channel_name VARCHAR(100) NOT NULL DEFAULT '' AFTER channel_id,
ADD COLUMN author_name VARCHAR(64) NOT NULL DEFAULT '' AFTER author_id,
ADD COLUMN timestampVARCHAR(64) NOT NULL DEFAULT '' AFTER has_media,
ADD COLUMN edited_timestamp VARCHAR(64) NULL AFTER timestamp,
ADD COLUMN reply_to_message_id BIGINT UNSIGNED NULL AFTER edited_timestamp,
ADD COLUMN message_type TINYINT UNSIGNED NOT NULL DEFAULT 0 AFTER reply_to_message_id,
ADD COLUMN pinned BOOLEANNOT NULL DEFAULT 0 AFTER message_type,
ADD COLUMN attachment_urls TEXTNULL AFTER pinned,
ADD COLUMN embed_count INT UNSIGNED NOT NULL DEFAULT 0 AFTER attachment_urls,
ADD COLUMN reactions TEXTNULL AFTER embed_count;

Inspired by DiscordChatExporter.