NetSuite

You can run a local, read-only MCP server that exposes NetSuite data to language models and other MCP clients. This server wraps the CData JDBC driver for NetSuite so you can ask natural-language questions and receive live data without writing SQL. The setup focuses on a straightforward local deployment that remains read-only, making it safe for querying while keeping configuration simple.

How to use

You connect to the NetSuite MCP server from your MCP client (for example Claude Desktop or any client that supports MCP). The server presents NetSuite data as read-only tools you can invoke through natural language prompts. You typically do not call individual tools directly; instead, you ask questions and the client uses built-in tools to retrieve relevant data such as table lists, column lists, and query results.

How to install

Prerequisites: you need a Java Runtime Environment and Maven for building the server.

# 1) Clone the project
git clone https://github.com/cdatasoftware/netsuite-mcp-server-by-cdata.git
cd netsuite-mcp-server-by-cdata

# 2) Build the server
mvn clean install

2. Download and install the CData JDBC Driver for NetSuite from the official download page.

3. License the CData JDBC Driver. Open a terminal in the driver’s lib folder and run the license command, then provide your name, email, and a TRIAL (or license key).

4. Configure your connection to NetSuite using the driver’s connection utility. Run the following to open the utility and create a connection string, then test the connection. Copy the resulting connection string for later use.

5. Create a .prp file that defines the MCP connection. Use the example below as a template and fill in your paths and values.

env
Prefix=netsuite
ServerName=CDataNetSuite
ServerVersion=1.0
DriverPath=PATH\\TO\\cdata.jdbc.netsuite.jar
DriverClass=cdata.jdbc.netsuite.NetSuiteDriver
JdbcUrl=jdbc:netsuite:InitiateOAuth=GETANDREFRESH;
Tables=

Run the MCP server locally

Use the stdio-based server run command shown below. This starts the MCP server using your netsuite.prp configuration.

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/netsuite.prp

Claude Desktop configuration (example)

To connect Claude Desktop to your local MCP server, add an entry to your claude_desktop_config.json. The entry launches the MCP server using the Java runtime and the netsuite.prp file.

{
  "mcpServers": {
    "netsuite_mcp": {
      "command": "PATH\\to\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\netsuite.prp"
      ]
    }
  }
}

Usage notes

You can expect to retrieve lists of available tables and columns and run read-only queries against NetSuite. The system supports natural-language prompts that translate into MCP tool calls behind the scenes. You do not need to craft raw SQL for common queries.

Troubleshooting

If the MCP server does not appear in your MCP client, fully quit the client and relaunch. Ensure your netsuite.prp is correctly referencing the JDBC driver jar and the right JDBC URL. If you encounter connection or authentication issues with NetSuite, re-check your connection string and OAuth flow in the driver’s configuration utility.

License

This MCP server is released under the MIT License. You may use, modify, and distribute it, subject to the terms of the MIT License.

All supported sources (overview)

NetSuite is exposed through the MCP interface alongside many other data sources. The server focuses on read-only access to NetSuite data via the CData JDBC Driver.

Available tools

netsuite_get_tables

Retrieves a list of tables available in the data source. Output is CSV with headers.

netsuite_get_columns

Retrieves a list of columns for a specific table. Output is CSV with headers.

netsuite_run_query

Executes a SQL SELECT query against the data source.