Hello, I’m a developer using Cursor IDE.
I have a specific requirement and I’m looking for a reliable way to implement it.
I want to automatically store every prompt I enter in Cursor IDE along with the AI’s response into an Excel file, organized by:
Date (YYYY-MM-DD)
Project name
Here’s how I want the behavior to work:
-
If the project or date changes, a new Excel file should be created.
-
If the project and date are the same, new entries (prompt and response pairs) should be appended as new rows to the existing Excel file.
I discovered that on macOS, Cursor stores this data in a SQLite database located in the workspace directory. I was able to extract the data into JSON format using a custom script. However, I’m running into some issues:
The dates and project names are not always parsed correctly.
The AI responses sometimes include parts of my own prompt mixed in.
As a result, the final Excel files are not clean or reliable.
So my main question is:
Is there a reliable way to extract accurate data from Cursor’s internal database—specifically: timestamp, project name, user prompt, and AI response—without them being mixed or corrupted?
Any guidance on how to correctly parse the prompt-response structure, or tips on how Cursor formats and stores this data in its database, would be greatly appreciated.
Thanks in advance!