MCP Local Database Server

A Model Context Protocol (MCP) server for managing tasks with a MySQL database.

Features

• Full CRUD operations for tasks

• Progress/status transition tracking with timestamps

• Filter and search capabilities

• Automatic timestamp management

Prerequisites

• Node.js 18+

• MySQL Server running locally

Database Schema

Tasks Table

Task Progress History Table

Installation

cd mcp-localdb
npm install

MySQL Configuration

Edit src/config.js to set your MySQL credentials:

export const dbConfig = {
  host: "localhost",
  port: 3306,
  user: "root",
  password: "your_password",
  database: "tasks"
};

Or use environment variables:

• MYSQL_HOST - MySQL host (default: localhost)

• MYSQL_PORT - MySQL port (default: 3306)

• MYSQL_USER - MySQL user (default: root)

• MYSQL_PASSWORD - MySQL password

• MYSQL_DATABASE - Database name (default: tasks)

Available Tools

create_task

Create a new task with name, description, assignee, and status.

get_task

Retrieve a specific task by ID.

list_tasks

List all tasks with optional filters (status, assigned_to, assigned_by).

update_task

Update task fields. Status changes are automatically tracked in history.

delete_task

Delete a task by ID.

get_task_progress_history

Get the complete status transition history for a task.

search_tasks

Search tasks by name or description.

Configuration

Add to your MCP client configuration (e.g., Claude Desktop):

{
  "mcpServers": {
    "mcp-localdb": {
      "command": "node",
      "args": [
        "/Users/manoj-13035/Documents/manoj/MCP/mcp-localdb/src/index.js"
      ]
    }
  }
}

Usage Examples

Create a Task

{
  "task_name": "Implement login feature",
  "task_description": "Add user authentication with OAuth",
  "assigned_by": "John",
  "assigned_to": "Jane",
  "status": "pending"
}

Update Task Status

{
  "task_id": 1,
  "status": "in_progress",
  "progress_notes": "Started working on the feature"
}

List Tasks by Status

{
  "status": "in_progress",
  "limit": 10
}

License

MIT