activecampaign-mcp-server-by-cdata
A locally hosted, read-only MCP server that exposes ActiveCampaign data through CData's JDBC Driver as simple MCP tools (get tables, get columns, run SELECT queries). It runs as a stdio process on the same machine as the MCP client (e.g., Claude Desktop) and uses a provided .prp configuration to point to the JDBC driver and connection details.
Score Breakdown
⚙ Agent Friendliness
🔒 Security
The MCP server runs locally over stdio (reducing network exposure), but the README provides little detail about how errors are handled or how sensitive connection strings/secrets are protected in logs. Authentication details are delegated to the CData JDBC driver; the README mentions OAuth may be required but does not document fine-grained scopes. The presence of a generic run_query tool that executes provided SQL increases risk of accidental over-broad data access if the agent constructs unsafe/expensive queries. No explicit TLS, secret redaction, or rate-limit handling behavior is documented in the MCP server README.
⚡ Reliability
Best When
You want a local MCP-capable assistant to query ActiveCampaign data on the same machine using a preconfigured JDBC connection.
Avoid When
You need robust authentication/session management for remote access, strong documented rate-limit behavior, or highly controlled query safety (since the interface includes arbitrary SELECT SQL execution).
Use Cases
- • Let an LLM query live ActiveCampaign data without writing SQL
- • Discovery of available tables/columns in the ActiveCampaign dataset via tools
- • Analytics-style questions using SELECT queries over exposed relational models
- • Local agent integrations where the client can run on the same host
Not For
- • Exposing an internet-reachable API endpoint for remote clients
- • Full CRUD or write/update/delete operations (advertised as read-only in this project)
- • Environments that require built-in pagination controls or cursor-based result handling
Interface
Authentication
Authentication is delegated to the CData JDBC Driver. The README notes that OAuth may require browser-based authentication for the connection string; specific scopes/permissions are not described in this MCP server README.
Pricing
No pricing for the MCP server itself is provided; the CData JDBC driver requires licensing as described in the setup.
Agent Metadata
Known Gotchas
- ⚠ Server uses stdio, so it must run on the same machine as the MCP client.
- ⚠ Arbitrary SQL is executed via run_query (SELECT), so the agent should avoid overly broad queries to reduce load and output size.
- ⚠ Claude Desktop may need a full restart to pick up newly configured MCP servers.
- ⚠ Tool outputs are returned in CSV; agents may need to parse/interpret CSV correctly.
Alternatives
Full Evaluation Report
Comprehensive deep-dive: security analysis, reliability audit, agent experience review, cost modeling, competitive positioning, and improvement roadmap for activecampaign-mcp-server-by-cdata.
AI-powered analysis · PDF + markdown · Delivered within 30 minutes
Package Brief
Quick verdict, integration guide, cost projections, gotchas with workarounds, and alternatives comparison.
Delivered within 10 minutes
Score Monitoring
Get alerted when this package's AF, security, or reliability scores change significantly. Stay ahead of regressions.
Continuous monitoring
Scores are editorial opinions as of 2026-04-04.