Bruin Academy

Guide

Chess Data to DuckDB

Build your first Bruin pipeline by ingesting chess API data and storing it in DuckDB - no credentials needed.

Build your first Bruin pipeline

Skip ahead

The whole project is one command. Run it, point your coding agent at the Bruin MCP, and it can configure and run everything itself.

$ bruin init chess

Three ways to go from here:

  • Self-service it. Let the agent configure and run the whole thing, and ask it questions as you go.
  • Follow this tutorial. Slower, and it explains why each setting matters - the part an agent will not guess for you.
  • Hand the tutorial to the agent. Point it at this page and have it work through the steps with you.

The template README is the short reference for everything it ships.

What

Build a complete data pipeline that pulls Chess.com game data from a public API and loads it into DuckDB for analysis. No API keys or database credentials are needed because the chess API is open and DuckDB runs locally.

How

Use bruin init chess to scaffold a project with pre-configured assets. Ingestr assets pull data from Chess.com, SQL assets transform it, and bruin run executes the pipeline end to end. You will finish by querying the DuckDB summary table.

Get help & contribute

Skip ahead

The whole project is one command. Run it, point your coding agent at the Bruin MCP, and it can configure and run everything itself.

$ bruin init chess

Three ways to go from here:

  • Self-service it. Let the agent configure and run the whole thing, and ask it questions as you go.
  • Follow this tutorial. Slower, and it explains why each setting matters - the part an agent will not guess for you.
  • Hand the tutorial to the agent. Point it at this page and have it work through the steps with you.

The template README is the short reference for everything it ships.

What

Build a complete data pipeline that pulls Chess.com game data from a public API and loads it into DuckDB for analysis. No API keys or database credentials are needed because the chess API is open and DuckDB runs locally.

How

Use bruin init chess to scaffold a project with pre-configured assets. Ingestr assets pull data from Chess.com, SQL assets transform it, and bruin run executes the pipeline end to end. You will finish by querying the DuckDB summary table.

Build your first Bruin pipeline

Sign up to our newsletter

Practical updates on open-source data pipelines, AI analysts, governance, and what we are shipping at Bruin.

The signup form is hosted by Brevo. Accept cookies to load it.