Todo MCP Server

A simple MCP (Model Context Protocol) server for managing todo items with SQLite database storage.

Features

• Add new todo items
• List all todo items
• Remove todo items by ID

Setup

1. Install dependencies:

   npm install
   

2. Configure database location (optional):

   Open src/database.ts and modify the DB_LOCATION variable to your preferred location:

   // Examples:
   // - Windows: "C:/todos"
   // - macOS: join(homedir(), "todos")
   // - Linux: "/home/username/todos" or join(homedir(), "todos")
   // - Current directory: join(process.cwd(), "data")
   const DB_LOCATION = "C:/todos";

3. Build the project:

   npm run build
   

Database

The application uses SQLite for data storage. By default, the database file is created at C:/todos/todos.db. You can change this location by modifying the DB_LOCATION variable in src/database.ts.

The database and its directory will be automatically created if they don't exist.

Available Tools

add-todo

Adds a new todo item to the list.

Parameters:

• text (string): The text content of the todo item

Example:

add-todo(text: "Buy groceries")

get-todos

Lists all todo items.

Example:

get-todos()

remove-todo

Removes a todo item by its ID.

Parameters:

• id (number): The ID of the todo item to remove

Example:

remove-todo(id: 1)

Development

This project is built with:

• TypeScript
• better-sqlite3 for database operations
• MCP SDK for the server implementation