Construction Cost Calculator MCP Server

A no-auth MCP (Model Context Protocol) server that provides construction cost estimation tools using data from a public Google Sheet.

Features

No Authentication Required: Reads from a publicly accessible Google Sheet
5 Tools Available:
- list_all_items - Get all construction items
- get_item - Get details for a specific item by code
- search_items - Search items by keyword
- get_items_by_category - Filter items by category
- calculate_cost - Calculate total project cost with quantities

Data Source

The server fetches construction cost data from this Google Sheet: Construction Cost Database

Data includes:

Concrete (slabs, footings, walls, columns, stairs)
Framing (walls, floors, roofs, beams)
Finishes (drywall, paint, flooring, tile)
Electrical (wiring, panels, outlets, fixtures)
Plumbing (pipes, fixtures, water heaters)
HVAC (systems, ductwork)
Roofing (materials, installation)
Exterior (siding, windows, doors)

Local Development

Prerequisites

Python 3.11+
pip

Setup

Clone the repository:

cd construct_cost_calc

Create a virtual environment:

python -m venv venv
source venv/bin/activate  # On Windows: venv\Scripts\activate

Install dependencies:

pip install -r requirements.txt

Run the server:

python server.py

The server will start on http://localhost:8000 with SSE transport.

Environment Variables

Variable	Default	Description
`GOOGLE_SHEET_ID`	`1laH5l1FjwWC5HXLp8xkG1eolwScKHIlxB6PohBWQjh0`	Google Sheet ID
`SHEET_GID`	`0`	Sheet tab GID
`CACHE_TTL_SECONDS`	`300`	Cache duration (5 min)
`DEFAULT_LABOR_RATE`	`75.0`	Default $/hour rate

Deploy to Render.com

One-Click Deploy

Manual Deploy

Push this repository to GitHub
Go to Render Dashboard
Click New → Blueprint
Connect your repository
Render will use render.yaml to configure the service

After Deployment

Your MCP server will be available at:

https://your-service-name.onrender.com/sse

Connect to Agenti AI Platform

Add the MCP server to your Agenti AI configuration:

{
  "mcpServers": {
    "construction-cost": {
      "url": "https://your-service-name.onrender.com/sse"
    }
  }
}

Tool Usage Examples

List All Items

Tool: list_all_items
Parameters: none

Get Specific Item

Tool: get_item
Parameters: {"item_code": "concrete_slab_4000psi"}

Search Items

Tool: search_items
Parameters: {"query": "drywall"}

Get Items by Category

Tool: get_items_by_category
Parameters: {"category": "concrete"}

Calculate Cost

Tool: calculate_cost
Parameters: {
  "items": [
    {"item_code": "concrete_slab_4000psi", "quantity": 2000},
    {"item_code": "framing_wall_2x4", "quantity": 500},
    {"item_code": "drywall_standard_12", "quantity": 3000}
  ],
  "labor_rate": 80.0
}

Cost Calculation Formula

Item Cost = (Material Cost × Quantity) + (Labor Hours × Quantity × Labor Rate)
Total Cost = Sum of all Item Costs

License

MIT

Construction Cost Calculator MCP