n8n_workflows
by shawnmcrowley
Overview
A comprehensive collection of N8N workflows for automating tasks with AI agents, web scraping, data processing, ETL, content marketing, and multi-platform integrations, leveraging PostgreSQL with pgvector for vector storage and offering enterprise-grade monitoring and automated backups.
Installation
docker-compose up -dEnvironment Variables
- DB_TYPE
- DB_POSTGRESDB_HOST
- DB_POSTGRESDB_PORT
- DB_POSTGRESDB_DATABASE
- DB_POSTGRESDB_SCHEMA
- DB_POSTGRESDB_USER
- DB_POSTGRESDB_PASSWORD
- PGADMIN_DEFAULT_EMAIL
- PGADMIN_DEFAULT_PASSWORD
- N8N_HOST
- N8N_PROTOCOL
- N8N_WEBHOOK_URL
- GENERIC_TIMEZONE
- N8N_RESTRICT_FILE_ACCESS_TO
- N8N_API_KEY
- FIRECRAWL_API_KEY
- OPENWEATHER_KEY
- ALPHA_VANTAGE_KEY
Security Notes
CRITICAL: Multiple workflows contain hardcoded API keys (e.g., for EODHD, Brave Search, BuzzSumo, NYT Article Search, Firecrawl). These should always be stored securely as environment variables or N8N credentials, not directly in workflow JSONs or code. CRITICAL: The 'chat-with-a-database-using-ai-.json' workflow passes AI-generated SQL directly to a PostgreSQL query, creating a severe SQL injection vulnerability if the AI agent's output can be manipulated by malicious user input. HIGH: The Docker Compose configuration uses default, weak credentials ('admin@admin.com'/'admin') for PgAdmin, which is unsuitable for any non-local development environment. MEDIUM: Extensive use of 'jsCode' nodes, while necessary for complex logic in N8N, increases the attack surface for potential vulnerabilities if not meticulously reviewed and secured, especially when processing external or AI-generated inputs. MEDIUM: The 'generate-swagger-specs-for-workflows-with-webhooks-.json' writes files to a mounted directory (`/swagger-html`), which, despite the `N8N_RESTRICT_FILE_ACCESS_TO` environment variable, introduces a file system write risk.
Similar Servers
n8n
This MCP server component is part of n8n, a workflow automation platform, enabling interaction with AI models and external services through the Model Context Protocol, including log streaming to syslog destinations.
n8n-mcp
The n8n-MCP server enhances n8n's workflow automation by providing a Model Context Protocol interface, allowing AI agents to discover, validate, and manage n8n nodes and workflows with rich, structured documentation and metadata.
mcp-n8n-builder
Programmatic creation and management of n8n workflows by AI assistants via the Model Context Protocol (MCP).
project-nova
Manages Paperless-NGX document management system, enabling AI agents to list, search, retrieve, upload, and organize digital documents via an SSE-based MCP server for n8n integration.