# CMS Open Payments query

Queries Open Payments (Sunshine Act) data: payments from drug and device makers to physicians and teaching hospitals, with payer, recipient. Needs dataset id.

Queries Open Payments (Sunshine Act) data: payments from drug and device makers to physicians and teaching hospitals, with payer, recipient (NPI, specialty, address), amount, date, nature of payment and products. 2024 General Payment Data: e6b17c6a-2534-4207-a4a1-6746a14911ff (2023: fb3a65aa-c901-4a38-a813-b04b00dfa2a9). Filter on one column, e.g. covered_recipient_npi or applicable_manufacturer_or_applicable_gpo_making_payment_name.

- Tool ID: `cms/open-payments-query`
- Provider: [CMS](/providers/cms.md)
- Capability: [Knowledge & research](/tools/knowledge.md)
- Price: no charge per call
- Authentication: an authorised Agentik workspace is required for execution, including zero-price tools.

## Pricing contract

No charge per call. A workspace is still needed so your agent can call it.


```json
{
  "model": "per_call",
  "amountUsd": 0
}
```

## Complete input schema


```json
{
  "type": "object",
  "properties": {
    "dataset_id": {
      "type": "string",
      "pattern": "^[0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12}$",
      "description": "Open Payments dataset UUID, e.g. 'e6b17c6a-2534-4207-a4a1-6746a14911ff' (2024 general payments)"
    },
    "filter_property": {
      "type": "string",
      "pattern": "^[a-z0-9_]{1,80}$",
      "description": "Column to filter, e.g. 'covered_recipient_npi'"
    },
    "filter_operator": {
      "type": "string",
      "enum": [
        "=",
        "<>",
        "<",
        "<=",
        ">",
        ">=",
        "like",
        "contains",
        "starts with"
      ],
      "description": "Condition operator (default '='), e.g. '='"
    },
    "filter_value": {
      "type": "string",
      "minLength": 1,
      "maxLength": 120,
      "description": "Value to match, e.g. '1376549477' or 'Novo Nordisk Inc'"
    },
    "sort_property": {
      "type": "string",
      "pattern": "^[a-z0-9_]{1,80}$",
      "description": "Column to sort by, e.g. 'total_amount_of_payment_usdollars'"
    },
    "sort_order": {
      "type": "string",
      "enum": [
        "asc",
        "desc"
      ],
      "description": "Sort order, e.g. 'desc'"
    },
    "count": {
      "type": "boolean",
      "default": false,
      "description": "Also return the total match count (slow on broad filters), e.g. true"
    },
    "limit": {
      "type": "integer",
      "minimum": 1,
      "maximum": 50,
      "default": 10,
      "description": "Rows to return, e.g. 10"
    },
    "offset": {
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000,
      "default": 0,
      "description": "Rows to skip, e.g. 10"
    }
  },
  "required": [
    "dataset_id"
  ],
  "additionalProperties": false,
  "dependencies": {
    "filter_property": [
      "filter_value"
    ],
    "filter_value": [
      "filter_property"
    ],
    "filter_operator": [
      "filter_property"
    ],
    "sort_order": [
      "sort_property"
    ]
  }
}
```

## Published example

This is the provider tool’s published example. Replace example values with the user’s requested inputs, respecting the schema; do not execute an example merely to test a connection.


```json
{
  "tool_id": "cms/open-payments-query",
  "input": {
    "dataset_id": "e6b17c6a-2534-4207-a4a1-6746a14911ff",
    "filter_property": "covered_recipient_npi",
    "filter_value": "1376549477",
    "limit": 2
  }
}
```

## Execute and retrieve

Inspect again before execution, explain the price and obtain the required authority. Use MCP run_tool or POST /v1/run with this tool ID, valid input and an idempotency key. Save the returned run ID and follow the actual state. If Agentik answers that the tool is temporarily unavailable, do not retry it blindly; use discovery to propose an alternative.

A partial or uncertain result can still have consumed provider resources. Consult [billing](/docs/billing.md), [idempotency](/docs/idempotency.md) and [asynchronous results](/docs/async.md).

Licence: US Government public data (public domain).

Attribution: Data from CMS Open Payments (openpaymentsdata.cms.gov).

[Provider documentation](https://openpaymentsdata.cms.gov/about/api)

[REST inspection](https://api.agentik.cc/v1/tools/cms/open-payments-query) · [OpenAPI](/openapi.json) · [Connection guide](/connect.md)

---

[HTML page](/providers/cms/open-payments-query) · [Agent index](/llms.txt)