[Epic] Phase 3: Complete MCP Support + Lineage Awareness

[Mullassery]

Phase 3: Complete MCP Support (Weeks 6-9)

Priority: HIGH
Duration: 3-4 weeks
Estimate: 55 hours

Focus: Implement all 6 MCP tools, complete transports, add lineage awareness

Key Deliverables

• ✅ All 6 tools implemented (code-formatter, test-generator, perf-analyzer, doc-generator, security-scanner, claude-code-gen)
• ✅ Stdio & socket transports complete (not stubs)
• ✅ Query lineage awareness (dbt/Airflow)
• ✅ PrismNote as MCP server (for Cursor integration)
• ✅ 30+ comprehensive tests

Tasks

3.1 MCP Tool Implementations

• Implement code-formatter (3h)
• Implement test-generator (4h)
• Implement performance-analyzer (4h)
• Implement documentation-generator (3h)
• Implement security-scanner (4h)
• Implement claude-code-generator (3h)

3.2 MCP Transport Completion

• Complete stdio transport (4h)
• Implement socket transport (3h)
• Test all transports (3h)

3.3 Lineage & Integration

• Implement dbt model lineage (3h)
• Implement Airflow DAG integration (3h)
• Build dependency detection (2h)
• Create lineage visualization (3h)

3.4 Cursor Integration

• Create PrismNote as MCP server (4h)
• Define MCP resources & tools (2h)
• Test Cursor interoperability (3h)

3.5 Testing

• Tool-specific tests (18 tests, 6h)
• Integration test suite (4h)
• Lineage correctness tests (3h)

Success Criteria

• ✅ All 6 tools working
• ✅ Stdio/socket transports production-ready
• ✅ 30+ tests passing
• ✅ Lineage tracks dependencies
• ✅ Cursor can access PrismNote via MCP

Related

• Issue [Epic] Phase 2: Claude Tool Use & NL-to-SQL (Function Calling) #15 (Phase 2 completion prerequisite)
• Strategic Feature Analysis: Cursor Integration
• DEVELOPMENT_ROADMAP.md