MCP Server Documentation — SPSS InsightGenius

Connecting Claude (web or desktop app)

Once connected, you can chat with your SPSS data inside Claude: frequency tables, crosstabs with significance letters, NPS and full tabulations exported to Excel, with no code.

In Claude, open Settings → Connectors → Add custom connector.
Name it InsightGenius and use the URL https://spss.insightgenius.io/mcp/sse.
Verify the connection. Start a new chat, enable the connector and try:
"Upload my survey.sav, then show me the frequency of Q1 broken down by gender with significance letters."

Free, no key needed. Claude asks you to upload your file at spss.insightgenius.io/upload and paste back the file_id. On the free plan files can be up to 5 MB, Excel tabulations use the first 100 respondents (each sheet says so), and calls are rate-limited.

Need the whole file? Get the full workbook for any number of respondents pay per use, from $3 per workbook, on Apify. Agencies that need an API key for higher limits can contact us; tools take the key in their api_key argument.

Other Clients

Cursor IDE

Add this to your MCP settings (mcp.json):

{
  "mcpServers": {
    "insightgenius": {
      "url": "https://spss.insightgenius.io/mcp/sse"
    }
  }
}

n8n / Make / Zapier (Automation)

For an MCP client node, point it at the SSE endpoint:

SSE Endpoint: https://spss.insightgenius.io/mcp/sse

To produce a full workbook on a schedule (for example, every tracking wave), the SPSS Tabulator on Apify has native n8n, Make and Zapier integrations and is billed per delivered workbook.

How It Works

1

Upload

spss_upload_file stores your file in a 30-minute session. Returns a file_id.

2

Analyze

Use file_id with any analysis tool. No re-uploading. Get structured results + insights.

3

Present

Every response includes content_blocks ready for Gamma, PowerPoint, Canva, or Google Slides.

Tools (15)

System

spss_get_started

Quick-start guide and the list of available analysis tools.

spss_get_server_info

Engine status, available tools, plan limits, supported formats. No auth required.

spss_upload_file writes

Upload .sav/.csv/.xlsx file. Returns file_id for reuse (30-min TTL, refreshes on use).

Exploration

spss_get_metadata

Variable names, labels, types, AI-detected: suggested banners, groups (MRS/Grid), preset nets.

spss_describe_variable

Deep profile of one variable: distribution, labels, missing values, mean/std/median.

Analysis

spss_analyze_frequencies

Frequency tables for 1-50 variables in one call (batch). Counts, %, mean, std, median.

spss_analyze_crosstab

Cross-tabulation with significance letters (A/B/C), chi-square p-value, optional means + T-test.

spss_analyze_correlation requires MRX

Correlation matrix (Pearson/Spearman/Kendall) with p-values and significance flags.

spss_analyze_anova requires MRX

One-way ANOVA with Tukey HSD post-hoc pairwise comparisons.

spss_analyze_gap requires MRX

Importance-Performance gap analysis with priority classification and quadrant assignment.

spss_summarize_satisfaction requires MRX

Compact summary: Top 2 Box %, Bottom 2 Box %, Mean for multiple scale variables in one call.

Output

spss_auto_analyze zero-config

Upload file, get complete Excel. AI auto-detects banners, groups, nets. Returns download URL.

spss_create_tabulation

Full professional Excel: sig letters, nets, means, MRS, grids, custom groups. Returns download URL + tables_summary.

spss_export_data

Convert data to xlsx, csv, parquet, or dta format. Returns the file inline (base64).

spss_export_powerbi

Export as a Power BI-ready ZIP with auto-generated DAX measures. Returns the ZIP inline (base64).

Response Format

Every analysis tool returns a standard envelope with structured data, a deterministic insight summary, and presentation-ready content blocks:

{
  "tool": "spss_analyze_frequencies",
  "file_id": "abc123",
  "variables_analyzed": ["Q1_satisfaction"],
  "sample_size": 796,
  "results": [ ... ],
  "insight_summary": "Q1: most common is 'Satisfied' (38.2%, n=796)",
  "content_blocks": {
    "title": "Customer Satisfaction Distribution",
    "key_finding": "'Satisfied' is the most common response (38.2%)",
    "data_table_markdown": "| Value | % | Count |..."
  }
}

content_blocks is tool-agnostic — feed it directly to Gamma, PowerPoint, Canva, or Google Slides.

File Sessions

Upload once, analyze many times. No need to re-send 50MB of data on every call.

1. spss_upload_file(file_base64="...", filename="survey.sav")
   → { file_id: "abc123", ttl_seconds: 1800 }

2. spss_get_metadata(file_id="abc123")
   → { variables: [...], suggested_banners: [...] }

3. spss_analyze_frequencies(file_id="abc123", variables=["Q1", "Q2"])
   → { results: [...], insight_summary: "..." }

Sessions last 30 minutes (sliding window — resets on each use).

Backwards compatible: you can still pass file_base64 directly to any tool.

Supported Formats

Format	Extension	Metadata
SPSS	.sav, .por, .zsav	Full (variable labels, value labels, types)
CSV	.csv, .tsv	Inferred from column names + dtypes
Excel	.xlsx, .xls	Inferred from column names + dtypes

Authentication

The server uses the SSE transport at https://spss.insightgenius.io/mcp/sse.

No key: the free plan (files up to 5 MB, tabulations use the first 100 respondents, rate-limited).
API key (sk_live_...): higher limits; pass it as the api_key argument of each tool call and when uploading at /upload. Keys are issued on request: hello@insightgenius.io.

Data Privacy

Sessions: uploaded file data is kept in Redis and expires 30 minutes after its last use
Downloads: download links expire after 5 minutes
Numbers: every statistic is computed by the deterministic engine, never by an AI model

Full policy: spss.insightgenius.io/privacy