Hologrow

[fastmoss] Use when the user wants active ad creatives or needs to filter ads by country, category, landing page, spend, ROAS, plays, or run days. Returns ad, creator, shop, products, and performance sections.

hologrow_fastmoss_ad_search

[fastmoss] Use when the user wants category sales contribution by creator follower_tier. Returns creator_count, category_gmv, gmv_share_percent, units_sold, and avg_creator_gmv.

hologrow_fastmoss_market_category_author_sales_matrix

[fastmoss] Use when the user wants category size, growth, competition, or opportunity. analysis_type basic_metrics returns category, scale_metrics, growth_metrics, concentration_metrics; sales_trends returns trend_series; price_distribution returns sales_price_distribution with left-open right-closed price bands and sub_category_units_sold_total.

hologrow_fastmoss_market_category_analysis

[fastmoss] Use when the user wants category ranking, growth, or concentration. Returns ranking_scope and ranked_categories; no category_id means level-1 category ranking, and a level-1 category_id means level-2 subcategory ranking.

hologrow_fastmoss_market_category_ranking

[fastmoss] Use when the user asks about creator follower, engagement, or commerce trends. Select field_type; returns daily series and period totals.

hologrow_fastmoss_creator_data_trends

[fastmoss] Use when the user wants a creator video-vs-live selling split and main promoted categories.

hologrow_fastmoss_creator_cargo_summary

[fastmoss] Use when the user wants to check whether a creator audience matches a target market. Returns age, gender, location, and top segments.

hologrow_fastmoss_creator_fans_distribution

[fastmoss] Use when the user wants a creator showcase product list. Returns product GMV, units sold, category, price, commission, shop info, and time_range_days.

hologrow_fastmoss_creator_product_list

[fastmoss] Use when the user wants creator content direction, tags, and selling videos. Returns video_tag_summary and video_list with interaction_rate_percent and linked_products so the model does not confuse video performance with product performance.

hologrow_fastmoss_creator_video_analysis

[fastmoss] Use when the AI needs FastMoss detail-page links. Takes no arguments and returns product, creator, shop, video, and live URL templates.

hologrow_fastmoss_fastmoss_detail_url_examples

[fastmoss] Use when the user asks about FastMoss rules, features, terms, or operations rather than real-time business data. Returns knowledge snippets and documents.

hologrow_fastmoss_search_fastmoss_documents

Inspect Hologrow columns, types, keys, meanings, metric definitions and query guidance for the selected tables before writing SQL. Use tables from list_tables; returned names may differ from source-platform API fields.

get_data_dictionary

Diagnose Hologrow sync coverage for stale/missing data, time-sensitive conclusions or query freshness warnings; do not call routinely.

get_freshness

Discover the user's connected Hologrow data: Amazon Seller/Vendor/Ads/DSP, Shopify, Shoplazza, TikTok Shop, Meta Ads, Google Ads, Google Analytics/GA4, Search Console and Lingxing ERP. Start here for platforms, connection state and schemas. Actions data.connections is independent of data entitlement. For more pages, pass connections_next_cursor as connections_cursor. Check errors and actions_availability before use.

list_platforms

Find Hologrow tables or analytics views before inspecting columns or writing SQL. type defaults to table. Use platforms from list_platforms; returns exact names for later tools and platform guidance.

list_tables

Internal read-only data loader for the Hologrow workbook UI. Loads exactly one previously verified sheet when the user opens it.

query_db_table_view_sheet

Default final presentation layer for Hologrow: interactive verified SQL tables. MUST call exactly once for two or more final tables or their underlying-data follow-ups; charts do not replace it. For one table, prefer Workbook over Markdown when interaction helps inspect, compare or verify results. Skip scalars, prose and one simple table without added value. For text-only requests or clients without app UI, use already returned analysis data.

query_db_table_view

Explore Hologrow data in PostgreSQL (PG): default structured analysis via one read-only SQL SELECT per call. Supports CTEs, JOINs, FILTER, GROUPING SETS/ROLLUP/CUBE, window functions, percentiles, CORR/REGR_* and metric decomposition/reconciliation. Discover names first; reuse available results. Apart from short call-boundary updates, do not narrate other intermediate steps or repeat the SQL.

query_db

[fastmoss] Use when the user wants one live session info, creator, key performance, and category breakdown.

hologrow_fastmoss_live_detail_analysis

[fastmoss] Use when the user wants products sold in a live session or high GMV/units within this live session. Returns live_units_sold, live_gmv, commission_rate_percent, sales_timeline only when pagesize <= 10, and shop_cumulative_units_sold.

hologrow_fastmoss_live_products_list

[fastmoss] Use when the user has no room_id and provides a live title, host, or shop. Returns live, creator, and performance_summary.

hologrow_fastmoss_live_search

[fastmoss] Use for agency product-category and price-band structure. Use agency_product_list for individual products.

hologrow_fastmoss_agency_product_analysis

[fastmoss] Use when the user wants individual products promoted through an agency. Supports category, price, period, sorting, and pagination.

hologrow_fastmoss_agency_product_list

[fastmoss] Use when the user wants an agency profile, historical performance, and recent 7/28/90-day data overview.

hologrow_fastmoss_agency_profile_overview

[fastmoss] Use when the user has an agency name or market clue but no agency_id. Returns matching agencies and recent 7-day performance.

hologrow_fastmoss_agency_search

[fastmoss] Use when the user wants agency collaborating-shop totals and individual shop performance.

hologrow_fastmoss_agency_shop_analysis

[fastmoss] Use when the user asks about the authenticated API-key user's credit balance, usage, packages, subscriptions, trial, or account status. Takes no arguments and never reads another user's data.

hologrow_fastmoss_credit_usage_summary

[fastmoss] Use when the user wants recently listed hot products. Returns FastMoss new-product ranking, first_3d_gmv/units_sold, and lifetime_gmv/total_units_sold; new means listed within 30 days.

hologrow_fastmoss_product_rank_new_listed

[fastmoss] Use when the user wants SKU sales share, inventory share, or SKU health. Returns SKU-level sales and inventory shares.

hologrow_fastmoss_product_sku

[fastmoss] Use when the user asks about product ads, spend, ROAS, or daily paid-traffic changes. Returns ad_performance_summary and daily_ad_performance_trend; ad_gmv is ad-attributed.

hologrow_fastmoss_product_investment

[fastmoss] Use when the user needs the product category tree or category levels. Prefer search_category_by_words for natural-language category terms.

hologrow_fastmoss_product_category_info

[fastmoss] Use when the user wants product basics, shop, price, rating, logistics, images, or ad status. Returns product and shop; detail_url points to TikTok.

hologrow_fastmoss_product_detail_info

[fastmoss] Use when the user wants product channel attribution, lifecycle/momentum, or ad-vs-organic structure. Returns period_summary, daily_trend, ads_distribution, channel_distribution, and content_distribution.

hologrow_fastmoss_product_overview

[fastmoss] Use when the user wants product reviews or buyer feedback. Returns review list and count; supports time_range_days and rating/create_time/review_id sorting.

hologrow_fastmoss_product_review_list

[fastmoss] Use when the user wants a product GMV/units trend or traction check. Returns period_summary and daily_trend with period_gmv, period_units_sold, daily_gmv, and daily_units_sold.

hologrow_fastmoss_product_sales_trend

[fastmoss] Use when the user has no product_id and provides a name, keyword, price band, category, bestseller clue, or new-product clue. Returns product, sales_summary, distribution_summary, and shop.

hologrow_fastmoss_product_search

[fastmoss] Use when the user wants videos selling a product, high-play videos, or paid-vs-organic video traffic. Filter with is_ad; returns GMV, plays, video_desc, and fastmoss_url.

hologrow_fastmoss_product_video_list

[fastmoss] Use when the user knows a product/category term but does not have the category_id yet. Returns matched TikTok product category IDs and Chinese category paths.

hologrow_fastmoss_search_category_by_words

[fastmoss] Use when the user asks about shop ads, spend, ROAS, ad GMV, or promoted assets. Returns ad estimates and daily changes.

hologrow_fastmoss_shop_investment_analysis

[fastmoss] Use when the user wants a shop snapshot, store type, rating, or profile. Returns cumulative GMV/units, ranks, age, product count, and creator/video/live counts.

hologrow_fastmoss_shop_base_info