netsuite-mcp-server-by-cdata

What is netsuite-mcp-server-by-cdata?

netsuite-mcp-server-by-cdata is a local, read-only Model Context Protocol (MCP) server that allows LLMs like Claude Desktop to query live NetSuite data using natural language, powered by the CData JDBC Driver for NetSuite.

How to use netsuite-mcp-server-by-cdata?

Clone the repository, build the JAR with Maven, install and license the CData JDBC Driver for NetSuite, create a .prp file with your JDBC connection string, then configure Claude Desktop’s claude_desktop_config.json to launch the JAR with the .prp file. The server runs locally via stdio.

Key features of netsuite-mcp-server-by-cdata

• Provides read-only access to live NetSuite data
• Exposes NetSuite as relational SQL models via JDBC
• Lets LLMs query data with natural language, no SQL needed
• Offers three tools: get_tables, get_columns, run_query
• Supports any NetSuite data accessible via CData JDBC Driver
• Uses stdio transport for local client integration

Use cases of netsuite-mcp-server-by-cdata

• Ask Claude Desktop about NetSuite sales data, such as closed won opportunities
• Retrieve open support tickets or project status from NetSuite
• Query calendar events or custom NetSuite tables without writing SQL
• Enable AI assistants to answer business questions from live NetSuite data

FAQ from netsuite-mcp-server-by-cdata

What is the difference between this server and the full CData MCP Server for NetSuite?

This server is read-only and locally hosted. The full CData MCP Server for NetSuite supports read, write, update, delete, and actions, and offers simplified setup. For fully remote MCP access, CData Connect AI is also available.

What are the runtime dependencies?

You need Java, Maven, and the CData JDBC Driver for NetSuite (download and install separately). The JDBC driver must be licensed before use.

Where does the NetSuite data live?

The data remains in NetSuite; the server queries it live through the JDBC driver. No data is stored locally by the server.

What are the known limitations?

The server is read-only and uses stdio transport, so it can only be used with clients running on the same machine. It does not support write, update, or delete operations.

How is authentication handled?

Authentication is configured in the JDBC connection string using the CData JDBC Driver’s Connection String utility, which may involve OAuth for NetSuite. The connection string is stored in the .prp file.