Name: NetSuite MCP Server by CData
Author: CDataSoftware

LABSCO SUMMARY

Three tools, because the driver does the modelling.

The work here is not in the tool surface — it is in the JDBC driver turning NetSuite's API into tables an LLM already knows how to query. Discovery, columns, SELECT: that is enough for a model to answer questions about data it has never seen. Two boundaries to know. This build is read-only and local, and CData points at their hosted platform for remote access and at their packaged MCP server for write, update and delete. The assistant can query every table the connection can see — the Tables property in the .prp file does not narrow that, so limit the connection or the account it signs in with.

What it is

CData's read-only server for NetSuite. The CData JDBC Driver models NetSuite as relational SQL tables; this Java server wraps that driver so an LLM can discover the tables and query them without you writing SQL.

What you get

netsuite_get_tables lists the tables available in the data source, returned as CSV with a header row
netsuite_get_columns lists the columns for one table, same CSV shape
netsuite_run_query executes a SQL SELECT
The prefix is yours to set in the .prp file, so the tools appear as netsuite_get_tables, netsuite_get_columns and netsuite_run_query
In practice you do not call them by hand — you ask a question about the data and the client picks the calls

Requirements

Java and Maven: clone, mvn clean install to produce CDataMCP-jar-with-dependencies.jar. Separately install and license the CData JDBC Driver for NetSuite — running java -jar cdata.jdbc.netsuite.jar --license accepts a key or TRIAL, and running it without arguments opens the connection-string utility. Then write a .prp file with Prefix, ServerName, ServerVersion, DriverPath, DriverClass and JdbcUrl, plus an optional Tables list, which does not limit what the tools can query. Launch it as java -jar CDataMCP-jar-with-dependencies.jar netsuite.prp. It speaks stdio, so client and server must be on the same machine.

Setup effort

Build from source — git clone https://github.com/cdatasoftware/netsuite-mcp-server-by-cdata.git

See installation options

USE CASES

01

Asking a question about NetSuite data

Describe what you want to know and let the client discover the tables and write the SELECT.

netsuite_get_tablesnetsuite_run_query

02

Finding out what is even queryable

List the tables and their columns before asking anything specific.

netsuite_get_tablesnetsuite_get_columns

3 tools

Listed in project docs. Your client may show a different list.

netsuite_get_tables

netsuite_get_columns

netsuite_run_query

BEFORE YOU INSTALL

What to know first

Tools you get

3 tools named in the project's documentation. Tool names take the Prefix from the .prp file, such as netsuite_get_tables with Prefix=netsuite. Despite a line promising writes, the build is read-only: run_query executes SELECT only.

Where it runs

The documented client runs the server on your machine.

INSTALLATION

Connect your client

You clone and build this one yourself.

Server setup

Clone the repository:

TERMINAL

git clone https://github.com/cdatasoftware/netsuite-mcp-server-by-cdata.git
cd netsuite-mcp-server-by-cdata

Build the server:

TERMINAL

mvn clean install

MCP Clients

Claude Desktop

CLAUDE DESKTOP · JSON

{
  "mcpServers": {
    "netsuite": {
      "command": "<YOUR_PATH_TO_JAVA>",
      "args": [
        "-jar",
        "<YOUR_PATH_TO_CDATA_MCP_JAR_WITH>",
        "<YOUR_PATH_TO_NETSUITE>"
      ]
    }
  }
}

NetSuite MCP Server by CData