snapchat-ads-mcp-server-by-cdata
Provides a local, read-only Model Context Protocol (MCP) server that exposes Snapchat Ads data to AI clients by wrapping a CData JDBC Driver connection as MCP tools (get tables, get columns, run SELECT queries).
Score Breakdown
⚙ Agent Friendliness
🔒 Security
TLS cannot be verified from the README (it is dependent on the underlying JDBC driver and remote APIs). Authentication is delegated to the CData JDBC driver via JDBC URL and possibly OAuth, but the MCP wrapper itself does not document fine-grained scopes or data access controls. Query execution is SQL-based (SELECT), which can still lead to data overexposure if users/agents are not constrained; no mention of query allowlisting, timeouts, or logging redaction. Secrets handling practices are not described in the MCP wrapper README.
⚡ Reliability
Best When
You want local, on-device MCP access to Snapchat Ads data for interactive analytics and question answering, using an existing CData JDBC Driver connection.
Avoid When
You need a remotely accessible API endpoint, webhooks, or strong built-in API-level rate limiting/pagination semantics at the MCP layer.
Use Cases
- • Let an MCP-capable desktop client (e.g., Claude Desktop) query live Snapchat Ads reporting data using natural language
- • Discover available data model tables/columns for Snapchat Ads via tools
- • Run ad-hoc SELECT queries over Snapchat Ads data and analyze results
Not For
- • Performing full CRUD operations (the MCP server is described as read-only)
- • Running remotely over the network (it uses stdio and is intended for same-machine clients)
- • High-volume, latency-sensitive automation without considering query cost/limits
Interface
Authentication
Auth details are delegated to the underlying CData JDBC driver. The README notes OAuth may require browser authentication, and the JDBC URL contains options like InitiateOAuth=GETANDREFRESH.
Pricing
No pricing for the MCP wrapper is provided; the JDBC driver licensing is required per the README.
Agent Metadata
Known Gotchas
- ⚠ Server uses stdio, so it is intended for clients running on the same machine; remote use will not work as described
- ⚠ Tool surface is limited to table/column discovery and running SELECT SQL; there is no stated guardrail against expensive queries
- ⚠ No explicit rate limiting or pagination behavior is documented at the MCP level
- ⚠ Because it delegates to SQL via run_query, agents may generate overly broad queries unless constrained
Alternatives
Full Evaluation Report
Comprehensive deep-dive: security analysis, reliability audit, agent experience review, cost modeling, competitive positioning, and improvement roadmap for snapchat-ads-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.