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
The Neon MCP Server allows users to interact with and manage their Neon Postgres databases using natural language commands, acting as a bridge between AI agents/LLMs and the Neon API and database operations.
MCP-PostgreSQL-Ops
The MCP server provides professional operations, monitoring, and management capabilities for PostgreSQL databases using natural language queries.
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.
dx-mcp-server
Empowers AI applications to interact with and query a user-provided Postgres database via the Model Context Protocol (MCP).