Skip to content

Database Tycoon

A local-first analytics CLI that adapts to your existing data stack.

pip install database-tycoon
tycoon init --template csv-import
tycoon data run-all

What is tycoon?

Tycoon is a single command-line tool that runs a local analytics pipeline — ingestion, transformation, and dashboards — across the tools you already use:

  • dlt for ingestion (REST APIs, files, SQL databases, your own dlt sources)
  • dbt for transformation (with first-class duckdb, MotherDuck, Snowflake, BigQuery, and Redshift support)
  • DuckDB for the warehouse (or MotherDuck, when you want it in the cloud)
  • Rill for dashboards

You write one tycoon.yml. Tycoon scaffolds, configures, and runs the rest.

Why local-first?

Every part of the stack runs on your laptop. You can demo, develop, or debug a full pipeline without an internet connection or a cloud account. When you're ready to push to a cloud warehouse, the same commands work — tycoon.yml just points somewhere else.

This isn't a "demo" or a "starter project" — it's a production tool that happens to be friendly to operate offline. Pipelines built with tycoon run identically on a laptop and on a cloud VM.

What's in this docs site?

  • Getting started


    Install tycoon, scaffold a first project, and walk through ingestion → transformation → dashboards end-to-end.

  • Commands


    Reference for every tycoon ... command. Each page documents the flags, behavior, and worked examples.

  • Recipes


    Worked end-to-end setups: a CSV to a live dashboard, MotherDuck with a local snapshot, and adopting tycoon alongside a dbt project you already have.

  • Reference


    The tycoon.yml schema, built-in templates, observability tables, and environment variables.

  • Releases


    Per-release narrative notes — what shipped, what didn't, and why.

  • City renderer notes on GitHub


    Contributor notes on the renderer behind tycoon city: the city.json and runs.json contracts, and the road grammar.

A note on this site

These docs track the current release of tycoon; the releases/ section carries the canonical change history, one page per version. Anything described as deferred or planned links to a tracking issue on the GitHub repo. The roadmap says what is in the current cycle, what comes next, and what is on the wish list.

The site is built with MkDocs Material; the source markdown lives in docs/ of the tycoon-cli repo.