explaingit

tracecast/open_data_apps

★ 12TypeScriptAudience · dataComplexity · 4/5Setup · hard

TLDR

Build interactive data dashboards by describing what you want in plain language, the AI writes a Marimo notebook against your Snowflake, BigQuery, Postgres, or CSV data and shows you a clean finished app.

Mindmap

mindmap
  root((Tracecast))
    Data Sources
      Snowflake
      BigQuery
      Postgres
      CSV files
    How It Works
      AI writes notebooks
      Marimo runtime
      DuckDB for CSV
    Output
      Clean dashboards
      Standalone apps
    Setup
      Docker
      API key
      Read-only DB user
Click or tap to explore — scroll the page freely

Code map

Detail Auto

An interactive map of this repo's files and how they connect — its source is parsed live in your browser. Click Visualize to build it.

filefunction / class

Things people build with this

USE CASE 1

Connect your Snowflake or BigQuery database and ask the AI in plain language to build a sales performance dashboard without writing any SQL or Python

USE CASE 2

Upload multiple CSV files and describe a joined analysis you want visualized, letting the AI query them together using DuckDB

USE CASE 3

Deploy a Marimo notebook as a standalone app for a team member who should see only the finished dashboard, not the underlying code

USE CASE 4

Set up a read-only database user and connect it to Tracecast so the AI can query your Postgres data without risk of modification

Tech stack

TypeScriptPythonMarimoDuckDBDockerPostgreSQL

Getting it running

Difficulty · hard Time to first run · 1h+

Requires Docker and an AI model API key, always connect data sources with a read-only database user to prevent AI-driven data modification.

No specific license terms were provided in the explanation beyond the project being open-source.

In plain English

Tracecast is an open-source tool that lets you build interactive data dashboards by chatting with an AI, similar to how coding assistants like Cursor work. You connect it to your data sources, describe what you want to see in plain language, and the AI writes a data visualization notebook for you, then shows you the finished result without ever exposing the underlying code or editing interface. The AI can connect to several types of data sources: Snowflake, BigQuery, Postgres, Metabase, and CSV files. When you upload a CSV, the tool can query it using a technology called DuckDB, which means you can even join multiple CSV files together using standard SQL-style queries. Under the hood, the AI writes Marimo notebooks, which are Python-based notebooks that can be deployed as standalone apps. The tool deliberately hides the notebook editing interface from end users, so you always see a clean, finished dashboard rather than raw code. Running it requires Docker. After cloning the repository and setting up a few environment variables, including an encryption key for storing database credentials securely, you start several local services: a Postgres database, the Marimo notebook runtime, an AI agent server, and a web app. You then go to the settings page in the browser to add your preferred AI model and API key. The README is careful about security. Because the AI writes SQL queries against your database, it recommends always connecting with a read-only database user. This prevents a situation where a malicious instruction embedded in your data could convince the AI to delete or modify records. Credentials for all connected data sources are stored in an encrypted form and are never sent directly to the AI model. This is a local-first tool intended for a single user on a personal machine. It is not designed or hardened for shared or public-facing deployments.

Copy-paste prompts

Prompt 1
I have a Postgres database with a sales table. Using Tracecast, help me set up a read-only user and write the environment variables needed to connect it securely.
Prompt 2
I have uploaded two CSV files to Tracecast. Write a natural-language prompt I can give the AI to join them on a shared customer ID column and show monthly revenue by region as a bar chart.
Prompt 3
Using Tracecast with a BigQuery connection, walk me through what happens step by step when I ask the AI to build a dashboard, from my prompt to the finished Marimo app.
Prompt 4
Help me write the Docker Compose configuration for Tracecast, including the Postgres database, Marimo runtime, agent server, and web app, with all required environment variables.
Open on GitHub → Explain another repo

← tracecast on gitmyhub — every repo by this author, as a profile.

Verify against the repo before relying on details.