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
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
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)
- Push to GitHub
- Connect to Vercel
- 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 numberssubtract
- Subtract two numbersmultiply
- Multiply two numbersget_posts
- Fetch posts from JSONPlaceholder APIget_tool_usage_stats
- View usage statisticsget_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-restartnpm run vercel-dev
- Vercel development servernpm run deploy
- Deploy to Vercelnpm run inspector
- MCP Inspector onlynpm run web
- Web dashboard only