ns_runCustomSuiteQL

Tool Description	Runs a custom SuiteQL query in NetSuite. Only read-only queries are supported. Useful for gathering information of all types. This tool can use ns_getRecordTypeMetadata to confirm the structure of a record before creating a query.
Annotation	Run Custom SuiteQL

Properties

Property	Type	Required or Optional	Description
sqlQuery	string	Required	SuiteQL query string. Only SuiteQL syntax is allowed.
description	string	Optional	Description of the query.
pageSize	number	Optional	Indicates the page size of the results. If included, the tool uses pagination to retrieve large amounts of data.

Permissions

There are no specific permission requirements to see this tool in the AI client. However, the data you can see or query with SuiteQL depends on the permissions assigned to your NetSuite role.

Related Topics

• Available Tools in the MCP Standard Tools SuiteApp
• Record Tools
• Report Tools
• Saved Search Tools
• SuiteQL Tools

General Notices