Database Tycoon¶
A local-first analytics CLI that adapts to your existing data stack.
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?¶
-
Install tycoon, scaffold a first project, and walk through ingestion → transformation → dashboards end-to-end.
-
Reference for every
tycoon ...command. Each page documents the flags, behavior, and worked examples. -
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.
-
The
tycoon.ymlschema, built-in templates, observability tables, and environment variables. -
Per-release narrative notes — what shipped, what didn't, and why.
-
Contributor notes on the renderer behind
tycoon city: thecity.jsonandruns.jsoncontracts, 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.