• 4 min read
Active Pieces as an MCP Server
This will explain and have the files needed to make your own AP MCP Server
Here is the output on how it works and what to keep an eye on.
This is the step by stem on how it works:
https://app.excalidraw.com/l/9rZJm2HlJOy/6LOO9HUH3ix
[
Let me get the csv as well.
Your MCP should look like this
[
If you watch the video the rule really helped
[
The files are below
{
"created": "1748636697130",
"updated": "1748636697130",
"name": "TicketSystem",
"description": "",
"tags": [],
"pieces": [
"@activepieces/piece-mcp",
"@activepieces/piece-http"
],
"template": {
"displayName": "TicketSystem",
"trigger": {
"name": "trigger",
"valid": true,
"displayName": "MCP Tool",
"type": "PIECE_TRIGGER",
"settings": {
"pieceName": "@activepieces/piece-mcp",
"pieceVersion": "0.0.5",
"pieceType": "OFFICIAL",
"packageType": "REGISTRY",
"input": {
"toolName": "ticket_system",
"inputSchema": [
{
"name": "name",
"type": "Text",
"required": true,
"description": "The name of the ticket"
},
{
"name": "description",
"type": "Text",
"required": true,
"description": "Information about the ticket"
}
],
"returnsResponse": true,
"toolDescription": "Add Ticket to our System"
},
"inputUiInfo": {
"customizedInputs": {}
},
"triggerName": "mcp_tool"
},
"nextAction": {
"name": "step_1",
"skip": false,
"type": "PIECE",
"valid": true,
"settings": {
"input": {
"url": "https://plane.dailyai.studio/api/v1/workspaces/dailyai/projects/4651d2f4-beb3-4051-8e26-1a97f8fcb625/issues/",
"body": {
"data": {
"name": "{{trigger['name']}}",
"description_html": "{{trigger['description']}}"
}
},
"method": "POST",
"headers": {
"x-api-key": "plane_api_da1a0637a85d4c23bcbf8821f876fdf2"
},
"authType": "NONE",
"failsafe": false,
"body_type": "json",
"use_proxy": false,
"authFields": {},
"queryParams": {},
"proxy_settings": {}
},
"pieceName": "@activepieces/piece-http",
"pieceType": "OFFICIAL",
"actionName": "send_request",
"inputUiInfo": {
"schema": {
"body": {
"data": {
"type": "JSON",
"required": true,
"displayName": "JSON Body"
}
},
"authFields": {},
"proxy_settings": {}
},
"customizedInputs": {}
},
"packageType": "REGISTRY",
"pieceVersion": "0.7.0",
"errorHandlingOptions": {
"retryOnFailure": {
"value": false
},
"continueOnFailure": {
"value": false
}
}
},
"displayName": "Send HTTP request"
}
},
"valid": true,
"connectionIds": [],
"schemaVersion": "1"
},
"blogUrl": ""
}{
"created": "1748636699445",
"updated": "1748636699445",
"name": "DocsMcpClient",
"description": "",
"tags": [],
"pieces": [
"@activepieces/piece-mcp",
"@activepieces/piece-tables"
],
"template": {
"displayName": "DocsMcpClient",
"trigger": {
"name": "trigger",
"valid": true,
"displayName": "MCP Tool",
"type": "PIECE_TRIGGER",
"settings": {
"pieceName": "@activepieces/piece-mcp",
"pieceVersion": "~0.0.5",
"pieceType": "OFFICIAL",
"packageType": "REGISTRY",
"input": {
"toolName": "docs",
"inputSchema": [],
"returnsResponse": true,
"toolDescription": "These are the internal docs"
},
"inputUiInfo": {
"customizedInputs": {}
},
"triggerName": "mcp_tool"
},
"nextAction": {
"name": "step_1",
"skip": false,
"type": "PIECE",
"valid": true,
"settings": {
"input": {
"filters": {
"filters": []
},
"table_id": "2FS1OaevzcZp36zLmO7c5"
},
"pieceName": "@activepieces/piece-tables",
"pieceType": "OFFICIAL",
"actionName": "tables-find-records",
"inputUiInfo": {
"schema": {
"filters": {
"filters": {
"type": "ARRAY",
"required": false,
"properties": {
"field": {
"type": "STATIC_DROPDOWN",
"options": {
"options": [
{
"label": "Title",
"value": {
"id": "ZZz0w4qj6JBsyipwfhGCm",
"name": "Title",
"type": "TEXT"
}
},
{
"label": "Content",
"value": {
"id": "XWb2yKyz23G7RT3gs7ROe",
"name": "Content",
"type": "TEXT"
}
}
]
},
"required": true,
"displayName": "Field"
},
"value": {
"type": "SHORT_TEXT",
"required": true,
"displayName": "Value"
},
"operator": {
"type": "STATIC_DROPDOWN",
"options": {
"options": [
{
"label": "Equals",
"value": "eq"
},
{
"label": "Not Equals",
"value": "neq"
},
{
"label": "Greater Than",
"value": "gt"
},
{
"label": "Greater Than or Equal",
"value": "gte"
},
{
"label": "Less Than",
"value": "lt"
},
{
"label": "Less Than or Equal",
"value": "lte"
},
{
"label": "Contains",
"value": "co"
}
]
},
"required": true,
"displayName": "Operator"
}
},
"displayName": "Filters"
}
}
},
"customizedInputs": {}
},
"packageType": "REGISTRY",
"pieceVersion": "~0.0.6",
"errorHandlingOptions": {
"retryOnFailure": {
"value": false
},
"continueOnFailure": {
"value": false
}
}
},
"nextAction": {
"name": "step_3",
"skip": false,
"type": "CODE",
"valid": true,
"settings": {
"input": {
"data": "{{step_1}}"
},
"sourceCode": {
"code": "export const code = async (inputs) => {\n const items = inputs.data;\n\n const output = items\n .map((item) => {\n const title = item?.cells?.['ZZz0w4qj6JBsyipwfhGCm']?.value ?? '';\n const content = item?.cells?.['XWb2yKyz23G7RT3gs7ROe']?.value ?? '';\n return `## ${title}\\n\\n${content}`;\n })\n .join('\\n\\n---\\n\\n');\n\n return { result: output };\n};",
"packageJson": "{}"
},
"inputUiInfo": {
"customizedInputs": {}
},
"errorHandlingOptions": {
"retryOnFailure": {
"value": false
},
"continueOnFailure": {
"value": false
}
}
},
"nextAction": {
"name": "step_2",
"skip": false,
"type": "PIECE",
"valid": true,
"settings": {
"input": {
"mode": "simple",
"respond": "stop",
"response": {
"response": {
"data": "{{step_3['result']}}"
}
}
},
"pieceName": "@activepieces/piece-mcp",
"pieceType": "OFFICIAL",
"actionName": "reply_to_mcp_client",
"inputUiInfo": {
"schema": {
"response": {
"response": {
"type": "OBJECT",
"required": true,
"displayName": "Response"
}
}
},
"customizedInputs": {}
},
"packageType": "REGISTRY",
"pieceVersion": "~0.0.5",
"errorHandlingOptions": {
"retryOnFailure": {
"value": false
},
"continueOnFailure": {
"value": false
}
}
},
"displayName": "Reply to MCP Client"
},
"displayName": "Custom Javascript Code"
},
"displayName": "Find Records"
}
},
"valid": true,
"connectionIds": [],
"schemaVersion": "1"
},
"blogUrl": ""
}CSV for the table https://docs.google.com/spreadsheets/d/1fP7mmPrkMPzh8mjHoYjmGnnr0JUTPvG6VNjHE29iMxg/edit?usp=drive_link