NetSuite MCP Server

A Model Context Protocol (MCP) server for querying NetSuite sales orders and invoices with filtering capabilities.

Features

• Query sales orders and invoices

• Filter by customer, item, or date range

• Get summary statistics

• Customer and item-specific analysis

• Sample data for testing and development

Related MCP server: SQLite MCP Server

Installation

1. Install dependencies:

Usage

Running the Server

Or using the installed script:

Available Tools

1. Query Sales Orders

2. Query Invoices

3. Get Customer Summary

4. Get Item Summary

Available Resources

• netsuite://sales-orders - All sales orders

• netsuite://invoices - All invoices

• netsuite://customers - All customers

• netsuite://items - All items/products

Sample Data

The server includes sample data for testing:

• Customers: Acme Corp, TechStart Inc, Retail Plus

• Items: Widget A, Widget B, Service Pack, Gadget Pro

• Sales Orders: 3 sample orders with different statuses

• Invoices: 3 sample invoices linked to sales orders

Filter Options

All query tools support the following filters:

• customer_id: Exact customer ID match

• customer_name: Partial customer name match (case-insensitive)

• item_id: Exact item ID match

• item_name: Partial item name match (case-insensitive)

• status: Exact status match

• start_date: Filter records created after this date

• end_date: Filter records created before this date

• include_summary: Include summary statistics in response

Development

Project Structure

Extending the Server

To add new functionality:

1. Add new data models to models.py

2. Extend the data service in data_service.py

3. Add new tools or resources to server.py

License

MIT License