Is there a way to have a name or id column be added to the eval output? I would like to dump my results into a database and then query to see which tests fail the most over time

Setting the

description

property on each of your test cases. See https://www.promptfoo.dev/docs/configuration/reference/#test-case

I currently have description but when I look at the csv the description doesnt appear

Ah, you're right! Sorry about that. I've opened up a pull request to fix this – https://github.com/promptfoo/promptfoo/pull/5654 – which will get into our next release.