Published on August 15, 2025.
Over the past few days, I've spent some time experimenting with NetSuite's new AI Connector Service. I think that its sleeper capability is its ability to provide Claude with access to data via SuiteQL queries. This means we don't always need custom MCP tools to make NetSuite data available. It opens the door to analyzing all sorts of information, directly, flexibly, and instantly.
With this powerful combination, SuiteQL-savvy business users can now run instant, ad hoc analysis that turns raw NetSuite data into actionable intelligence.
The NetSuite AI Connector opens a new paradigm for ERP analytics. Instead of being limited to pre-built reports and dashboards, you can now run sophisticated SuiteQL queries directly through Claude and receive immediate analysis of the results.
Here's an example:
SELECT ID, FirstName AS "First Name", LastName AS "Last Name", Title, Supervisor AS "Supervisor ID", BUILTIN.DF( Supervisor ) AS "Supervisor Name", Subsidiary AS "Subsidiary ID", BUILTIN.DF( Subsidiary ) AS "Subsidiary Name", Department AS "Department ID", BUILTIN.DF( Department ) AS "Department Name" FROM Employee WHERE -- Exclude inactive employees for current workforce analysis. ( IsInactive = 'F' )
Within seconds, Claude executes the query and provides:
• Organizational structure insights
• Headcount distribution across regions and departments
• Management hierarchy analysis
• Data quality observations
• Strategic recommendations
It's worth noting that SuiteQL queries can only be run against the tables and data that your NetSuite role has permissions to access. This ensures that sensitive data remains secure and unavailable to unauthorized users. If you're concerned about security, this should give you confidence that the AI Connector respects the same permission model you already rely on in NetSuite.
The real breakthrough comes when you write SuiteQL queries with AI interpretation in mind. The way you structure queries, use aliases, and add comments directly affects the quality of insights Claude delivers.
SELECT Supervisor, BUILTIN.DF(Supervisor), Subsidiary, BUILTIN.DF(Subsidiary) FROM EmployeeAI-Optimized Query:
SELECT Supervisor AS "Supervisor ID", BUILTIN.DF( Supervisor ) AS "Supervisor Name", Subsidiary AS "Subsidiary ID", BUILTIN.DF( Subsidiary ) AS "Subsidiary Name" FROM Employee
The second approach instantly communicates:
• Data Relationships: The parallel ID/Name structure reveals relational context.
• Business Meaning: Clear aliases like "Supervisor Name" provide semantic clarity.
• Analysis Intent: Claude knows you want both reference IDs and readable values.
Comments aren't just helpful for developers. They also help AI interpret intent.
For example...
WHERE -- Exclude inactive employees for current workforce analysis. ( IsInactive = 'F' )
This small note tells Claude:
• The business context (workforce analysis)
• The filtering logic (active vs inactive)
• The analytical intent (current state, not historical)
Using BUILTIN.DF() together with thoughtful aliases creates a query result that's ideal for AI:
• ID Fields allow grouping, pattern analysis, and relationships.
• Display Fields allow human-readable reporting and recommendations.
Write Self-Documenting Queries
• Use aliases that describe meaning
• Add comments to capture intent
• Think about both human and AI readability
Leverage NetSuite Functions
• Use BUILTIN.DF() to map IDs to names.
• Date functions for time-based trends
• Hierarchical functions for org data
Go Beyond Data Retrieval
• Frame queries for analysis, not extraction
• Include contextual fields that help interpretation
• Structure results to reveal patterns
Iterate and Refine
• Start broad, then narrow
• Use Claude's feedback to expand or adjust
• Continuously improve query quality
The NetSuite AI Connector isn't just a new feature — it's a new way of thinking about business intelligence.
By combining SuiteQL's flexibility with Claude's analytical power, organizations can:
• Democratize Analysis: Insights for business users without IT dependency
• Accelerate Decisions: Minutes instead of days
• Improve Data Quality: AI highlights gaps and inconsistencies
• Scale Intelligence: One approach, unlimited scenarios
I believe the real shift that's happening - or is about to happen - isn't really technical. Instead, it's about mindset, and thinking differently.
Instead of thinking about SuiteQL queries as simply a way to extract data, we need to start thinking of them as a way to guide conversations with AI.
When you:
• Add aliases that carry meaning,
• Write comments that explain intent,
• And frame queries as questions,
you transform raw NetSuite data into strategic intelligence.
The future of ERP analytics is here: intelligent conversations with your data, powered by SuiteQL and the NetSuite AI Connector.
Hello, I'm Tim Dietrich. I develop custom software for businesses that are running on NetSuite, including mobile apps, Web portals, Web APIs, and more.
I'm the developer of several popular NetSuite open source solutions, including the SuiteQL Query Tool, SuiteAPI, and more.
I founded SuiteStep, a NetSuite development studio, to provide custom software and AI solutions - and continue pushing the boundaries of what's possible on the NetSuite platform.
Copyright © 2025 Tim Dietrich.