Pipeworx Data Analyst

Connect to 252 data sources and 1008+ tools through one gateway. Ask questions in plain English — Pipeworx picks the right tool, fills the arguments, and returns real data.

Setup

{
  "mcpServers": {
    "pipeworx": {
      "url": "https://gateway.pipeworx.io/mcp"
    }
  }
}

How to use

Ask anything

Call ask_pipeworx with a question. The gateway finds the right API and returns the answer.

• "What is the US trade deficit with China?"
• "What are the side effects of ozempic?"
• "What's the weather in Tokyo?"
• "Get Apple's latest 10-K filing"
• "Find cybersecurity government contracts"

Find specific tools

Call discover_tools with a description to browse what's available.

Scope to a domain

Add ?task= to the URL for focused sessions with only relevant tools:

• gateway.pipeworx.io/mcp?task=housing+market
• gateway.pipeworx.io/mcp?task=international+trade
• gateway.pipeworx.io/mcp?task=drug+safety+research

Remember context

Use remember and recall to save findings across tool calls.

Compound tools

These combine multiple APIs into one call:

| Tool | Description | |------|-------------| | trade_bilateral_analysis | Complete bilateral trade analysis between two countries in one call. Combines Comtrade trade flows ( | | trade_country_profile | Comprehensive trade profile for a country — top 10 import/export partners and top 10 import/export c | | trade_macro_dashboard | US trade macro indicators dashboard — customs revenue, exchange rates, trade balance, monthly trends | | fintech_company_deep_dive | Complete company financial analysis in one call — SEC filings (10-K), stock quote, company overview, | | fintech_bank_health_check | Bank health assessment — FDIC institution lookup, financials, recent industry failures, consumer com | | fintech_market_snapshot | Financial market conditions dashboard — CFPB complaint trends, FDIC banking industry summary, and op | | pharma_drug_profile | Complete drug dossier in one call — FDA approvals, drug labels, adverse events, RxNorm properties, d | | pharma_pipeline_scan | Clinical trial pipeline analysis — by condition (e.g., "lung cancer", "Alzheimer") or by sponsor (e. | | pharma_safety_report | Drug safety assessment — adverse event reports, top reaction types, recall history, and drug-drug in | | govcon_contractor_profile | Complete government contractor dossier — SAM.gov entity registration, federal award history (USAspen | | govcon_opportunity_scan | Government contracting opportunity search — open SAM.gov opportunities, set-aside contracts (8(a), H | | govcon_agency_landscape | Federal agency contracting landscape — spending overview, recent awards, SBIR program stats, and spe | | housing_market_snapshot | Get a national housing market snapshot — 30-year mortgage rates, housing starts, Case-Shiller home p | | housing_property_report | Complete property analysis combining ATTOM data — property details, automated valuation (AVM), sales | | housing_rental_analysis | Rental market analysis for a property and area — estimated rent (ATTOM), fair market rents (HUD, if | | housing_affordability_check | Check housing affordability metrics — current mortgage rate (national), median home price (national) | | housing_employment_outlook | Labor market indicators relevant to housing — total nonfarm employment, construction employment, res | | housing_signal_scan | Comprehensive housing market signal scan — checks 45+ indicators for reversals, unusual moves, accel |

Response metadata

Every response includes _meta with cost breakdown, cache status, next-step suggestions, and error alternatives.