STATISTICA MCP
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
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
| Capability | Details |
|---|---|
| tools | {
"listChanged": false
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| 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 |
| 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 |
| sort_dataB | Sort a spreadsheet in place by one or more keys (case names move with their rows). |
| 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 |
| 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. |
| 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 |
| 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: |
| 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. |
| 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). |
| statistica_clusterB | Hierarchical cluster analysis (module 2201). |
| statistica_factorA | Factor analysis / principal components (module 2101). Extraction method defaults to PrincipalComponents; |
| 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 |
| 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
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 41 tools
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.
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.
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.
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.