openFDA
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Connect openFDA to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Pull U.S. FDA drug, device, and food data — adverse event reports, recalls, drug labeling, 510(k) clearances, and the NDC directory — into the PostHog Data warehouse.
An API key is optional but recommended. Without one, openFDA limits you to 1,000 requests/day per IP; with one, 120,000 requests/day. Get a free key from the openFDA API basics page.
Configuration
| Option | Type | Required |
|---|---|---|
API key (optional) | password | No |
Linking openFDA to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select openFDA
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
drug_events | Adverse event and medication error reports submitted to the FDA (FAERS). One row per safety report. | Incremental, Full refresh | receivedate | safetyreportid |
drug_labels | Structured Product Labeling (SPL) — the FDA-approved prescription and OTC drug labeling content. One row per label document. | Full refresh | — | id |
drug_ndc | National Drug Code (NDC) Directory — every drug product currently or recently marketed in the U.S. One row per product. | Full refresh | — | product_id |
drug_enforcement | Drug recall enforcement reports — recalls of drug products classified by the FDA. One row per recall. | Incremental, Full refresh | report_date | recall_number |
device_events | Medical device adverse event reports (MAUDE). One row per report of a device suspected of a death, injury, or malfunction. | Incremental, Full refresh | date_received | mdr_report_key |
device_510k | 510(k) premarket notification clearances — devices cleared by the FDA as substantially equivalent to a legally marketed device. One row per clearance. | Incremental, Full refresh | decision_date | k_number |
device_enforcement | Medical device recall enforcement reports. One row per recall. | Incremental, Full refresh | report_date | recall_number |
food_enforcement | Food recall enforcement reports. One row per recall. | Incremental, Full refresh | report_date | recall_number |
food_events | Food and cosmetic adverse event reports (CAERS). One row per report submitted to the FDA. | Incremental, Full refresh | date_created | report_number |