Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@BOM-MCPshow the bill of materials and total weight for pump ESP-001"
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.
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
Usage
MCP Server (SSE transport - default)
REST API (optional)
CLI
MCP Tools
Tool | Description |
| List all ESP pump models |
| Get complete ESP with assemblies and parts |
| Get flat BOM parts list for an ESP |
| Get BOM summary (weight, counts, critical) |
| Filter parts by category |
| List all critical parts |
| 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
Google Cloud Run Deployment
The MCP server will be available at your Cloud Run URL.
License
MIT