{"id":"cdatasoftware-square-mcp-server-by-cdata","name":"square-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/square-mcp-server-by-cdata","category":"infrastructure","subcategories":[],"tags":["mcp","stdio","square","cdata","jdbc","llm-integration","read-only","local-dev"],"what_it_does":"Provides a local, read-only MCP server that exposes Square data as queryable tables/columns via a wrapped CData JDBC Driver. It runs as an MCP stdio server intended for use with local MCP clients (e.g., Claude Desktop) to retrieve live Square data without requiring users to write SQL.","use_cases":["Answering natural-language questions about Square data (e.g., open items, transactions, events)","Exploring available tables and columns for Square datasets via MCP tools","Running read-only SQL SELECT queries against Square data mapped through the CData JDBC driver","Integrating Square data retrieval into local LLM workflows where stdio-based MCP is supported"],"not_for":["Providing a secure multi-tenant or internet-exposed service (stdio is local-only)","User-facing production APIs requiring strong API gateway features (auth/rate limiting/auditing)","Full CRUD operation (server is described as read-only; tools shown include get_tables/get_columns/run_query)"],"best_when":"You have a local MCP-capable client (Claude Desktop) and want to query Square data from a local machine using a JDBC-to-relational mapping without building custom database connectors.","avoid_when":"You need network-accessible deployment, centralized authentication, documented SLAs, or robust rate-limit/error-contract guarantees at the MCP layer.","alternatives":["CData's managed MCP platform for Square (mentioned as CData Connect AI)","Direct use of the Square APIs (with your own OAuth/token handling)","Direct access to Square data via CData JDBC driver integrated into your own application rather than MCP","Other Square MCP implementations (if available) or generic MCP SQL gateway servers"],"af_score":49.0,"security_score":43.8,"reliability_score":25.0,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T20:00:30.221051+00:00","interface":{"has_rest_api":false,"has_graphql":false,"has_grpc":false,"has_mcp_server":true,"mcp_server_url":null,"has_sdk":false,"sdk_languages":[],"openapi_spec_url":null,"webhooks":false},"auth":{"methods":["JDBC driver OAuth flow in browser (when required by the underlying data source configuration)"],"oauth":true,"scopes":false,"notes":"The README indicates that if the Square data source uses OAuth, authentication happens in a browser via the JDBC connection string utility. MCP itself appears to rely on the locally configured JDBC connection string stored in the .prp file."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"Pricing for the MCP server/package is not specified in the provided README content. The CData JDBC driver requires licensing/trial/license key as described."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":49.0,"security_score":43.8,"reliability_score":25.0,"mcp_server_quality":75.0,"documentation_accuracy":70.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":60.0,"rate_limit_clarity":0.0,"tls_enforcement":80.0,"auth_strength":45.0,"scope_granularity":20.0,"dependency_hygiene":30.0,"secret_handling":40.0,"security_notes":"Runs locally via stdio (reduces network exposure) but relies on JDBC driver configuration and OAuth/token material captured in the connection string/.prp file. The README does not discuss secret storage practices (e.g., file permissions), token handling, logging redaction, or MCP-side authorization. OAuth complexity is delegated to the JDBC driver connection utility. No explicit TLS/network transport settings apply at the MCP boundary since it is stdio-local.","uptime_documented":0.0,"version_stability":40.0,"breaking_changes_history":30.0,"error_recovery":30.0,"idempotency_support":"false","idempotency_notes":"Not documented. The MCP exposes a SQL SELECT tool (run_query) which is typically idempotent, but the server overall is not clearly described with idempotency guarantees.","pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["Server is stdio-based and 'can only be used with clients that run on the same machine as the server'.","Tool naming uses a server prefix (servername) in tool names (e.g., {servername}_run_query); callers must use the configured server name/prefix correctly.","The .prp file must include correct JDBC DriverPath/DriverClass/JdbcUrl and optional Tables filtering; missing/incorrect configuration will prevent successful tool operations."]}}