DB & Calculator MCP Server

MCP Example Server

This is a Model Context Protocol (MCP) server that provides two main categories of tools:

Database Tools - For interacting with a SQLite database
Calculator Tools - For performing mathematical calculations

Features

Database Tools

query_database - Execute custom SQL queries
get_all_users - Retrieve all users with optional limit
get_user_by_id - Get a specific user by ID
add_user - Add a new user to the database
update_user - Update an existing user
delete_user - Delete a user from the database

Calculator Tools

calculate - Perform basic mathematical operations (add, subtract, multiply, divide, power, sqrt, sin, cos, tan, log, abs, round, floor, ceil)
calculate_expression - Evaluate mathematical expressions
calculate_stats - Calculate statistical measures (mean, median, variance, standard deviation, etc.)

Installation

Install dependencies:

npm install

The database will be automatically created when you first run the server.

Usage

Starting the Server

npm start

Or for development with auto-restart:

npm run dev

Database Schema

The server creates a SQLite database with the following schema:

CREATE TABLE users (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT NOT NULL,
  email TEXT UNIQUE NOT NULL,
  age INTEGER,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);

Sample data is automatically inserted when the database is first created.

Tool Examples

Database Operations

Get all users:

{
  "name": "get_all_users",
  "arguments": {}
}

Get user by ID:

{
  "name": "get_user_by_id",
  "arguments": {
    "id": 1
  }
}

Add a new user:

{
  "name": "add_user",
  "arguments": {
    "name": "John Doe",
    "email": "john@example.com",
    "age": 30
  }
}

Execute custom query:

{
  "name": "query_database",
  "arguments": {
    "query": "SELECT * FROM users WHERE age > 25"
  }
}

Calculator Operations

Basic calculation:

{
  "name": "calculate",
  "arguments": {
    "operation": "add",
    "numbers": [5, 3]
  }
}

Evaluate expression:

{
  "name": "calculate_expression",
  "arguments": {
    "expression": "2 + 3 * 4"
  }
}

Statistical analysis:

{
  "name": "calculate_stats",
  "arguments": {
    "numbers": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10]
  }
}

Available Calculator Operations

add - Addition
subtract - Subtraction
multiply - Multiplication
divide - Division (with zero check)
power - Exponentiation
sqrt - Square root
sin - Sine function
cos - Cosine function
tan - Tangent function
log - Natural logarithm
abs - Absolute value
round - Round to nearest integer
floor - Floor function
ceil - Ceiling function

Project Structure

├── package.json
├── README.md
├── src/
│   ├── server.js      # Main MCP server
│   ├── database.js    # Database operations
│   └── calculator.js  # Calculator operations
└── data/
    └── example.db     # SQLite database (created automatically)

Error Handling

The server includes comprehensive error handling for:

Invalid SQL queries
Database connection issues
Mathematical operation errors (division by zero, invalid inputs)
Missing required parameters
Unknown tool names

Development

To modify or extend the server:

Add new tools in the setupTools() method in server.js
Implement corresponding handler methods
Update the tools list in the tools/list handler
Add any necessary database operations in database.js
Add calculator functions in calculator.js

Dependencies

@modelcontextprotocol/sdk - MCP SDK for Node.js
sqlite3 - SQLite database driver
express - Web framework (for potential future HTTP transport)

License

MIT

This server cannot be installed

security - not tested

license - not found

quality - not tested

How are these scores calculated?

A Model Context Protocol server providing tools for SQLite database operations (query, add, update, delete users) and mathematical calculations including basic arithmetic, expression evaluation, and statistical analysis.

Related MCP Servers

SQLite MCP Server
jacksteamdev
A
security
A
license
A
quality
A Model Context Protocol server that provides database interaction capabilities through SQLite, enabling users to run SQL queries, analyze business data, and automatically generate business insight memos.
Last updated -
6
9
TypeScript
MIT License
Database MCP Server
georgi-terziyski
-
security
-
license
-
quality
A Model Context Protocol server that provides tools for connecting to and interacting with various database systems (SQLite, PostgreSQL, MySQL/MariaDB, SQL Server) through a unified interface.
Last updated -
Python
SQLite MCP Server
isaacgounton
-
security
F
license
-
quality
A Model Context Protocol server that enables SQL operations (SELECT, INSERT, UPDATE, DELETE) and table management through a standardized interface with SQLite databases.
Last updated -
JavaScript
Memory MCP
drdee
-
security
A
license
-
quality
A Model Context Protocol server that allows users to store, retrieve, update, and delete memories using SQLite storage.
Last updated -
Python
MIT License

View all related MCP servers