BOM-MCP

Electric Submersible Pump (ESP) Parts and Bill of Materials (BOM) database with MCP server for AI assistants.

Features

• SQLite database with ESP parts, assemblies, and units
• MCP server (SSE transport) for AI assistants
• Command-line interface
• REST API server (optional)

Installation

pip install -r requirements.txt

Usage

MCP Server (SSE transport - default)

python run_mcp.py --port 8080

REST API (optional)

python api.py [port]  # Default port: 5000

CLI

python cli.py esp list
python cli.py esp get ESP-001
python cli.py esp bom ESP-001
python cli.py parts get ESP-MTR-001
python cli.py assemblies get ASM-MTR-001

MCP Tools

Tool	Description
list_esps	List all ESP pump models
get_esp	Get complete ESP with assemblies and parts
get_esp_bom	Get flat BOM parts list for an ESP
get_bom_summary	Get BOM summary (weight, counts, critical)
get_parts_by_category	Filter parts by category
get_critical_parts	List all critical parts
get_assembly	Get assembly with its parts
And more...

Data Model

• Parts: Individual components (part_number, name, category, material, weight_kg, is_critical, uom)
• Assemblies: Groups of parts
• ESP Units: Top-level pumps linking assemblies

Docker

Local Development

# Build and run MCP server on port 8080
docker-compose up --build

# MCP server available at http://localhost:8080

Google Cloud Run Deployment

# Deploy directly from source
gcloud run deploy bom-mcp \
  --source . \
  --platform managed \
  --region us-central1 \
  --allow-unauthenticated

The MCP server will be available at your Cloud Run URL.

License

MIT