- 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
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:
- Connect to n8n.io API
- Fetch all templates from the last 6 months
- Download complete workflow JSON for each template
- Store in local SQLite database
- 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 nodesget_template(templateId)- Get complete workflow JSONsearch_templates(query, limit)- Search by keywordsget_templates_for_task(task)- Get templates for common tasks
Task Categories
ai_automation- AI-powered workflowsdata_sync- Database and spreadsheet synchronizationwebhook_processing- Webhook handling workflowsemail_automation- Email processing workflowsslack_integration- Slack bots and notificationsdata_transformation- Data manipulation workflowsfile_processing- File handling workflowsscheduling- Scheduled and recurring tasksapi_integration- External API connectionsdatabase_operations- Database CRUD operations
Implementation Details
Architecture
template-fetcher.ts- Handles API communication and rate limitingtemplate-repository.ts- Database operations and queriestemplate-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:templatesmanually when you need fresh templates - API rate limiting is implemented (200-500ms between requests)
- Progress is shown during fetching for large datasets