Which integrations are available for this server?

Included as a web framework dependency for potential future HTTP transport capabilities in the MCP server. Used as the runtime environment for the MCP server with SDK support via @modelcontextprotocol/sdk. Used for package management and script execution for installing dependencies and starting the server. Provides database integration allowing for SQL query execution, user management operations (create, read, update, delete), and custom database interactions.

How do I use DB & Calculator MCP Server?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@DB & Calculator MCP Server calculate the average age of users in the database" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

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.)

Related MCP server: Database MCP Server

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

F

license - not found

-

quality - not tested

How are these scores calculated?

Resources

GitHub Repository

Need Help?

Report Issue

Related Servers

DB & Calculator MCP Server