Query Reporting

curl --request POST \
  --url 'https://api.adside.ai/meta-reporting/mcp#query_reporting' \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "jsonrpc": "<string>",
  "method": "<string>",
  "params": {
    "name": "<string>",
    "arguments": {
      "sql": "<string>",
      "params": {}
    }
  },
  "id": "1"
}
'

{
  "jsonrpc": "<string>",
  "id": "<string>",
  "result": {
    "content": [
      {
        "type": "<string>",
        "text": "<string>"
      }
    ]
  }
}

Meta Reporting

Query Reporting

Execute a read-only SELECT against reporting.meta_* (ClickHouse) — the default tool for any analytical question over historical Meta Ads data. Faster than the Graph API and supports SQL-level aggregation (GROUP BY, JOINs, sum/avg, breakdowns). Read-only by infrastructure: INSERT/UPDATE/DELETE/DDL are rejected by the server. Tenant isolation (organization_id/workspace_id) is enforced automatically by the warehouse — no need to filter on those. Data freshness: ~12h cadence. The system prompt provides the full curated schema; use it directly. Use parameterized placeholders ({name: Type}) + the `params` object for any user-controlled value.

POST

meta-reporting

mcp#query_reporting

Query Reporting

curl --request POST \
  --url 'https://api.adside.ai/meta-reporting/mcp#query_reporting' \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "jsonrpc": "<string>",
  "method": "<string>",
  "params": {
    "name": "<string>",
    "arguments": {
      "sql": "<string>",
      "params": {}
    }
  },
  "id": "1"
}
'

{
  "jsonrpc": "<string>",
  "id": "<string>",
  "result": {
    "content": [
      {
        "type": "<string>",
        "text": "<string>"
      }
    ]
  }
}

Authorizations

Authorization

string

header

required

API key (sk_live_*) — SHA256 hashed, looked up in Redis. Generate via the web app's workspace settings.

Body

application/json

jsonrpc

string

required

Allowed value: "2.0"

method

string

required

Allowed value: "tools/call"

params

object

required

Show child attributes

string

Example:

"1"

Response

JSON-RPC response with tool result

jsonrpc

string

Allowed value: "2.0"

string

result

object

Show child attributes

Get Interest Suggestions Describe Table