SuiteQL Query Tool

v2025.6

Get Started

A lightweight, modern Suitelet for testing SQL directly in NetSuite. Write queries, visualize results, and perform DML operations safely.

Download SuiteQL Tool
v2025.6 • suiteql-tool-sl.js • Single File
Type
NetSuite Suitelet (2.1)
License
MIT / Open Source

Keyboard Shortcuts

Execute Query Ctrl + Enter
Autocomplete Ctrl + Space

Supported Actions

Run Standard Queries

Execute any standard SuiteQL (SQL-92) query. Supports JOINs, Aggregates, and built-in Oracle functions.

DML Operations (Safe Mode)

Perform INSERT, UPDATE, and DELETE directly.
Note: DROP and TRUNCATE are blocked for safety.

Recent Queries History

The tool automatically saves your last 20 queries to your browser's local storage.

Simple Deployment

Single-file solution. No external assets needed.

1

Download the Script

Download suiteql-tool-sl.js from the Overview tab.

2

Upload to NetSuite

Navigate to Documents > Files > SuiteScripts and upload the file.

3

Create Script Record

Go to Customization > Scripting > Scripts > New. Select the file you just uploaded.

4

Deploy

Click Deploy Script. Set Status to Released and Audience to All Roles (or specific admins).

Copy the generated URL link to your bookmarks!

v2025.6 Latest
v2021.2 Legacy

Mosses Ross

Technical Consultant @ Metafygx

Originally created by Tim Dietrich. Reconstructed with help from Yogan Sriram.