# data-connector # Ask AI Data Connector ## Quick Start ```bash # Connect this server (installs CLI if needed) npx -y @smithery/cli@latest mcp add ask-ai/data-connector # Browse available tools npx -y @smithery/cli@latest tool list ask-ai/data-connector # Get full schema for a tool npx -y @smithery/cli@latest tool get ask-ai/data-connector ask_question # Call a tool npx -y @smithery/cli@latest tool call ask-ai/data-connector ask_question '{}' ``` ## Direct MCP Connection Endpoint: `https://data-connector--ask-ai.run.tools` ## Tools (39) - `ask_question` — Quick natural-language queries about core Shopify data ONLY (revenue, orders, products, inventory, customers). Do NOT u… - `get_data_sources` — CALL THIS FIRST to see which data sources are connected and have data. Returns connection status and record counts for:… - `get_complete_dashboard` — Get a unified dashboard with key metrics from ALL connected data sources in one call. Returns a lean snapshot of revenu… - `get_metrics_comparison` — BEST FOR COMPARISONS: Get core e-commerce metrics (Revenue, Sessions, CVR, AOV, Revenue per Session) with period-over-p… - `get_metrics_multi_compare` — Get metrics with MULTIPLE comparisons at once. Perfect for questions like 'Show me revenue WoW and YoY' or 'Compare thi… - `get_daily_metrics_breakdown` — Get daily breakdown of metrics for charts and trend analysis. Returns daily values for revenue, sessions, CVR, AOV, and… - `get_customer_insights` — Get customer behavior and retention insights. Reports: new_vs_returning (revenue/orders/AOV split by first-time vs repe… - `get_refunds` — Get refund/return analytics. Reports: summary (total refunds, refund rate, % of revenue), top_products (most refunded p… - `get_discounts` — Get discount code analytics. Reports: summary (usage rate, AOV impact), top_codes (best performing codes by revenue/usa… - `get_inventory_velocity` — Get inventory velocity analytics. Reports: summary (sell-through rate, turnover, health status), by_product (products s… - `get_marketing_performance` — Get marketing performance dashboard. Returns: funnel metrics (sessions, addToCartRate, checkoutRate, purchaseRate, cvr)… - `get_products_by_channel` — Get products with marketing channel attribution showing which channels drive sales for each product. Use for questions … - `get_store_summary` — Get overall store metrics: revenue, orders, average order value, items sold, discounts, unique customers — all for the … - `query_orders` — Query and filter orders with various criteria. Returns individual orders with name, status, fulfillment, orderTotal (fo… - `get_orders` — Get order analytics by dimension. Reports: by_status (order counts/revenue by financial status), by_country (geographic… - `get_top_products` — Get top selling products ranked by revenue or quantity. Returns: rank, productId, title, unitsSold, revenue (formatted)… - `get_product_catalog` — Get product catalog with inventory levels, pricing, variants, and status. Returns: title, status, vendor, productType, … - `get_customers` — Get customer analytics by dimension. Reports: segments (one-time/returning/VIP/at-risk), top (by spend or orders — incl… - `get_inventory` — Get inventory analytics. Reports: summary (total products, stock levels), low_stock (products needing reorder), out_of_… - `get_daily_revenue` — Get daily revenue and order count as a time series. Each row: date, revenue (formatted), orders. Use this for charting … - `get_weekly_trends` — Get weekly revenue, orders, and items sold as a time series. Each row: weekStart, revenue (formatted), orders, itemsSol… - `get_triple_whale` — Get Triple Whale marketing analytics. Reports: summary (metrics grouped by category — each metric has id, name, value, … - `get_klaviyo` — Get Klaviyo email marketing analytics. Reports: campaign_summary (overall campaign stats), campaigns (individual campai… - `get_gorgias` — Get Gorgias customer support analytics. Reports: summary (ticket counts by status, avg first response time in seconds +… - `get_recharge` — Get Recharge subscription analytics. Reports: summary (MRR as formatted money, activeSubscriptions, cancelledSubscripti… - `get_search_console` — Get Google Search Console SEO analytics. Reports: summary (clicks, impressions, CTR, position), top_queries (best keywo… - `get_clarity` — Get Microsoft Clarity UX/session analytics. Reports: summary (totalSessions, totalUsers, avgSessionDuration in seconds,… - `get_youtube` — Get YouTube analytics. Reports: summary (channel stats, subscribers, views), videos (video list with metrics), top_vide… - `get_reviews` — Get product review analytics (Yotpo, Reviews.io, or Judge.me). Reports: summary (average rating, distribution), trends … - `get_loyalty` — Get Smile.io loyalty program analytics. Reports: summary (members, points balances, VIP tiers), points_activity (earnin… - `get_wishlist` — Get Swish wishlist analytics. Reports: summary (total items, unique products, unique customers), top_products (most wis… - `get_meta_ads` — Get Meta (Facebook/Instagram) ad performance data. Reports: summary (total spend, ROAS, CPC, CPM, conversions for date … - `get_shipstation` — Get ShipStation shipping analytics. Reports: summary (total shipments, costs, avg cost, shipping margin, void rate), ca… - `get_xero` — Get Xero accounting data. Reports: financials (P&L: revenue, COGS, gross profit, operating expenses, net profit + Balan… - `get_daily_stats` — Get pre-computed daily analytics from Shopify order data. Reports: daily (each day: revenue, orders, avgOrderValue, ite… - `get_abandoned_checkouts` — Get cart abandonment analytics. Reports: stats (totalCheckouts, abandonedCheckouts, recoveredCheckouts, recoveryRate %,… - `get_product_velocity` — Get product sales velocity data. Reports: summary (totalUnitsSold, revenue, productsTracked, inventoryHealth counts by … - `get_analytics` — Get Google Analytics (GA4) website traffic data. Reports: summary (sessions, activeUsers, newUsers, pageViews, engagedS… - `get_reviewsio` — Get Reviews.io specific analytics. Reports: stats (aggregate product/merchant/third-party stats, NPS), nps_trend (daily… ```bash # Get full input/output schema for a tool npx -y @smithery/cli@latest tool get ask-ai/data-connector ```