MTG Legendary Creature Evolution

Historical printing trends and set-by-set distribution analytics powered by DuckDB and Apache Superset.

This dashboard was created in September 2026 prior to the release of the Reality Fracture expansion set.

It was built to explore a simple question: "Driven by the rising popularity of the Commander format, how has the printing rate of Legendary Creatures evolved over time?"

What started as a single query turned into a broader exploration of MTG design shifts across decades of set releases. I hope you find the dataset insights as fascinating as I did!

Interactive Superset Analytics Board

Access the full analytical workspace directly on my homelab infrastructure via Cloudflare Tunnel. Filter by set releases, legendary creature power scales, and color identities in real time.

No need to log in. Just click on "Dashboards" on the top of the window and click on the "MTG Legendary Creatures Data Visualization" dashboard.

Architecture & Analytical Objective

This pipeline parses bulk JSONL records from Scryfall to evaluate card design shifts across decades of Magic: The Gathering releases.

Engineering Highlights

DuckDB Engine: High-speed columnar SQL parsing of raw card attributes.
Proxmox Hosting: Containerized Apache Superset stack hosted on local homelab hardware.
Cloudflare Tunnel: Secure Zero-Trust outbound routing eliminating open router ports.

Pipeline Stack

DatabaseDuckDB
BI PlatformApache Superset
TunnelingCloudflare Tunnel
Data IngestionScryfall JSONL