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 itemsget_item- Get details for a specific item by codesearch_items- Search items by keywordget_items_by_category- Filter items by categorycalculate_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.yamlto 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