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": {
      "url": "https://data.supple.tools/mcp"
    }
  }
}
      

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 6 tools for AI assistants:

list_clients      — Browse all clients
client_summary    — Latest SEO summary
keyword_rankings  — SE Ranking positions
gsc_performance   — Search Console data
query_warehouse   — Custom SQL queries
data_catalog      — Available tables
      