<<<<<<< HEAD

🚀 MCP Task Notes Server

<p align="center"> A production-style Model Context Protocol (MCP) server for AI-powered task and note management using Python and SQLite. </p>

---

📌 Overview

MCP Task Notes Server is a lightweight local MCP server built using Python FastMCP that enables AI assistants to interact with task and note management tools through the Model Context Protocol (MCP).

The server provides structured tools for creating, retrieving, updating, searching, and deleting tasks and notes while maintaining persistent data storage using SQLite.

This project demonstrates how modern AI applications can securely interact with custom backend services through MCP.

---

✨ Key Features

📋 Task Management

• Create new tasks
• Retrieve task lists
• Search tasks by keyword
• Mark tasks as completed
• Delete tasks
• Filter tasks based on status:
  • All
  • Pending
  • Completed
  • Overdue

📝 Note Management

• Create personal notes
• Retrieve saved notes
• Search notes
• Delete notes
• Support note tagging

🗄️ Data Persistence

• SQLite-based local storage
• Automatic database initialization
• Clean database abstraction layer
• Structured SQL schema management

🤖 MCP Integration

• Built with FastMCP framework
• Exposes reusable AI tools
• Compatible with MCP-enabled AI clients
• Designed for AI agent workflows

---

🏛️ Architecture

                 AI Application
                      |
                      |
              Model Context Protocol
                      |
                      |
              FastMCP Server Layer
                      |
        --------------------------------
        |                              |
     server.py                    database.py
        |                              |
        --------------------------------
                      |
                  SQLite Database
                      |
              tasks_notes.db

---

🧰 Tech Stack

Technology	Purpose
Python 3.x	Backend Development
FastMCP	MCP Server Framework
SQLite	Database Storage
SQL	Database Management
MCP Protocol	AI Tool Communication

---

📂 Project Structure

mcp-task-notes-server/
│
├── server.py
│   └── MCP server implementation
│
├── database.py
│   └── SQLite database operations
│
├── schema.sql
│   └── Database table definitions
│
├── README.md
│
├── .gitignore
│
└── .venv/
    └── Python virtual environment

---

⚙️ Installation & Setup

1. Clone Repository

git clone https://github.com/<username>/mcp-task-notes-server.git

Navigate into the project:

cd mcp-task-notes-server

---

2. Create Virtual Environment

python -m venv .venv

Activate environment:

Windows

.venv\Scripts\activate

---

3. Install Dependencies

pip install mcp[cli]

---

▶️ Running the MCP Server

Start the server:

python server.py

Successful startup:

Database initialized
Starting Task Notes MCP Server...

---

🛠️ MCP Tools Available

Task Tools

Tool	Description
add_task	Create a new task
list_tasks	Retrieve tasks
complete_task	Update task status
delete_task	Remove a task
search_tasks	Search tasks

---

Note Tools

Tool	Description
add_note	Create a note
list_notes	Retrieve notes
search_notes	Search notes
delete_note	Remove notes

---

🔍 Testing with MCP Inspector

Install MCP CLI:

pip install mcp[cli]

Launch inspector:

mcp dev server.py

MCP Inspector allows testing:

• Available tools
• Tool inputs
• Tool responses
• Server communication

---

🗃️ Database Design

Tasks Table

Column	Description
id	Unique identifier
title	Task title
due_date	Task deadline
priority	Task priority
status	Task status
completed_at	Completion timestamp
created_at	Creation timestamp

Notes Table

Column	Description
id	Unique identifier
title	Note title
content	Note details
tags	Note categories
updated_at	Last update timestamp

---

🔐 Design Principles

• Separation of concerns
• Modular backend architecture
• Local-first data storage
• Reusable MCP tools
• Clean database abstraction

---

🚀 Future Enhancements

• REST API integration using FastAPI
• Web dashboard interface
• Authentication and authorization
• Cloud database migration
• Docker containerization
• AI-based task prioritization
• Notification and reminder system

---

🎓 Skills Demonstrated

Through this project:

✔ MCP Server Development
✔ Python Backend Engineering
✔ SQLite Database Management
✔ AI Tool Integration
✔ Software Architecture Design
✔ API-Oriented Development

---

👨‍💻 Author

Mercy

BCA Final Year Student

Interested in:

• Artificial Intelligence
• Python Development
• Backend Engineering
• MCP & AI Agent Systems

---

=======

mcp-task-notes-server

df0852c29a922ffcd2296d1d90263173064339f6