mertadali_mcp_server_openai_chat

mertadali_mcp_server_openai_chat

by mertadali
An AI-powered todo assistant integrating OpenAI's API and Google Calendar for natural language task management.

AI-Powered Todo Assistant with Google Calendar Integration

A modern, AI-powered todo list and calendar management application that combines OpenAI's Assistant API with Google Calendar integration. Built with TypeScript and featuring both MCP (Model Context Protocol) and traditional API endpoints.

Todo Assistant Main Screen

Todo Assistant Approval Screen

Todo Google Calendar Screen

🌟 Key Features

  • AI-Powered Chat Interface: Natural language interaction using OpenAI's GPT-3.5 Turbo
  • Smart Todo Management: Add, remove, list, and toggle todos using natural language
  • Google Calendar Integration: Seamlessly sync todos with Google Calendar
  • Multi-Language Support: Full support for English and Turkish
  • Tool Approval System: Secure approval workflow for sensitive operations
  • MCP (Model Context Protocol): Standardized AI tool interactions
  • Responsive Design: Modern, mobile-friendly web interface
  • Persistent Storage: SQLite database for reliable data management

🛠️ Technical Stack

Backend

  • Node.js with Express
  • TypeScript
  • SQLite (via better-sqlite3)
  • OpenAI Assistant API
  • Google Calendar API

Frontend

  • HTML5 & CSS3
  • Modern JavaScript
  • Responsive Design

AI & Integration

  • OpenAI GPT-3.5 Turbo
  • Model Context Protocol (MCP)
  • OAuth 2.0 for Google Calendar

📋 Prerequisites

  • Node.js (v16 or higher)
  • npm or yarn
  • OpenAI API key
  • Google Cloud Console account
  • SQLite

🚀 Getting Started

  1. Clone the Repository
    shell git clone https://github.com/yourusername/todo-assistant.git cd todo-assistant

  2. Install Dependencies
    shell npm install

  3. Environment Setup Create a .env file in the root directory:
    dotenv OPENAI_API_KEY=your_openai_api_key PORT=3000 CLIENT_ID=your_google_client_id CLIENT_SECRET=your_google_client_secret GOOGLE_REDIRECT_URI=http://localhost:3000/google/callback

  4. Build and Run
    ```shell
    # Build TypeScript
    npm run build

# Start server
npm start

# Development mode with auto-reload
npm run dev

# Start with MCP enabled
npm run dev:mcp
```

🗄️ Database Structure

Todos Table

CREATE TABLE todos (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    text TEXT NOT NULL,
    completed BOOLEAN NOT NULL DEFAULT 0,
    createdAt TEXT NOT NULL
)

Calendar Events Table

CREATE TABLE calendar_events (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    todoId INTEGER NOT NULL,
    title TEXT NOT NULL,
    date TEXT NOT NULL,
    time TEXT NOT NULL,
    createdAt TEXT NOT NULL,
    FOREIGN KEY (todoId) REFERENCES todos(id) ON DELETE CASCADE
)

🔌 API Endpoints

Traditional REST API

  • POST /api/thread - Create/get user thread
  • POST /api/chat - Send/receive messages
  • GET /api/history/:userId - Get chat history
  • POST /api/tool-response - Handle tool approvals

MCP Endpoints

  • POST /mcp - Main MCP interaction endpoint
  • GET /mcp/health - Health check
  • GET /mcp/tools - Available tools listing

💡 Usage Examples

English Commands

"Add 'Buy groceries' to my todo list"
"Show all my todos"
"Mark todo #3 as complete"
"Add 'Team meeting' to calendar for tomorrow at 2pm"
"Show my calendar events for next week"

Turkish Commands

"Alışveriş yapmayı listeye ekle"
"Tüm görevlerimi göster"
"3 numaralı görevi tamamlandı olarak işaretle"
"Yarın saat 14:00'da takım toplantısını takvime ekle"
"Gelecek haftaki takvim etkinliklerimi göster"

🔒 Security Features

  • Tool approval workflow for sensitive operations
  • OAuth 2.0 authentication for Google Calendar
  • Secure credential management
  • Input validation and sanitization

🌐 Google Calendar Setup

  1. Go to Google Cloud Console
  2. Create a new project or select existing
  3. Enable Google Calendar API
  4. Configure OAuth 2.0 credentials:
  5. Set application type as "Web application"
  6. Add authorized redirect URI: http://localhost:3000/google/callback
  7. Download credentials and update .env file

🤝 Contributing

  1. Fork the repository
  2. Create your feature branch (git checkout -b feature/AmazingFeature)
  3. Commit your changes (git commit -m 'Add some AmazingFeature')
  4. Push to the branch (git push origin feature/AmazingFeature)
  5. Open a Pull Request

📝 License

This project is licensed under the MIT License - see the LICENSE file for details.

🙏 Acknowledgments

  • OpenAI for their powerful Assistant API
  • Google Calendar API team
  • Contributors and testers

📞 Support

For support, please open an issue in the GitHub repository or contact the maintainers.

About

AI-powered todo assistant with Google Calendar integration using OpenAI's API and Model Context Protocol (MCP) support for natural language task management.

Topics

ai mcp llm

Resources

Readme

License

MIT license

Activity

Stars

1 star

Watchers

1 watching

Forks

0 forks

Report repository

Releases


No releases published

Packages 0


No packages published

Languages

Features & Capabilities

Categories
mcp_server model_context_protocol typescript javascript openai google_calendar ai task_management api_integration

Implementation Details

Stats

0 Views
1 GitHub Stars

Repository Info

mertadali Organization

Similar MCP Servers

continuedev_continue by continuedev
25049
21423
9300