# ⚡ Pulse MCP Server — EOD Intelligence Bridge

**Pulse MCP** is an automated bridge connecting **Antigravity IDE**, **Google Sheets**, and **OpenProject**. It automatically captures daily developer activity, formats it into structured End-of-Day (EOD) reports, and synchronizes updates directly into your daily tracking sheets without needing manual git commits or complex Google Cloud OAuth.

---

## 💻 Commands Cheat Sheet (Quick Copy-Paste)

### 📌 Daily Synchronization Commands

```bash
# 1. Navigate to Pulse directory
cd /Users/apple/Desktop/AI/pulse_mcp

# ── A. Google Sheets Only (Default) ─────────────────────
# Sync TODAY'S updates to Google Sheets
PYTHONPATH=. python push_updates.py

# Sync YESTERDAY'S updates to Google Sheets
PYTHONPATH=. python push_updates.py --date yesterday

# Sync a SPECIFIC past date to Google Sheets
PYTHONPATH=. python push_updates.py --date 24-Aug-2026

# ── B. Google Sheets + OpenProject (With Confirmation) ──
# Sync TODAY with interactive OpenProject confirmation preview
PYTHONPATH=. python push_updates.py --openproject

# Sync YESTERDAY with interactive OpenProject confirmation preview
PYTHONPATH=. python push_updates.py --date yesterday --openproject

# Sync a SPECIFIC past date with interactive OpenProject confirmation preview
PYTHONPATH=. python push_updates.py --date 24-Aug-2026 --openproject
```

### 🔌 Running the MCP Server (For AI Assistants)

```bash
cd /Users/apple/Desktop/AI/pulse_mcp
source /Users/apple/Desktop/AI/env/bin/activate
python server/main.py
```

### 🧪 Diagnostics & Verification

```bash
# Test Google Apps Script Webhook connection
curl -L "https://script.google.com/macros/s/AKfycbw8D0l54OojfO3zFzpdf9Gpx616tgx0jj9Cuzhk4Htj4hZoZ6H4TD3M5E212uJGGM8/exec"

# Run full test suite
pytest tests/
```

---

## 🏗️ Architecture

```text
 ┌─────────────────────────────────────────────────────────┐
 │                  Antigravity IDE Brain                  │
 │  ~/.gemini/antigravity-ide/brain/<conversation-id>/     │
 │  • task.md (- [x] checklists)                           │
 │  • walkthrough.md (Features & Accomplishments)          │
 │  • Workspace modified files (.py, excel, configs)       │
 └────────────────────────────┬────────────────────────────┘
                              │
                              ▼
 ┌─────────────────────────────────────────────────────────┐
 │                    Pulse MCP Engine                     │
 │  1. Ingests session tasks & file modifications          │
 │  2. Classifies projects (FLA, AI, TrueClaim, etc.)      │
 │  3. Summarizes with local Qwen 2.5 / Ollama AI          │
 │  4. Formats into clean point-wise bullets               │
 │  5. Checks duplicates via SQLite audit store            │
 └─────────────┬─────────────────────────────┬─────────────┘
               │                             │
               ▼                             ▼
 ┌───────────────────────────┐ ┌───────────────────────────┐
 │       Google Sheets       │ │        OpenProject        │
 │  • Smart Date Search      │ │  • Work Packages          │
 │  • Column-aware insertion │ │  • Daily comments & logs  │
 │  • Zero-OAuth Webhook     │ │  • Status tracking        │
 └───────────────────────────┘ └───────────────────────────┘
```

---

## 🌟 Key Features

* **🧠 Direct Antigravity Ingestion:** Extracts completed checklists (`task.md`) and verified changes (`walkthrough.md`) directly from your Antigravity IDE brain sessions.
* **🔀 Hybrid Mode (Antigravity + File Modifications):** If you coded directly in the workspace without an Antigravity task list, it automatically inspects modified `.py` and dataset files from that day.
* **📊 Smart Google Sheets Webhook:** Locates the date row (e.g. `21-Aug-2026`) in your sheet regardless of column location and updates the task column smoothly. Bypasses Google Cloud service account restrictions.
* **📅 Historical & Past Date Sync:** Supports updating missed or historical dates (`--date yesterday`, `--date 21-Aug-2026`).
* **🤖 Local AI Summarization:** Integrates with local Ollama (`qwen2.5-coder:7b`) to convert developer notes into executive-friendly summaries.
* **🗃️ Local SQLite Audit Trail:** Tracks all synchronization records in `database/pulse.db` to prevent duplicate submissions.

---

## 🛠️ MCP Tools Reference

When running as an active MCP server, Pulse exposes the following tools to AI assistants:

| Tool                                     | Description                                                                                                   |
| ---------------------------------------- | ------------------------------------------------------------------------------------------------------------- |
| **`sync_eod`**                   | Ingests Antigravity session data, categorizes projects, generates summaries, and syncs to Sheets/OpenProject. |
| **`generate_eod_summary`**       | Generates a preview of today's categorized EOD report without writing to destinations.                        |
| **`read_antigravity_artifacts`** | Reads and parses`task.md`, `walkthrough.md`, and plans from the Antigravity local brain.                  |
| **`google_sheets_append_eod`**   | Directly appends or updates an EOD entry to a specific Google Sheet tab.                                      |
| **`record_daily_activity`**      | Manually records a custom activity item into the local SQLite store.                                          |
| **`get_daily_activity`**         | Queries logged activities for a given date from SQLite.                                                       |
| **`get_sync_status`**            | Returns synchronization audit logs and verification status.                                                   |
| **`list_projects`**              | Lists mapped projects and their keyword classification rules.                                                 |
| **`openproject_*`**              | Tools for searching projects, creating work packages, and adding daily progress comments.                     |

---

## ⚙️ Environment Configuration (`.env`)

Create or edit your `.env` file in the root directory:

```ini
# Google Sheets Webhook Configuration
GOOGLE_SHEET_ID=1NPdY9u-wb548d89Co-WeqHv6slgoegZ0
GOOGLE_SHEET_DEFAULT_GID=1431037120
GOOGLE_APPS_SCRIPT_URL=https://script.google.com/macros/s/AKfycbw8D0l54OojfO3zFzpdf9Gpx616tgx0jj9Cuzhk4Htj4hZoZ6H4TD3M5E212uJGGM8/exec

# Local AI / Ollama Configuration (Optional)
OLLAMA_URL=http://198.162.112.2:11434/api/generate
OLLAMA_MODEL=qwen2.5-coder:7b

# OpenProject Configuration
OPENPROJECT_URL=http://4.188.80.194
OPENPROJECT_API_KEY=your_openproject_api_token
OPENPROJECT_ASSIGNEE_NAME=Vidit Khairkar
OPENPROJECT_ASSIGNEE_ID=5

# Local SQLite & Brain Storage
PULSE_DB_PATH=/Users/apple/Desktop/AI/pulse_mcp/database/pulse.db
ANTIGRAVITY_BRAIN_DIR=/Users/apple/.gemini/antigravity-ide/brain
```

---

## 📁 Project Structure

```text
pulse_mcp/
├── .env                       # Environment credentials & endpoints
├── push_updates.py            # CLI script for 1-click EOD sync
├── database/
│   ├── db.py                  # SQLite database wrapper & migrations
│   └── models.py              # Pydantic data schemas
├── server/
│   ├── main.py                # FastMCP server entrypoint
│   ├── connectors/
│   │   ├── antigravity.py     # Local brain parser (task.md, walkthrough.md)
│   │   ├── google_sheets.py   # Webhook-based Google Sheets client
│   │   └── openproject.py     # OpenProject REST API client
│   ├── services/
│   │   ├── sync_engine.py     # Core EOD aggregation & orchestrator
│   │   ├── project_mapper.py  # Keyword-based project classification
│   │   └── summarizer.py      # EOD report formatter
│   └── tools/                 # FastMCP registered tools
└── README.md                  # Documentation & Commands
```