openfda_dataframe_query
Run read-only SQL over a result set staged on a DataCanvas (opt-in)
How to use it
Project documentation lists openfda_dataframe_query for the Openfda MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), then check which tools your installed version makes available. Tool availability can depend on configuration and credentials. A server handshake does not verify this tool’s behavior. See the full listing for setup details.
FULL OPENFDA MCP SERVER LISTINGOther tools in Openfda MCP Server (14)
Aggregate and tally unique values for any field across any openFDA endpoint
List tables and column schemas staged on a DataCanvas (opt-in)
Return searchable field paths for an openFDA endpoint, grouped by category
One drug name → consolidated FDA profile: identity, label, adverse events, recalls, approval, shortage
Look up FDA drug labeling (package inserts / SPL documents)
Look up drugs in the NDC (National Drug Code) Directory
Search adverse event reports across drugs, food, and devices
Search adverse event reports for veterinary drugs and devices
Search FDA device premarket notifications — 510(k) clearances and PMA approvals
Search the Drugs@FDA database for NDA/ANDA application approvals
Search FDA drug shortage records — status, availability, therapeutic category, manufacturer
Search enforcement reports and recall actions across drugs, food, and devices
Search problem reports for tobacco products, e-cigarettes, and vaping devices
narrows each record to the requested keys plus metadata (openfda, setid, id, effectivetime, version); a selection over the budget is returned whole, never trimmed, with its serialized size reported