SQL Editor · IntellX

Hundreds of SQL editors. Only one speaks Sage X3.

Built-in table dictionary, autocompletion on your folder and your custom fields, guarded read-only execution. Queries written in minutes instead of an afternoon.

From your browser · No direct database access for your users

Stock below minimum.sqlPROD folderRead only
-- Items below safety stock, MTL site
SELECT I.ITMREF_0, I.ITMDES1_0, S.PHYSTO_0, F.REOMINQTY_0
FROM ITMMASTER I
JOIN ITMFACILIT F ON F.ITMREF_0 = I.ITMREF_0
JOIN ITMM 
ITMMVTItem stock by site
ITMMASTERItems
ZITMCHANTItems by site code · custom
ItemDescriptionStockMin
BMS0100Engine block S1001250
BMS0240Engine block S240325
CPL1120Coupling 1120040
7 rows · 0.4 sExport to Excel

The problem

Generic SQL knows nothing about your folder

The Sage X3 data model is not something you improvise: thousands of tables, abbreviated field names, dimension suffixes, and your own additions on top.

Finding the right table

ITMMASTER, ITMFACILIT, ITMMVT, STOCK: which one holds the data you are after?

Decoding the fields

_0 suffixes, activity codes, miscellaneous tables: a field name does not say what it holds.

Working without a safety net

Running a query straight on the production database is a risk nobody enjoys taking.

Features

Write X3 SQL without knowing the dictionary by heart

Dictionary

The tables, explained

Every table and field shows its business label, right inside the editor.

Assistance

From plain language to SQL

Describe what you are looking for, the editor proposes the query, the joins and the filters that go with it.

Autocompletion

On your folder

Standard tables, custom fields, company and site codes: completion knows your environment, not a theoretical X3.

Security

Guarded execution

Read only by default. Queries run with guardrails, and every run is logged.

Results

Usable straight away

Results you can sort, filter and export to Excel or CSV for your analysis.

Team

Shared queries

Useful queries become a common library, instead of circulating by e-mail.

In practice

From the question to the answer

1 · Your question

"Revenue invoiced per customer in 2026, with the number of invoices"

2 · The proposed query

SELECT BPR_0,
  COUNT(*) AS NB,
  SUM(AMTNOT_0) AS CA_HT
FROM SINVOICE
WHERE YEAR(ACCDAT_0) = 2026
GROUP BY BPR_0

3 · The result

CL0042318 400 €
CL0117247 950 €
CL000896 300 €

You review, you adjust, you export.

Illustrative example, on demonstration data.

Security

Query without ever touching your data

The editor is for reading, understanding and extracting. Writes into Sage X3 go through the standard screens and mechanisms, never through a query.

  • Read only by default on your folders
  • Editor access granted user by user
  • Every run logged: who, what, when
  • Your queries and results stay in your private space
See how ChatX3 learns your customisations

Who uses it

Developers

Check a value during development, without leaving the browser.

Consultants

Diagnose a setup discrepancy by querying the folder directly.

Finance and controlling

Pull a reliable extract without queuing behind IT.

IntellX

Your X3 data, one query away.

Bring the query that has been resisting you for weeks. We write it together during the demo.

Adrien GeraldesLaurent Verde

30 min with Adrien or Laurent.
We solve your current X3 headache together.