MCP Demo Server

Example Use Cases

• 1

  Query organization and device records from a local PostgreSQL-backed MCP server for testing or demonstration.

• 2

  Compute geographic distances between devices and their associated organization addresses (Haversine-based) to support location-aware decisions.

• 3

  A simple, locally runnable MCP endpoint to integrate with developer tools (e.g., Claude Desktop) or to prototype device-management workflows.

Description

This repository provides a demo implementation of a Model Context Protocol (MCP) server that connects to a PostgreSQL database to manage organizations and devices. It includes utilities to fetch organizations and devices, list devices by organization, and calculate distances using the Haversine formula. The project is intended as a developer/demo tool to run locally or integrate with local tools like Claude Desktop for testing and exploration. It includes SQL schema/seed data and configuration examples for quick setup.

Capabilities(2 total)