NetSuite Power Tools

Full SQL Studio inside NetSuite. AI query generation (Claude, GPT, Gemini, Grok), CodeMirror syntax highlighting, dark mode, Excel export, query history, drag-and-drop columns, plugin architecture. The gold standard.

Single RESTlet that replaces SuiteTalk REST. SuiteQL beyond 5K rows, record retrieval with sublists, saved searches, File Cabinet upload/download, PDF generation, email, AI APIs. All via JSON POST.

Shows slowest records, scripts, and workflows. Drill into specific scripts causing performance issues. Data visualizations, page time summaries, script analysis. Install → Customization > Performance.

SuiteQL Editor (syntax highlighting, autocomplete, multi-tab, CSV/JSON export) + Script Log Viewer + Record Detail Viewer (any record as JSON tree) + Command Palette (Ctrl+Shift+K) + side panel mode.

Open any record → see every field with internal ID, current value, data type. Search and filter. Copy as JSON. Essential for knowing exactly what field IDs to reference when building Suitelets.

Official IDE plugin. Create SDF projects, SuiteScript autocomplete, deploy directly to your account. AI-powered Developer Assistant generates SuiteScript 2.1, unit tests, and docs from natural language.

Put ANY SuiteQL query on your dashboard as a live portlet. Instant custom KPIs from raw SQL. Query and title configurable via script parameters.

Better alternative to NetSuite's Global Search. Faster, more flexible, searches across record types with better result formatting.

Dashboard portlet showing transactions matching your criteria. Live alerts on your home page for overdue, pending, or flagged transactions.

Look up any item's inventory balance for any historical date. Critical for audits and USDA drawdown tracking.

Find transactions, entities, and items by external ID. Essential for debugging integrations.

Call SuiteQL from external systems via simple RESTlet. Lightweight alternative to full SuiteAPI when you only need query access.

Call saved searches from external systems via RESTlet. Expose any saved search as a JSON API endpoint.

External interface to your File Cabinet. Upload and download files programmatically from outside NetSuite.

Open source framework for developing NetSuite-native applications. Scaffolding and patterns for building production Suitelets.

Build saved search in UI → click Export → get complete SuiteScript 1.0 or 2.0 code. Also exports Workbooks to SuiteQL. Massive time saver.

Open any record → instantly see all User Event Scripts, Client Scripts, and Workflows deployed to it. Shows deployment status and lets you preview script files.

Lightweight SuiteQL from any page. Autocomplete table/field names, Records Catalog browser, syntax highlighting, formatting. Quick queries without navigating to Query Tool.

Drag and drop files onto any record with a Files subtab. Multiple simultaneous uploads. Saves clicks every day.

Hover any field → see internal ID. Shift+Click copies ID to clipboard. Ctrl+Shift+F searches record for specific ID. Simpler than Field Explorer for quick lookups.

Search all SuiteScript files in your account for a specific string. Find which scripts reference a field, function, or record type.

Shows scripted records on current page, extended field metadata, and debugging shortcuts. Takes field help to the next level.

General productivity — shortcuts, navigation enhancements, quick actions. Originally built for personal use, now widely adopted.

OpenAI-powered NetSuite assistant. Toggle Field IDs, search record body fields, AI-generated "How-To" help, on-page list search, navigation assistance. Free to all NetSuite users.

Simple web IDE for the NetSuite Query Module with tabs and a built-in schema browser. Lightweight alternative when you just need quick queries.

Enhanced Shortcuts portlet — create groups and categories for frequently used menus with customizable shortcuts in a dedicated portlet. Way better than the default.

Autocomplete, embedded API docs, type-checking, error detection for every SuiteScript module. Catches bugs before deploy.

Active Record-style data access library. Bundles lodash + moment.js for cleaner SuiteScript record operations.

Wrapper libraries for common N/search operations. Makes SuiteScript search code cleaner and more reusable.

ESLint rules for SuiteScript v1/v2. Catches common errors, enforces best practices, validates script type annotations.

TypeScript + SDF project template. Type-safe SuiteScript development from day 1 with proper build pipeline.

Unit testing framework for SuiteScript using Mocha + Chai. Test your scripts locally before deploying to NetSuite.

Clean React + SDF project structure for Suitelets. Local dev + test, then deploy via SDF. The React Suitelet starter.

Vue 3 + Vite boilerplate for NetSuite SPAs. Built-in plugin handles RESTlet API calls during dev and production.

Google Auth for SuiteScript. Call Google APIs (Sheets, Maps, etc.) from your Suitelets with proper authentication.

Official sample projects from real customer customizations. SDF + SuiteScript 2.1, includes SPA examples.

Community fork of Tim Dietrich's SuiteQL Tool with additional AI features and enhancements.

Production-ready NetSuite MCP client — talk to NetSuite in natural language from any AI provider. React + Express + LangChain. OAuth 2.0 PKCE auth. Supports OpenAI, Anthropic, Google.

Official MCP servers list entry. MCP server for NetSuite data via OAuth 2.0 PKCE. Works with Claude Code, Cursor IDE, Gemini CLI. The bridge between AI tools and your NetSuite data.

Curated list of NetSuite AI resources, MCP integration tools, articles, and community contributions. The starting point for AI + NetSuite.

SDF project: configurable Suitelet to organize and publish all your reports. Supports saved searches + SuiteQL, CSV download, role-based publishing. Setup > Custom > Report Hub Configurations.

Suitelet that turns any saved search into a report with a user-friendly UI. Parameter selection, search execution, and one-click Excel export. Drop-in ready.

Proof of concept Suitelet that exports saved search rows to real XLSX format using xlsx.js library. Also has an XML-based Excel export variant using Handlebars templates.

jQuery DataTables integration for Suitelets — inline searching, sorting, filtering, and pagination on large data tables without server postbacks. External DB integration included.

Creates custom print button on any NetSuite record that generates a PDF from an Advanced PDF/HTML template using current record data. Drop-in branding solution.

Suitelet utility for developing and testing Map/Reduce scripts. Run, debug, and inspect M/R stages interactively. From the creator of Field Explorer.

n8n community node for NetSuite SuiteTalk REST. Connect NetSuite to 400+ apps via the open-source n8n workflow automation platform. Self-hosted, full data control.

Run SuiteQL queries against NetSuite from your terminal via SuiteTalk REST. Great for scripting, CI/CD pipelines, and data extraction workflows.

CLI + Gulp plugin for uploading/downloading files to NetSuite File Cabinet. Uses an included RESTlet. Automate your deployment pipeline.

Python library to make requests to Oracle NetSuite REST Web Services. Most starred Python NS library. Perfect for data scripts and automation.

NetSuite mock framework for unit testing SuiteScripts. Simulates the NS environment locally so you can test without deploying. The most starred SS testing tool.

dbt data models for Fivetran's NetSuite connector. Pre-built transformations for financial reporting, GL, AP, AR. If you use dbt for analytics, this is gold.

Node.js module simplifying NetSuite RESTlet connections via OAuth and NLAuth. Clean API for calling RESTlets from external apps.

Open source document capture SuiteApp — OCR, custom fields, form XML, transaction field support. Automate invoice/receipt processing inside NetSuite.

SuiteScript library that lets users toggle split-pane views in NetSuite. Side-by-side record comparison or multi-panel layouts.

Official barrel/block cheddar cheese prices in JSON. The data behind Federal Milk Marketing Order price calculations. Report 2993 has 40-lb block and 500-lb barrel sections. 180 days per request.

Agricultural census data, crop/livestock statistics. Covers every commodity the USDA tracks. JSON output.

Raw market news data across all commodities. Programmatic access to the same data in USDA market reports.

170+ commodities with forex-style pricing. Current and historical rates with currency conversion.

CME, NYMEX, CBOT futures — gold, silver, crude oil, natural gas, wheat, coffee, and 25+ more in JSON.

Every record type, field ID, sublist, search filter, and join path in NetSuite. The canonical reference for all development.

Complete module documentation for N/search, N/record, N/ui/serverWidget, N/https, N/cache, N/render, and every other SuiteScript API.

More comprehensive than Records Catalog — includes all sub-tables and join paths. The future of SuiteQL schema exploration.