Smart Survey Server
Data Upload & Analysis
Upload survey data to a PostgreSQL database and use the mcp-capabilities for automatic processing and cross-table analysis
Upload
Excel file processing supports up to two worksheets with automated detection of codebooks and datasets based on worksheet naming conventions (Innofact format). For single-worksheet files, codebooks are generated automatically. All column headers must be unique. SPSS files are parsed to import both the data and variables datasets.
Client Configuration
Claude Desktop Configuration
"mcpServers": {
"surveys": {
"command": "npx",
"args": [
"mcp-remote",
"https://surveys.vmc-data.de/mcp",
"--header",
"Authorization: Bearer ${AUTH_TOKEN}",
"--header",
"x-mcp-database: surveys"
],
"env": {
"AUTH_TOKEN": "api-key-here"
}
}
}
VSCode Configuration
"servers": {
"surveys": {
"url": "https://surveys.vmc-data.de/mcp",
"type": "http",
"headers": {
"Authorization": "Bearer api-key-here",
"x-mcp-database": "surveys"
}
}
}
Cursor AI Configuration
"mcpServers": {
"surveys": {
"url": "https://surveys.vmc-data.de/mcp",
"headers": {
"Authorization": "Bearer api-key-here",
"x-mcp-database": "surveys"
}
}
}
Windsurf Configuration
"mcpServers": {
"surveys": {
"serverUrl": "https://surveys.vmc-data.de/mcp",
"headers": {
"Authorization": "Bearer api-key-here",
"x-mcp-database": "surveys"
}
}
}
Replace api-key-here with your actual API key. The x-mcp-database
header specifies which database to use initially (optional). Contact your administrator for
API access credentials.
Prompt Templates
discover-survey-structure
Comprehensive survey structure discovery and metadata analysis for understanding data architecture.
analyze-survey-frequencies
Comprehensive frequency analysis for survey variables with SPSS-equivalent output and statistics.
cross-tabulation-analysis
Cross-tabulation analysis workflow comparing survey variables with statistical testing.
nps-analysis
Comprehensive Net Promoter Score analysis with proper variable identification and segmentation workflow.
customer-satisfaction-analysis
Complete customer satisfaction analysis including NPS, cross-tabs, and customer segmentation.
advanced-survey-modeling
Advanced statistical modeling for survey data including correlation and predictive analysis.
Available Tools
query
Execute read-only SQL queries against PostgreSQL databases with full support for complex operations, joins, aggregations, and advanced PostgreSQL features.
inspect_table
Comprehensive table inspection with detailed column definitions, constraints, indexes, relationships, sample data, and JSON/JSONB key analysis for database exploration.
get_frequencies
SPSS-equivalent frequency analysis for survey variables with value labels, percentages, cumulative statistics, and missing value handling for comprehensive data insights.
analyze_codebook
Intelligent survey structure analysis that detects variable patterns, question sets, NPS candidates, and question types for automated survey metadata insights.
calculate_nps
Net Promoter Score calculation with automatic variable detection, customer segmentation, and business intelligence insights. Supports custom scales and statistical interpretation.