Files
n8n-mcp/src/templates
czlonkowski c824fb5ebf fix: complete Phase 4 integration test fixes
- Fixed better-sqlite3 ES module imports across all tests
- Updated template repository method to handle undefined results
- Fixed all database column references to match schema
- Corrected MCP transport initialization
- All integration tests now passing
2025-07-29 12:46:55 +02:00
..

n8n Templates Integration

This module provides integration with n8n.io's workflow templates, allowing AI agents to discover and use proven workflow patterns.

Features

  • API Integration: Connects to n8n.io's official template API
  • Fresh Templates: Only includes templates updated within the last 6 months
  • Manual Fetch: Templates are fetched separately from the main node database
  • Full Workflow JSON: Complete workflow definitions ready for import
  • Smart Search: Find templates by nodes, keywords, or task categories

Usage

Fetching Templates

npm run fetch:templates

This command will:

  1. Connect to n8n.io API
  2. Fetch all templates from the last 6 months
  3. Download complete workflow JSON for each template
  4. Store in local SQLite database
  5. Display progress and statistics

Testing

npm run test:templates

MCP Tools

The following tools are available via MCP:

  • list_node_templates(nodeTypes, limit) - Find templates using specific nodes
  • get_template(templateId) - Get complete workflow JSON
  • search_templates(query, limit) - Search by keywords
  • get_templates_for_task(task) - Get templates for common tasks

Task Categories

  • ai_automation - AI-powered workflows
  • data_sync - Database and spreadsheet synchronization
  • webhook_processing - Webhook handling workflows
  • email_automation - Email processing workflows
  • slack_integration - Slack bots and notifications
  • data_transformation - Data manipulation workflows
  • file_processing - File handling workflows
  • scheduling - Scheduled and recurring tasks
  • api_integration - External API connections
  • database_operations - Database CRUD operations

Implementation Details

Architecture

  • template-fetcher.ts - Handles API communication and rate limiting
  • template-repository.ts - Database operations and queries
  • template-service.ts - Business logic and MCP integration

Database Schema

Templates are stored in a dedicated table with:

  • Workflow metadata (name, description, author)
  • Node usage tracking
  • View counts for popularity
  • Complete workflow JSON
  • Creation/update timestamps
  • 6-month freshness constraint

API Endpoints Used

  • /api/templates/workflows - List all workflows
  • /api/templates/search - Search with pagination
  • /api/templates/workflows/{id} - Get specific workflow
  • /api/templates/search/filters - Available filters

Notes

  • Templates are NOT fetched during regular database rebuilds
  • Run fetch:templates manually when you need fresh templates
  • API rate limiting is implemented (200-500ms between requests)
  • Progress is shown during fetching for large datasets