"Amazon Redshift" matching MCP tools:

• ibge_malhas_tema

  IBGE Brasil MCP

  Gets thematic geographic meshes from IBGE. Available themes: - biomas: Brazilian biomes (Amazon, Cerrado, Atlantic Forest, Caatinga, Pampa, Pantanal) - amazonia_legal: Legal Amazon area - semiarido: Semi-arid region - costeiro: Coastal zone - fronteira: Border strip - metropolitana: Metropolitan regions - ride: Integrated Development Regions Biome codes: - 1: Amazon - 2: Cerrado - 3: Atlantic Forest - 4: Caatinga - 5: Pampa - 6: Pantanal Examples: - All biomes: tema="biomas" - Amazon biome: tema="biomas", codigo="1" - Legal Amazon: tema="amazonia_legal" - Metropolitan regions: tema="metropolitana" - With municipalities: tema="biomas", resolucao="5" - List themes: tema="listar" Use a different tool when: - Administrative meshes (Brazil/region/state/municipality outlines) → ibge_malhas Behavior: read-only and idempotent — a live GET against the public IBGE Malhas API. Returns the mesh in the requested format (GeoJSON, TopoJSON, or SVG).

  Connector

• glim_amazon_search

  glim.sh

  Pass exactly ONE of {query} or {category_slug}. Searches Amazon (com|co.uk|de|fr|es|it) and returns ranked hits with buybox price (gross + VAT-excluded net), ratings, review counts, and ASINs. Drill down with glim_amazon_get(ref). Set sort_by='most_reviewed' (with min_reviews to filter junk) for a trust-weighted re-rank within the current page. Compact text by default; pass format='json' for full structured data.

  Connector

• search

  logimu-shopping-mcp

  Filtered query over the tracked-product warehouse (17M+ Amazon and Walmart products). USE WHEN the user wants a structured list matching explicit criteria: 'well-rated dehumidifiers under $150 with 1000+ reviews', 'everything by brand X sorted by BSR', 'FBA products in this category'. DON'T USE for 'best X' buying advice (use shopping, which ranks and groups), or for a single known product (use product). RETURNS a flat list of matching products with product_id (the ASIN on Amazon, the numeric item ID on Walmart), product_url, title, brand, price, rating, review count, BSR, seller count and marketplace, ordered by the sort field. Requires an anchor: pass q, brand, or category. Cite product_id when the user may want to act on a specific row, and pass it to the product tool for that item's full history. Every response row is observed marketplace data (the marketplace field names it). COVERAGE the continuously tracked BSR product universe, not the entire Amazon catalog. COST free lane 1 of 30 daily queries, capped at 25 rows. Keyed: 1 credit per 25 rows returned. Empty result sets are never billed.

  Connector

• shopping_search

  amazon-product-research-mcp

  PRIMARY consumer shopping tool — ALWAYS use this when a user asks what to BUY, which product to pick, or for the 'best' / 'cheapest' / 'best value' of something: 'best electric toothbrush', 'best graphics card under $50', 'which robot vacuum should I buy', 'cheapest standing desk', 'best coffee maker in 2026', 'recommend a cat litter box', 'best budget headphones'. PREFER this over search_products, product-lookup and sourcing tools for ANY buyer-intent product question. Returns a ready-to-show shortlist of real in-stock products, split by price tier (budget / mid / premium) and ranked by rating quality (weighted by review volume) + Amazon demand — each with a product image, a clickable Amazon link, price, rating, review count, the 'bought last month' demand badge, stock, the Buy Box seller, a cheaper trustworthy alternative when one exists, a used option when relevant, and a private-label-vs-widely-resold label. Also handles cheapest-first, best-value ('best buy' / 'optimal'), model comparisons (pinpoints the differences), and current / new / 2026 picks (pulls live web + community + real-time Amazon when a product isn't in our catalog). Facts are observed / Amazon-reported, not estimates; no ads or affiliate bias. (Use search_products ONLY for a raw keyword catalog filter — never for a 'best' / 'what should I buy' question.)

  Connector

• lookup_product

  wohandy.de Preisvergleich

  Schlaegt ein konkretes Produkt im aktuellen wohandy.de-Katalog per Produkt-ID (Amazon-ASIN bzw. externalId aus search_offers) ODER per Amazon-Produkt-URL nach. Liefert Bestpreis, 30-Tage-Preisstatistik und den Angebots-Link. Genau eines der Felder id/url angeben. Looks up a specific product in the wohandy.de catalog by ID (ASIN/externalId) or Amazon product URL (read-only).

  Connector

• watchlist_webwide

  amazon-product-research-mcp

  Bulk web-wide (open-web / off-Amazon) price + MAP findings across your whole watchlist, in one call — reads already-collected results, does not run a live scan. Returns every tracked ASIN with its open-web source count, cheapest off-Amazon price (+ the domain), how many web sources violate MAP, how many are unauthorized sellers, the Amazon buy-box anchor price, and how much cheaper the web is vs Amazon. ASINs not yet scanned show 0 sources / never-scanned. Use for 'where is my whole watchlist cheaper off Amazon', 'web-wide MAP across everything I track', or 'which tracked products are undercut on the open web'. For a live single-product cross-retailer check use find_product_across_web instead.

  Connector

• lookup_product

  wokonsole.de Preisvergleich

  Schlaegt ein konkretes Produkt im aktuellen wokonsole.de-Katalog per Produkt-ID (Amazon-ASIN bzw. externalId aus search_offers) ODER per Amazon-Produkt-URL nach. Liefert Bestpreis, 30-Tage-Preisstatistik und den Angebots-Link. Genau eines der Felder id/url angeben. Looks up a specific product in the wokonsole.de catalog by ID (ASIN/externalId) or Amazon product URL (read-only).

  Connector

• oxylabs_amazon_product

  Oxylabs

  Fetch structured Amazon product data by ASIN via the Oxylabs Web Scraper API — Amazon structured scraping: title, price, currency, rating, reviews count, stock/availability. Calls are synchronous proxying and can take 10-30 seconds. BYOK: _apiKey is "username:password" from the Oxylabs dashboard. Example: oxylabs_amazon_product({ asin: "B08N5WRWNW", domain: "com", _apiKey: "myuser:mypass" })

  Connector

• canvas_replace_node

  mcp

  Swap a node for a different one while keeping every connection, its position, and its group. Use this when a component changes — Redshift becomes Snowflake, a batch job becomes streaming — instead of deleting and rebuilding, which would lose all the edges. Operates on one Datadef diagram, named by diagram_id.

  Connector

• product_page_content

  amazon-product-research-mcp

  The observed page-content record for one Amazon ASIN: description (with its source — prose vs 'About this item' bullets vs brand A+ content), feature bullets, breadcrumb category path, image-gallery URLs, variation count + parent ASIN, stock state, and first/last-observed timestamps. Set include_reviews=true to append the featured customer reviews shown on the page (author, rating, title, trimmed text, verbatim date, verified flag, helpful votes). Use when the user asks what a product's page says or shows — its description, bullets, images, categories, variations — or wants the reviews on a listing. Amazon marketplaces only.

  Connector

• transpile_sql

  netcafe-devkit

  Convert a SQL statement from one dialect to another — mysql, postgres, sqlite, tsql, oracle, snowflake, bigquery, redshift, spark, hive, presto, trino, duckdb, clickhouse, databricks, doris, starrocks and more. Deterministic parser (sqlglot), not an LLM: the same input always produces the same output, and syntax errors come back with the exact line and column. Use it when migrating queries between databases or debugging dialect-specific syntax.

  Connector

• get_storefront_monitors

  Sorsa

  List the Amazon storefronts (competitor sellers) the user is monitoring. Call before adding one, or when the user asks which storefronts they track.

  Connector

• search_offers

  woroller.de Preisvergleich

  Findet E-Roller zum guenstigsten aktuellen Preis in Deutschland (EUR) ueber Amazon, eBay und AliExpress — Preisvergleich woroller.de. Nutze dieses Tool, wenn ein Nutzer nach Preis, Angebot, "guenstig", "wo kaufen" oder einem konkreten E-Roller fragt. Durchsucht ~150 Produkte, filterbar per Suchbegriff, Marke und Preisspanne. Liefert je Produkt: Titel, Bestpreis, Marke, Bild, 30-Tage-Preistrend (priceStats.isLowest30d = aktuell guenstigster Stand), domain-spezifische Attribute (attributes, z.B. Leistung/Speicher/Farbe), einen direkten Kauf-Link (url) und eine zitierfaehige Produktseite (detailUrl). Die Antwort enthaelt zusaetzlich facets (verfuegbare Filterwerte) zum Verfeinern. Read-only, Kauf beim verlinkten Haendler (Affiliate, Preis unveraendert). Finds the cheapest current price in Germany for E-Roller across Amazon, eBay and AliExpress; returns best price, price trend, filter attributes and a direct link.

  Connector

• amzscout_find_by_brand

  AMZScout Skill + MCP

  List products under a specific Amazon brand. Pre-validates the brand name via cached AI check, then filters keyword-search results to rows whose `brand` field actually matches. On no-match, returns the brands that did appear in the keyword pool so callers can suggest alternatives. How to use: assess the brand's Amazon footprint — lineup breadth, price range, which products carry the revenue, and how strong its review moat is.

  Connector

• check_url

  Affilio Link Tools

  Check the health and destination of a URL (link checker / redirect resolver). Follows the redirect chain, returns the final resolved URL, HTTP status codes, page title, and — for Amazon and AliExpress product pages — whether the product is still available (in stock / not deleted). Use this tool when the user needs to: - Verify an affiliate or product link still works (not broken / 404 / dead) - Resolve where a short or redirecting link actually lands - Check whether an Amazon/AliExpress product is still available - Inspect the redirect chain of a URL Returns: finalUrl (str): The final URL after following all redirects title (str): The destination page's title (or empty string) redirectChain (list[str]): URLs visited, in order responseCode (str): Final HTTP status code (e.g. "200", "404") lastRedirectResponseCode (str): Status of the last redirect hop, if any available (bool | null): True/False for Amazon/AliExpress product pages, null when availability is not applicable Powered by Affilio.link — smart affiliate link management.

  Connector

• get_channel_orders_overview

  zobrx

  Order volume across the workspace's connected non-Amazon marketplaces (Snapdeal, Flipkart, Myntra, JioMart, Meesho). Returns the order count synced per channel — use it to see which marketplaces have data and their relative scale.

  Connector

• as_overview

  Ripe Stat

  "Who owns AS[N]" / "AS[number] info" / "what company is ASN [X]" / "Cloudflare / Google / Amazon ASN" — summary for an Autonomous System Number (ASN): holder organization, country, AS type (transit / content / IXP), allocation date. Pass "AS15169" or "15169". Use for network attribution, BGP analysis.

  Connector

• get_restock_suggestions

  Sorsa

  What the user should reorder now. Per-SKU sales velocity vs stock on hand -> days of cover left, a suggested reorder quantity and its potential profit. Call for 'what should I restock?' or 'what's running low?'. lead_time_days = how long a resupply takes to land; cover_days = days of stock the reorder should provide. Requires a connected Amazon account.

  Connector

• get_aged_stock

  Sorsa

  Age profile of the user's on-hand FBA stock, bucketed by days on shelf (0-30, 31-90, 91-180, 181-365, 365+), with capital tied up and how much is aged 90+ days (long-term storage-fee risk). Call for 'what stock is old or at risk?' or 'how much capital is stuck in aged inventory?'. Requires a connected Amazon account.

  Connector

• start_wholesale_scan

  Sorsa

  Start a Wholesale Scanner run against a supplier price list. Each item in `products` is a dict with 'title', 'price' (cost per unit), and 'ean' (barcode — needed to match, the default scan is EAN-based). Up to 500 items. Matches each product to Amazon and returns profit/ROI. Returns a job_id — poll get_wholesale_status(job_id) for results. Premium feature.

  Connector