MCP Tabular Data Analysis Server
Enables querying and analyzing SQLite databases, including executing SQL queries, listing tables and schemas, and performing data analysis operations on database contents.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@MCP Tabular Data Analysis Servershow me the top 5 sales categories from sample_sales.csv"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
MCP Tabular Data Analysis Server
A Model Context Protocol (MCP) server that provides tools for analyzing numeric and tabular data. Works with CSV files and SQLite databases.
Demo
auto_insights
data_quality_report
analyze_time_series
Related MCP server: Vibe Preprocessing and Analysis MCP Server
Features
Core Tools
Tool | Description |
| List available CSV and SQLite files in the data directory |
| Generate statistics for a dataset (shape, types, distributions, missing values) |
| Find outliers using Z-score or IQR methods |
| Calculate correlation matrices between numeric columns |
| Filter data using various operators (eq, gt, lt, contains, etc.) |
| Group data and compute aggregations (sum, mean, count, etc.) |
| Execute SQL queries on SQLite databases |
| List all tables and schemas in a SQLite database |
Analytics Tools
Tool | Description |
| Create Excel-style pivot tables with flexible aggregations |
| Data quality assessment with scores and recommendations |
| Time series analysis with trends, seasonality, and moving averages |
| Create visualizations (bar, line, scatter, histogram, pie, box plots) |
| Join/merge two datasets together (inner, left, right, outer joins) |
| Hypothesis testing (t-test, ANOVA, chi-squared, correlation tests) |
| Discover patterns and insights |
| Export filtered/transformed data to new CSV files |
Installation
Prerequisites
Python 3.10+
uv (recommended) or pip
Install with uv
cd mcp-tabular
uv syncInstall with pip
cd mcp-tabular
pip install -e .Usage
Running the Server Directly
# With uv
uv run mcp-tabular
# With pip installation
mcp-tabularConfigure with Claude Desktop
Locate your Claude Desktop config file:
macOS:
~/Library/Application Support/Claude/claude_desktop_config.jsonWindows:
%APPDATA%\Claude\claude_desktop_config.jsonLinux:
~/.config/Claude/claude_desktop_config.json
Add this configuration (replace
/Users/kirondeb/mcp-tabularwith your actual path):
{
"mcpServers": {
"tabular-data": {
"command": "/Users/kirondeb/mcp-tabular/.venv/bin/python",
"args": [
"-m",
"mcp_tabular.server"
]
}
}
}Restart Claude Desktop (quit and reopen)
Test by asking Claude: "Describe the dataset in data/sample_sales.csv"
See CONNECT_TO_CLAUDE_DESKTOP.md for detailed instructions and troubleshooting.
See TEST_PROMPTS.md for example prompts.
Sample Data
The project includes sample data for testing:
data/sample_sales.csv- Sales transaction datadata/sample.db- SQLite database with customers, orders, and products tables
To create the SQLite sample database:
python scripts/create_sample_db.pyPath Resolution
All file paths are resolved relative to the project root directory:
Relative paths like
data/sample_sales.csvwork from any working directoryAbsolute paths also work as expected
Paths resolve relative to where
mcp_tabularis installed
Tool Examples
List Data Files
List available data files:
list_data_files()Lists all CSV and SQLite files in the data directory with metadata.
Describe Dataset
Generate statistics for a dataset:
describe_dataset(file_path="data/sample_sales.csv")Includes shape, column types, numeric statistics (mean, std, median, skew, kurtosis), categorical value counts, and a sample preview.
Detect Anomalies
Find outliers in numeric columns:
detect_anomalies(
file_path="data/sample_sales.csv",
column="total_sales",
method="zscore",
threshold=3.0
)Supports zscore and iqr methods.
Compute Correlation
Calculate correlations between numeric columns:
compute_correlation(
file_path="data/sample_sales.csv",
method="pearson"
)Includes full correlation matrix and top correlations ranked by strength.
Filter Rows
Filter data based on conditions:
filter_rows(
file_path="data/sample_sales.csv",
column="category",
operator="eq",
value="Electronics"
)Operators: eq, ne, gt, gte, lt, lte, contains, startswith, endswith
Group & Aggregate
Group data and compute aggregations:
group_aggregate(
file_path="data/sample_sales.csv",
group_by=["category", "region"],
aggregations={"total_sales": ["sum", "mean"], "quantity": ["count"]}
)Query SQLite
Execute SQL queries on databases:
query_sqlite(
db_path="data/sample.db",
query="SELECT * FROM customers WHERE lifetime_value > 1000"
)List Tables
List tables and schemas in a SQLite database:
list_tables(db_path="data/sample.db")Advanced Analytics Examples
Create Pivot Table
Create Excel-style pivot tables:
create_pivot_table(
file_path="data/sample_sales.csv",
index=["region"],
columns=["category"],
values="total_sales",
aggfunc="sum"
)Data Quality Report
Generate a data quality assessment:
data_quality_report(file_path="data/sample_sales.csv")Includes completeness score, duplicate detection, outlier analysis, and an overall quality grade (A-F).
Time Series Analysis
Analyze trends and seasonality:
analyze_time_series(
file_path="data/sample_sales.csv",
date_column="order_date",
value_column="total_sales",
freq="M",
include_forecast=True
)Generate Charts
Create visualizations (returned as base64 images):
generate_chart(
file_path="data/sample_sales.csv",
chart_type="bar",
x_column="category",
y_column="total_sales",
title="Sales by Category"
)Supported chart types: bar, line, scatter, histogram, pie, box
Merge Datasets
Join or merge two datasets:
merge_datasets(
file_path_left="data/orders.csv",
file_path_right="data/customers.csv",
on=["customer_id"],
how="left"
)Statistical Testing
Run hypothesis tests:
statistical_test(
file_path="data/sample_sales.csv",
test_type="ttest_ind",
column1="total_sales",
group_column="region",
alpha=0.05
)Supported tests: ttest_ind, ttest_paired, chi_squared, anova, mann_whitney, pearson, spearman
Auto Insights
Discover patterns and insights:
auto_insights(file_path="data/sample_sales.csv")Includes insights about correlations, outliers, skewed distributions, missing data, and more.
Export Data
Export filtered data to a new CSV:
export_data(
file_path="data/sample_sales.csv",
output_name="electronics_sales",
filter_column="category",
filter_operator="eq",
filter_value="Electronics",
sort_by="total_sales",
sort_ascending=False
)Development
Run Tests
uv run pytestProject Structure
mcp-tabular/
├── src/
│ └── mcp_tabular/
│ ├── __init__.py
│ └── server.py # Main MCP server implementation
├── data/
│ ├── sample_sales.csv # Sample CSV data
│ └── sample.db # Sample SQLite database
├── scripts/
│ └── create_sample_db.py
├── pyproject.toml
├── claude_desktop_config.json
└── README.mdLicense
MIT
Available Tools
16 toolsanalyze_time_seriesA
Perform time series analysis including trend detection, seasonality, and statistics.
Args:
file_path: Path to CSV or SQLite file
date_column: Name of the date/datetime column
value_column: Name of the numeric column to analyze
freq: Frequency for resampling - 'D' (daily), 'W' (weekly), 'M' (monthly), 'Q' (quarterly), 'Y' (yearly)
include_forecast: If True, include simple moving average forecast
Returns:
Dictionary containing:
- trend: Overall trend direction and statistics
- statistics: Time series statistics
- moving_averages: 7, 30, 90 period moving averages
- seasonality: Day of week / month patterns
- forecast: Simple forecast if requested
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| date_column | Yes | ||
| value_column | Yes | ||
| freq | No | D | |
| include_forecast | No |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries the full burden. It discloses the analysis components and return structure, which is helpful, but lacks critical behavioral details like computational requirements, error handling, file format specifics beyond CSV/SQLite, or whether it modifies input files. It adequately describes the operation but misses deeper behavioral context.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is well-structured with clear sections for Args and Returns, making it easy to parse. It's appropriately sized with no redundant information, though the 'Returns' section could be slightly more concise by omitting obvious details like 'if requested'.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the complexity of time series analysis, no annotations, and an output schema (implied by the Returns section), the description is fairly complete. It covers parameters thoroughly and outlines return values, but could benefit from more behavioral context like performance characteristics or limitations.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The schema description coverage is 0%, so the description must fully compensate. It provides detailed semantics for all 5 parameters: file_path specifies CSV/SQLite, date_column and value_column explain their roles, freq lists enum-like values with explanations, and include_forecast clarifies its effect. This adds substantial meaning beyond the bare schema.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool performs time series analysis with specific components (trend detection, seasonality, statistics), which is a clear verb+resource combination. However, it doesn't explicitly differentiate from sibling tools like 'detect_anomalies' or 'statistical_test' that might also analyze data, missing full sibling differentiation.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool versus alternatives like 'detect_anomalies' or 'statistical_test'. It mentions what the tool does but offers no context about appropriate use cases, prerequisites, or exclusions.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
auto_insightsA
Automatically generate interesting insights about a dataset.
Perfect for quick data exploration and understanding.
Args:
file_path: Path to CSV or SQLite file
max_insights: Maximum number of insights to generate (default 10)
Returns:
Dictionary containing automatically discovered insights
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| max_insights | No |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations are provided, so the description carries the full burden of behavioral disclosure. It mentions that insights are 'automatically generated' and 'interesting,' but lacks details on what types of insights are produced, whether the operation is read-only or modifies data, performance characteristics, or error handling. This is a significant gap for a tool with no annotation coverage.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is well-structured and front-loaded with the core purpose, followed by concise usage guidance and clear parameter/return sections. Every sentence adds value without redundancy, making it efficient and easy to scan.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool's moderate complexity (2 parameters, no annotations), the description is reasonably complete: it explains the purpose, usage context, parameters, and return value. Since an output schema exists, the description doesn't need to detail return values, but it could improve by addressing behavioral aspects like data safety or insight types to better compensate for the lack of annotations.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The description adds meaningful context for both parameters: it specifies that 'file_path' is for 'CSV or SQLite file' and 'max_insights' has a default of 10. Since schema description coverage is 0% (no schema descriptions provided), this compensates well by clarifying file types and default behavior, though it doesn't detail constraints like valid file paths or insight count ranges.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool's purpose: 'Automatically generate interesting insights about a dataset.' It specifies the verb ('generate insights') and resource ('dataset'), though it doesn't explicitly differentiate from siblings like 'describe_dataset' or 'data_quality_report' which might offer similar exploratory functions.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides some implied usage guidance with 'Perfect for quick data exploration and understanding,' suggesting it's for initial analysis. However, it doesn't explicitly state when to use this tool versus alternatives like 'describe_dataset' or 'detect_anomalies,' nor does it mention any prerequisites or exclusions.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
compute_correlationA
Compute correlation matrix between numeric columns.
Args:
file_path: Path to CSV or SQLite file
columns: List of columns to include (default: all numeric columns)
method: Correlation method - 'pearson' (default), 'spearman', or 'kendall'
Returns:
Dictionary containing:
- method: Correlation method used
- correlation_matrix: Full correlation matrix
- top_correlations: Top 10 strongest correlations (excluding self-correlations)
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| columns | No | ||
| method | No | pearson |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries the full burden of behavioral disclosure. It describes the return structure in detail, which is helpful, but lacks information on error handling, performance characteristics, or data size limitations. It adequately covers the core operation but misses advanced behavioral traits.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is well-structured and front-loaded with the core purpose, followed by clear sections for arguments and returns. Every sentence adds value, with no redundant or verbose language, making it efficient and easy to parse.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool's moderate complexity, no annotations, and an output schema that likely covers return values, the description is mostly complete. It details parameters and returns well, but could improve by addressing usage guidelines or edge cases. The presence of an output schema reduces the need for return value explanation.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The description adds significant meaning beyond the input schema, which has 0% description coverage. It explains that 'file_path' is for CSV or SQLite files, 'columns' defaults to all numeric columns, and 'method' includes specific options like 'pearson', 'spearman', or 'kendall' with a default. This fully compensates for the schema's lack of descriptions.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the verb 'compute' and the resource 'correlation matrix between numeric columns,' making the purpose specific and unambiguous. It distinguishes this tool from siblings like 'statistical_test' or 'describe_dataset' by focusing specifically on correlation analysis.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool versus alternatives. It does not mention sibling tools like 'statistical_test' for other analyses or 'describe_dataset' for basic statistics, leaving the agent without context for tool selection.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
create_pivot_tableA
Create a pivot table from tabular data - the most common business analysis operation.
Args:
file_path: Path to CSV or SQLite file
index: Column(s) to use as row labels (grouping)
columns: Column(s) to use as column headers (optional)
values: Column to aggregate (default: first numeric column)
aggfunc: Aggregation function - 'sum', 'mean', 'count', 'min', 'max', 'median', 'std'
fill_value: Value to replace missing entries (default: None = show as null)
Returns:
Dictionary containing the pivot table data and metadata
Example:
create_pivot_table(
file_path="data/sales.csv",
index=["region"],
columns=["category"],
values="revenue",
aggfunc="sum"
)
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| index | Yes | ||
| columns | No | ||
| values | No | ||
| aggfunc | No | mean | |
| fill_value | No |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries the full burden of behavioral disclosure. It describes the core operation (creating a pivot table) and mentions the return format ('dictionary containing the pivot table data and metadata'), but doesn't cover important behavioral aspects like error handling, performance characteristics, file format limitations beyond CSV/SQLite, or whether the operation modifies source data.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is well-structured and appropriately sized. It begins with a clear purpose statement, follows with detailed parameter explanations in a structured format, specifies the return value, and provides a concrete example. Every sentence adds value without redundancy, making it easy for an AI agent to parse and understand.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool's complexity (6 parameters, data transformation operation) and the presence of an output schema, the description is largely complete. It explains the core operation, all parameters, and mentions the return format. The main gap is lack of behavioral context around errors, performance, or limitations, but the output schema reduces the need to fully describe return values.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
With 0% schema description coverage, the description provides excellent parameter semantics that fully compensate. Each parameter is clearly explained with its purpose, defaults, and examples. The description adds substantial meaning beyond the bare schema, explaining what 'index', 'columns', 'values', 'aggfunc', and 'fill_value' actually mean in the context of pivot table creation.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool's purpose with specific verbs ('create a pivot table from tabular data') and resource ('tabular data'), distinguishing it from sibling tools like 'group_aggregate' or 'analyze_time_series'. It explicitly identifies this as 'the most common business analysis operation', providing clear differentiation.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool versus alternatives like 'group_aggregate' or 'analyze_time_series'. While it mentions this is for 'the most common business analysis operation', it doesn't specify scenarios where pivot tables are preferred over other aggregation or analysis methods available in the sibling tools.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
data_quality_reportA
Generate a comprehensive data quality assessment report.
Essential for understanding data health before analysis.
Args:
file_path: Path to CSV or SQLite file
Returns:
Dictionary containing:
- completeness: Missing value analysis per column
- uniqueness: Duplicate detection
- validity: Data type consistency and outlier counts
- overall_score: Data quality score (0-100)
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries the full burden of behavioral disclosure. It describes the tool's output format in detail, which is valuable, but doesn't cover other behavioral aspects like performance characteristics, error handling, or resource requirements. It adequately explains what the tool does but could add more operational context.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is well-structured and appropriately sized. It starts with the core purpose, provides usage context, then details arguments and returns in clear sections. Every sentence adds value, though the 'Essential for...' line could be slightly more concise.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool's complexity (data quality assessment), the description is reasonably complete. It explains the purpose, usage context, parameter semantics, and detailed return values. Since an output schema exists, the description doesn't need to explain return values, but it does so anyway, adding clarity. The main gap is lack of behavioral details beyond output format.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The description adds significant meaning beyond the input schema. The schema has 0% description coverage and only shows 'file_path' as a string parameter. The description specifies that it accepts 'Path to CSV or SQLite file,' clarifying the expected file formats, which is crucial information not present in the schema.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool's purpose: 'Generate a comprehensive data quality assessment report.' It specifies the verb ('generate') and resource ('data quality assessment report'), making the function unambiguous. However, it doesn't explicitly differentiate from sibling tools like 'describe_dataset' or 'detect_anomalies', which might also provide data insights.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides some usage context: 'Essential for understanding data health before analysis.' This implies when to use it (pre-analysis data assessment) but doesn't specify when not to use it or name alternatives among siblings. It's helpful but lacks explicit guidance on tool selection.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
describe_datasetA
Generate comprehensive statistics for a tabular dataset.
Args:
file_path: Path to CSV or SQLite file
include_all: If True, include statistics for all columns (not just numeric)
Returns:
Dictionary containing:
- shape: (rows, columns)
- columns: List of column names with their types
- numeric_stats: Descriptive statistics for numeric columns
- missing_values: Count of missing values per column
- sample: First 5 rows as preview
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| include_all | No |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries the full burden of behavioral disclosure. It partially succeeds by describing the return format in detail, but fails to mention critical behaviors like performance implications for large datasets, memory usage, error handling for invalid files, or whether the operation is read-only (implied but not stated). The description adds some context but leaves significant gaps.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is perfectly structured and front-loaded: the first sentence states the core purpose, followed by clearly labeled sections for arguments and returns. Every sentence earns its place by providing essential information without redundancy, making it highly scannable and efficient.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool's moderate complexity (2 parameters, no annotations, but with output schema), the description is reasonably complete. The output schema exists, so the description appropriately doesn't need to explain return values in schema terms, but it usefully summarizes the dictionary structure. However, it misses some context like performance considerations or error cases.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema description coverage is 0%, so the description must compensate. It effectively explains both parameters: 'file_path' is clarified as 'Path to CSV or SQLite file', and 'include_all' is explained as controlling whether statistics cover all columns or just numeric ones. This adds meaningful semantics beyond the bare schema, though it doesn't detail file path format or validation rules.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the specific action ('Generate comprehensive statistics') and resource ('tabular dataset'), distinguishing it from sibling tools like 'data_quality_report' or 'statistical_test' by focusing on descriptive statistics rather than quality assessment or hypothesis testing. The verb 'generate' and scope 'comprehensive statistics' precisely define what the tool does.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool versus alternatives like 'data_quality_report' or 'auto_insights', nor does it mention prerequisites such as file format requirements or data size limitations. It lacks explicit when/when-not statements or named alternatives, leaving usage context implied at best.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
detect_anomaliesA
Detect anomalies/outliers in a numeric column.
Args:
file_path: Path to CSV or SQLite file
column: Name of the numeric column to analyze
method: Detection method - 'zscore' (default), 'iqr', or 'isolation_forest'
threshold: Threshold for anomaly detection (default 3.0 for zscore, 1.5 for IQR)
Returns:
Dictionary containing:
- method: Detection method used
- anomaly_count: Number of anomalies found
- anomaly_indices: Row indices of anomalies
- anomalies: The anomalous rows
- statistics: Column statistics
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| column | Yes | ||
| method | No | zscore | |
| threshold | No |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries full burden and does well by disclosing key behavioral traits: it specifies input requirements (numeric column, file types), default values for parameters, and detailed return structure. However, it doesn't mention potential limitations like file size constraints or computational intensity of methods like 'isolation_forest'.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is efficiently structured with a clear purpose statement followed by organized sections for Args and Returns. Every sentence adds value: the opening defines the tool, parameter explanations are necessary, and return details are essential given the output schema. No wasted words.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool's complexity (4 parameters, no annotations, 0% schema coverage) and the presence of an output schema, the description is complete. It covers purpose, parameters with semantics, and return structure, providing all necessary context for an agent to understand and invoke the tool correctly without redundancy.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The schema description coverage is 0%, so the description must compensate fully. It successfully adds meaning beyond the schema by explaining each parameter's purpose, default values, and method-specific threshold defaults. The 'Args' section provides clear semantics that the schema lacks entirely.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the specific action ('detect anomalies/outliers'), the resource ('numeric column'), and the context ('in a CSV or SQLite file'). It distinguishes itself from siblings like 'statistical_test' or 'describe_dataset' by focusing specifically on anomaly detection rather than general analysis or description.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description implies usage through parameter details (e.g., 'numeric column', 'CSV or SQLite file'), but doesn't explicitly state when to use this tool versus alternatives like 'data_quality_report' or 'statistical_test'. It provides context but lacks explicit guidance on tool selection among siblings.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
export_dataB
Export filtered/transformed data to a new CSV file.
Args:
file_path: Path to source CSV or SQLite file
output_name: Name for output file (without extension, saved to data/ folder)
filter_column: Optional column to filter on
filter_operator: Filter operator - 'eq', 'ne', 'gt', 'gte', 'lt', 'lte', 'contains'
filter_value: Value to filter by
columns: List of columns to include (default: all)
sort_by: Column to sort by
sort_ascending: Sort direction (default: ascending)
limit: Maximum rows to export
Returns:
Dictionary containing export details and file path
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| output_name | Yes | ||
| filter_column | No | ||
| filter_operator | No | ||
| filter_value | No | ||
| columns | No | ||
| sort_by | No | ||
| sort_ascending | No | ||
| limit | No |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations are provided, so the description carries full burden for behavioral disclosure. While it mentions the tool creates a new CSV file and returns a dictionary with export details, it lacks critical behavioral information: whether this operation modifies source files, what permissions are required, where exactly files are saved (beyond 'data/ folder'), error handling, or performance characteristics. The description is insufficient for a mutation tool with no annotation coverage.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is well-structured with clear sections (purpose, args, returns) and uses bullet-like formatting for parameters. Every sentence adds value, though the parameter explanations could be slightly more concise. The front-loaded purpose statement is effective, and there's no redundant information.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool's complexity (9 parameters, mutation operation) and lack of annotations, the description does well but has gaps. It thoroughly documents parameters and mentions the return format, but lacks behavioral context about file operations, permissions, or error conditions. The presence of an output schema helps, but for a data export tool that creates files, more operational context would be beneficial.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
With 0% schema description coverage, the description compensates excellently by providing detailed parameter documentation. It explains all 9 parameters with clear semantics: what each parameter controls, optional vs. required status, default values, and even enumerates the filter_operator options. This goes far beyond what the bare schema provides and makes the parameters fully understandable.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool's purpose: 'Export filtered/transformed data to a new CSV file.' It specifies the verb (export), resource (data), and output format (CSV file). However, it doesn't explicitly differentiate from sibling tools like 'filter_rows' or 'merge_datasets' which might have overlapping functionality, preventing a perfect score.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool versus alternatives. With sibling tools like 'filter_rows', 'merge_datasets', and 'query_sqlite' available, there's no indication of when this export tool is preferred over those for data manipulation tasks. The description only states what it does, not when it should be used.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
filter_rowsB
Filter rows based on a condition.
Args:
file_path: Path to CSV or SQLite file
column: Column name to filter on
operator: Comparison operator - 'eq', 'ne', 'gt', 'gte', 'lt', 'lte', 'contains', 'startswith', 'endswith'
value: Value to compare against
limit: Maximum number of rows to return (default 100)
Returns:
Dictionary containing:
- filter_applied: Description of the filter
- original_count: Number of rows before filtering
- filtered_count: Number of rows after filtering
- rows: Filtered rows (up to limit)
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| column | Yes | ||
| operator | Yes | ||
| value | Yes | ||
| limit | No |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries the full burden of behavioral disclosure. It mentions the tool filters rows and returns a dictionary with counts and rows, but fails to describe critical behaviors like whether it modifies the original file, handles errors (e.g., invalid file paths), supports pagination beyond the limit, or has performance implications for large datasets. This leaves significant gaps for a mutation-like tool.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is appropriately sized and front-loaded with the core purpose in the first sentence, followed by structured sections for arguments and returns. Every sentence earns its place by providing essential information, though minor improvements could include briefer formatting or merging related details for slightly better flow.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool's moderate complexity (5 parameters, no annotations, but with an output schema), the description is partially complete. It adequately covers parameters and return values due to the output schema, but lacks behavioral context (e.g., file handling, error cases) and usage guidelines relative to siblings, leaving room for improvement in overall completeness.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The description adds substantial meaning beyond the input schema, which has 0% description coverage. It clearly explains each parameter's purpose: 'file_path' for CSV/SQLite files, 'column' for filtering, 'operator' with specific comparison options, 'value' as the comparison target, and 'limit' with its default. This fully compensates for the schema's lack of descriptions, making parameters well-understood.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool's purpose as 'Filter rows based on a condition' with the verb 'filter' and resource 'rows', which is specific and actionable. However, it doesn't explicitly differentiate from sibling tools like 'query_sqlite' or 'group_aggregate' that might also involve data filtering operations, preventing a perfect score.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool versus alternatives like 'query_sqlite' for SQL-based filtering or 'list_data_files' for file operations. It lacks context about prerequisites (e.g., file format support) or exclusions, offering only basic parameter documentation without usage context.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
generate_chartB
Generate a chart/visualization from tabular data.
Returns chart as base64-encoded PNG for display.
Args:
file_path: Path to CSV or SQLite file
chart_type: Type of chart - 'bar', 'line', 'scatter', 'histogram', 'pie', 'box'
x_column: Column for X-axis (not needed for histogram/pie)
y_column: Column for Y-axis values
group_by: Optional column for grouping/coloring
title: Chart title (auto-generated if not provided)
output_format: 'base64' (default) or 'file' (saves to data/charts/)
Returns:
Dictionary containing chart data as base64 or file path
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| chart_type | Yes | ||
| x_column | No | ||
| y_column | No | ||
| group_by | No | ||
| title | No | ||
| output_format | No | base64 |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries the full burden of behavioral disclosure. It does disclose key behavioral traits: the tool returns charts as base64-encoded PNGs or file paths, and it auto-generates titles if not provided. However, it lacks important details like error handling, performance characteristics, file format limitations (beyond CSV/SQLite), or whether the operation is read-only/destructive. The description adds some value but doesn't fully compensate for the absence of annotations.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is well-structured and appropriately sized. It starts with the core purpose, then covers the return format, followed by a clear parameter section with brief explanations. Each sentence earns its place, though the 'Returns' section could be slightly more concise. The information is front-loaded with the most important details first.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool's moderate complexity (7 parameters, data visualization functionality) with no annotations but an output schema, the description provides good coverage. It explains what the tool does, parameter meanings, and return formats. The output schema handles return value documentation, so the description appropriately focuses on usage. However, it could better address error cases, performance considerations, or integration with sibling tools to be fully complete.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
With 0% schema description coverage, the description must compensate, and it does so effectively. It provides clear semantic explanations for all 7 parameters: what each parameter represents, optional vs. required status, valid values for chart_type, when x_column is not needed, default behaviors, and output format options. The description adds substantial meaning beyond the bare schema, though it could provide more detail about file path requirements or column name constraints.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool's purpose: 'Generate a chart/visualization from tabular data.' It specifies the verb (generate) and resource (chart/visualization) with the data source (tabular data). However, it doesn't explicitly differentiate from sibling tools like 'analyze_time_series' or 'auto_insights' that might also involve visualization, leaving some ambiguity about when to choose this specific chart generation tool.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool versus alternatives. With sibling tools like 'analyze_time_series' and 'auto_insights' that might overlap in visualization capabilities, there's no indication of when this specific chart generation tool is preferred. The description mentions basic usage context (tabular data) but lacks explicit when/when-not instructions or named alternatives.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
group_aggregateA
Group data and compute aggregations.
Args:
file_path: Path to CSV or SQLite file
group_by: Columns to group by
aggregations: Dictionary mapping column names to list of aggregation functions
(e.g., {"sales": ["sum", "mean"], "quantity": ["count", "max"]})
Supported: sum, mean, median, min, max, count, std, var
Returns:
Dictionary containing grouped and aggregated data
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| group_by | Yes | ||
| aggregations | Yes |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries full burden for behavioral disclosure. While it mentions the tool processes CSV or SQLite files and returns a dictionary, it lacks critical behavioral details: whether this operation modifies source files, memory/performance characteristics for large datasets, error handling for invalid inputs, or authentication requirements. The description covers basic functionality but misses important operational context.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is perfectly structured and concise. It begins with a clear purpose statement, then provides organized parameter documentation with helpful examples, and concludes with return value information. Every sentence earns its place, and the formatting with bullet-like sections makes it easily scannable without unnecessary verbiage.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool's moderate complexity (3 parameters with nested objects), no annotations, but with an output schema present, the description is reasonably complete. It covers all parameters thoroughly, specifies supported file formats and aggregation functions, and mentions the return type. The main gap is lack of behavioral context about file handling and performance, but the parameter documentation is comprehensive enough for basic usage.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The description provides excellent parameter semantics despite 0% schema description coverage. It clearly explains each parameter's purpose: 'file_path' accepts CSV or SQLite files, 'group_by' takes columns for grouping, and 'aggregations' is a dictionary mapping columns to specific functions with enumerated examples. The list of supported aggregation functions ('sum, mean, median, min, max, count, std, var') adds crucial value beyond the bare schema.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool's purpose: 'Group data and compute aggregations.' This specifies both the verb ('group and compute aggregations') and the resource ('data'), making it immediately understandable. However, it doesn't explicitly differentiate from sibling tools like 'create_pivot_table' or 'analyze_time_series' which might have overlapping functionality.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool versus alternatives. With multiple sibling tools for data analysis (e.g., 'create_pivot_table', 'analyze_time_series', 'compute_correlation'), there's no indication of when this specific aggregation approach is preferred or what distinguishes it from other data manipulation tools on the server.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
list_data_filesB
List available data files in the project data directory.
Args:
data_dir: Relative path to data directory (default: "data")
Returns:
Dictionary containing list of available CSV and SQLite files
| Name | Required | Description | Default |
|---|---|---|---|
| data_dir | No | data |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations are provided, so the description carries the full burden of behavioral disclosure. It states the tool lists files and returns a dictionary, but lacks details on permissions, rate limits, error handling, or whether it's read-only (implied but not explicit). For a tool with zero annotation coverage, this is a significant gap in transparency about its operational behavior.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is efficiently structured and front-loaded: the first sentence states the core purpose, followed by clear 'Args' and 'Returns' sections. Every sentence earns its place by providing necessary information without redundancy, making it easy to scan and understand quickly.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool's low complexity (one optional parameter) and the presence of an output schema (which handles return value documentation), the description is reasonably complete. It covers the purpose, parameter semantics, and return type adequately. However, it lacks usage guidelines and behavioral details, which are minor gaps in this simple context.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The description adds meaningful context for the single parameter: it explains that 'data_dir' is a 'Relative path to data directory' with a default of 'data', which clarifies its purpose beyond the schema's basic type and title. Since schema description coverage is 0%, the description compensates well by providing essential semantic information, though it could specify path format or constraints.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool's purpose: 'List available data files in the project data directory.' It specifies the verb ('List') and resource ('available data files'), and distinguishes it from siblings like 'list_tables' by focusing on files rather than database tables. However, it doesn't explicitly differentiate from other file-related operations that might exist in a broader context.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool versus alternatives. It doesn't mention when this tool is appropriate compared to siblings like 'list_tables' (for database contents) or 'describe_dataset' (for metadata), nor does it specify prerequisites or exclusions. The only contextual hint is the default parameter value, which is insufficient for usage decisions.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
list_tablesA
List all tables in a SQLite database.
Args:
db_path: Path to SQLite database file
Returns:
Dictionary containing table names and their schemas
| Name | Required | Description | Default |
|---|---|---|---|
| db_path | Yes |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries the full burden. It states the tool lists tables and returns a dictionary with names and schemas, which covers basic behavior. However, it lacks details on error handling, permissions, or performance characteristics that would be useful for a database operation.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is front-loaded with the core purpose in the first sentence, followed by structured 'Args' and 'Returns' sections. Every sentence adds value without redundancy, making it efficient and easy to parse.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool's low complexity (one parameter) and the presence of an output schema (implied by 'Returns' statement), the description is reasonably complete. It covers purpose, input, and output, though it could benefit from more behavioral context given the lack of annotations.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The description adds meaningful context for the single parameter 'db_path' by specifying it as 'Path to SQLite database file', which clarifies its purpose beyond the schema's generic 'string' type. With 0% schema description coverage, this compensates adequately, though it doesn't detail format constraints like file existence or accessibility.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the specific action ('List all tables') and resource ('in a SQLite database'), distinguishing it from siblings like 'list_data_files' or 'query_sqlite'. It precisely defines the tool's scope without ambiguity.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description implies usage when needing to enumerate tables in a SQLite database, but provides no explicit guidance on when to use this tool versus alternatives like 'describe_dataset' or 'query_sqlite'. No exclusions or prerequisites are mentioned.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
merge_datasetsA
Merge/join two datasets together - essential for combining data sources.
Args:
file_path_left: Path to left/primary dataset
file_path_right: Path to right/secondary dataset
on: Column(s) to join on (if same name in both datasets)
left_on: Column name in left dataset to join on
right_on: Column name in right dataset to join on
how: Join type - 'inner', 'left', 'right', 'outer'
preview_limit: Number of rows to return in preview
Returns:
Dictionary containing merged data preview and statistics
| Name | Required | Description | Default |
|---|---|---|---|
| file_path_left | Yes | ||
| file_path_right | Yes | ||
| on | No | ||
| left_on | No | ||
| right_on | No | ||
| how | No | inner | |
| preview_limit | No |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries full burden. It reveals this is a data transformation operation that returns a preview with statistics, which is useful behavioral context. However, it doesn't disclose important traits like whether this creates persistent data, has performance implications, handles missing data, or has any limitations on dataset size or format.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is well-structured with clear sections for purpose, arguments, and returns. The opening sentence states the core function, followed by organized parameter explanations. While efficient, the 'essential for combining data sources' phrase adds little value and could be omitted for better conciseness.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool's complexity (7 parameters, data transformation operation) and no annotations, the description does well by explaining all parameters and the return format. The presence of an output schema means the description doesn't need to detail return values. However, for a data transformation tool, it could better address behavioral aspects like data persistence and limitations.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
With 0% schema description coverage, the description fully compensates by explaining all 7 parameters in detail. It clarifies the purpose of each parameter, distinguishes between 'on' vs 'left_on/right_on' approaches, explains the join types for 'how', and specifies that 'preview_limit' controls returned rows. This adds substantial meaning beyond the bare schema.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool merges/joins two datasets together and is essential for combining data sources. It specifies the verb (merge/join) and resource (datasets), but doesn't explicitly differentiate from sibling tools like 'group_aggregate' or 'create_pivot_table' which might also combine data in different ways.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool versus alternatives. It doesn't mention sibling tools or clarify scenarios where merge_datasets is preferred over other data manipulation tools like 'group_aggregate' or 'create_pivot_table'. The 'essential for combining data sources' phrase is too generic to provide meaningful usage context.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
query_sqliteA
Execute a SQL query on a SQLite database.
Args:
db_path: Path to SQLite database file
query: SQL query to execute (SELECT queries only for safety)
limit: Maximum number of rows to return (default 100)
Returns:
Dictionary containing:
- query: The executed query
- row_count: Number of rows returned
- columns: List of column names
- rows: Query results
| Name | Required | Description | Default |
|---|---|---|---|
| db_path | Yes | ||
| query | Yes | ||
| limit | No |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries the full burden of behavioral disclosure. It effectively communicates safety constraints ('SELECT queries only for safety'), default behavior ('limit: default 100'), and the return structure. It lacks details on error handling or performance limits, but covers essential operational traits.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is well-structured and front-loaded with the core purpose, followed by organized sections for arguments and returns. Every sentence adds value without redundancy, making it efficient and easy to parse for an AI agent.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool's complexity (SQL execution with safety constraints), no annotations, and a detailed output schema (implied by the Returns section), the description is complete. It covers purpose, usage guidelines, parameters, and return values, providing all necessary context for correct tool invocation.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The description adds significant meaning beyond the input schema, which has 0% description coverage. It explains each parameter's purpose: 'db_path' as the database file path, 'query' as the SQL to execute with safety restrictions, and 'limit' as a maximum row return with a default value. This fully compensates for the schema's lack of documentation.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the specific action ('Execute a SQL query') and resource ('on a SQLite database'), distinguishing it from sibling tools like 'list_tables' or 'describe_dataset' which perform different data operations. It precisely defines the tool's function without ambiguity.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides clear context by specifying 'SELECT queries only for safety,' which implicitly guides usage toward read-only operations. However, it does not explicitly mention when to use alternatives like 'filter_rows' or 'group_aggregate' for non-SQL operations, nor does it state exclusions for other query types.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
statistical_testA
Perform statistical hypothesis tests on data.
Args:
file_path: Path to CSV or SQLite file
test_type: Type of test:
- 'ttest_ind': Independent samples t-test (compare 2 groups)
- 'ttest_paired': Paired samples t-test
- 'chi_squared': Chi-squared test for categorical independence
- 'anova': One-way ANOVA (compare 3+ groups)
- 'mann_whitney': Non-parametric alternative to t-test
- 'pearson': Pearson correlation test
- 'spearman': Spearman correlation test
column1: First column for analysis
column2: Second column (required for correlation, optional for t-test)
group_column: Column defining groups (for t-test, ANOVA)
alpha: Significance level (default 0.05)
Returns:
Dictionary containing test statistic, p-value, and interpretation
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| test_type | Yes | ||
| column1 | Yes | ||
| column2 | No | ||
| group_column | No | ||
| alpha | No |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries full burden but only partially discloses behavioral traits. It mentions the return format ('Dictionary containing test statistic, p-value, and interpretation') but doesn't cover important aspects like error handling, performance characteristics, data format requirements beyond file types, or whether the operation modifies data. The description doesn't contradict annotations since none exist.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is well-structured with clear sections (Args, Returns) and uses bullet points for test types. It's appropriately sized for a complex statistical tool with 6 parameters. Some minor redundancy exists (e.g., 'column2' explanation could be more concise), but overall it's efficient and front-loaded with the core purpose.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool's complexity (6 parameters, statistical operations) and the presence of an output schema (implied by 'Returns' section), the description provides good contextual coverage. It explains parameters thoroughly and mentions the return format. However, without annotations and given the statistical complexity, it could benefit from more behavioral context about assumptions, limitations, or data requirements.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
With 0% schema description coverage, the description fully compensates by providing comprehensive parameter semantics. Each parameter is explained with clear meanings, test type enumerations with descriptions, default values, and conditional requirements (e.g., 'required for correlation, optional for t-test'). This adds substantial value beyond the bare schema.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool's purpose as 'Perform statistical hypothesis tests on data' with specific test types listed. It distinguishes from siblings like 'compute_correlation' by covering broader statistical testing beyond just correlation, but doesn't explicitly differentiate from all siblings like 'analyze_time_series' or 'detect_anomalies' which might also involve statistical methods.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description implies usage through parameter explanations (e.g., 'required for correlation, optional for t-test'), but doesn't provide explicit guidance on when to choose this tool over alternatives like 'compute_correlation' or 'analyze_time_series'. The test type explanations help understand appropriate contexts, but no explicit when/when-not statements are provided.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
TDQS
Most tools have distinct purposes, but there is some overlap between compute_correlation and statistical_test (which includes correlation tests) and between filter_rows and export_data (which includes filtering). The descriptions help clarify differences, but an agent might occasionally misselect between these pairs.
All tool names follow a consistent verb_noun or verb_adjective_noun pattern in snake_case, such as analyze_time_series, create_pivot_table, and detect_anomalies. There are no deviations in naming conventions, making the set highly predictable and readable.
With 16 tools, the count is slightly high but reasonable for a comprehensive tabular data analysis server. It covers a wide range of operations without feeling excessively bloated, though it borders on the upper limit of typical scope.
The tool set provides complete coverage for tabular data analysis, including data loading (list_data_files, list_tables), exploration (describe_dataset, auto_insights), transformation (filter_rows, merge_datasets), analysis (statistical_test, analyze_time_series), visualization (generate_chart), and export (export_data). No obvious gaps exist for the domain.
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Connectors
Paste-your-data analytics: CSV profiling, A/B tests, correlation, growth. 4 of 7 free.
The all-in-one data stack for agents. Upload files, run SQL, evolve tables, and render charts.
Ask data questions in natural language. Get SQL, insights, and charts from your databases.
Explore, query, and inspect SQLite databases with ease. List tables, preview results, and view det…
Related MCP Servers
- AlicenseBqualityFmaintenanceEnables autonomous data exploration on .csv-based datasets, providing intelligent insights with minimal effort.2544MIT
- FlicenseNot gradedqualityDmaintenanceEnables users to preprocess, analyze, and visualize CSV data through comprehensive tools for data manipulation, statistical analysis, and graph generation.3
- FlicenseNot gradedqualityDmaintenanceEnables analysis of datasets from CSV/Excel files, Google Sheets, and Google Drive with comprehensive data profiling tools including schema inference, missing value reports, correlation analysis, and outlier detection. Supports exporting analytical reports in multiple formats to local storage or Google Drive.
- FlicenseNot gradedqualityDmaintenanceEnables conversational analysis of CSV and Parquet files through natural language, providing statistics, summaries, data type information, and comprehensive multi-step data analysis.
Appeared in Searches
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/K02D/mcp-tabular'
If you have feedback or need assistance with the MCP directory API, please join our Discord server