Skip to content

Migration gaps: Entity mapping and documentation needed before wider adoption #61

@TomerFi

Description

@TomerFi

Opening this issue per @ilan-pinto's request.

I'm on board with adopting Ghost, but while attempting to integrate my own automation tooling, I discovered several gaps that should be addressed before migration can proceed smoothly.


Issues Identified

1. Missing low-level documentation

The README covers setup and lists MCP tools, but there's no documentation for:

  • Entity definitions and data model
  • How log_activity relates to manual reports
  • Architecture for AI agents to understand the system

2. Unclear entity definitions

The relationship between log_activity entries (which auto-attach to reports) and manually-created reports (with free-form text) is confusing. It's not clear when to use which, or how they relate to each other.

3. No migration path from existing system

The old system routes reports to managers based on Category → Initiative → Project. Ghost routes based on Team membership. There's no documented mapping between these concepts, and no clear equivalent for Epic and Achievements in Ghost's data model.

4. Limited manager adoption

Currently only one manager is using Ghost. For projects managed by other managers (e.g., NIM Integration), we still need to use the old Google Form workflow. This means we need a clear path for integration tools that can work with both systems simultaneously.


How I discovered this

I have my own automation tool for weekly reports. I forked this repo to integrate the two - allowing my agent to push reports directly to Ghost. That's when I discovered the entity mismatch: there's no clear mapping between the old system's components (Category/Initiative/Project/Epic/Achievements) and Ghost's data model.


Suggested next steps

  • Document the intended data model and entity relationships (for humans and AI agents)
  • Define migration path from Category/Initiative/Project to Ghost's Field/Project hierarchy
  • Clarify the role of log_activity vs manual report entries
  • Document integration path for external tools during the transition period

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions