# Makefile for XLSX MCP Server
.PHONY: help install dev-install format lint test dev mcp-info serve-http serve-sse test-http clean
PYTHON ?= python3
HTTP_PORT ?= 9017
HTTP_HOST ?= localhost
help: ## Show help
@awk 'BEGIN {FS=":.*?## "} /^[a-zA-Z_-]+:.*?## / {printf "%-18s %s\n", $$1, $$2}' $(MAKEFILE_LIST)
install: ## Install in editable mode
$(PYTHON) -m pip install -e .
dev-install: ## Install with dev extras
$(PYTHON) -m pip install -e ".[dev]"
format: ## Format (black + ruff --fix)
black . && ruff --fix .
lint: ## Lint (ruff, mypy)
ruff check . && mypy src/xlsx_server
test: ## Run tests
pytest -v --cov=xlsx_server --cov-report=term-missing
dev: ## Run FastMCP server (stdio)
@echo "Starting XLSX FastMCP server (stdio)..."
$(PYTHON) -m xlsx_server.server_fastmcp
mcp-info: ## Show stdio client config snippet
@echo '{"command": "python", "args": ["-m", "xlsx_server.server_fastmcp"], "cwd": "'$(PWD)'"}'
serve-http: ## Run with native FastMCP HTTP
@echo "Starting FastMCP server with native HTTP support..."
@echo "HTTP endpoint: http://$(HTTP_HOST):$(HTTP_PORT)/mcp/"
@echo "API docs: http://$(HTTP_HOST):$(HTTP_PORT)/docs"
$(PYTHON) -m xlsx_server.server_fastmcp --transport http --host $(HTTP_HOST) --port $(HTTP_PORT)
serve-sse: ## Run with mcpgateway.translate (SSE bridge)
@echo "Starting with translate SSE bridge..."
@echo "SSE endpoint: http://$(HTTP_HOST):$(HTTP_PORT)/sse"
@echo "HTTP endpoint: http://$(HTTP_HOST):$(HTTP_PORT)/"
$(PYTHON) -m mcpgateway.translate --stdio "$(PYTHON) -m xlsx_server.server_fastmcp" --host $(HTTP_HOST) --port $(HTTP_PORT) --expose-sse
test-http: ## Basic HTTP checks
curl -s http://$(HTTP_HOST):$(HTTP_PORT)/ | head -20 || true
curl -s -X POST -H 'Content-Type: application/json' \
-d '{"jsonrpc":"2.0","id":1,"method":"tools/list","params":{}}' \
http://$(HTTP_HOST):$(HTTP_PORT)/ | head -40 || true
clean: ## Remove caches
rm -rf .pytest_cache .ruff_cache .mypy_cache __pycache__ */__pycache__ *.egg-info build/ dist/