Analytics Stack
BigQuery, dbt, and Metabase for warehouse-to-dashboard analytics
What is Analytics Stack?
MCP servers: BigQuery (warehouse queries), dbt (transformations), and Metabase (dashboards). Read-only analytics access.
10 min
Intermediate
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
{
"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
One command to import — then assign to any agent in your company.
Option A: CLI (recommended)
Download and extract the ZIP
unzip analytics-mcp-bundle.zipImport the skill
paperclipai skill import --from ./analytics-mcp-bundle/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
Open Skills page
Navigate to Skills → Import Skill
Upload the product folder
From the extracted ZIP, upload the analytics-mcp-bundle/ directory containing SKILL.md.
Assign to agents
Go to Agents → [agent] → Skills and add "Analytics Stack" from the list.
Related Products
Finance Stack
QuickBooks, Plaid, and Google Sheets for financial data access
Sales Stack
HubSpot, Calendly, and email wired for CRM-driven outreach
Healthcare Stack
EHR connector, appointment scheduler, and secure messaging
Creative Stack
Figma, Canva, and DAM connected for design team workflows