Skip to main content
Glama
Proflores MCP Server

Proflores MCP Server

by jjesusaf

Proflores MCP Server

Servidor MCP (Model Context Protocol) para el sistema de presupuestos de Proflores.

Stack

  • Python 3.12

  • MCP SDK (mcp[cli]>=1.26.0) con transporte Streamable HTTP

  • Supabase como base de datos

  • Deploy en Render (Docker)

Related MCP server: Supabase MCP Server

Estructura

mcp-server/
├── src/
│   ├── server.py                # Entry point
│   ├── tools/
│   │   ├── catalogs.py          # 8 tools de lectura de catálogos
│   │   ├── budget.py            # 6 tools de presupuestos
│   │   └── catalog_write.py     # 6 tools de escritura de catálogos
│   ├── resources/
│   │   └── schema.py            # 2 resources (schema del sistema)
│   ├── prompts/
│   │   └── budget.py            # 2 prompts para flujos guiados
│   └── services/
│       ├── supabase_client.py   # Singleton del cliente Supabase
│       └── helpers.py           # to_json, resolve_uuid
├── requirements.txt
├── Dockerfile
├── render.yaml
├── .env.example
└── .gitignore

Setup local

cp .env.example .env
# Editar .env con tus credenciales de Supabase

python -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt

python src/server.py

El servidor estará disponible en http://localhost:8000/mcp/.

Tools disponibles (20)

Lectura de catálogos (8)

Tool

Descripción

list_companies

Lista empresas registradas

list_clients

Lista o busca clientes

list_projects

Lista proyectos con filtros

list_concepts

Lista conceptos (partidas de obra)

list_resources

Lista recursos (materiales, mano de obra, equipo)

list_units_of_measure

Lista unidades de medida

list_price_lists

Lista listas de precios

list_suppliers

Lista proveedores

Presupuestos (6)

Tool

Descripción

list_budgets

Lista presupuestos existentes

get_budget_detail

Detalle completo de un presupuesto

create_budget

Crea un presupuesto vacío (DRAFT)

add_budget_item

Agrega una partida a un presupuesto

update_budget

Actualiza campos de un presupuesto

update_budget_item

Actualiza una partida

Escritura de catálogos (6)

Tool

Descripción

create_client

Crea un nuevo cliente

create_concept

Crea un concepto (partida de obra)

create_apu

Crea un APU (Análisis de Precio Unitario)

add_apu_item

Agrega un recurso a un APU

create_resource

Crea un recurso (material, mano de obra, equipo)

set_resource_price

Asigna precio a un recurso en una lista de precios

Resources

  • schema://system-overview — Visión general del sistema

  • schema://budget-structure — Estructura de tablas de presupuestos

Prompts

  • budget_creation_assistant — Guía paso a paso para crear presupuestos

  • budget_review — Guía para revisar un presupuesto existente

Variables de entorno

Variable

Descripción

SUPABASE_URL

URL del proyecto Supabase

SUPABASE_SERVICE_ROLE_KEY

Service role key de Supabase

MCP_HOST

Host del servidor (default 0.0.0.0)

MCP_PORT

Puerto del servidor (default 8000)

Deploy

El proyecto está configurado para deploy en Render con Docker. Ver render.yaml.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    Related MCP Connectors

    • Bloom MCP server for ChatGPT, Claude and any AI agent: create lead, create project, send invoice, send contract and record payment in your own Bloom account. Cotlet works in the account through your Cloud Browser, a real Chrome where you sign in to Bloom yourself; Cotlet does not store your password and you need no Bloom API key. About the official Bloom API: Bloom publishes no public API or developer docs; its only connection is a Zapier app with triggers such as new lead or new payment (checked 8 Nov 2026). It has no official MCP server. Setup and FAQ: https://cotlet.dev/integrations/bloom-api-mcp-server

      https://cotlet.dev/mcp/v1/bloom
    • Procore MCP server for ChatGPT, Claude and any AI agent: list RFIs, create RFI, list submittals, create punch list item, create observation and add manpower entry in your own Procore account. Cotlet works in the account through your Cloud Browser, a real Chrome where you sign in to Procore yourself; Cotlet does not store your password and you need no Procore API key. About the official Procore API: Procore has a REST API with OAuth 2.0 and a sandbox, but publishes no MCP server for your own AI agent (checked 5 Nov 2026). The API runs through an app that you register in the Developer Portal and a company admin installs. Setup and FAQ: https://cotlet.dev/integrations/procore-api-mcp-server

      https://cotlet.dev/mcp/v1/procore
    • Joist MCP server for ChatGPT, Claude and any AI agent: create estimate, convert estimate to invoice, list invoices, add client and record payment in your own Joist account. Cotlet works in the account through your Cloud Browser, a real Chrome where you sign in to Joist yourself; Cotlet does not store your password and you need no Joist API key. About the official Joist API: Joist has no public API (checked 26 Oct 2026): its help center and pricing page document none, and there are no webhooks. The only built-in link out is QuickBooks Sync, part of Joist Pro, which copies issued estimates and invoices to QuickBooks Online once a night. Setup and FAQ: https://cotlet.dev/integrations/joist-api-mcp-server

      https://cotlet.dev/mcp/v1/joist
    • Contractor Foreman MCP server for ChatGPT, Claude and any AI agent: create estimate, add daily log, create change order, update schedule, list invoices and get job costing in your own Contractor Foreman account. Cotlet works in the account through your Cloud Browser, a real Chrome where you sign in to Contractor Foreman yourself; Cotlet does not store your password and you need no Contractor Foreman API key. About the official Contractor Foreman API: Contractor Foreman has no public API (checked 11 Oct 2026). Its only programmatic access is a Zapier app with 7 triggers for leads, customers and file uploads, and 2 actions: Create Lead and Create Customer. Setup and FAQ: https://cotlet.dev/integrations/contractor-foreman-api-mcp-server

    Related MCP Servers

    • A
      license
      B
      quality
      B
      maintenance
      Enables AI assistants to access and manage Streamline tasks, notes, tags, and workspaces via a Supabase-powered backend. It supports full CRUD operations, allowing users to search, create, update, and organize their productivity data through natural language.
      17
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      Provides secure access to Supabase databases via PostgREST API and management tools for projects, schemas, branches, logs, and code generation.
      MIT
    • A
      license
      B
      quality
      C
      maintenance
      Enables MCP clients to interact with a live Progresso workspace for board, CRM, projects, and time tracking via Supabase.
      15
      MIT
    • A
      license
      Not graded
      quality
      B
      maintenance
      Enables AI assistants to search and manage construction project economic data, including unit price analyses, resource catalogs, budget trees, and price lists, with secure multi-tenant access.
      MIT