A set of tools to extract and analyze chat logs from Cursor's SQLite databases.
This repository contains the following Python scripts:
- find_dbs.py - Find Cursor database files in common locations
- list_conversations.py - List all conversations in a database
- extract_conversation.py - Extract and analyze a specific conversation
./find_dbs.pyThis will search for Cursor's SQLite databases in the common locations.
./list_conversations.py /path/to/database.vscdbThis will list all conversations found in the specified database.
./extract_conversation.py /path/to/database.vscdb CONVERSATION_ID [output_dir]This will extract the specified conversation, analyze its content, and generate a terse report.
Here's a complete workflow:
# Find databases
./find_dbs.py
# List conversations in the first database
./list_conversations.py ~/Library/Application\ Support/Cursor/User/globalStorage/state.vscdb
# Extract a specific conversation
./extract_conversation.py ~/Library/Application\ Support/Cursor/User/globalStorage/state.vscdb b6030831-dc69-4fae-b0b0-071b04e2757a ~/chat_logs/Cursor stores its data in different locations depending on your operating system:
~/Library/Application Support/Cursor/
Key subdirectories:
User/globalStorage/state.vscdb- Main database containing chat historyUser/workspaceStorage/<workspace-hash>/- Workspace-specific dataextensions/- Installed extensionslogs/- Application logs
%APPDATA%/Cursor/
Expected subdirectories follow a similar structure to macOS:
User/globalStorage/state.vscdb- Main databaseUser/workspaceStorage/<workspace-hash>/- Workspace dataextensions/- Installed extensions
$HOME/.config/Cursor/
Or:
$XDG_CONFIG_HOME/Cursor/
Similar structure to other platforms:
User/globalStorage/state.vscdb- Main databaseUser/workspaceStorage/<workspace-hash>/- Workspace dataextensions/- Installed extensions
-
The
state.vscdbfile is a SQLite database containing:- Chat history
- Workspace state
- Editor preferences
- Debug configurations
-
The
workspaceStoragedirectory contains workspace-specific data:- Each workspace gets a unique hash
- Contains workspace-specific settings and state
- May include temporary files and caches
-
Backup Considerations:
- Back up the entire Cursor directory to preserve all settings
- The
state.vscdbfile is particularly important as it contains chat history - Consider excluding the
extensionsdirectory from backups (can be reinstalled) - Workspace storage can be large; consider selective backup
-
Security Note:
- The database may contain sensitive information from chats
- Consider encrypting backups
- Be cautious when sharing database files
- Review chat content before sharing
-
Migration:
- W 529E hen moving to a new machine, copy the entire Cursor directory
- Extensions will need to be reinstalled on the new machine
- Some paths may need to be updated in workspace settings
For more detailed analysis of your chat history, you can use the tools in this repository to extract and analyze the conversations stored in the state.vscdb file.
To contribute to this project, please create a pull request on GitHub. The repository is available at: GitHub - CursorChatAnalyzer
MIT