FichaPao MCP Server

HTTP MCP server for the FichaPao AI agent to control bakery technical sheets with Postgres.

The goal of this app is to provide secure tools for the agent, without exposing raw SQL.

Architecture

OpenWebUI
  -> Agente FichaPao AI
  -> MCP HTTP /mcp
  -> fichapao-mcp-server
  -> Postgres

Related MCP server: mcp-enterprise-starter

MCP Tools

• search_recipe: search for a sheet by name.

• get_recipe: query a sheet by recipe_id, version_id, or name.

• create_recipe_draft: create a sheet in 0.1 draft status.

• update_draft: update a draft or revision version.

• create_new_version: create a new version in draft.

• approve_version: approve a version if there are no blocking pending items.

• list_pending_items: list pending items.

• register_production_test: register a production test.

• compare_versions: compare two versions.

• archive_recipe: archive a sheet.

• get_database_stats: database summary.

Implemented Rules

• New sheets always start as draft.

• Initial version is 0.1.

• Approved sheets cannot be edited directly.

• Changes to an approved sheet must become a new version in draft.

• Approval is blocked when there are critical pending items.

• First approval of a 0.x version becomes 1.0.

• The database separates:

  • current_version_id: most recent/work-in-progress version.

  • active_version_id: approved version in production.

Run Locally

cp .env.example .env
docker compose up --build

Health check:

curl http://localhost:3001/health

MCP Endpoint:

http://localhost:3001/mcp

In docker-compose.yml, the local port is mapped as 3001:3000 to avoid conflicts with common apps that already use 3000.

If MCP_API_KEY is set, send:

Authorization: Bearer sua-chave

Deploy on EasyPanel

Create two services:

1. Postgres

2. Docker app pointing to this repository

App Variables:

NODE_ENV=production
PORT=3000
DATABASE_URL=postgresql://usuario:senha@host:5432/fichapao
AUTO_MIGRATE=true
MCP_API_KEY=troque-por-uma-chave-forte
CORS_ORIGIN=*

After publishing, validate:

https://seu-dominio/health

In OpenWebUI:

Admin Settings -> External Tools -> Add MCP Server
URL: https://seu-dominio/mcp
Auth: Bearer token com o valor de MCP_API_KEY

Database

Main migration:

migrations/001_init.sql

Tables:

• recipes

• recipe_versions

• pending_items

• production_tests

• change_history

Development

npm install
npm run typecheck
npm run build
npm run dev