MCP_Server_n8n_
by SachdevaVansh
Overview
Provides a Python-based Model Context Protocol (MCP) server to bridge an AI client (e.g., Claude Desktop) with a PostgreSQL database hosted on NeonDB and integrate with n8n for workflow automation.
Installation
python postgresql.pySecurity Notes
CRITICAL: The `postgresql.py` file contains a hardcoded PostgreSQL connection string (`psqlurl`) including database credentials (owner username and password). This is a severe security vulnerability. While the README suggests using environment variables, the code does not implement this. Additionally, the project encourages public exposure via ngrok, which, while noted as optional, combined with hardcoded credentials and the direct database query capabilities, poses a significant risk if not handled with extreme care. The `mcp.tool()` functions use parameterized queries, mitigating direct SQL injection for the defined tools, but the general `query_db` function could be misused if new tools are added without proper parameterization.
Similar Servers
mcp-server-neon
Enables natural language interaction with Neon Postgres databases, facilitating database management, migrations, and query optimization via an LLM agent.
MCP-PostgreSQL-Ops
This MCP server provides comprehensive PostgreSQL database operations, monitoring, and management through natural language queries.
mcp-n8n-builder
Programmatically create, manage, and monitor n8n workflows and their executions via an MCP server, allowing AI assistants to automate workflow development without direct user intervention.
dx-mcp-server
Empowers AI applications to interact with and query a user-provided Postgres database via the Model Context Protocol (MCP).