ERP-File MCP Server
Loads data from a Google Sheet, exposing tools to list, search, and summarize data dynamically.
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
ERP & File MCP Server
A dual FastMCP (Model Context Protocol) server built with FastAPI. This application exposes two concurrent MCP servers natively routed via custom ASGI middleware to interact with backend ERP APIs and local/Google Sheets data.
Features
Dual MCP Endpoints:
/mcp: Connects to an external ERP API, caches data locally into PostgreSQL with adaptive fetching algorithms, and exposes tools for querying standard business reports./mcp-file: Loads data from a Google Sheet (ifGOOGLE_CREDENTIALSprovided) or a local file (Excel/CSV), exposing tools to list, search, and summarize data dynamically.
Adaptive Database Sync: Heavily optimizes API usage by scaling fetch windows based on historical data density. Keeps a rolling cache up-to-date automatically using background concurrency.
Robust Error Handling: Handles network, API, and credential failures seamlessly, preventing server crashes and falling back when sources become unreachable.
Related MCP server: NetSuite AI Connector
Endpoints / Test Paths
ERP Data FastMCP:
http://localhost:8080/mcpFile / Sheets FastMCP:
http://localhost:8080/mcp-file
Prerequisites
Python 3.11+
PostgreSQL
Valid
.envconfiguration (see.env.example)
Environment Variables
Check .env.example for full configuration details. Key variables include:
DATABASE_URL: PostgreSQL connection string.GOOGLE_CREDENTIALS: JSON string representation of a Google Service Account (optional, for Google Sheets integration).
Running Locally
Install dependencies:
pip install -r requirements.txtStart the Uvicorn server:
uvicorn main:app --host 0.0.0.0 --port 8080Docker
Build and run using Docker:
docker build -t erp-mcp-server .
docker run -p 8080:8080 --env-file .env erp-mcp-serverTool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
Related MCP Connectors
One governed MCP endpoint for 40+ business systems. Read-only, source-cited answers.
MCP server unifying ERPs, CRMs, APIs and knowledge base for Claude, ChatGPT and Gemini.
MCP server for querying and analyzing data from ad platforms, analytics tools, and spreadsheets
Read-only MCP over your Excel or Airtable plus the PDFs beside it, joined as one relational dataset.
Related MCP Servers
AlicenseNot gradedqualityDmaintenanceExposes ERP data (production orders, inventory, BOM, customers) to any MCP client through a backend-neutral interface, with a mock backend for testing.2MIT- FlicenseNot gradedqualityDmaintenanceGoverned MCP bridge that lets AI clients query live ERP data via SuiteQL, saved searches, and records, with role-based permissions and full audit logging.-
- AlicenseNot gradedqualityDmaintenanceEnables querying Proluxe ERP data such as customers, orders, invoices, AR aging, bills of materials, product catalog, focus priorities, and projects through MCP tools.1MIT
- AlicenseNot gradedqualityDmaintenanceEnables querying products and stock, sales orders, contacts, invoices, payables/receivables, and creating contacts through the official ERP API.MIT