Build your own CUSTOM API MCP server
This n8n demonstrates how any organisation can quickly and easily build and offer MCP servers to their customers or internal staff to improve productivity. T...
🔌 Nodes & Integrations Used (5)
📖 Implementation & Setup Guide
This n8n demonstrates how any organisation can quickly and easily build and offer MCP servers to their customers or internal staff to improve productivity.
This MCP example uses PayCaptain.com as an example and shows how to create an MCP server which can search for and update employee data.
How it works * A MCP server trigger is used and connected to 3 custom workflow tools: Search Employee, Get Employee by ID and Update Employee. * Each tool makes calls to the PayCaptain API to perform their respective tasks. Extra care is performed to strip out sensitive data and ensure we're not sharing too much. * The Update Employee too also guards against updating fields which would preferably remain readonly. When you control the MCP server, you can determine behaviour of the tool. * Finally, a Google Sheet node is used to log all operations for later audit. This will add a tiny bit of latency but recommended if sensitive data is being accessed.
How to use * This MCP server allows any compatible MCP client to manage their PayCaptain employee database. You will need to have a PayCaptain account and developer key to use it. * Connect your MCP client by following the n8n guidelines here - https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-langchain.mcptrigger/#integrating-with-claude-desktop * Try the following queries in your MCP client: * "When did Sarah start here employment at the company?" * "Does Jack work Wednesdays or Fridays?" * "Please update Tracy's NI number to ABCD123456"
Requirements * PayCaptain Account and Developer Key. * Google Sheets to log actions for later audit. * MCP Client or Agent for usage such as Claude Desktop - https://claude.ai/download
Customising this workflow * Add or remove employee attributes as required for your user case. * If Google Sheets is too slow, consider an API call to a faster service to log calls to the MCP server. * Remember to set the MCP server to require credentials before going to production and sharing this MCP server with others!
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Build your own CUSTOM API MCP server.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related AI Agents Workflows
View All in AI Agents →5 ways to process images PDFs with Gemini AI in n8n
How it works Many users have asked in the support forum about different methods to analyze images and PDF documents with Google Gemini AI in n8n. This workfl...
7 AI Sales Assistant
Production-ready n8n automation template for 7 AI Sales Assistant built by AhiXLight. Seamlessly connects Airtop Tool, Slack, Airtop with 24 configured nodes.
AAVE portfolio professional AI agent Telegram Email GPT 4o
A next-generation AI-powered DeFi health monitor that tracks wallet positions across Aave V3 using GPT-4o and LangChain. It delivers human-readable reports v...
Access control for AI agents RBAC using Airtable and Telegram
Purpose This workflow allows granular control over the access to tools connected to AI Agents (including Multi-Agent setups) using Role Based Access Control....