The headache after lumbar puncture is common (~30%) and is not migraine headache. The mechanism is not entirely clear but likely involves a drop of cerebrospinal fluid volume and/or pressure (PubMed):
There are two possible explanations. Firstly, the low CSF
[cerebrospinal fluid] volume depletes the cushion of fluid supporting
the brain and its ...