Hologrow MCP

The commerce data layer for AI. Connect Amazon, Google Ads, GA4, and other selling systems once. Hologrow keeps the data synced, then MCP lets Claude, Cursor, Codex, ChatGPT, and other agents query it — without CSV exports or one-off API scripts.

Hosted at mcp.hologrow.ai. Console at connector.hologrow.ai. Docs at docs.hologrow.ai.

Why Hologrow?

• Built for the tools you already use: Connect once, then ask questions in Claude, Cursor, Codex, ChatGPT, Doubao, or Hermes

• LLM-ready commerce data: Stable tables for Amazon SP, Amazon Ads, Google Ads, GA4, Search Console, Shoplazza, and Lingxing ERP

• We handle the hard stuff: Platform OAuth, sync, freshness, and schema — agents only read

• Read-only by default: MCP never writes back to ad accounts or storefronts

• Agent ready: Five discovery tools plus analysis skills you can install with one command

Related MCP server: Snowflake MCP Server

Feature Overview

MCP tools

More

Quick Start

1. Create a workspace at connector.hologrow.ai.

2. Connect at least one data source and wait for the first sync.

3. Add Hologrow MCP to your agent. OAuth clients authorize in the UI. Cursor / Claude Code / Hermes use an API key from AI Platforms → Advanced settings.

Creating an API key is not enough. Installation succeeds when the agent can call list_platforms.

MCP

Connect any MCP-compatible client. Transport is Streamable HTTP.

{
  "mcpServers": {
    "Hologrow": {
      "url": "https://mcp.hologrow.ai/mcp",
      "headers": {
        "Authorization": "Bearer YOUR_API_KEY"
      }
    }
  }
}

ChatGPT web

1. ChatGPT → Settings → Security and login → turn on Developer mode.

2. Sidebar → Plugins → +.

   • Name: Hologrow

   • Server URL: https://mcp.hologrow.ai/mcp

   • Authentication: OAuth

3. Click Sign in with Hologrow and allow access.

ChatGPT desktop / Codex

1. Settings → Plugins → Add MCP server.

2. Name: Hologrow. Type: Streamable HTTP. URL: https://mcp.hologrow.ai/mcp.

3. Click Authenticate and complete authorization.

Claude web / desktop

1. Settings → Customize → Connectors → Add custom connector.

2. Name: Hologrow. Remote MCP server URL: https://mcp.hologrow.ai/mcp.

3. Sign in and click Allow access.

Doubao desktop (desktop app only)

1. Skills · Connectors · Partners → New custom connector.

2. Name: Hologrow. Transport: HTTP. URL: https://mcp.hologrow.ai/mcp. Leave headers empty.

3. Click Authorize and allow access.

Copy an API key from the console, then send this prompt to a new Agent conversation. Replace {apiKey}. Do not ask the agent to echo the key.

Install the Hologrow MCP server and test the connection.

Connection details:
- Name: Hologrow
- URL: https://mcp.hologrow.ai/mcp
- Transport: Streamable HTTP
- Authentication: API Key
- Header: Authorization: Bearer {apiKey}

Requirements:
1. Add Hologrow using this client's native MCP configuration. Use API Key authentication only; do not use OAuth.
2. Make only the changes required for installation. Keep the API key secret and do not repeat, log, or include it in your response.
3. After installation, call Hologrow's list_platforms tool once. Do not call any other tools.
4. If successful, list the connected data platforms exactly as returned. If installation, authentication, connection, or the tool call fails, stop and explain the error.

Verify

Start a new conversation and send:

Use Hologrow’s list_platforms tool to list my connected data platforms. Do not call any other tools.

Output:

{
  "items": [
    {
      "platform": "amazon_sp_seller",
      "connected": true,
      "table_count": 30,
      "schemas": [
        {
          "schema_name": "amazon_sp_seller_xxxxxxxx",
          "display_name": "US Seller",
          "connection_status": "healthy"
        }
      ]
    },
    {
      "platform": "google_ads",
      "connected": false,
      "table_count": 15,
      "schemas": []
    }
  ]
}

An empty list still means MCP is installed — the workspace just has no connected source yet.

Power Your Agent

Connect Hologrow to any AI agent in minutes.

Skill

Give your agent the query workflow and Amazon / Google Ads playbooks.

npx skills@latest add hologrow/hologrow-mcp --skill hologrow-data-middleware --global --yes

Restart the agent after installing. Works with Claude Code, Cursor, Codex, and other skills-compatible clients.

npx skills@latest add hologrow/hologrow-mcp --skill amazon-ppc-campaign --agent cursor --global --yes
npx skills@latest add hologrow/hologrow-mcp --skill google-ads-audit --agent claude-code --global --yes

Agent onboarding

Are you an AI agent? Fetch this skill, then call list_platforms.

curl -s https://raw.githubusercontent.com/hologrow/hologrow-mcp/main/skills/hologrow-data-middleware/SKILL.md

Tools

Always discover names from the tools. Never invent platform, schema, table, or column names. Middleware field names often differ from Amazon / Google UI labels.

list_platforms → list_tables → get_data_dictionary → get_freshness → query_db

If a tool fails or is cancelled, say so. Never infer zero, no data, or a metric from a missing result.

list_platforms

Call this first. Returns platform names, connected, and schemas[].schema_name.

list_platforms()

list_tables

List queryable tables for one platform from list_platforms.

list_tables({ "platform": "amazon_sp_seller" })

Output:

{
  "tables": ["order_items", "sales_and_traffic_daily", "fba_inventory_summaries"]
}

get_data_dictionary

Get columns, types, keys, and descriptions. Pass 1–10 exact table names from list_tables.

get_data_dictionary({
  "platform": "amazon_sp_seller",
  "table_names": ["orders", "order_items"]
})

get_freshness

Check sync coverage before treating a number as current. schema_name comes from list_platforms. Optional scope filters by resource identity.

get_freshness({
  "schema_name": "amazon_sp_seller_xxxxxxxx",
  "table_names": ["orders"],
  "scope": { "marketplace_id": "ATVPDKIKX0DER" }
})

query_db

Run one read-only SELECT. Qualify every table as schema_name.table. Use only columns from get_data_dictionary.

query_db({
  "query": "SELECT purchase_date::date AS day, order_status, COUNT(*) AS order_items, SUM(quantity) AS units FROM amazon_sp_seller_<schema>.order_items WHERE purchase_date >= CURRENT_DATE - INTERVAL '7 days' GROUP BY 1, 2 ORDER BY 1 DESC LIMIT 100",
  "max_rows": 100
})

Replace <schema> with schema_name from list_platforms. item_price is the order-line total; divide by NULLIF(quantity, 0) only when you need per-unit price. Do not use _synced_at as the sales date.

Rules

• Single statement only. No INSERT / UPDATE / DELETE / DDL, no EXCEPT or INTERSECT, no public schema or system catalogs

• Prefer filters, aggregation, and LIMIT over SELECT *

• Default max_rows is 1000

Skills

Advisory, read-only workflows on top of connected Hologrow data. Install hologrow-data-middleware first so other skills check coverage and freshness before they interpret performance.

npx skills@latest add hologrow/hologrow-mcp --skill SKILL_NAME

Example prompt after install:

Use $hologrow-data-middleware, then $google-ads-audit.
Audit my connected Google Ads account for the last 30 days. Show evidence, caveats, and the next action.

A larger catalog (SEO, research connectors, and more) lives in hologrow/hologrow-ai-skills. This repo keeps the skills that depend on Hologrow MCP.

Integrations

Agents & AI tools

• ChatGPT web, ChatGPT desktop, Codex

• Claude web, Claude desktop, Claude Code

• Cursor

• Doubao (desktop)

• Hermes

Data sources

Amazon SP Seller, Amazon SP Vendor, Amazon Ads, Google Ads, GA4, Google Search Console, Shoplazza, Lingxing ERP.

Resources

• Documentation

• Product

• Console

• MCP endpoint

• Skills catalog

Safety

Hologrow MCP is tenant-scoped and read-only. Use only sources the workspace has authorized. Check freshness before treating a number as current. State the metric definition, attribution window, and comparison period with every important conclusion. Never put API keys into git, skill files, or model replies.

Treat campaign, listing, and budget changes as proposals until a human approves them.

Troubleshooting