You will sure find the DB location for your OS in the forum. I havent tried opening the file myself but i use an extension SpecStory to backup the chats, later i can reference it with @. (Its not made by me) Built a Cursor Extension to save and share chat and composer history
Those who had that issue had too many chats, so removing some old ones in sqlite would work i guess (not a cursor internal dev)