Solo Unicorn Club logo

Integration Stacks

Analytics Stack

BigQuery, dbt, and Metabase for warehouse-to-dashboard analytics

analytics teamsdbt userswarehouse-centric operators

Why buy

The buyer is clear, the stack is familiar, and the value is immediate: less wiring before insights.

// First 7 days

What can be running fast.

01

connect warehouse-to-dashboard faster

02

Ship a usable package with 13 included files and working structure.

03

Move from purchase to first setup in about 10 min.

// Included files

What is inside the package.

mcp-servers.json
servers/bigquery/config.json
servers/bigquery/auth-setup.md
servers/bigquery/permissions.md
servers/dbt/config.json
servers/dbt/auth-setup.md
servers/metabase/config.json
servers/metabase/auth-setup.md
docker-compose.yaml
env.example
scripts/setup.sh
scripts/test-connections.sh
README.md

Description

What is Analytics Stack?

MCP servers: BigQuery (warehouse queries), dbt (transformations), and Metabase (dashboards). Read-only analytics access.

solo-unicornclaude-code

Upgrade path

  • 01Start with this package and validate the workflow.
  • 02Add specialized skills or bundles once the core system is stable.
  • 03Use the community to sharpen positioning, demos, and feedback loops.
Previewmcp-servers.json
// mcp-servers.json
{
  "mcpServers": {
    "bigquery": {
      "command": "npx",
      "args": ["-y", "@mcp/bigquery-server"],
      "env": {
        "GCP_PROJECT_ID": "${GCP_PROJECT_ID}",
        "GCP_CREDENTIALS_PATH": "./credentials/gcp.json",
        "BQ_DATASET": "${BQ_DATASET}"
      }
    },
    "dbt": {
      "command": "npx",
      "args": ["-y", "@mcp/dbt-server"],
      "env": {
        "DBT_PROJECT_DIR": "${DBT_PROJECT_DIR}",
        "DBT_PROFILES_DIR": "${DBT_PROFILES_DIR}"
      }
    },
    "metabase": {
      "command": "npx",
      "args": ["-y", "@mcp/metabase-server"],
      "env": {
        "METABASE_URL": "${METABASE_URL}",
        "METABASE_API_KEY": "${METABASE_API_KEY}"
      }
    }
  }
}

// Community acceleration

Use the room after the purchase.

Bring your workflow into the Solo Unicorn community for sharper feedback, operator critique, and more visibility once the system is live.

Discuss implementation