openfda_dataframe_describe

Active

declared in 0.4.0

List the tables and column schemas on a DataCanvas staged by an openFDA search tool. Call before openfda_dataframe_query to discover the exact table name, column names, and DuckDB types needed for valid SQL. row_count is the full staged result set, not the inline preview count. Columns typed JSON hold nested openFDA objects/arrays — query them with DuckDB json functions.

Parameters schema

{
  "type": "object",
  "$schema": "http://json-schema.org/draft-07/schema#",
  "required": [
    "canvas_id"
  ],
  "properties": {
    "canvas_id": {
      "type": "string",
      "description": "Canvas ID from an openFDA search tool response."
    }
  }
}

What this tool wraps· 2 endpoints

min confidence0.70 0.50

Data resourceopenFDA API
FDA · science
name mention0.85
Data resourceDuckDB
DuckDB Labs · database
name mention0.65

Parent server

@cyanheads/openfda-mcp-server

https://github.com/cyanheads/openfda-mcp-server

2/7 registries

View full server →