Supple Data Warehouse

📊

7 Data Sources

Ingests data from all your SEO and project tools into BigQuery, transforms with dbt, and caches in Supabase for instant access.

Google Analytics 4 Google Search Console Google Ads SE Ranking Trello Podio Xero

⚡

Cost-Controlled Queries

Smart query routing — checks Supabase cache first (free, instant), falls back to BigQuery marts with cost controls. Daily budget limits prevent runaway spend.

🤖

AI-First Design

Built with MCP (Model Context Protocol) server so AI assistants like Claude can directly query client data, pull SEO rankings, and generate reports.

Connect with AI

MCP Server

Add the data warehouse as an MCP server in Claude Desktop or any MCP-compatible AI tool.

// claude_desktop_config.json
{
  "mcpServers": {
    "supple-data": {
      "type": "streamable-http",
      "url": "https://data.supple.tools/mcp/",
      "headers": {
        "Authorization": "Bearer YOUR_API_KEY"
      }
    }
  }
}
      

REST API

Query the warehouse directly via the REST API. Ask questions in natural language or fetch specific client data.

# Query the warehouse
curl -X POST https://data.supple.tools/query \
  -H "Content-Type: application/json" \
  -d '{
    "question": "Top 10 keywords for client X",
    "client_id": "client-slug"
  }'

# Get cached summary
curl https://data.supple.tools/client/my-client/summary/seo
      

Available Tools

The MCP server exposes 28 tools for AI assistants:

# Free (Supabase cache)
search_clients         — Search by name/slug
get_client_detail      — Full client profile
list_clients           — Browse all clients
get_client_summary     — Latest cached summary
get_cross_client_rankings — Portfolio rankings
get_alerts             — Data quality alerts
get_budget             — Query cost budget
get_data_catalog       — Available tables

# Paid (BigQuery, cost-capped)
get_marketing_metrics  — GA4/Ads/GSC metrics
get_weekly_summary     — Weekly performance
get_gsc_queries        — Search Console queries
get_gsc_pages          — Search Console pages
get_keyword_rankings   — SE Ranking positions
get_ranking_summary    — Ranking overview
get_google_ads_campaigns — Ads campaigns
get_google_ads_performance — Ads daily
get_trello_cards       — Trello cards
get_podio_items        — Podio items
get_activity_notes     — Comments & notes
get_client_meetings    — Calendar meetings
get_meetings_analytics — Meeting analytics
get_analyst_workload   — Analyst workload
get_project_health     — Project health
get_financial_summary  — Xero financials
get_invoices           — Xero invoices
get_ar_aging           — AR aging
query_warehouse        — Ad-hoc SQL
get_warehouse_schema   — Table schemas
      