openfda_dataframe_query
Run read-only SQL over a result set staged on a DataCanvas (opt-in)
How to use it
openfda_dataframe_query is exposed by the Openfda MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the openfda_dataframe_query tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.
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