SuiteQL Query Tool

I'm currently working on SuiteQL Query Tool v2026.1 - the first new version in more than four years.

This version is a complete rebuild. The UI has been modernized with a SQL Studio-inspired design, Bootstrap 5.3, and CodeMirror for syntax highlighting. I've added dark mode, query history, keyboard shortcuts, Excel export, drag-and-drop column reordering, and a focus mode that hides the NetSuite chrome so you can concentrate on your work.

The most significant addition is AI integration. You can now generate queries using natural language, ask questions about tables, validate queries before running them, and get optimization suggestions for slow queries. It works with both Claude and ChatGPT—bring your own API key.

Beta Testing

If you'd like to help with beta testing, the latest version is available here:
SuiteQL Query Tool v2026.1 Beta 09

What's New in Beta 09

Clickable Record Links

• ID columns now automatically link to NetSuite records
• Click to open the record in a new tab
• Supports: Customers, Vendors, Employees, Items, Transactions, Subsidiaries, Departments, Classes, Locations, Accounts, and more
• Works in Table view, DataTable view, and Row Details modal
• Toggle option "Link IDs to records" in Options panel (enabled by default)

Plugin Architecture

• Plugins are self-contained files stored in NetSuite File Cabinet
• New CONFIG.PLUGIN_FOLDER_ID setting to enable plugin loading
• Automatic dependency resolution with topological sorting
• Server-side hooks: onBeforeQuery, onAfterQuery, onError
• Client-side hooks: onInit, onResultsDisplay, onEditorChange, and more
• 17 UI injection points (toolbar, header, editor, results, sidebar, modals)
• Extended public API: SQT.getResults(), SQT.getQuery(), SQT.setQuery(), SQT.getEditor()
• Sample plugin included (query-logger.sqt-plugin.js)

Data Visualization / Charts

• New "Chart" button in results toolbar to visualize query data
• Chart types: Bar, Line, Pie, Doughnut, Polar Area
• Manual configuration with label (X-axis) and value (Y-axis) column selection
• AI-assisted chart generation from natural language descriptions
• Theme-aware colors that adapt to light/dark mode
• Export charts as PNG images
• Powered by Chart.js library

Editor Enhancements

• Syntax highlighting for NetSuite BUILTIN functions (BUILTIN.DF, etc.)
• Improved SQL formatter with better keyword detection and CASE/WHEN support
• New "OpenAI-Compatible" AI provider option for custom API endpoints (OpenRouter, Azure OpenAI, local models)

Schema Explorer Improvements

• Collapsible Build Schema and Export Schema sections
• Fix for NetSuite Records Catalog API bug with malformed labels

Complete Feature List

Query Editor

• CodeMirror-based SQL editor with syntax highlighting
• SQL formatting/beautification (Ctrl+Shift+F)
• Table and column autocomplete (Ctrl+Space)
• Schema-aware autocomplete (using Schema Explorer data)
• Adjustable font size (Extra Small to Extra Large)
• Edit history with undo/redo support
• Query parameters with {{paramName}} syntax and input modal
• Import SQL files from local computer
• Download query as .sql file

Query Execution

• Run query with Ctrl+Enter
• Pagination support with configurable row ranges
• Return all rows option (bypasses 5000 row limit)
• Execution time tracking
• Slow query detection with optimization suggestions
• Force cache miss option (bypasses Oracle query cache)
• Virtual views support (reference saved queries as #viewname)

Results Display

• DataTables integration for sorting, searching, and pagination
• Row details modal (click row number to view)
• Auto-linking of ID columns to NetSuite records
• Column pinning (freeze first 1-3 columns)
• Column statistics display (min, max, avg, sum, null count)
• Configurable NULL value display (dimmed, "null", or blank)
• Render HTML in results option
• Maximize results panel (Shift+R)

Export Options

• Export as Excel (.xlsx), CSV, or JSON
• Export to Airtable (create tables and records)
• Export to Google Sheets (create spreadsheets, append data)

AI Features

• AI Query Generator (chat-based interface)
• Natural language query bar (Quick Ask Bar)
• Explain Query - AI explains what a query does
• Validate Query - AI checks for issues and suggests improvements
• Multiple AI providers: Anthropic (Claude), OpenAI (GPT), OpenAI-Compatible, Cohere, xAI (Grok), Google (Gemini), Mistral AI
• AI-assisted chart generation
• AI Results Chat (optional - analyze results with AI)

Document Generator

• Create PDF/HTML documents from query results
• FreeMarker template support
• Multiple data sources in single document
• Document preview before generation
• Save/load document projects
• Generate standalone Suitelet code
• AI-assisted template generation

Tables Reference

• Browse all NetSuite tables
• View table columns with data types
• AI-powered table search (find tables by description)
• Generate SELECT query from selected columns
• Ask AI about selected tables/columns

Schema Explorer

• Build complete schema of NetSuite database
• Export formats: JSON, MySQL DDL, PostgreSQL DDL, SQLite DDL, SQL Server DDL, BigQuery DDL, Snowflake DDL, Redshift DDL, dbt Schema (YAML), Apache Avro, Markdown Documentation, DBML, Graphviz DOT
• Interactive ERD viewer with Mermaid.js
• Export ERD as SVG, PNG, or DOT

Query Libraries

• Remote Query Library (pre-built queries from cloud)
• Local Query Library (save to NetSuite File Cabinet)
• Query history with localStorage persistence

User Interface

• Modern SQL Studio-inspired design
• Dark mode toggle
• Focus mode (hides NetSuite navigation)
• Compact toolbar mode (icons only)
• Resizable editor/results panels
• Keyboard shortcuts help modal

Plugin Architecture

• Extensible plugin system
• Server-side hooks (onBeforeQuery, onAfterQuery, onError)
• Client-side hooks (onInit, onAfterQuery, onEditorChange)
• Custom server handlers
• 17 UI injection points
• Plugin settings with schema support