simple-mcp-server

FullPokerFace/simple-mcp-server

3.2

If you are the rightful owner of simple-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

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

Tools
  1. add

    Add two numbers

  2. subtract

    Subtract two numbers

  3. multiply

    Multiply two numbers

  4. get_posts

    Fetch posts from JSONPlaceholder API

  5. get_tool_usage_stats

    View usage statistics

  6. get_tool_usage_history

    View recent usage history

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

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