square -by-cdata

This MCP server wraps the CData JDBC Driver for Square to expose live Square data through a simple MCP interface in read-only mode. It is designed to let LLMs query data by asking natural language questions, without requiring direct SQL. The server ships with a set of built-in tools you can invoke via JSON-RPC or through your MCP client: square_get_tables to list available tables, square_get_columns to list columns for a given table, and square_run_query to execute a SELECT query against the Square data. The configuration file (square.prp) connects to your Square data source via the CData JDBC Driver, and Claude Desktop (or any compatible MCP client) can discover and use the server once configured in claude_desktop_config.json. To use, start the server with the Java command and point it at your square.prp, then use the provided tool names in your client payloads to fetch metadata or run queries. For natural language prompts, you can simply ask questions like: “What is the total revenue by product category this quarter?” and the client will translate them into appropriate tool calls behind the scenes.

Prerequisites:

• Java Development Kit (JDK) 8+ installed on your machine
• Maven (for building the MCP server package)
• Access to the CData JDBC Driver for Square and its license

Installation steps:

1. Clone the repository and navigate into it: git clone https://github.com/cdatasoftware/square-mcp-server-by-cdata.git cd square-mcp-server-by-cdata

2. Build the MCP server package (produces CDataMCP-jar-with-dependencies.jar): mvn clean install

3. Download and install the CData JDBC Driver for Square from: https://www.cdata.com/drivers/square/download/jdbc

4. License the CData JDBC Driver as described in the driver docs and ensure the JDBC driver is usable from your environment.

5. Create a .prp configuration file (e.g., square.prp) with your JDBC connection details and settings as described in the README (Prefix, ServerName, ServerVersion, DriverPath, DriverClass, JdbcUrl, Tables).

6. Run the MCP server using the generated JAR and your .prp file: java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/square.prp

Notes:

• The server uses standard input/output (stdio), so it must run on the same machine as clients that communicate via MCP protocol.
• You can configure Claude Desktop or another MCP client to load the server by editing the appropriate JSON config file and adding an entry that points to the Java command and parameters above.

Tips and common issues:

• Ensure the square.prp file is correctly formed with the required properties (Prefix, ServerName, ServerVersion, DriverPath, DriverClass, JdbcUrl, Tables).
• If Claude Desktop does not list the MCP server, fully quit and restart Claude Desktop to refresh available servers.
• When testing connections, use the CData JDBC Driver’s Connection String utility to validate your JdbcUrl before placing it in the .prp file.
• Remember that the MCP server is read-only by design; write/update/delete actions are not exposed in this configuration.
• The server operates over stdio; ensure your MCP client is capable of communicating through that channel on the same host.