MCP Demo

@tanjibpa

About MCP Demo

No overview available yet

#mcp-server #model-context-protocol #server-demo

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mcp-server-demo-tanjibpa": {
      "command": "uv",
      "args": [
        "venv"
      ]
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is MCP Demo?

MCP Demo is a demo implementation of a Model Context Protocol (MCP) server that manages organizations and devices, calculates distances between devices and their associated organizations using the Haversine formula, and provides tools for interacting with the data via a PostgreSQL database.

How to use MCP Demo?

Set up a PostgreSQL database, clone the repository, configure environment variables in a .env file, and run uv run main.py. Optionally, configure Claude Desktop by editing its MCP server config to point to the project directory, then use tools like get_organizations, get_devices, get_devices_by_organization, and list_devices_with_distance.

Key features of MCP Demo

Connects to a PostgreSQL database for managing organizations and devices.
Calculates distances using the Haversine formula.
Provides MCP tools to fetch organizations, devices, and distances.
Includes a SQL script for database schema and seed data.
Configurable for use with Claude Desktop.

Use cases of MCP Demo

Demonstrating how an MCP server can interact with a relational database.
Exploring distance calculations between devices and their organization locations.
Testing MCP tool integration with a desktop client like Claude.

FAQ from MCP Demo

What are the runtime requirements?

Python 3.12.5 and a PostgreSQL database are required.

How do I set up the database?

Run the provided tables.sql script against your PostgreSQL instance after configuring the .env file.

How is the distance calculation performed?

It uses the Haversine formula to calculate distances between devices and their associated organizations.

Can I use MCP Demo with Claude Desktop?

Yes, by adding an MCP server entry in Claude Desktop's configuration file pointing to the project directory and setting the required environment variables.

What dependencies are needed?

The server depends on httpx, mcp[cli], and psycopg2.

Frequently asked questions

What are the runtime requirements?

Python 3.12.5 and a PostgreSQL database are required.

How do I set up the database?

Run the provided `tables.sql` script against your PostgreSQL instance after configuring the `.env` file.

How is the distance calculation performed?

It uses the Haversine formula to calculate distances between devices and their associated organizations.

Can I use MCP Demo with Claude Desktop?

Yes, by adding an MCP server entry in Claude Desktop's configuration file pointing to the project directory and setting the required environment variables.

What dependencies are needed?

The server depends on `httpx`, `mcp[cli]`, and `psycopg2`.

Comments

Basic information

More Other MCP servers

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K