Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type @ followed by the MCP server name and your instructions, e.g., "@TodoSQLite MCP Server Add task 'Finish report' due tomorrow"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Quản lý todo list cá nhân với lưu trữ SQLite local - hỗ trợ CRUD đầy đủ, search theo từ khóa, stateful và persistent. Lý tưởng cho AI agent productivity tool (giống Todoist mini hoặc Linear task manager).
Built with Node.js + TypeScript + FastMCP + better-sqlite3 + Zod — designed to demonstrate senior-level MCP tooling skills.
# 1. Clone / navigate to project
cd /path/to/MyMCPServer
# 2. Install dependencies
npm install
# 3. (Optional) Build to JS
npm run buildDatabase: Automatically created at
~/.todo_mcp.dbon first run. No setup needed.
Related MCP server: Tasks MCP Server
npm run devnpm run build && npm startnpm run typecheckTool | Description | Key Params |
| Add a new task |
|
| List all todos with | — |
| Toggle completed/pending by ID |
|
| Permanently delete a task by ID |
|
| Case-insensitive LIKE search |
|
CREATE TABLE todos (
id INTEGER PRIMARY KEY AUTOINCREMENT,
task TEXT NOT NULL,
completed INTEGER NOT NULL DEFAULT 0, -- 0=pending, 1=done
created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,
due_date TEXT -- ISO date e.g. "2026-03-01"
);DB file location: ~/.todo_mcp.db (configurable via TODO_DB_PATH env var)
Add this entry to your mcp_config.json:
{
"mcpServers": {
"todo-sqlite": {
"command": "npx",
"args": [
"ts-node",
"--esm",
"/absolute/path/to/MyMCPServer/src/index.ts"
],
"env": {}
}
}
}Or if using compiled JS:
{
"mcpServers": {
"todo-sqlite": {
"command": "node",
"args": ["/absolute/path/to/MyMCPServer/dist/index.js"],
"env": {}
}
}
}# Add a task due tomorrow
@todo-sqlite Thêm task "Hoàn thành MCP server cho interview" due tomorrow
# List all todos
@todo-sqlite Liệt kê tất cả todos của tôi
# Search for a keyword
@todo-sqlite Tìm kiếm task liên quan đến "interview"
# Toggle task #1 as done
@todo-sqlite Đánh dấu task #1 là hoàn thành
# Delete task #3
@todo-sqlite Xóa task #3
# Workflow: add multiple, then list
Add these tasks:
- "Review PR #42" due today
- "Update README" due 2026-03-05
- "Write unit tests" due tomorrow
Then list all todos.MyMCPServer/
├── src/
│ ├── index.ts # FastMCP server — 5 tools, Zod schemas, error handling
│ └── db.ts # SQLite layer — prepared statements, typed CRUD functions
├── dist/ # Compiled output (after npm run build)
├── .env.example # Environment variable reference
├── package.json
├── tsconfig.json
└── README.mdConcern | Approach |
SQL Injection | 100% prepared statements via |
Type safety | Full TypeScript strict mode + |
Validation | Zod schemas with |
Modularity | DB logic isolated in |
Error handling | Each tool wrapped in try/catch → friendly string messages |
Persistence | SQLite WAL mode, singleton DB connection |
Natural language dates |
|
This server cannot be deployed
AI-native task management: list, create, update and archive tasks with rich context for AI agents
Manage Superlist tasks and lists in plain language from any MCP-compatible AI agent.
Local-first task manager: create, edit, and complete tasks, projects, and checklists via MCP.
Manage tasks, Focus Zone, notes, projects, and task history from compatible AI assistants.