MCP App Store
by KeenEthics
InsightfulPipe icon

InsightfulPipe MCP Server for Claude and ChatGPT

By Insightful Pipe, LLC

Overview

Connect ChatGPT to 50 marketing, advertising, analytics, SEO, social media, e-commerce, database, and productivity platforms through one InsightfulPipe workspace. Ask questions in plain language, retrieve live data, compare performance across channels, create reports, and perform supported actions when your connection allows it. Advertising and competitive research: Analyze campaigns, spend, conversions, audiences, and creatives across Google Ads, Meta Ads, Microsoft Ads, LinkedIn Ads, TikTok Ads, Pinterest Ads, Snapchat Ads, X Ads, and OpenAI Ads. Research competitors with supported public advertising libraries. Analytics, SEO, and site health: Work with Google Analytics 4, Google Search Console, Bing Webmaster Tools, Microsoft Clarity, CallRail, YouTube Analytics, DataForSEO, PageSpeed Insights, website crawling, screenshots, and Google Tag Manager. Social media, content, and scheduling: Analyze connected Instagram, Facebook Pages, LinkedIn Pages, TikTok, Pinterest, YouTube, Google Business Profile, WordPress, and Telegram sources. Upload media and schedule, publish, cancel, or reschedule supported social posts across connected accounts. E-commerce, email, and app research: Explore Shopify, WooCommerce, Magento, Google Merchant Center, Klaviyo, and Mailchimp data. Research apps, developers, and reviews from the Apple App Store and Google Play. Business data and custom sources: Query BigQuery, PostgreSQL, MySQL, and SQL Server according to each connection's permissions. Work with Google Sheets, Airtable, Notion, Slack, and workspace-defined REST APIs based on OpenAPI 3.x specifications. InsightfulPipe can combine data that normally lives in separate services. For example, compare ad spend with website sessions, conversions, orders, and revenue, or combine search performance with technical SEO findings to prioritize optimizations. Read and write capabilities are separated. Read-only tools do not modify connected accounts. Write actions require the necessary permissions and confirmation for destructive or public-facing changes. Platform-specific safety controls also apply. An InsightfulPipe account with at least one authorized connection is required. Available platforms, fields, metrics, and actions depend on the user's connected services, plan, and granted permissions.

How to connect

  1. Claude: Open the InsightfulPipe listing in the Claude connectors directory and choose Connect. Claude listing InsightfulPipe exposes 5 tools here.
  2. ChatGPT: Open the InsightfulPipe listing in the ChatGPT app directory and choose Connect. ChatGPT listing InsightfulPipe exposes 5 tools here.

Tools

execute_action

ChatGPT
Execute write operations on any platform (create, update, delete, publish, send). Runs write actions from the InsightfulPipe raw actions API; the query_contexts helper documents each action's exact request schema. Use for creating posts, updating products, deleting comments, publishing content, sending emails/SMS, and managing campaigns. For read-only queries, use query_data instead. REQUIRED: Complete these steps first using query_contexts: 1. request='accounts' platform='<platform>' - Get workspace_id, brand_id, and source identifiers 2. request='available_actions' platform='<platform>' - Get list of all available actions 3. request='actions_details' platform='<platform>' actions=['xxxx'] - Get detailed body structure Always call step 3 to see the exact body structure before executing. WARNING: This tool can perform irreversible actions. Confirm intent before proceeding. Platform-specific safety rules may apply. For Pinterest Ads, supported writes are create/update only, no delete methods are exposed, and campaign/ad group/ad delivery remains PAUSED. For Pinterest Pages, supported writes are create/update only for pins, boards, and board sections; no delete methods are exposed.

list_platforms

ChatGPT
List all supported platforms and their descriptions. Use this tool to see what platforms are available before querying data.

prompts_menu

ChatGPT
Access the InsightfulPipe prompt catalog for any platform. Use list_platforms to see all supported platforms. Operations: 1. request='menu', platform='<platform>' – List public prompts 2. request='menu', platform='<platform>', prompt_type='custom', workspace_id=<int> – List custom prompts 3. request='prompt_details', platform='<platform>', prompt_id=<int> – Get public prompt text 4. request='prompt_details', platform='<platform>', prompt_id=<int>, is_custom=True, workspace_id=<int> – Get custom prompt text

query_contexts

ChatGPT
Helper for planning InsightfulPipe data queries across all platforms. Use list_platforms to see all supported platforms. Step 1: request='accounts' – Retrieve connected sources. • Without platform: Returns ALL connected sources across all platforms • With platform: Returns sources for that specific platform only Step 2: request='available_actions' platform='<platform>' – List all available tables/actions. Step 3: request='actions_details' platform='<platform>' actions=['table_a', 'table_b'] – REQUIRED before querying. Returns exact request body structure. Optional: request='brands' with brand_id + workspace_id to pull brand guidelines.

query_data

ChatGPT
Query and read data from any platform (read-only operations). Runs read actions from the InsightfulPipe raw actions API; the query_contexts helper documents each action's exact request schema. Use for fetching reports, analytics, metrics, and listings. For write operations, use execute_action instead. REQUIRED: Complete these steps first using query_contexts: 1. request='accounts' platform='<platform>' - Get workspace_id, brand_id, and source identifiers 2. request='available_actions' platform='<platform>' - Get list of all available actions 3. request='actions_details' platform='<platform>' actions=['xxxx'] - Get detailed body structure Always call step 3 to see the exact body structure before querying. Follow the schema exactly.

execute_action

Claude

list_platforms

Claude

prompts_menu

Claude

query_contexts

Claude

query_data

Claude

Capabilities

Writes

Example Prompts

Click any prompt to copy it.

Similar Apps

Listed on MCP App Store

Listed on MCP App Store

Add this badge to your site or README. It links to this page.

HTML

<a href="https://mcp-app-store.keenethics-labs.com/app/insightfulpipe"><img src="https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg" alt="Listed on MCP App Store" width="220" height="44"></a>

Markdown

[![Listed on MCP App Store](https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg)](https://mcp-app-store.keenethics-labs.com/app/insightfulpipe)