netsuite -by-cdata

This MCP server exposes NetSuite data through a read-only MCP interface by wrapping the CData JDBC Driver for NetSuite. Once running, clients (including Claude Desktop and similar MCP-enabled tools) can query NetSuite data using simple tools rather than writing SQL directly. The server provides three built-in tools: netsuite_get_tables to list available tables, netsuite_get_columns to list columns for a specific table, and netsuite_run_query to execute SQL SELECT queries against NetSuite data. To use it with Claude Desktop, add a Claude MCP entry referencing the Java JAR and the netsuite.prp connection configuration, then start Claude to browse and query NetSuite data via the provided tools. The setup is designed for local, read-only access, which is suitable for answering questions like data availability, table structures, and read-only insights from live NetSuite data.

Prerequisites:

• Java (JDK) installed and accessible on your system (required to run the MCP server JAR).
• Maven (optional, for building the JAR from source).
• NetSuite JDBC driver licensed and installed as described in the project docs (for local setup and testing).

Installation steps:

1. Build the MCP server JAR (from source): mvn clean install This produces CDataMCP-jar-with-dependencies.jar.
2. Download and license the NetSuite JDBC Driver as described in the README (install if needed):
   • Obtain the driver from the CData site and place it in an accessible location.
   • Run the license command as specified (e.g., java -jar cdata.jdbc.netsuite.jar --license) and provide your name, email, and license key.
3. Create a netsuite.prp file with your JDBC connection details (Prefix, ServerName, ServerVersion, DriverPath, DriverClass, JdbcUrl, Tables).
4. Prepare the Claude Desktop (or other MCP client) config to include the netsuite_by_cdata entry, pointing to the built JAR and netsuite.prp as shown in the mcp_config example.
5. Run the MCP server: java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/netsuite.prp The server uses stdio and is intended for local access (the MCP client runs on the same machine).
6. In Claude Desktop, refresh or restart the client to detect the newly configured MCP server.

Prerequisites summary:

• Java JDK installed
• Maven (for building the project)
• CData NetSuite JDBC Driver installed and licensed
• netsuite.prp generated with correct JDBC connection details

Notes and tips:

• The MCP server is read-only by design for this package; use netsuite_run_query to run SELECT statements if needed, keeping in mind NetSuite permissions.
• The server exposes tools using a server-specific prefix in the config (e.g., netsuite_by_cdata_get_tables, netsuite_by_cdata_get_columns, netsuite_by_cdata_run_query). Adjust the class name in your config file accordingly.
• If Claude Desktop (or another client) doesn’t see the server, ensure you fully quit and restart the client so it reloads the MCP configuration.
• Connection strings and credentials should be kept secure; store netsuite.prp with restricted permissions.
• Since the server uses stdio, the client must run on the same machine; consider networked alternatives if remote access is required.
• For troubleshooting, verify the Netsuite.prp file contents (Prefix, ServerName, ServerVersion, DriverPath, DriverClass, JdbcUrl, Tables) and confirm the JDBC driver is properly licensed and accessible.