Semantic and geographic atlas of DuckDB release codenames. No ducks were harmed. Some vectors migrated.

Duckmaxxing

I used a series of prompts on Codex with MotherDuck MCP from synthetic data generation to Dive creation. Find the final repo at https://github.com/na399/Divemaxxing

Duckmaxxing: Tracing How Wild Ducks Turn Into Digital Ducks on DuckDB 

Max Natthawut Adulyanukosol

Watch the DuckDB ecosystem emerge from a single repository into an entire galaxy. Play Evolution and watch the universe build itself from 2018 to 2026.

Duckverse: The Evolution of DuckDB

Rishabh Sethi

Explore the most pawpular dog names across NYC's five boroughs from 2015-2024. Interactive filters let you discover naming trends by borough and gender, plus see Luna's meteoric rise to fame!

🐾 NYC's Top Dog Names 🐾

Blossom Coryat

Five-tab interactive XCEL gymnastics Dive: physics of a perfect 10.0, personal score simulator that the gymnast can input their scores in for analysis, judge's deduction frequency playbook, season meet tracker with trend charts, and a Bronze-to-Sapphire level progression roadmap.

XCEL Perfect 10 — Score Physics & Simulator

Can I build the physics of a perfect 10.0 score in xcel girls gymnastics. I would like to see across all 4 events - bars, beam, floor, and vault. It should be interactive on a second tab for me to input different variables that impact the score (ideally that I as the gymnast could control) to see what my score could be to try to get to that perfect 10.

Add these: Tab 4 — "Where Am I Losing the Most?" Goal Tracker Let you save scores from multiple meets over a season, then chart your improvement event-by-event over time. Uses MotherDuck persistent storage.
Tab 5 — Level Comparison Show how the Special Requirements and Value Part requirements escalate from Bronze → Silver → Gold → Platinum → Diamond → Sapphire side by side. Great for planning which level to move to next.
FIG/NCAA Gymnastics Deduction Frequency DataSome coaching databases publish which deductions get called most often by event. A "most common judge's calls" ranking would be eye-opening — spoiler: bent knees and steps are called far more than falls.

alexandra.tomei@bluesprigpediatrics.com


import { useState } from "react";
import { useSQLQuery } from "@motherduck/react-sql-query";
import { BarChart, Bar, LineChart, Line, XAxis, YAxis, CartesianGrid, Tooltip, ResponsiveContainer } from "recharts";
import { Loader2 } from "lucide-react";


export const REQUIRED_DATABASES = [
  { type: 'share', path: 'md:_share/sample_data/23b0d623-1361-421d-ae77-62d701d471e6', alias: 'sample_data' }
];
const N = (v: unknown): number => (v != null ? Number(v) : 0);
const BLUE = "#0777b3";
const RED = "#bd4e35";
const GREEN = "#2d7a00";

export default function TaxiOpsDashboard() {
  const [selectedDay, setSelectedDay] = useState<string | null>(null);

  const kpis = useSQLQuery(`
    SELECT
      count(*) as total_trips,
      round(sum(total_amount), 0) as total_revenue,
      round(avg(trip_distance), 1) as avg_distance_mi,
      round(avg(total_amount), 2) as avg_fare
    FROM "sample_data"."nyc"."taxi"
    WHERE tpep_pickup_datetime >= '2022-11-01' AND tpep_pickup_datetime < '2022-12-01'
      AND total_amount > 0 AND trip_distance > 0
  `);

  const daily = useSQLQuery(`
    SELECT
      strftime(d, '%Y-%m-%d') as day,
      strftime(d, '%b %d') as day_label,
      COALESCE(count(t.tpep_pickup_datetime), 0) as trips,
      COALESCE(round(sum(t.total_amount), 0), 0) as revenue
    FROM generate_series(DATE '2022-11-01', DATE '2022-11-30', INTERVAL 1 DAY) AS s(d)
    LEFT JOIN "sample_data"."nyc"."taxi" t
      ON date_trunc('day', t.tpep_pickup_datetime) = s.d
      AND t.total_amount > 0 AND t.trip_distance > 0
    GROUP BY 1, 2 ORDER BY 1
  `);

  const hourly = useSQLQuery(`
    SELECT
      extract(hour FROM tpep_pickup_datetime) as hour,
      count(*) as trips
    FROM "sample_data"."nyc"."taxi"
    WHERE tpep_pickup_datetime >= '2022-11-01' AND tpep_pickup_datetime < '2022-12-01'
      AND total_amount > 0 AND trip_distance > 0
      ${selectedDay ? `AND strftime(tpep_pickup_datetime, '%Y-%m-%d') = '${selectedDay}'` : ""}
    GROUP BY 1 ORDER BY 1
  `);

  const topZones = useSQLQuery(`
    SELECT
      PULocationID as zone_id,
      count(*) as trips,
      round(avg(total_amount), 2) as avg_fare,
      round(avg(tip_amount / NULLIF(total_amount, 0) * 100), 1) as tip_pct
    FROM "sample_data"."nyc"."taxi"
    WHERE tpep_pickup_datetime >= '2022-11-01' AND tpep_pickup_datetime < '2022-12-01'
      AND total_amount > 0 AND trip_distance > 0
      ${selectedDay ? `AND strftime(tpep_pickup_datetime, '%Y-%m-%d') = '${selectedDay}'` : ""}
    GROUP BY 1 ORDER BY trips DESC LIMIT 8
  `);

  const kpiRows = Array.isArray(kpis.data) ? kpis.data : [];
  const dailyData = (Array.isArray(daily.data) ? daily.data : []).map(r => ({
    day: r.day as string,
    dayLabel: r.day_label as string,
    trips: N(r.trips),
    revenue: N(r.revenue),
  }));
  const hourlyData = (Array.isArray(hourly.data) ? hourly.data : []).map(r => ({
    hour: `${N(r.hour)}:00`,
    trips: N(r.trips),
  }));
  const zoneRows = (Array.isArray(topZones.data) ? topZones.data : []);

  return (
    <div className="p-6 space-y-6" style={{background:"#f8f8f8"}}>
      <div>
        <h1 className="text-2xl font-semibold" style={{color:"#231f20"}}>NYC Taxi Operations</h1>
        <p className="text-sm" style={{color:"#6a6a6a"}}>
          November 2022 {selectedDay ? `\u2014 ${selectedDay}` : ""}
          {selectedDay && (
            <button onClick={() => setSelectedDay(null)} className="ml-2 underline" style={{color:BLUE}}>
              clear filter
            </button>
          )}
        </p>
      </div>

      {/* KPIs */}
      <div className="grid grid-cols-4 gap-8">
        {[
          { label: "Total Trips", val: kpiRows[0]?.total_trips, fmt: (v: number) => v.toLocaleString() },
          { label: "Revenue", val: kpiRows[0]?.total_revenue, fmt: (v: number) => `$${(v / 1e6).toFixed(1)}M` },
          { label: "Avg Distance", val: kpiRows[0]?.avg_distance_mi, fmt: (v: number) => `${v} mi` },
          { label: "Avg Fare", val: kpiRows[0]?.avg_fare, fmt: (v: number) => `$${v.toFixed(2)}` },
        ].map(({ label, val, fmt }) => (
          <div key={label}>
            {kpis.isLoading ? (
              <div className="h-12 w-24 bg-gray-200 animate-pulse rounded" />
            ) : (
              <p className="text-4xl font-bold" style={{color:"#231f20"}}>{fmt(N(val))}</p>
            )}
            <p className="text-sm mt-1" style={{color:"#6a6a6a"}}>{label}</p>
          </div>
        ))}
      </div>

      {/* Daily trips — click a bar to filter */}
      <div>
        <h2 className="text-lg font-semibold mb-2" style={{color:"#231f20"}}>Daily Trip Volume</h2>
        <p className="text-xs mb-2" style={{color:"#6a6a6a"}}>Click a bar to filter hourly demand and top zones</p>
        {daily.isLoading ? (
          <div className="bg-gray-100 animate-pulse rounded" style={{height:200}} />
        ) : (
          <ResponsiveContainer width="100%" height={200}>
            <BarChart data={dailyData} onClick={(e) => { if (e?.activePayload?.[0]) setSelectedDay(e.activePayload[0].payload.day); }}>
              <CartesianGrid strokeDasharray="3 3" stroke="#eee" />
              <XAxis dataKey="dayLabel" fontSize={10} interval={2} />
              <YAxis tickFormatter={(v) => `${(v / 1000).toFixed(0)}K`} fontSize={10} />
              <Tooltip formatter={(v: number) => v.toLocaleString()} labelFormatter={(l) => `${l}`} />
              <Bar dataKey="trips" fill={BLUE} cursor="pointer" />
            </BarChart>
          </ResponsiveContainer>
        )}
      </div>

      {/* Bottom row: hourly demand + top zones */}
      <div className="grid grid-cols-2 gap-6">
        <div>
          <h2 className="text-lg font-semibold mb-2" style={{color:"#231f20"}}>Hourly Demand</h2>
          {hourly.isLoading ? (
            <div className="bg-gray-100 animate-pulse rounded" style={{height:200}} />
          ) : (
            <ResponsiveContainer width="100%" height={200}>
              <LineChart data={hourlyData}>
                <CartesianGrid strokeDasharray="3 3" stroke="#eee" />
                <XAxis dataKey="hour" fontSize={10} interval={3} />
                <YAxis tickFormatter={(v) => `${(v / 1000).toFixed(0)}K`} fontSize={10} />
                <Tooltip formatter={(v: number) => v.toLocaleString()} />
                <Line type="linear" dataKey="trips" stroke={RED} strokeWidth={2} dot={false} />
              </LineChart>
            </ResponsiveContainer>
          )}
        </div>

        <div>
          <h2 className="text-lg font-semibold mb-2" style={{color:"#231f20"}}>Top Pickup Zones</h2>
          {topZones.isLoading ? (
            <div className="animate-pulse space-y-2">
              {[...Array(5)].map((_, i) => <div key={i} className="h-4 bg-gray-200 rounded w-3/4" />)}
            </div>
          ) : (
            <table className="w-full text-sm" style={{color:"#231f20"}}>
              <thead>
                <tr style={{borderBottom:"1px solid #ddd"}}>
                  <th className="text-left py-1 font-semibold">Zone</th>
                  <th className="text-right py-1 font-semibold">Trips</th>
                  <th className="text-right py-1 font-semibold">Avg Fare</th>
                  <th className="text-right py-1 font-semibold">Tip %</th>
                </tr>
              </thead>
              <tbody>
                {zoneRows.map((r, i) => (
                  <tr key={i} style={{borderBottom:"1px solid #f0f0f0"}}>
                    <td className="py-1">Zone {N(r.zone_id)}</td>
                    <td className="text-right py-1">{N(r.trips).toLocaleString()}</td>
                    <td className="text-right py-1">${N(r.avg_fare).toFixed(2)}</td>
                    <td className="text-right py-1" style={{color: N(r.tip_pct) > 15 ? GREEN : "#231f20"}}>{N(r.tip_pct)}%</td>
                  </tr>
                ))}
              </tbody>
            </table>
          )}
        </div>
      </div>
    </div>
  );
}


Daily operations dashboard for NYC taxi fleet management — KPIs, daily trip volume, hourly demand patterns, and top pickup zones.

NYC Taxi Operations Dashboard

create a dive in my motherduck account based on taxi data in sample_data repo. show a dashboard that a logistics company might want to use to manage day-to-day taxi operations.

Ryan Boyd

Filter 4 million rows of data by zooming or panning around a map! This uses Dual Execution for super fast crossfiltering using in-browser local compute. Moving the map crossfilters the top 5 location types and complaint types.

Interactive Map Filtering

Alex Monahan

The 2026 FIFA World Cup, decided entirely by national duck stocks. It uses the real 48-team format, live match results, full Annex C third-place bracket logic, and deterministic bird tiebreaks: ducks in regulation, geese in extra time, chickens on penalties. The joke is ducks. The machinery is real DuckDB.

The Duck World Cup 🦆

Tim Finkel

Qlik Sense–style P&L with an Excel-like grid: associative filter panes, entity sheet tabs, formula bar, outline levels, 3-tier drill (section › group › GL) down to journal-entry transactions, row-specific calculations (Gross Profit Margin %, Net Income from Operations, FFO, Interest Coverage), Actual/Budget/Variance, a print-ready bank statement layout, and Excel export. Synthetic data generated in SQL.

Real Estate Development P&L – Bank-Ready Statement

can you build me a dive in motherduck that mimics Qlik Sense's dashboarding style that almost looks like an excel sheet? use  dummy P&L data shaped like a real estate developer if you need to

bo@motherduck.com


import { useState } from "react";
import { BarChart, Bar, LineChart, Line, XAxis, YAxis, CartesianGrid, Tooltip, ResponsiveContainer } from "recharts";
import { useSQLQuery } from "@motherduck/react-sql-query";


export const REQUIRED_DATABASES = [
  { type: 'share', path: 'md:_share/sample_data/23b0d623-1361-421d-ae77-62d701d471e6', alias: 'sample_data' }
];
const N = (v) => (v != null ? Number(v) : 0);

export default function NYC311Dashboard() {
  const totalQuery = useSQLQuery(`SELECT COUNT(*) as total, COUNT(DISTINCT complaint_type) as types FROM "sample_data"."nyc"."service_requests"`);
  const trendQuery = useSQLQuery(`SELECT strftime(date_trunc('month', created_date), '%Y-%m') as month, COUNT(*) as complaints FROM "sample_data"."nyc"."service_requests" WHERE created_date >= '2020-01-01' AND created_date < '2023-01-01' GROUP BY 1 ORDER BY 1`);
  const boroughQuery = useSQLQuery(`SELECT borough, COUNT(*) as cnt FROM "sample_data"."nyc"."service_requests" WHERE borough IS NOT NULL AND borough != 'Unspecified' GROUP BY 1 ORDER BY 2 DESC`);
  const complaintsQuery = useSQLQuery(`SELECT complaint_type, COUNT(*) as cnt FROM "sample_data"."nyc"."service_requests" GROUP BY 1 ORDER BY 2 DESC LIMIT 8`);

  const totalRows = Array.isArray(totalQuery.data) ? totalQuery.data : [];
  const trendRows = Array.isArray(trendQuery.data) ? trendQuery.data : [];
  const boroughRows = Array.isArray(boroughQuery.data) ? boroughQuery.data : [];
  const complaintRows = Array.isArray(complaintsQuery.data) ? complaintsQuery.data : [];

  const chartTrend = trendRows.map(r => ({ month: r.month, complaints: N(r.complaints) }));
  const chartComplaints = complaintRows.map(r => ({
    name: String(r.complaint_type).length > 18 ? String(r.complaint_type).slice(0, 18) + "…" : String(r.complaint_type),
    count: N(r.cnt),
  }));

  return (
    <div className="p-6" style={{ background: "#f8f8f8", margin: "0 auto" }}>
      <h1 className="text-2xl font-semibold mt-2" style={{ color: "#231f20" }}>NYC 311 Service Requests</h1>
      <p className="text-sm mb-6" style={{ color: "#6a6a6a" }}>32.5M complaints from 2010–2023</p>

      {/* KPIs */}
      <div className="grid grid-cols-3 gap-8 mb-8">
        <div>
          {totalQuery.isLoading ? (
            <div className="h-12 w-24 bg-gray-200 animate-pulse rounded" />
          ) : (
            <p className="text-5xl font-bold" style={{ color: "#231f20" }}>{(N(totalRows[0]?.total) / 1e6).toFixed(1)}M</p>
          )}
          <p className="text-sm mt-2" style={{ color: "#6a6a6a" }}>Total Requests</p>
        </div>
        <div>
          {totalQuery.isLoading ? (
            <div className="h-12 w-24 bg-gray-200 animate-pulse rounded" />
          ) : (
            <p className="text-5xl font-bold" style={{ color: "#231f20" }}>{N(totalRows[0]?.types)}</p>
          )}
          <p className="text-sm mt-2" style={{ color: "#6a6a6a" }}>Complaint Types</p>
        </div>
        <div>
          <p className="text-5xl font-bold" style={{ color: "#231f20" }}>5</p>
          <p className="text-sm mt-2" style={{ color: "#6a6a6a" }}>Boroughs</p>
        </div>
      </div>

      {/* Monthly trend */}
      <p className="text-sm font-semibold mb-2" style={{ color: "#231f20" }}>Monthly Complaints (2020–2022)</p>
      {trendQuery.isLoading ? (
        <div className="bg-gray-100 animate-pulse rounded" style={{ height: 200 }} />
      ) : (
        <ResponsiveContainer width="100%" height={200}>
          <LineChart data={chartTrend}>
            <CartesianGrid strokeDasharray="3 3" stroke="#eee" />
            <XAxis dataKey="month" fontSize={10} interval={5} />
            <YAxis tickFormatter={(v) => `${(v / 1000).toFixed(0)}K`} fontSize={10} />
            <Tooltip formatter={(v) => v.toLocaleString()} />
            <Line type="linear" dataKey="complaints" stroke="#0777b3" strokeWidth={2} dot={false} />
          </LineChart>
        </ResponsiveContainer>
      )}

      {/* Borough + Top Complaints side by side */}
      <div className="grid grid-cols-2 gap-6 mt-6">
        <div>
          <p className="text-sm font-semibold mb-2" style={{ color: "#231f20" }}>By Borough</p>
          {boroughQuery.isLoading ? (
            <div className="animate-pulse space-y-2">
              <div className="h-4 bg-gray-200 rounded w-3/4" />
              <div className="h-4 bg-gray-200 rounded w-1/2" />
              <div className="h-4 bg-gray-200 rounded w-2/3" />
            </div>
          ) : (
            <table className="w-full text-sm">
              <tbody>
                {boroughRows.map((r) => (
                  <tr key={r.borough} style={{ borderBottom: "1px solid #eee" }}>
                    <td className="py-1" style={{ color: "#231f20" }}>{r.borough}</td>
                    <td className="py-1 text-right font-medium" style={{ color: "#231f20" }}>{(N(r.cnt) / 1e6).toFixed(1)}M</td>
                  </tr>
                ))}
              </tbody>
            </table>
          )}
        </div>
        <div>
          <p className="text-sm font-semibold mb-2" style={{ color: "#231f20" }}>Top Complaints</p>
          {complaintsQuery.isLoading ? (
            <div className="bg-gray-100 animate-pulse rounded" style={{ height: 180 }} />
          ) : (
            <ResponsiveContainer width="100%" height={180}>
              <BarChart data={chartComplaints} layout="vertical" margin={{ left: 80 }}>
                <XAxis type="number" tickFormatter={(v) => `${(v / 1e6).toFixed(0)}M`} fontSize={10} />
                <YAxis type="category" dataKey="name" fontSize={10} width={80} />
                <Tooltip formatter={(v) => v.toLocaleString()} />
                <Bar dataKey="count" fill="#0777b3" radius={[0, 2, 2, 0]} />
              </BarChart>
            </ResponsiveContainer>
          )}
        </div>
      </div>
    </div>
  );
}


Dashboard of 32.5M NYC 311 complaints (2010–2023) showing monthly trends, borough breakdown, and top complaint types.

Dive Gallery

Duckmaxxing: Tracing How Wild Ducks Turn Into Digital Ducks on DuckDB

Duckverse: The Evolution of DuckDB

🐾 NYC's Top Dog Names 🐾

XCEL Perfect 10 — Score Physics & Simulator

NYC Taxi Operations Dashboard

Interactive Map Filtering

The Duck World Cup 🦆

Real Estate Development P&L – Bank-Ready Statement

NYC 311 Service Requests

Duckmaxxing: Tracing How Wild Ducks Turn Into Digital Ducks on DuckDB 