Litefarm-mcp-server-n8n
by Bundelkund
Overview
An MCP server for LiteFarm, enabling n8n workflows or Claude Desktop to automate farm management tasks and perform direct database operations via HTTP or stdio.
Installation
npm startEnvironment Variables
- LITEFARM_API_URL
- LITEFARM_EMAIL
- LITEFARM_PASSWORD
- TRANSPORT
- PORT
- DB_HOST
- DB_PORT
- DB_NAME
- DB_USER
- DB_PASSWORD
- CHARACTER_LIMIT
Security Notes
CRITICAL: The `db_execute_sql` tool directly executes arbitrary SQL queries provided as input (`client.query(sql)` in `db-tools.ts`). This is a severe SQL injection vulnerability if the `sql` input is not strictly controlled or validated. A malicious actor (e.g., via prompt injection to an LLM or direct tool invocation) could execute DDL (CREATE TABLE, DROP TABLE, etc.), delete/modify data, or perform other arbitrary database commands. Although the documentation mentions read/write only, the code does not enforce this. Test scripts have hardcoded login credentials, which is a minor risk for non-production use.
Similar Servers
enhanced-postgres-mcp-server
This server acts as a Model Context Protocol interface for PostgreSQL, enabling LLMs to query data, modify records, and manage database schema objects with read and write capabilities.
mcp-server
A PHP 8.4 MCP (Model Context Protocol) server designed to expose custom PHP methods as AI tools and resources, facilitating AI agent interaction with data storage systems like Redis, MongoDB, and Memgraph.
NeuronDB
The NeuronMCP server acts as a Model Context Protocol (MCP) gateway, enabling MCP-compatible clients (like Claude Desktop) to interact with the NeuronDB PostgreSQL extension for vector search, machine learning, RAG pipelines, and agent runtime capabilities.
n8n-mcp-server
Facilitates natural language management of n8n workflows, executions, and credentials through integration with Claude AI via the Model Context Protocol.