claude-connector-perfexcrm
by parthamjangir2020
Overview
Provides AI-powered integration for Claude Desktop to manage and query data within Perfex CRM through direct database access via a Model Context Protocol (MCP) server.
Installation
node dist/index.jsEnvironment Variables
- DB_HOST
- DB_PORT
- DB_NAME
- DB_USER
- DB_PASSWORD
- DB_PREFIX
Security Notes
The 'execute_sql' tool allows arbitrary raw SQL queries to be executed directly against the Perfex CRM database. While other tools use prepared statements for parameters, the 'sql' argument itself is directly taken from input, posing a severe SQL injection risk if the LLM's output for this argument is not perfectly safe or if an attacker gains control. This grants full control over the database, including modification, deletion, and exfiltration of all data. The MCP server operates with a single database user, lacking granular, in-server role-based access control. Database credentials are handled via environment variables, which is a good practice for secure storage, but the broad capabilities of the 'execute_sql' tool remain a critical vulnerability.
Similar Servers
Delphi-MCP-Server
Implements the Model Context Protocol (MCP) in Delphi to enable AI-powered development workflows and integrate with clients like Claude Code.
mcp-server
The Perses MCP Server enables LLM hosts (e.g., Claude Desktop, VS Code) to interact with the Perses Application in a standardized way using the Model Context Protocol.
vibes
Vibes transforms Claude Desktop into a conversational development environment through distributed MCP servers, allowing users to describe what they want to build and have Claude implement it while teaching them.
PDBe-MCP-Servers
Provides Model Context Protocol (MCP) servers to integrate PDBe's structural biology data (API, Graph, Search) into AI-powered applications like Claude Desktop.