Skip to main content
Glama
macola-mcp

macola-mcp

by Banidan

macola-mcp

An unofficial MCP server for the Macola 10 REST API. It lets Claude (or any MCP client) look up and, if you allow it, update your Macola data: customers, contacts, addresses, customer orders, inventory, prices, purchase orders, GL accounts and more. 88 tools in all.

Not affiliated with or endorsed by ECI Software Solutions. "Macola" is a trademark of its owner. This project contains no Macola code or documentation; it only calls the REST API that your own licensed Macola 10 installation provides.

Highlights

  • Windows sign-in, no stored password. Each request is made as the Windows user running the MCP client (Kerberos), so people get their own Macola rights and Macola records changes under their own name.

  • Read-only by default in the desktop extension. Turn it off only when you want Claude to create, change or delete records.

  • One-click install for Claude Desktop (.mcpb extension): no Node.js, Git or scripts needed on the PC.

Related MCP server: mcp-epicor

Requirements

  • Macola 10 with the REST API installed (built against Macola 10.7; check http://<server>/Macola/api/docs/index).

  • A Windows 10 (1803+) or Windows 11 PC joined to the same domain as the Macola server. The built-in curl.exe does the sign-in.

  • Each user needs Macola rights for what they look up or change (see Troubleshooting).

Install (Claude Desktop)

  1. Download macola.mcpb from Releases, or build it yourself (below).

  2. Double-click it (or Claude Desktop → Settings → Extensions → Install Extension).

  3. Enter your Macola server name, e.g. ERPSERVER (it becomes http://ERPSERVER/Macola/api). Use the server's name, not its IP address; Kerberos needs the name. A full address such as https://erp.example.local/Macola/api also works.

  4. Leave Read-only on until you're comfortable.

Install (any MCP client, manual)

git clone <this repo> && cd macola-mcp
npm install && npm run build

Then add it to your client's config, for example Claude Desktop's %APPDATA%\Claude\claude_desktop_config.json:

{
  "mcpServers": {
    "macola": {
      "command": "node",
      "args": ["C:\\path\\to\\macola-mcp\\dist\\index.js"],
      "env": {
        "MACOLA_SERVER": "YOUR-MACOLA-SERVER",
        "MACOLA_AUTH": "windows",
        "MACOLA_READONLY": "true"
      }
    }
  }
}

Other MCP clients

It runs as a local (stdio) MCP server, so it works with any client that can start one. It does not work with the ChatGPT app or website: those only connect to MCP servers hosted on the internet, and this one runs on the user's PC so it can sign in as that Windows user.

OpenAI Codex CLI: %USERPROFILE%\.codex\config.toml

[mcp_servers.macola]
command = "node"
args = ["C:\\path\\to\\macola-mcp\\dist\\index.js"]
env = { MACOLA_SERVER = "YOUR-MACOLA-SERVER", MACOLA_AUTH = "windows", MACOLA_READONLY = "true" }

VS Code (GitHub Copilot agent mode): .vscode/mcp.json in your workspace (or run "MCP: Add Server")

{
  "servers": {
    "macola": {
      "type": "stdio",
      "command": "node",
      "args": ["C:\\path\\to\\macola-mcp\\dist\\index.js"],
      "env": { "MACOLA_SERVER": "YOUR-MACOLA-SERVER", "MACOLA_AUTH": "windows", "MACOLA_READONLY": "true" }
    }
  }
}

Cursor / Windsurf / Claude Code: same mcpServers block as the Claude Desktop example above (Cursor: %USERPROFILE%\.cursor\mcp.json; Claude Code: claude mcp add macola -e MACOLA_SERVER=YOUR-MACOLA-SERVER -e MACOLA_READONLY=true -- node C:\path\to\macola-mcp\dist\index.js).

Settings

Variable

Meaning

MACOLA_SERVER

Required. Your Macola server's name, e.g. ERPSERVER (becomes http://ERPSERVER/Macola/api)

MACOLA_BASE_URL

Instead of MACOLA_SERVER: the full API address, for non-standard setups (HTTPS, other path or port)

MACOLA_AUTH

windows (default): sign in as the current Windows user. basic: fixed account from MACOLA_USERNAME / MACOLA_PASSWORD (avoid if you can)

MACOLA_READONLY

true: only read tools are offered (61 of 88). Unset or false: all tools, including create/update/delete

MACOLA_CURL

Optional path to a curl.exe with SSPI. Default: %windir%\System32\curl.exe, then Git for Windows' curl

What it covers

Addresses, contacts, customer orders and order lines (including credit-hold removal and create-from-master), customer items, comment codes, inventory items, locations, bins, kits, serial/lots, in-transit, feature options, product categories, substitute items, inventory transactions, warehouse locations, purchase orders and lines, GL accounts, cost centers and units, pricing, divisions, receivable terms, projects, job titles, titles, tax codes and schedules, shop floor orders, standard routings, and ForecastPro export/import.

Every "find" tool accepts the API's common query options (pageSize, page, skip, fields, order, ...), and any property name works as a filter.

Troubleshooting

Symptom

Cause / fix

401 "Windows sign-in was not accepted"

Use the server name in MACOLA_SERVER (not an IP), and run on a domain-joined PC signed in with a domain account

403 "Access Denied. Insufficient rights"

The signed-in user has no Macola rights for that resource. Grant them in Macola

Reading contacts works, but saving a contact gives a bare 500

The Macola API forwards contact saves to Synergy as the user, and the update (HTTP MERGE) needs write permission on Synergy's services\Exact.Entity.REST.svc file (ASP.NET file authorization, 401.3 behind the scenes). Grant the user, or better an AD group, Modify on that one file. No restart needed

500 when filtering by Account

Account filters need the account's GUID, not the customer number

500 with totalCount on CustomerItem / ProductCategory

An API quirk; those tools drop totalCount

Known limitations

  • forecast_pro_import has not been tested against a live system.

  • Windows only (Windows sign-in relies on SSPI). MACOLA_AUTH=basic works anywhere Node runs.

Build the desktop extension

pwsh .\build-extension.ps1      # -> release\macola.mcpb

Contributing

Issues and pull requests are welcome, especially reports of which tools work on other Macola versions. Please never include customer data, server names or credentials in issues, logs or screenshots.

License

MIT. Provided as is, without warranty: test with read-only mode first, and review what Claude proposes before allowing changes.

Available Tools

88 tools
addresses_address_bookC

Get Addresses and Contacts for a given account.

Inputs: page, skip, order, fields, +6 more.

addresses_createD

Creates a new Address.

Inputs: ID, Fax, City, Main, +28 more.

addresses_deleteC

Deletes the specific Address.

Inputs: id (required).

addresses_findC

Get Addresses. Supports filtering by any address property via query parameters.

Inputs: City, page, skip, order, +11 more.

addresses_getB

Get the Address for a particular entry by specifying its ID.

Inputs: id (required).

addresses_updateC

Updates the specified Address with the data provided. PUT and PATCH are interchangeable.

Inputs: ID, Fax, City, Main, +28 more.

comment_codes_createC

Creates a new Comment Code (Shipping Instruction).

Inputs: RowVersion, CommentCode, Description, Description2.

comment_codes_deleteC

Deletes the specific Comment Code (Shipping Instruction).

Inputs: id (required).

comment_codes_findD

Find some or all Comment Codes (Shipping Instructions).

Inputs: page, skip, fields, distinct, +6 more.

comment_codes_getB

Get the Comment Code for a particular entry by specifying its ID.

Inputs: id (required).

comment_codes_updateC

Updates the specified Comment Code (Shipping Instruction) with the data provided.

Inputs: ID, RowVersion, CommentCode, Description, +1 more.

contacts_createD

Creates a new Contact.

Inputs: ID, Fax, Email, Phone, +22 more.

contacts_deleteC

Deletes the specific Contact.

Inputs: id (required).

contacts_findC

Get Contacts. Supports filtering by any contact property.

Inputs: page, skip, Email, order, +9 more.

contacts_getC

Get the Contact for a particular entry by specifying its ID.

Inputs: id (required).

contacts_updateA

Updates a Contact. Identify it by ID (the number, e.g. 7029) or ContactID (the GUID); the tool looks up the contact, its current RowVersion and stored email itself, so pass only the fields you want to change (e.g. { ID: 7029, Email: "new@example.com" }). Returns the changed fields before and after.

Inputs: ID, Fax, Email, Phone, +22 more.

customer_items_findC

Find Customer Items (customer-specific item numbers/descriptions).

Inputs: page, skip, fields, distinct, +7 more.

customer_items_getC

Get the Customer Item by ID.

Inputs: id (required).

customer_order_lines_createD

Creates a new Customer Order Line.

Inputs: LineType, Location, UnitCost, IsTaxable, +21 more.

customer_order_lines_deleteC

Deletes the specific Customer Order Line.

Inputs: id (required).

customer_order_lines_findC

Find Customer Order Lines. Filter by OrderNumber, ItemNumber, CustomerNumber, etc.

Inputs: page, skip, fields, Location, +10 more.

customer_order_lines_getB

Get the Customer Order Line for a particular entry by specifying its ID.

Inputs: id (required).

customer_order_lines_updateC

Updates the specified Customer Order Line with the data provided.

Inputs: ID, OrderType, UnitPrice, LineNumber, +6 more.

customer_orders_createD

Creates a new Customer Order.

Inputs: Status, TaxCode, HoldCode, ShipDate, +42 more.

customer_orders_create_from_masterC

Create a Regular Order (Type O) from a Master Order (Type M).

Inputs: OrderNumber (required), CustomerNumber, UseCurrentCost, UseCurrentPrice, +2 more.

customer_orders_deleteC

Deletes the specific Customer Order.

Inputs: id (required).

customer_orders_findC

Find Customer Orders. Filter by CustomerNumber, OrderType, Status, dates, etc.

Inputs: page, skip, Status, fields, +10 more.

customer_orders_getB

Get one Customer Order for a particular entry by specifying its ID.

Inputs: id (required).

customer_orders_remove_credit_holdC

Attempts to remove a Customer Order from credit hold status, given the OrderType and OrderNumber.

Inputs: OrderType (required), OrderNumber (required).

customer_orders_updateC

Updates the specified Customer Order with the data provided. If CustomerOrderComments is provided, all previous comments will be replaced.

Inputs: Status, TaxCode, HoldCode, ShipDate, +42 more.

divisions_findC

Find Division information. Note: the "division" parameter is ignored for this API.

Inputs: page, skip, order, fields, +5 more.

divisions_getB

Get one Division's information, given the Division Code.

Inputs: id (required).

forecast_pro_exportC

Export history data from Macola as a CSV file that can be imported into Forecast Pro TRAC.

Inputs: EndDate, Location, StartDate, StockedItem, +10 more.

forecast_pro_importA

UNTESTED - do not use without checking first. Import a Forecast Pro TRAC XML forecast file into Macola for a given Calendar Number and optionally a specific Location. (The API spec documents the XML as a required "request" parameter; this tool sends it as the body.)

Inputs: xmlContent (required), Location, CalendarNumber.

gl_accounts_findC

Find some or all of the Chart of Accounts (GL Accounts).

Inputs: page, skip, order, fields, +6 more.

gl_accounts_getA

Get a single Chart of Account (GL Account) by specifying its ID.

Inputs: id (required).

gl_cost_centers_findC

Get Cost Centers. GeneralLedgerAccount or CustomerNumber is required.

Inputs: page, skip, order, fields, +7 more.

gl_cost_units_findC

Get Cost Units. GeneralLedgerAccount or CustomerNumber is required.

Inputs: page, skip, order, fields, +7 more.

inventory_bins_findC

Find Inventory Bin entries.

Inputs: page, skip, order, fields, +7 more.

inventory_bins_getB

Get the Inventory Bin information for a particular entry by specifying its ID.

Inputs: id (required).

inventory_feature_options_findC

Find Feature Options (for configurable/kit items).

Inputs: page, skip, order, fields, +6 more.

inventory_feature_options_getC

Get the Feature Option for a particular entry by specifying its ID.

Inputs: id (required).

inventory_in_transit_findD

Find Inventory In Transit information.

Inputs: page, skip, order, fields, +7 more.

inventory_in_transit_getB

Get the Inventory In Transit information for a particular entry by specifying its ID.

Inputs: id (required).

inventory_items_findC

Find Inventory Items (master item records).

Inputs: page, skip, order, fields, +10 more.

inventory_items_getB

Get the Inventory Item for a particular entry by specifying its item number ID.

Inputs: id (required).

inventory_kits_findD

Find Inventory Kit data.

Inputs: page, skip, order, fields, +6 more.

inventory_kits_getB

Get the Inventory Kit information for a particular entry by specifying its ID.

Inputs: id (required).

inventory_locations_findC

Find Inventory Location entries (item quantities at specific locations).

Inputs: page, skip, order, fields, +7 more.

inventory_locations_getB

Get one Inventory Location entry by specifying its ID.

Inputs: id (required).

inventory_product_categories_findD

Find Product Categories.

Inputs: page, skip, order, fields, +6 more.

inventory_product_categories_getB

Get the Product Category by ID.

Inputs: id (required).

inventory_serial_lots_findD

Find Inventory Serial/Lot information.

Inputs: page, skip, order, fields, +8 more.

inventory_serial_lots_getB

Get the Inventory Serial/Lot information for a particular entry by specifying its ID.

Inputs: id (required).

inventory_substitute_items_findD

Find Substitute Items.

Inputs: page, skip, order, fields, +6 more.

inventory_substitute_items_getC

Get the Substitute Item by ID.

Inputs: id (required).

inventory_transaction_requestC

Request a new Inventory Transaction. Only Issue and Receipt types are currently supported.

Inputs: TransactionType (required), Comment, Journal, Comment2, +10 more.

job_titles_findD

Find Job Titles.

Inputs: page, skip, Title, order, +6 more.

job_titles_getB

Get the Job Title for a particular entry by specifying its ID.

Inputs: id (required).

locations_findC

Find Locations (warehouse/inventory locations). When StockingFilter is true, filtering applies to both Location and InventoryLocation.

Inputs: page, skip, order, fields, +7 more.

locations_getC

Get the Location information for a particular entry by specifying its ID.

Inputs: id (required).

price_getC

Gets Price information for the specified Item, Customer, Quantity, date, etc.

Inputs: PriceDate, CurrencyCode, CustomerType, ExchangeRate, +2 more.

projects_findC

Find Projects (Jobs).

Inputs: page, skip, order, fields, +6 more.

projects_getA

Get the Project (Job) for a particular entry by specifying its ID.

Inputs: id (required).

purchase_order_lines_createC

Creates a new Purchase Order Line.

Inputs: ID, JobNumber, ItemNumber, LineNumber, +17 more.

purchase_order_lines_deleteC

Deletes the specific Purchase Order Line.

Inputs: id (required).

purchase_order_lines_findD

Find Purchase Order Lines.

Inputs: page, skip, order, fields, +9 more.

purchase_order_lines_getB

Get the Purchase Order Line for a particular entry by specifying its ID.

Inputs: id (required).

purchase_order_lines_updateC

Updates the specified Purchase Order Line with the data provided.

Inputs: ID, JobNumber, ItemNumber, LineNumber, +17 more.

purchase_orders_createD

Creates a new Purchase Order.

Inputs: ID, Date, Type, Status, +18 more.

purchase_orders_deleteC

Deletes the specific Purchase Order.

Inputs: id (required).

purchase_orders_findD

Find Purchase Orders.

Inputs: Type, page, skip, order, +10 more.

purchase_orders_getB

Get the Purchase Order for a particular entry by specifying its ID.

Inputs: id (required).

purchase_orders_updateC

Updates the specified Purchase Order with the data provided.

Inputs: ID, Date, Type, Status, +18 more.

receivable_terms_findD

Find Receivable Accounts Terms.

Inputs: page, skip, order, fields, +6 more.

receivable_terms_getB

Get the Receivable Accounts Term for a particular entry by specifying its ID.

Inputs: id (required).

shop_floor_orders_createC

Creates a new Shop Floor Order (manufacturing work order).

Inputs: DueDate, JobNumber, OrderType, ItemNumber, +14 more.

shop_floor_orders_findC

Find Shop Floor Orders (manufacturing work orders).

Inputs: page, skip, order, fields, +10 more.

shop_floor_orders_getB

Get the Shop Floor Order for a particular entry by specifying its ID.

Inputs: id (required).

standard_routing_createD

Creates a new Standard Routing.

Inputs: ItemNumber, OverlapCode, UserDefined1, UserDefined2, +11 more.

standard_routing_findC

Find Standard Routings (manufacturing routing templates).

Inputs: page, skip, order, fields, +7 more.

standard_routing_getA

Get the Standard Routing for a particular entry by specifying its ID.

Inputs: id (required).

tax_codes_findD

Find Tax Codes.

Inputs: page, skip, order, fields, +6 more.

tax_codes_getA

Get the Tax Code for a particular entry by specifying its ID.

Inputs: id (required).

tax_schedules_findD

Find Tax Schedules.

Inputs: page, skip, order, fields, +6 more.

tax_schedules_getB

Get the Tax Schedule for a particular entry by specifying its ID.

Inputs: id (required).

titles_findC

Find Titles (salutation lookup values, e.g. Mr., Mrs., Dr.).

Inputs: page, skip, order, fields, +5 more.

titles_getB

Get the Title for a particular entry by specifying its ID.

Inputs: id (required).

Tool Schema Changelog

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

Loading tool schema changelog…

    TDQS

    C2.3/5.0

    Scored across 88 tools

    Disambiguation3/5

    Most tools target distinct resources and actions, but the large surface creates several close pairs such as locations_find/locations_get versus inventory_locations_find/inventory_locations_get, and addresses_find versus addresses_address_book. Descriptions help, but an agent must carefully distinguish many find/get pairs across similar ERP entities.

    Naming Consistency4/5

    The dominant convention is clear snake_case with an entity prefix followed by an action (addresses_find, purchase_orders_create, inventory_items_get). There are minor deviations such as singular/plural inconsistencies (purchase_orders vs purchase_order_lines, standard_routing), awkward names like addresses_address_book, and special action names like customer_orders_remove_credit_hold.

    Tool Count1/5

    With 88 tools, the server is far beyond a practical MCP tool surface and will be difficult for an agent to navigate efficiently. Although the ERP domain is broad, the set is bloated with many repetitive find/get pairs and would benefit from consolidation or resource-oriented grouping.

    Completeness3/5

    Core sales, purchasing, inventory, and contact/address workflows are broadly covered, with several resources supporting full CRUD. However, many resources are read-only or partially covered, such as inventory_items, projects, shop_floor_orders, locations, and tax codes, leaving notable lifecycle gaps.

    Maintenance

    ActivityMaintained
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables querying Proluxe ERP data such as customers, orders, invoices, AR aging, bills of materials, product catalog, focus priorities, and projects through MCP tools.
      1
      MIT
    • A
      license
      B
      quality
      C
      maintenance
      Enables read-only access to Epicor Kinetic ERP data, including sales orders, customers, parts, and shipments, through secure MCP tools.
      4
      MIT
    • A
      license
      Not graded
      quality
      B
      maintenance
      Enables MCP-capable clients to sign in with OAuth and perform purchaser tasks such as browsing catalogues, checking inventory, managing stocktakes and recipes, drafting requisitions, updating buy lists, exporting reports, and processing invoices. It also supports supplier access for listing and inspecting connections, catalogues, products, purchase orders, invoices, and entitled reports.
      MIT
    • A
      license
      A
      quality
      B
      maintenance
      Enables MCP clients to search and describe API routes, retrieve people, admissions, academics, and billing records, download exports, and optionally make changes against a school information system, read-only by default.
      6
      161 npm
      MIT