Skip to main content
Glama

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault

No arguments

Instructions

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Capabilities

Features and capabilities supported by this server

Protocol revision2025-11-25

CapabilityDetails
tools
{
  "listChanged": false
}

Tools

Functions exposed to the LLM to take actions

NameDescription
statistica_infoA

Report STATISTICA COM availability, version and executable path. Run this first if STATISTICA operations fail.

list_analysis_modulesA

List every analysis procedure exposed by STATISTICA (id + name) that can be driven with run_analysis.

describe_spreadsheetB

Open a .sta/.stw file and report case count, variable count and every variable (index, short name, clean name, long name/formula, type, measurement level, missing code).

read_variablesB

Read variable values. Numeric columns are read vectorized; text columns as strings. Missing values are returned as null.

list_sheetsA

List the sheets inside a .sta/.stw file (index, name, size) without loading variable data.

describe_analysisA

Introspect a STATISTICA analysis dialog before driving it: lists every settable property and callable method, plus known enum constants. Use it to build a run_analysis request.

write_variablesA

Overwrite whole variables in a spreadsheet. Numeric columns require exactly one value per case; missing values may be null. Text columns accept per-row strings (shorter arrays leave the rest untouched). Changes are only persisted if save is given.

set_formulaA

Assign a formula to a variable (STATISTICA keeps it in the variable long name) and recompute it, e.g. formula "=v9*v10". The result values are returned for inspection. Use attach=true to write into the running STATISTICA window.

add_variablesB

Append new empty variables to a spreadsheet. type: 0=numeric, 1=text, 2=integer, 3=byte.

rename_variablesC

Rename variables and/or change their long names, keyed by current variable name or index.

delete_variablesC

Delete an inclusive range of variables by index or name.

set_sizeB

Resize a spreadsheet. Growing adds empty cases/variables; shrinking discards the excess.

case_namesB

Read (and optionally set) case names / text labels for the rows of a spreadsheet. When names is given they are written (one per case, starting at case 1).

sort_dataB

Sort a spreadsheet in place by one or more keys (case names move with their rows). order may be a single value or one per key: 0/asc or 1/desc.

select_casesB

Keep only the rows matching a condition and drop the rest (all columns are rewritten). Supports numeric and text comparisons; missing values can be matched with op "missing".

recodeB

Recode the values of one variable using a mapping (old value -> new value), optionally sending every unlisted value to default. Missing values are preserved unless missing is given.

set_measurementA

Set the measurement level of a variable (auto/continuous/categorical/ordinal). STATISTICA uses it to treat the variable as a factor or a covariate in analysis.

value_labelsA

Attach or clear text labels for the numeric values of a variable. labels maps a numeric value to a label string or an object {label, description}; clear removes existing labels first.

export_csvC

Export a sheet to CSV using the STATISTICA built-in CSV writer.

save_spreadsheetB

Save a sheet to a new file. Extension selects the format (.sta, .stw, .csv, .xlsx).

import_dataC

Import a delimited text file or an Excel workbook into STATISTICA and optionally save it as .sta.

statistica_screenshotA

Launch STATISTICA visibly, optionally build a graph/analysis result, then capture the main window to a PNG/JPG image for a report. Content is prepared while hidden, then the window is shown and captured.

statistica_dialogB

Open an analysis module dialog in the running STATISTICA window and capture the actual setup panel to an image (Time Series/Forecasting, Transformations tabs, etc.). Use run:true to advance to the second-level panel.

statistica_openA

Launch a visible STATISTICA window (optionally opening a file) and leave it running. Subsequent calls with attach:true edit this same window — no repeated start/stop of the application.

descriptivesB

Fast descriptive statistics computed in Node from data read through COM (N, missing, mean, sd, se, min, q1, median, q3, max, sum). Missing values are honoured using each variable's declared missing code.

statistica_descriptivesB

Descriptive statistics computed by the STATISTICA engine itself (Basic Statistics module), including ones the JS shortcut does not provide.

statistica_correlationC

Pearson correlation matrix computed by the STATISTICA Basic Statistics module.

statistica_frequenciesC

Frequency tables and histograms computed by the STATISTICA Basic Statistics module.

statistica_regressionC

Multiple linear regression via STATISTICA General Regression Models. The first predictor list entry is the dependent variable? No: dependent is the outcome and predictors are the regressors.

statistica_t_testA

Student t-tests via the STATISTICA Basic Statistics module. kind=single tests means against a constant; kind=dependent runs paired comparisons over the listed variables (pairs).

statistica_graphA

Build a STATISTICA graph and optionally export it to an image file. variables uses the module syntax, typically "x | y". properties sets additional dialog options (e.g. GraphType, FitType, ShowRawDataPoints). Common modules: 11003 2D Scatterplots, 11012 2D Line Plots, 11002 2D Histograms, 11010 2D Box Plots, 11021 3D Sequential, 11032 3D Surface.

statistica_time_seriesC

Time Series / Forecasting module. procedure is one of: descriptives, autocorrelation, partial_autocorrelation, cross_correlation, arima, spectral, smoothing, shift, exponential_smoothing, differencing, seasonal_decomposition. autocorrelation/partial_autocorrelation/spectral/smoothing/differencing/descriptives operate on a single series.

statistica_anovaA

Analysis of variance via STATISTICA General Linear Models (module 4100 / ANOVA). dependent is the outcome; between lists factor/covariate effects. Returns the ANOVA table (UnivariateResults) and parameter estimates.

statistica_clusterB

Hierarchical cluster analysis (module 2201). variables are the variables to cluster; returns cluster membership, the amalgamation schedule and descriptive statistics.

statistica_factorA

Factor analysis / principal components (module 2101). Extraction method defaults to PrincipalComponents; factors sets the requested number of factors. Returns eigenvalues, loadings and communalities.

statistica_correlation_matrixB

Build lagged series products for a time series: for lags 1..lags it creates variables Lag1..LagK holding x(t)*x(t-lag) (correlation products), optionally smoothed with a moving average, and returns their preview. Use mode "shift" for plain lagged series.

add_fit_lineA

Fit an ordinary least-squares line of y on x (x defaults to the case number) and write the fitted values to a new variable, so the trend can be plotted next to the data (a scriptable substitute for the interactive graph fit).

run_macroA

Execute STATISTICA BASIC (SVB) source code (or a .svb file) with the opened spreadsheet as ActiveSpreadsheet, then optionally save the result. Use it for custom recurrent models (DWLS/Lowess/EWPR) supplied as SVB macros.

statistica_normalityC

Normality diagnostics via the Basic Statistics module: descriptive summary plus Shapiro-Wilk W and Kolmogorov-Smirnov/Lilliefors tests and a histogram.

add_lag_columnB

Compute the lag-m correlation product x(t)*x(t-lag) of a series, smooth it with a centered moving average, and append it as a named column to a target sheet (builds the Month + Lag1..LagK matrix step by step).

run_analysisA

Run ANY STATISTICA analysis by executing an ordered list of steps against its dialog. Each step is one of: {"set": {PropertyName: value}} (set dialog properties), {"call": "MethodName", "args": [...]} (invoke a dialog method, e.g. ARIMAAndAutocorrelationFunctions), {"run": true} (execute the analysis), {"result": "Summary"} (read a result document/table after the run), {"saveGraph": "C:\out\plot.png", "result": "Graphs"} (export a graph document to an image; .png/.jpg/.emf). Results are returned as tables, arrays or document handles. Use describe_analysis to discover property and method names.

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

TDQS

C2.9/5.0

Scored across 41 tools

Disambiguation3/5

Several tools have overlapping purposes: descriptives vs statistica_descriptives, statistica_correlation vs statistica_correlation_matrix (which actually builds lagged products, not a correlation matrix), add_lag_column vs statistica_correlation_matrix, and run_analysis vs run_macro. Descriptions often clarify the intended use, but the names alone can mislead.

Naming Consistency3/5

Mostly snake_case, but the 'statistica_' prefix is applied inconsistently (statistica_regression vs descriptives, add_fit_line) and two tools share near-identical names (descriptives / statistica_descriptives). Still readable overall.

Tool Count2/5

41 tools is well above the typical 3-15 range; while STATISTICA is a large suite, redundancies (duplicate descriptives, overlapping correlation/lag tools, run_analysis vs run_macro) suggest consolidation is possible.

Completeness4/5

Covers file I/O, data manipulation, many statistical procedures, graphing, and GUI control, plus generic run_analysis/run_macro escape hatches. Minor gaps like explicit merge/join or case deletion exist but are workable via macros.

Maintenance

ActivityMaintained
ResponsivenessNo issues