Simple MCP Server

A Model Context Protocol (MCP) server implementation with SQLite database logging and web dashboard.

Features

• Math Tools: Add, subtract, multiply numbers

• API Tools: Fetch data from external APIs (JSONPlaceholder)

• Database Tools: View usage statistics and history

• Web Dashboard: Monitor tool usage at localhost:8000

• SQLite Logging: Automatic logging of all tool usage with execution times

Related MCP server: DB & Calculator MCP Server

Deployment

Vercel (Recommended)

1. Push to GitHub

2. Connect to Vercel

3. Deploy automatically

Local Development

# Install dependencies
npm install

# Run all services (MCP server, Inspector, Web dashboard)
npm run dev

# Run individual services
npm run inspector  # MCP Inspector
npm run web       # Web dashboard only
npm start         # MCP server only

Usage

Claude Desktop Configuration

Local Usage:

{
  "mcpServers": {
    "simple-mcp-server": {
      "command": "node",
      "args": ["/absolute/path/to/index.js"]
    }
  }
}

Vercel Usage:

{
  "mcpServers": {
    "simple-mcp-server": {
      "command": "curl",
      "args": [
        "-X", "POST",
        "-H", "Content-Type: application/json",
        "-d", "@-",
        "https://your-app.vercel.app/api/mcp"
      ]
    }
  }
}

Available Tools

• add - Add two numbers

• subtract - Subtract two numbers

• multiply - Multiply two numbers

• get_posts - Fetch posts from JSONPlaceholder API

• get_tool_usage_stats - View usage statistics

• get_tool_usage_history - View recent usage history

Web Dashboard

Access at https://your-app.vercel.app/ to view:

• Usage statistics

• Recent tool usage history

• Real-time monitoring

Project Structure

├── api/                  # Vercel API routes
│   ├── mcp.js           # MCP server endpoint
│   └── web/             # Web dashboard APIs
├── mcp/                 # MCP implementation
│   ├── tools/           # Tool implementations
│   ├── database/        # Database logic
│   └── resources/       # MCP resources
├── public/              # Web dashboard
└── index.js            # Local MCP server

Development

• Node.js: 18.x or higher

• Database: SQLite (auto-created)

• Framework: MCP TypeScript SDK

Scripts

• npm run dev - All services with auto-restart

• npm run vercel-dev - Vercel development server

• npm run deploy - Deploy to Vercel

• npm run inspector - MCP Inspector only

• npm run web - Web dashboard only