Supports running the MCP server as a Docker container for statistical analysis and ML prediction capabilities
Allows analyzing data from PostgreSQL databases, calculating statistics, and generating ML predictions based on database content
Statsource MCP Server
A Model Context Protocol server that provides statistical analysis capabilities. This server enables LLMs to analyze data from various sources, calculate statistics, and generate predictions.
The statistics tool connects to our analytics API and allows AI models to perform statistical analysis and generate ML predictions based on user data, whether it's in a PostgreSQL database or a CSV file.
Available Tools
get_statistics
Analyze data and calculate statistics or generate ML predictions based on provided parameters.
Arguments:
columns
(list of strings, required): List of column names to analyze or predict (Ask user for exact column names).data_source
(string, optional): Path to data file (uploaded to statsource.me), database connection string (ask user for exact string), or API endpoint. If not provided, usesDB_CONNECTION_STRING
from env config if set.source_type
(string, optional): Type of data source ("csv", "database", or "api"). If not provided, usesDB_SOURCE_TYPE
from env config if set.table_name
(string, optional but required ifsource_type
is "database"): Name of the database table to use (Ask user for exact table name).statistics
(list of strings, optional): List of statistics to calculate (required forquery_type="statistics"
). Valid options include: 'mean', 'median', 'std', 'sum', 'count', 'min', 'max', 'describe', 'correlation', 'missing', 'unique', 'boxplot'.query_type
(string, optional, default="statistics"): Type of query ("statistics" or "ml_prediction").periods
(integer, optional): Number of future periods to predict (required forquery_type="ml_prediction"
).filters
(dict, optional): Dictionary of column-value pairs to filter data (e.g.,{"status": "completed", "region": ["North", "East"]}
).groupby
(list of strings, optional): List of column names to group data by before calculating statistics (e.g.,["region", "product_category"]
).options
(dict, optional): Dictionary of additional options for specific operations.date_column
(string, optional): Column name containing date/timestamp information for filtering and time-series analysis.start_date
(string or datetime, optional): Inclusive start date for filtering (ISO 8601 format, e.g., "2023-01-01").end_date
(string or datetime, optional): Inclusive end date for filtering (ISO 8601 format, e.g., "2023-12-31").
Key Usage Notes:
- Data Sources: For CSV, the user must upload the file to statsource.me first and provide the filename. For databases, ask the user for the exact connection string and table name. Never guess or invent connection details.
- Configuration: If
data_source
andsource_type
are not provided, the tool will attempt to useDB_CONNECTION_STRING
andDB_SOURCE_TYPE
from the environment configuration (see below). - Filtering/Grouping: Use
filters
,groupby
,date_column
,start_date
, andend_date
to analyze specific subsets of data.
suggest_feature
Suggest a new feature or improvement for the StatSource analytics platform.
Arguments:
description
(string, required): A clear, detailed description of the suggested featureuse_case
(string, required): Explanation of how and why users would use this featurepriority
(string, optional): Suggested priority level ("low", "medium", "high")
Installation
Using uv (recommended)
When using uv no specific installation is needed. We will use uvx to directly run mcp-server-stats.
Docker Support
A pre-built Docker image is available on Docker Hub, which simplifies running the server. You can use this image directly without needing to build it yourself.
Pull the image (optional, as docker run
will do this automatically if the image isn't present locally):
To run the server using the Docker image:
Note: For actual usage within applications like Claude.app, refer to the Configuration section below for passing necessary environment variables like API keys and database connection strings.
Using PIP
Alternatively you can install mcp-server-stats via pip:
After installation, you can run it as a script using:
Or use the console script:
Configuration
Configure for Claude.app
Add to your Claude settings:
Using uvx
Using docker
Using pip installation
Environment Variables
You can configure the server using environment variables in your Claude.app configuration:
Available environment variables:
API_KEY
: Your API key for authentication with statsource.meDB_CONNECTION_STRING
: Default database connection stringDB_SOURCE_TYPE
: Default data source type (usually "database")
Debugging
You can use the MCP inspector to debug the server. For uvx installations:
Or if you've installed the package in a specific directory or are developing on it:
Contributing
We encourage contributions to help expand and improve mcp-server-stats. Whether you want to add new tools, enhance existing functionality, or improve documentation, your input is valuable.
Pull requests are welcome! Feel free to contribute new ideas, bug fixes, or enhancements to make mcp-server-stats even more powerful and useful.
License
mcp-server-stats is licensed under the MIT License. This means you are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License. For more details, please see the LICENSE file in the project repository.
This server cannot be installed
hybrid server
The server is able to function both locally and remotely, depending on the configuration or use case.
Enables LLMs to perform statistical analysis and generate ML predictions on user data from databases or CSV files through a Model Context Protocol server.
Related MCP Servers
- AsecurityAlicenseAqualityA Model Context Protocol server that provides basic mathematical and statistical functions to LLMs, enabling them to perform accurate numerical calculations through a simple API.Last updated -131331MIT License
- -securityAlicense-qualityA comprehensive toolkit that enhances LLM capabilities through the Model Context Protocol, allowing LLMs to interact with external services including command-line operations, file management, Figma integration, and audio processing.Last updated -22Apache 2.0
- -securityAlicense-qualityA Model Context Protocol server that enables LLMs to interact with databases (currently MongoDB) through natural language, supporting operations like querying, inserting, deleting documents, and running aggregation pipelines.Last updated -MIT License
- -securityAlicense-qualityProvides advanced analytical, research, and natural language processing capabilities through a Model Context Protocol server, enabling dataset analysis, decision analysis, and enhanced NLP features like entity recognition and fact extraction.Last updated -3MIT License