Migrate existing data to EdgeDB

[mitselek]

Overview

Import existing filesystem-based data into the new EdgeDB-backed MCP system.

Data Sources

Applications (applications/)

• REGISTRY.md - main index with status, dates, notes
• Individual application folders with CVs, cover letters, correspondence

Knowledge Base (knowledge_base/)

• Experience files with YAML frontmatter
• Skills, achievements, education entries
• Existing tag/classifier relationships

Migration Strategy

1. Parse REGISTRY.md to extract application metadata
2. Walk application directories for documents and correspondence
3. Parse knowledge_base .md files with frontmatter
4. Insert into EdgeDB using MCP tools or direct EdgeDB client

Acceptance Criteria

• All REGISTRY.md entries imported as Applications
• All correspondence files linked to correct applications
• All knowledge_base entities imported with tags
• compile() produces equivalent _compiled_context.md
• No data loss verified

Dependencies

• Set up EdgeDB infrastructure with Docker #36 (EdgeDB infrastructure)
• Implement Applications MCP server #37 (Applications MCP)
• Implement Knowledge Base MCP server #38 (Knowledge Base MCP)

Notes

This can be a one-time migration script, doesn't need to be part of ongoing system.