Pharma TrailPharma Trail
← search

Use it from any AI (MCP)

Pharma Trail exposes its data through a read-only MCP server. MCP is an open standard, so you can connect any MCP-capable assistant — Claude, ChatGPT, Cursor, VS Code Copilot, and others — to the live dataset and ask in plain English. It writes the SQL, runs it, and builds charts. Same public CMS data as the site.

Endpoint
https://br-wild-smoke-ajj9b4o9-mcp.compute.c-3.us-east-2.aws.neon.tech/mcp
Streamable HTTP transport · read-only · no credentials needed · public data.
Connect
Any MCP client
Add a custom / remote MCP server and paste the endpoint URL above (transport: HTTP / Streamable HTTP). No API key — it’s public and read-only.
Claude Codeclaude mcp add --transport http pharma-trail https://br-wild-smoke-ajj9b4o9-mcp.compute.c-3.us-east-2.aws.neon.tech/mcp
Claude Desktop / claude.ai
Settings → Connectors → Add custom connector → paste the URL → enable Artifacts (for charts). (Custom connectors need a paid Claude plan.)
ChatGPT / Cursor / VS Code
Add it as a remote MCP server in the app’s connector/MCP settings and paste the URL.
Things to ask
  • “Look up Dr. John Smith — payments and prescribing vs unpaid peers.”
  • “For each drug, average claims for paid vs unpaid prescribers — and chart it.”
  • “Top 10 cardiologists by Eliquis payments, with their claim counts.”
  • “Show the Ozempic payment dose-response and confirm metformin has zero payments.”
  • “Which manufacturers paid the most for Xarelto?”
The server exposes read-only tools (run_query,find_doctor,list_tables) over the rx database, and ships schema + charting instructions on connect. It cannot write or modify anything.