• REGIONAL
  • HOSPITAL
  • COMPANY
  • HUMAN

How to analyze medical industry spending trends with your AI

Connect your AI to the CMS Open Payments database. Once linked, your agent can scan datasets to find specific payment patterns.

Ask AI about this page

Short answer

How can I track medical payment patterns with AI?

Your AI accesses CMS Open Payments datasets to isolate spending by region, hospital, or manufacturer. You get filtered results that highlight specific distribution trends. This breakdown shows how to move from raw data to insights.

Data outcomes

What you can extract from the data

The AI processes raw CMS files into organized findings.

REGIONAL

Geographic spending maps

The AI filters datasets to show which states or cities receive the most payments. You see exactly where manufacturer funds are concentrated.

HOSPITAL

Teaching hospital patterns

Query specific teaching hospitals to see their total receipts from medical companies. This identifies high-volume recipients in the healthcare system.

COMPANY

Manufacturer footprints

Isolate a single company to see how they spread payments across different medical specialties. You get a clear view of their distribution strategy.

HUMAN

Compliance review

The AI identifies the trends, but you must perform the final audit. You decide if the patterns suggest a conflict of interest or standard business practice.

The workflow

What your AI does when the data arrives.

Your agent acts as a data analyst, navigating the CMS structure to find what you need.

  1. Locate datasets

    Your AI scans the available CMS Open Payments files to find the specific years or categories you want to study.

    list_datasets

  2. Access files

    Once the right files are identified, the AI pulls the raw data into its context for analysis.

    get_dataset

  3. Filter and aggregate

    The AI runs logic against the data to group payments by hospital name, zip code, or manufacturer.

    query_dataset

  4. Summarize findings

    The AI translates the rows of numbers into a plain English summary of the spending trends it found.

    query_dataset

Try it

Copy these to start.

Use these prompts to begin your analysis immediately.

Starting points

Swap out the bracketed terms for the specific hospital or company you are investigating.

Open Payments (CMS) Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_PFgVygzxyWx8tBYJnrB993CjxJkqslxBuj7JwmHP/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — Open Payments (CMS) capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "open-payments-cms-physician-data-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_PFgVygzxyWx8tBYJnrB993CjxJkqslxBuj7JwmHP/mcp"
    }
  }
}
Copy into chat04

  • List all available Open Payments datasets so I can see which years are covered.

  • Query the dataset to find the total payments made to teaching hospitals in California last year.

  • Get the dataset for 2023 and show me the top five pharmaceutical companies by total payment amount.

  • Find all payments made to physicians in the New York City area from specific medical device manufacturers.

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect Open Payments (CMS Physician Data) once, then ask.

Just click the link to connect. Your credentials stay encrypted, and you can start querying the CMS data through your preferred AI client right away.

Connect Open Payments (CMS Physician Data) to your AI

FAQ

How this task behaves

  • 01

    Can the AI change the data in the CMS database?

    No. The AI only has read access to the datasets via the tools provided.

  • 02

    Can I export the results to an Excel file?

    The AI can format the data as a table or CSV text for you to copy, but it cannot directly write or save files to your local hard drive.

  • 03

    Does the AI handle the data cleaning?

    Yes. The AI uses the query tool to filter out irrelevant rows and aggregate the numbers for you.

  • 04

    Can the AI make decisions about medical compliance?

    No. The AI identifies patterns and provides data, but all compliance and legal conclusions must be made by you.

  • 05

    How does the AI find specific hospitals?

    It uses the query tool to search the dataset for specific names or identifiers within the physician and hospital records.

  • More questions about Open Payments (CMS Physician Data)? The Connector page answers them. See everything the Open Payments (CMS Physician Data) Connector can do

Connect Open Payments (CMS) to Claude, Cursor, ChatGPT & more