Setup & Installation
Or with the ClawHub CLI, for registry-managed skill folders outside a full OpenClaw workspace:
Version History
- Added "Important Notes" section detailing security and cost considerations for embedding conversations. - Clarified that an OpenAI API key is required and shared advice on handling secrets and API key usage. - Noted that the output database does not store your API key. - Reminded users to back up prior to embedding; script refuses to overwrite existing databases. - Provided an example cost for embeddings to help users estimate expenses.
What This Skill Does
Converts exported ChatGPT conversation history into a local SQLite database with vector embeddings, then registers it as an extra memory search path in OpenClaw. After setup, OpenClaw's memory search covers both its native memory and all past ChatGPT conversations.
Embeds conversations once into a local SQLite file, so all past ChatGPT history is queryable alongside native OpenClaw memory without re-uploading or reprocessing on each search.
When to use it
- Searching old ChatGPT conversations by topic or keyword
- Migrating from ChatGPT without losing conversation history
- Finding code snippets discussed in past ChatGPT sessions
- Building a searchable personal archive of AI conversations
- Recovering context from months-old ChatGPT threads
Example Workflow
Here's how your AI assistant might use this skill in practice.
User asks: find my old ChatGPT conversations about database indexing
- 1User exports conversations.json from ChatGPT account settings
- 2Runs convert_chatgpt.py to convert conversations into markdown files
- 3Runs bulk_embed.py with OPENAI_API_KEY to embed and store results in chatgpt-memory.sqlite
- 4Adds the SQLite path to OpenClaw config under memorySearch.extraPaths
- 5Restarts the OpenClaw gateway to load the new search path
Memory search returns matching segments from past ChatGPT conversations alongside native OpenClaw results
Requirements
Accounts, API keys, or tools you or your AI assistant may need to set up while using this skill.