AI, ML and LLMsSQLMotherDuck FeaturesTutorialBI & VisualizationEcosystem

The MCP Sessions Vol. 1: Sports Analytics

2026/01/13

TL;DR: Watch Claude analyze NFL playoff simulations and PGA Tour statistics in real-time using the MotherDuck MCP connector—demonstrating how natural language queries can replace complex SQL for sports analytics.

What is the MotherDuck MCP?

The MotherDuck MCP (Model Context Protocol) connector enables Claude to:

  • Query MotherDuck databases directly
  • Write and iterate on SQL automatically
  • Self-correct when queries fail
  • Generate visualizations from results

The connector is now on Anthropic's approved marketplace—add it to Claude Desktop in Settings → Capabilities.

Demo 1: NFL Playoff Analysis

Jacob runs Monte Carlo simulations for NFL seasons. The demo compares two database snapshots:

  • mds_box_copy: End of regular season
  • coffee_wc: After Wild Card weekend

Natural Language Prompting

The analyst simply describes what they want to analyze in plain English, and Claude automatically:

  1. Lists tables in both databases
  2. Identifies 6 new games added
  3. Calculates Super Bowl odds changes
  4. Attributes probability shifts to specific game outcomes

Key Findings

  • Seahawks dropped from 27% → 25% Super Bowl odds (bracket got harder as favorites won)
  • Texans gained odds after beating the Steelers
  • When a team loses, their Super Bowl odds "go back to the pool" for redistribution

SQL Self-Correction

When Claude writes incorrect SQL and gets an error, it automatically checks the schema, identifies the issue, and rewrites the query correctly.

Demo 2: PGA Tour Statistics

Logan analyzes golf statistics to find undervalued players and validate Scottie Scheffler's dominance.

Finding Correlations to Earnings

Asking "Which stat categories correlate most to money list rankings?" reveals that Shots Gained Tee-to-Green vastly outweighs Shots Gained Putting for predicting earnings.

Identifying Dark Horse Players

Asking "Who played well statistically in 2025 but underperformed on money list?" surfaces players like Pearson Cudi and Pureborn Olison:

  • Ranked 124th and 107th in earnings
  • But ranked 28th and 20th in Shots Gained
  • Watch list candidates for breakout seasons

Validating Historic Dominance

Comparing Scheffler's 2025 to the best seasons from 2017-2022 shows his season was statistically better than Rory's 2019 and Morikawa's 2021. Even accounting for the weaker field post-LIV, his gap to #2 was unprecedented.

Visualization with Invis

The demo uses a custom Claude skill called Invis for charting:

  • Generates HTML artifacts from markdown + JSON specs
  • Creates interactive dashboards
  • Supports iterative refinement ("make this chart taller")

Tips for MCP Analytics

  1. Hint at tools: Include "MotherDuck MCP" in prompts to guide Claude
  2. SQL is ideal for AI: Verbose but well-validated, with great error messages
  3. Iterate visually: Ask for different visualization styles (Tufte-inspired, etc.)
  4. Compare time periods: Load historical snapshots to validate trends

Related Videos

"The MCP Sessions - Vol 2: Supply Chain Analytics" video thumbnail

2026-01-21

The MCP Sessions - Vol 2: Supply Chain Analytics

Jacob and Alex from MotherDuck query data using the MotherDuck MCP. Watch as they analyze 180,000 rows of shipment data through conversational AI, uncovering late delivery patterns, profitability insights, and operational trends with no SQL required!

Stream

AI, ML and LLMs

MotherDuck Features

SQL

BI & Visualization

Tutorial

"Building a Serverless Lakehouse with DuckLake" video thumbnail

2025-12-26

Building a Serverless Lakehouse with DuckLake

In this hands-on workshop, Jacob Matson walks through building a serverless lakehouse from scratch using DuckLake.

Webinar

Tutorial

"Watch Me Deploy a DuckLake to Production with MotherDuck!" video thumbnail

2025-12-10

Watch Me Deploy a DuckLake to Production with MotherDuck!

In this video, Hoyt Emerson will show you the fastest way to get DuckLake into production using MotherDuck's beta implementation. If you've been following his DuckLake series, this is the next step you've been waiting for!

YouTube

Data Pipelines

Tutorial

MotherDuck Features

SQL

Ecosystem