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
Installation
- Install dependencies:
Usage
Running the Server
Or using the installed script:
1. Query Sales Orders
{
"name": "query_sales_orders",
"arguments": {
"customer_id": "cust_001",
"customer_name": "John Smith",
"item_id": "item_001",
"item_name": "Widget",
"status": "Fulfilled",
"start_date": "2024-01-01T00:00:00Z",
"end_date": "2024-12-31T23:59:59Z",
"include_summary": true
}
}
2. Query Invoices
{
"name": "query_invoices",
"arguments": {
"customer_id": "cust_001",
"status": "Outstanding",
"include_summary": true
}
}
3. Get Customer Summary
{
"name": "get_customer_summary",
"arguments": {
"customer_name": "Acme Corp"
}
}
4. Get Item Summary
{
"name": "get_item_summary",
"arguments": {
"item_name": "Widget A"
}
}
Available Resources
netsuite://sales-orders - All sales ordersnetsuite://invoices - All invoicesnetsuite://customers - All customersnetsuite://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
netsuite-mcp/
├── netsuite_mcp/
│ ├── __init__.py
│ ├── server.py # Main MCP server implementation
│ ├── models.py # Pydantic data models
│ ├── data_service.py # Data querying and filtering logic
│ └── sample_data.py # Sample data for testing
├── main.py # Entry point
├── pyproject.toml # Project configuration
└── README.md
Extending the Server
To add new functionality:
- Add new data models to
models.py - Extend the data service in
data_service.py - Add new tools or resources to
server.py
License
MIT License