`fr_decp_contract_stats`

Pack: fr-decp · Connect: https://pipeworx.io/mcp (see Connect below for a single-pack URL)

No MCP client? Call it directly: GET https://gateway.pipeworx.io/v1/tools/fr_decp_contract_stats for the schema, then POST the same URL with its arguments for the data.

Aggregate French public-contract AWARD counts (DECP), grouped by one dimension, over the same filters as fr_decp_search_contracts (buyer, supplier, CPV, department, amount range, date range, keyword). Answers “which departments/regions/CPV codes/buyer types won the most French public contracts matching X” without pulling every matching row. Returns one row per group value with its contract count, sorted by count descending.

Parameters

Name	Type	Required	Description
`group_by`	string	yes	Dimension to group by: acheteur_departement_nom (buyer department), acheteur_region_nom (buyer region), acheteur_categorie (buyer type, e.g. Commune/Région), titulaire_categorie (supplier size category, e.g. PME/ETI/GE), titulaire_departement_nom (supplier department), codeCPV (CPV code), procedure (award procedure), type (Travaux/Fournitures/Services).
`keyword`	string	no	Free-text filter within the contract object (objet).
`buyer_name`	string	no	Substring match on the awarding buyer’s name.
`buyer_siret`	string	no	Exact SIRET/SIREN of the awarding buyer.
`supplier_name`	string	no	Substring match on the awarded supplier’s name.
`supplier_siret`	string	no	Exact SIRET of the awarded supplier.
`cpv_code`	string	no	CPV code, exact or leading-digits prefix.
`department_code`	string	no	French department code of the awarding buyer.
`min_amount`	number,string	no	Minimum contract amount in euros.
`max_amount`	number,string	no	Maximum contract amount in euros.
`date_from`	string	no	Earliest notification date, inclusive, YYYY-MM-DD.
`date_to`	string	no	Latest notification date, inclusive, YYYY-MM-DD.
`limit`	number,string	no	Number of group rows to return (1-100). Default 20.

Example call

Arguments

{
  "group_by": "acheteur_departement_nom",
  "keyword": "informatique",
  "limit": 5
}

curl

curl -X POST https://gateway.pipeworx.io/fr-decp/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"fr_decp_contract_stats","arguments":{"group_by":"acheteur_departement_nom","keyword":"informatique","limit":5}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('fr_decp_contract_stats', {
  "group_by": "acheteur_departement_nom",
  "keyword": "informatique",
  "limit": 5
});

Response shape

Field	Type	Description
`error`	string

Full JSON Schema

{
  "type": "object",
  "properties": {
    "error": {
      "type": "string"
    }
  },
  "additionalProperties": true
}

Connect

Add this to your MCP client config — every tool in the catalog, including this one — or use one-click install buttons:

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

Connect to just the fr-decp pack

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

See Getting Started for client-specific install steps.

fr_decp_contract_stats