Modern Todo MCP Server with Authentication, Database & Billing

A complete Model Context Protocol (MCP) server that demonstrates modern web development practices with authentication, billing, and database integration. Perfect for beginners learning full-stack development!

What This Project Does

This project creates a Todo Management System that you can interact with through Cursor AI (or any MCP-compatible client). It includes:

• Real Authentication with Kinde
• Billing System with free tier limits
• Database Storage with Neon PostgreSQL
• AI Integration through MCP protocol
• Web Interface for authentication

Key Features

• 5 Free Todos for new users
• Upgrade to Paid for unlimited todos
• Real Authentication with Google/social login
• Database Persistence with PostgreSQL
• AI Chat Integration through Cursor
• Session Management with secure cookies

Architecture Overview

┌─────────────────┐    ┌──────────────────┐    ┌─────────────────┐
│   Cursor AI     │    │   MCP Server     │    │  Kinde Auth     │
│   (Your Chat)   │◄──►│   (This Project) │◄──►│   (Authentication)│
└─────────────────┘    └──────────────────┘    └─────────────────┘
                              │
                              ▼
                       ┌──────────────────┐
                       │  Neon Database   │
                       │  (PostgreSQL)    │
                       └──────────────────┘

Prerequisites

Before you start, you'll need:

1. Node.js (version 18 or higher)
2. A Neon Database account (free)
3. A Kinde account (free)
4. Cursor IDE (for MCP integration)

Quick Start Guide

Step 1: Clone and Install

# Clone the repository
git clone <your-repo-url>
cd todo-mcp-server

# Install dependencies
npm install

Step 2: Set Up Environment

# Run the setup script
chmod +x setup.sh
./setup.sh

This creates a .env file with placeholder values.

Step 3: Set Up Neon Database (Free)

1. Go to neon.tech
2. Create a free account
3. Create a new database
4. Copy your connection string
5. Update your .env file:

DATABASE_URL=postgresql://your-connection-string-here

Step 4: Set Up Kinde Authentication (Free)

1. Go to kinde.com
2. Create a free account
3. Create a new application
4. Copy your credentials
5. Update your .env file:

KINDE_ISSUER_URL=https://your-domain.kinde.com
KINDE_CLIENT_ID=your_client_id
KINDE_CLIENT_SECRET=your_client_secret

Step 5: Initialize Database

# Set up database tables
npm run setup-db

Step 6: Build and Run

# Build the project
npm run build

# Start the MCP server
npm start

Project Structure

mcp-todo-rebuild/
├── src/
│   ├── server.ts              # Main MCP server
│   ├── kinde-auth-server.ts   # Authentication web server
│   └── setup-db.ts           # Database setup script
├── dist/                     # Compiled JavaScript
├── package.json              # Dependencies and scripts
├── tsconfig.json            # TypeScript configuration
├── .env                     # Environment variables (create this)
└── README.md               # This file

How It Works

1. MCP Server (src/server.ts)

• Handles AI chat commands like "create todo", "list todos"
• Manages user authentication and billing
• Connects to database for data persistence

2. Auth Server (src/kinde-auth-server.ts)

• Provides web interface for login/logout
• Handles OAuth flow with Kinde
• Automatically creates user database records

3. Database Setup (src/setup-db.ts)

• Creates necessary database tables
• Sets up indexes for performance
• Initializes user and todo schemas

How to Use

1. Start the Servers

# Terminal 1: Start MCP server
npm start

# Terminal 2: Start auth server
npm run auth-server

2. Configure Cursor

Add this to your Cursor MCP configu

... View full README on GitHub