任务管理服务器

AI Client (Claude/Kiro/etc)
    ↓ SSE (Server-Sent Events)
MCP Server (Cloudflare Workers)
    ↓
Database (Cloudflare D1 - SQLite)
    ↓
Cron Jobs (Every 5 minutes)
    ↓
Email Service (Resend/SendGrid)

git clone https://github.com/chenjiahui-offical/mcp-todo-server.git
cd mcp-todo-server
npm install

# Install Wrangler CLI
npm install -g wrangler

# Login to Cloudflare
wrangler login

# Create D1 database
wrangler d1 create mcp-todo-db

# Update wrangler.toml with the database_id from above

# Initialize database
wrangler d1 execute mcp-todo-db --remote --file=./schema.sql

# Set secrets
echo "your_resend_api_key" | wrangler secret put SMTP_PASS
echo "noreply@yourdomain.com" | wrangler secret put SMTP_FROM_EMAIL

# Deploy
npm run deploy

{
  "mcpServers": {
    "todo": {
      "url": "https://your-worker.workers.dev/sse",
      "transport": "sse",
      "env": {
        "USER_EMAIL": "your-email@example.com",
        "USER_TIMEZONE": "Asia/Shanghai"
      }
    }
  }
}

Add a task:
- Title: Complete project report
- Description: Include data analysis and conclusions
- Deadline: tomorrow at 3 PM
- Remind me 1 hour before
- Priority: high
- Tags: work, important

Show all my pending tasks

Change the deadline of "Complete project report" to next Friday at 5 PM

Mark "Complete project report" as completed

CREATE TABLE users (
    email TEXT PRIMARY KEY,
    timezone TEXT NOT NULL DEFAULT 'UTC',
    created_at INTEGER NOT NULL
);

CREATE TABLE todos (
    id TEXT PRIMARY KEY,
    user_email TEXT NOT NULL,
    title TEXT NOT NULL,
    description TEXT,
    deadline_utc INTEGER NOT NULL,
    remind_before_minutes INTEGER NOT NULL DEFAULT 60,
    priority TEXT DEFAULT 'medium',
    tags TEXT,
    is_completed INTEGER DEFAULT 0,
    is_expired INTEGER DEFAULT 0,
    reminder_sent INTEGER DEFAULT 0,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL,
    FOREIGN KEY (user_email) REFERENCES users(email)
);

name = "mcp-todo-server"
main = "src/index.ts"
compatibility_date = "2024-01-01"

[[d1_databases]]
binding = "DB"
database_name = "mcp-todo-db"
database_id = "your-database-id"

[triggers]
crons = ["*/5 * * * *"]  # Every 5 minutes

[vars]
SMTP_HOST = "api.resend.com"
SMTP_PORT = "443"
SMTP_FROM_NAME = "MCP Todo Reminder"

npm run dev

./scripts/test-api.sh http://localhost:8787

wrangler tail

wrangler d1 execute mcp-todo-db --remote --command "SELECT * FROM todos"

mcp-todo-server/
├── src/
│   ├── index.ts          # MCP server entry point
│   ├── db.ts             # Database operations
│   ├── email.ts          # Email sending
│   ├── cron.ts           # Scheduled tasks
│   ├── timezone.ts       # Timezone utilities
│   └── types.ts          # TypeScript types
├── scripts/
│   ├── setup.sh          # Setup automation
│   └── test-api.sh       # API testing
├── schema.sql            # Database schema
├── wrangler.toml         # Cloudflare config
├── package.json          # Dependencies
└── README.md             # This file

# Check database ID in wrangler.toml
wrangler d1 list

# Verify tables exist
wrangler d1 execute mcp-todo-db --remote --command "SELECT name FROM sqlite_master WHERE type='table'"

# Check logs
wrangler tail

# Verify email service configuration
# Check src/email.ts implementation