ClipMarts

Analytics Stack

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

analytics teamsdbt userswarehouse-centric operators
$29Operator PackFor departments, agencies, and ops-heavy teams

What is Analytics Stack?

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

Setup Time

10 min

Difficulty

Intermediate

Works With
paperclipclaude-code

Why This Product Sells

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

Best For

  • analytics teams
  • dbt users
  • warehouse-centric operators

Outcomes

  • connect warehouse-to-dashboard faster
  • enable data agents safely
  • reduce setup friction

Included

  • BigQuery access
  • dbt hooks
  • Metabase connectivity

Before vs. After

Before

  • Fragmented tools and disconnected workflows
  • No standardized operating structure for the function
  • Senior staff stuck on low-leverage coordination work

After deploying Analytics Stack

  • connect warehouse-to-dashboard faster
  • enable data agents safely
  • reduce setup friction

What's Included

  • 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

Preview

mcp-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}"
      }
    }
  }
}

Installation Guide

terminal
$ paperclipai skill import --from ./analytics-mcp-bundle/
Skill imported successfully.

One command to import — then assign to any agent in your company.

Option A: CLI (recommended)

1

Download and extract the ZIP

unzip analytics-mcp-bundle.zip
2

Import the skill

paperclipai skill import --from ./analytics-mcp-bundle/
3

Assign to an agent

# Via CLI:
paperclipai agent update <agent-name> --add-skill analytics-mcp-bundle

# Or in the dashboard:
# Agents → [agent name] → Skills → Add "Analytics Stack"

Option B: Dashboard UI

1

Open Skills page

Navigate to Skills → Import Skill

2

Upload the product folder

From the extracted ZIP, upload the analytics-mcp-bundle/ directory containing SKILL.md.

3

Assign to agents

Go to Agents → [agent] → Skills and add "Analytics Stack" from the list.

Share
Files included13
Setup time10 min
Difficultyintermediate

Tags

mcpbigquerydbtmetabaseanalyticsdata-warehouse