basecamp -by-cdata

This MCP server provides a read-only interface to Basecamp data via the CData MCP Server for Basecamp. It exposes a set of tools derived from the MCP framework that let you discover available data sources and run read-only queries against them. The server is intended to be used with Claude Desktop or compatible MCP clients, and relies on a local Java process that serves data through standard MCP tool calls. The common tool set follows the pattern: {servername}_get_tables to list tables, {servername}_get_columns to list columns in a table, and {servername}_run_query to execute a SELECT query. For example, after configuring the MCP entry (via Claude Desktop config), you can request the list of available tables, inspect columns, and retrieve rows in CSV format. The server runs with stdio, so it should be used on the same machine as the client unless you configure an alternate transport. This read-only mode is designed to safely expose live Basecamp data for natural language questions without allowing data modification.

Prerequisites:

• Java Runtime Environment (JRE) 8+ installed on your machine
• Maven (for building the project)
• Access to a Basecamp instance and a CData JDBC Driver licensed for Basecamp (as described in the project README)

Step-by-step installation:

1. Clone the repository git clone https://github.com/cdatasoftware/basecamp-mcp-server-by-cdata.git cd basecamp-mcp-server-by-cdata

2. Build the MCP server JAR mvn clean install This will produce CDataMCP-jar-with-dependencies.jar (the runtime server).

3. Install and license the CData JDBC Driver for Basecamp (outside of this repository, per the README):

   • Download the driver from CData's site
   • Follow the licensing steps described in the README (java -jar cdata.jdbc.basecamp.jar --license)

4. Create a basecamp.prp configuration file (example). This file will contain your JDBC/connection properties and server metadata as shown in the README. For example: Prefix=basecamp ServerName=CDataBasecamp ServerVersion=1.0 DriverPath=PATH\TO\cdata.jdbc.basecamp.jar DriverClass=cdata.jdbc.basecamp.BasecampDriver JdbcUrl=jdbc:basecamp:InitiateOAuth=GETANDREFRESH; Tables=

5. Run the MCP server: java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/basecamp.prp Note: The server uses stdio for communication, so ensure your MCP client runs on the same machine or adapt transport as needed.

6. Configure Claude Desktop or your MCP client to connect using the entry below (Windows/Linux/Mac variations shown in the README): To Claude Desktop, add an mcpServers entry with the command pointing to the Java executable and arguments as shown in the mcp_config section above.

Notes and tips:

• This MCP server is read-only by design. If you need write/update/delete capabilities, refer to the full CData MCP Server for Basecamp.
• The server operates via stdio, so it expects a client on the same machine or a compatible transport setup.
• Ensure the basecamp.prp file correctly references the JDBC driver jar path and the correct JdbcUrl for your Basecamp connection.
• If Claude Desktop cannot discover the MCP server, fully quit and restart the client after updating the config, or copy the claude_desktop_config.json to the appropriate directory as described in the README.
• For troubleshooting, validate the JDBC connection string using the Basecamp driver utility and confirm your OAuth flow (if applicable) completes before starting the MCP server.