Google Data Studio MCP server for AI agents and assistants

Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Google Data Studio MCP or direct API to search report assets, inspect ownership, manage sharing permissions, and audit dashboard access through natural language.

Google Data Studio logoGoogle Data Studio
Oauth2

Google Data Studio is Google's business intelligence platform for building dashboards and reports. Use it to turn data into shareable insights across teams and organizations.

5 Tools

Try Google Data Studio now

Type what you want done — sign in and watch it run live in the Tool Router playground.

TOOL ROUTER PLAYGROUND
Google Data Studio
Try asking
TOOLS

Supported Tools

Every Google Data Studio action and event your agent gets out of the box.

Add Members to Asset Role

Add members to a mutable Google Data Studio asset role and verify their membership after the write.

Get Asset Permissions

Get every populated permission role and the current concurrency etag for one Google Data Studio asset.

Replace Asset Permissions

Replace all four mutable permission-role memberships for a Google Data Studio asset, preserving owners and rejecting stale etags.

Revoke Asset Member Permissions

Remove one or more members from every removable role on a Google Data Studio asset and verify whether each was removed or already absent.

Search Assets

Search accessible Google Data Studio reports or data sources and return one page of asset metadata.

SETUP GUIDE

Connect Google Data Studio MCP Tool with your Agent

1

Install Composio

typescript
npm install @composio/core ai @ai-sdk/mcp @ai-sdk/openai
Install the Composio SDK and your agent framework
2

Create a session with MCP enabled

typescript
import { Composio } from "@composio/core";

const composio = new Composio();
const { mcp } = await composio.create("your-user-id", {
  toolkits: ["google_data_studio"],
  mcp: true,
});
Create a session scoped to Google Data Studio and read its MCP URL and headers
3

Connect your agent to the MCP server

typescript
import { createMCPClient } from "@ai-sdk/mcp";
import { openai } from "@ai-sdk/openai";
import { generateText, stepCountIs } from "ai";

const client = await createMCPClient({
  transport: { type: "http", url: mcp.url, headers: mcp.headers },
});

const { text } = await generateText({
  model: openai("gpt-5.6-sol"),
  tools: await client.tools(),
  prompt: "Find all Google Data Studio reports shared with my organization and summarize their owners and permissions",
  stopWhen: stepCountIs(10),
});

console.log(text);
await client.close();
Pass the session's MCP URL and headers to your agent and run a Google Data Studio request
SETUP GUIDE

Connect Google Data Studio API Tool with your Agent

1

Install Composio

typescript
npm install @composio/core @composio/openai openai
Install the Composio SDK, the OpenAI provider, and the OpenAI SDK
2

Create a Composio session

typescript
import OpenAI from "openai";
import { Composio } from "@composio/core";
import { OpenAIResponsesProvider } from "@composio/openai";

const composio = new Composio({ provider: new OpenAIResponsesProvider() });
const client = new OpenAI();

const session = await composio.create("your-user-id", { toolkits: ["google_data_studio"] });
const tools = await session.tools();
Initialize Composio with the OpenAI Responses provider and create a session scoped to Google Data Studio
3

Run Google Data Studio tools with your agent

typescript
let response = await client.responses.create({
  model: "gpt-5.6-sol",
  tools,
  input: [{ role: "user", content: "Find all Google Data Studio reports shared with my organization and summarize their owners and permissions" }],
});

while (response.output.some((o) => o.type === "function_call")) {
  const outputs = await composio.provider.handleToolCalls(session, response.output);
  response = await client.responses.create({
    model: "gpt-5.6-sol",
    tools,
    previous_response_id: response.id,
    input: outputs,
  });
}

console.log(response.output_text);
Send a request, execute the Google Data Studio tool calls through the session, and print the final answer

Why Use Composio?

AI Native Google Data Studio Integration

  • Supports both Google Data Studio MCP and direct API based integrations
  • Structured, LLM-friendly schemas for reliable Asset API execution
  • Rich coverage for searching reports, finding dashboards, and managing sharing permissions

Managed Auth

  • Built-in OAuth handling with automatic token refresh and lifecycle management
  • Central place to manage, scope, and revoke Google Data Studio access
  • Per user and per environment credentials instead of hard-coded OAuth tokens

Agent Optimized Design

  • Tools are tuned for real agent workflows like asset lookup, access review, and report discovery
  • Comprehensive execution logs so you always know what ran, when, and on whose behalf

Enterprise Grade Security

  • Fine-grained RBAC so you control which agents and users can access Google Data Studio
  • Scoped, least privilege access to Google Data Studio assets and permissions
  • Full audit trail of agent actions to support security reviews and compliance
FRAMEWORKS

Use Google Data Studio with any AI Agent Framework

Choose a Framework you want to connect Google Data Studio with

Rolling this out across your team?

Give your team centralized access control across every framework with Composio’s MCP Gateway.

EXPLORE MCP GATEWAY
FAQ

Frequently asked questions

Start with Google Data Studio.It takes 30 seconds.

Managed auth, hosted MCP servers, and every Google Data Studio tool your agent needs.Free to start.

Start building