Building a Full BI System with Claude Code and Metabase for Under $50/month
A developer on r/ClaudeAI shared a detailed walkthrough of building a complete business intelligence system using Claude Code (Opus 4.7) instead of hiring BI consultants. After receiving quotes of $15,000 for analytics dashboards, they built the entire system themselves in 3 days for ~$30/month on Google Cloud Platform.
Architecture & Setup
- Connect Claude Code via CLI to GCP — used the Claude CLI tool to interact with Google Cloud services directly.
- Data sources integrated: Stripe, Google Analytics 4, YouTube API (free tier), Google Sheets, Rewardful, and others — all pulled via APIs.
- Data warehouse: Built tables in BigQuery as the single source of truth (SSOT).
- Dashboarding: Installed Metabase (open-source, self-hosted) for the frontend.
Key Design Decisions
The developer spent hours discussing the architecture with Claude. The critical insight: define revenue as the single source of truth (SSOT). All other data layers are built around this core. This constraint keeps Claude focused when validating dashboard data, preventing scope drift.
To maintain coherence as the project grows, they deployed Kartpathi's Wiki LLM for Obsidian Graph on the project's GitHub repo — a "brain system" that tracks context and helps Claude stay aligned with prior decisions. The author plans to open-source this format soon.
Cost Breakdown
- Claude Pro subscription: ~$20/month (what they used).
- Google Cloud Platform (BigQuery + compute): ~$30/month.
- Total: well under $50/month. No per-seat licensing or BI expert fees.
Practical Tips
- Use Google Cloud CLI with Claude Code for direct API access.
- Start with one SSOT (revenue) and layer other metrics around it.
- Self-host Metabase to avoid per-user costs of tools like Looker or Tableau.
- Document the architecture in an Obsidian graph to keep Claude consistent on large projects.
📖 Read the full source: r/ClaudeAI
👀 See Also
Automating OAuth Token Refresh for Bots Using Claude Code
A Reddit user shares a method to prevent OAuth token expiration by configuring Claude Code to automatically refresh tokens every 8 hours, keeping bots running continuously without manual intervention.
Practical Prompt Structure for Claude AI Execution Agents
A developer shares prompt engineering techniques that reduced hallucinations in Claude AI agents performing API calls, data extraction, and multi-step workflows. Key strategies include writing prompts as contracts, dedicating 40% of tokens to error handling, and separating 'wait' from 'stop' conditions.
Claude Code Cheat Sheet with 140 Tips and LLMs.txt File
A GitHub repository contains a Claude Code cheat sheet with 140 tips organized into 14 sections, tagged by difficulty. The repository includes an llms.txt file that can be fed directly to Claude for learning or applying the tips.
OpenClaw setup for human-in-the-loop browser automation with Docker, Chromium, and noVNC
A developer shares their Docker container setup that enables OpenClaw to handle CAPTCHAs and approvals mid-run by using Chromium with noVNC for remote access, requiring ~300MB RAM and 3-second cold starts.