Trader Journal MCP

AI-powered trading analytics and coaching platform built with FastAPI, SQLite, and MCP.

Overview

Trader Journal MCP helps traders discover their trading edge by analyzing historical trades and exposing insights through an MCP server that can be used by AI assistants.

Instead of only recording trades, the system identifies:

• Best-performing strategies
• Best-performing setups
• Emotional trading patterns
• Drawdown and recovery metrics
• Trading expectancy
• Risk-reward performance
• Behavioral mistakes such as revenge trading and overtrading

The ultimate goal is to provide an AI Trading Coach that helps traders improve decision-making based on real historical data.

---

Architecture

MT5 CSV ↓ Importer ↓ SQLite Database ↓ Analytics Engine ↓ FastAPI API ↓ MCP Server ↓ AI Assistant

---

Features

Performance Analytics

• Trading Summary
• Expectancy Analysis
• Risk-Reward Analysis
• Monthly Performance
• Drawdown Analysis
• Equity Curve

Behavioral Analytics

• Revenge Trading Detection
• Overtrading Detection

Context Analytics

• Pair Performance
• Session Performance
• Day of Week Analysis
• Trade Duration Analysis
• Strategy Performance
• Emotion Performance
• Setup Performance
• Strategy + Emotion Analysis

AI Trading Coach

The AI coach combines all analytics and identifies:

• Strongest trading edge
• Weakest trading behavior
• Best strategy
• Best setup
• Best emotional state
• Personalized recommendations

---

API Endpoints

Performance

• GET /api/v1/performance/summary
• GET /api/v1/performance/expectancy
• GET /api/v1/performance/risk-reward
• GET /api/v1/performance/drawdown
• GET /api/v1/performance/equity-curve
• GET /api/v1/performance/coach

Behavior

• GET /api/v1/behavior/revenge-trading
• GET /api/v1/behavior/overtrading

Context

• GET /api/v1/context/pairs
• GET /api/v1/context/sessions
• GET /api/v1/context/days
• GET /api/v1/context/duration
• GET /api/v1/context/strategies
• GET /api/v1/context/emotions
• GET /api/v1/context/setups
• GET /api/v1/context/monthly
• GET /api/v1/context/strategy-emotions

---

MCP Tools

Performance

• get_summary()
• get_expectancy()
• get_risk_reward()
• get_monthly_performance()
• get_drawdown_analysis()
• get_equity_curve()

Behavior

• detect_revenge_trading()
• detect_overtrading()

Context

• get_session_analysis()
• get_strategy_performance()
• get_emotion_performance()
• get_setup_performance()
• get_strategy_emotion_performance()

AI Coach

• analyze_my_edge()

---

Tech Stack

• Python
• FastAPI
• SQLite
• SQLAlchemy
• Pandas
• FastMCP
• HTTPX

---

Future Roadmap

• Live MT5 integration
• Automated trade journaling
• Equity curve visualizations
• AI trade reviews
• Trade screenshots
• RAG-powered trading memory
• Portfolio analytics
• Multi-account support
• Telegram integration
• Voice-based trading coach

---

Author

Cephars Bonacci