Server Configuration
Describes the environment variables required to run the server.
Name | Required | Description | Default |
---|---|---|---|
CSV_STORAGE_PATH | No | Base path for CSV file storage | current directory |
CSV_MAX_FILE_SIZE | No | Maximum file size in MB | 50 |
CSV_BACKUP_ENABLED | No | Enable automatic backups | true |
CSV_SUPPORT_ABSOLUTE_PATHS | No | Enable absolute path support | true |
Schema
Prompts
Interactive templates invoked by user choice
Name | Description |
---|---|
analyze_csv | Generate analysis prompts for CSV data. Args: filename: Name of the CSV file to analyze analysis_type: Type of analysis (basic, statistical, exploratory) Returns: Analysis prompt text |
transform_csv | Generate transformation suggestions for CSV data. Args: filename: Name of the CSV file goal: Transformation goal (clean, normalize, aggregate, pivot) Returns: Transformation suggestion prompt |
Resources
Contextual data attached and managed by the client
Name | Description |
---|---|
No resources |
Tools
Functions exposed to the LLM to take actions
Name | Description |
---|---|
create_csv | Create a new CSV file with headers and optional initial data.
Args:
filename: Name of the CSV file to create (without .csv extension)
headers: List of column headers
data: Optional list of rows, where each row is a list of values
Returns:
Dictionary with creation results and file information |
read_csv | Read and return CSV file contents.
Args:
filename: Name of the CSV file to read
limit: Optional limit on number of rows to return
Returns:
Dictionary with file contents and metadata |
update_csv | Update a specific cell in the CSV file.
Args:
filename: Name of the CSV file to update
row_index: Zero-based index of the row to update
column: Name of the column to update
value: New value for the cell
Returns:
Dictionary with update results |
add_row | Add a new row to the CSV file.
Args:
filename: Name of the CSV file
row_data: Dictionary mapping column names to values
Returns:
Dictionary with addition results |
remove_row | Remove a specific row from the CSV file.
Args:
filename: Name of the CSV file
row_index: Zero-based index of the row to remove
Returns:
Dictionary with removal results |
get_info | Get basic information about a CSV file.
Args:
filename: Name of the CSV file
Returns:
Dictionary with file metadata and structure information |
get_statistics | Get statistical summary of numeric columns in the CSV file.
Args:
filename: Name of the CSV file
Returns:
Dictionary with statistical analysis of numeric columns |
filter_data | Filter CSV data based on conditions.
Args:
filename: Name of the CSV file
conditions: Dictionary of column conditions.
Simple: {"column": "value"}
Complex: {"column": {"gt": 5, "lt": 10, "contains": "text"}}
limit: Optional limit on number of rows to return
Returns:
Dictionary with filtered data |
sort_data | Sort CSV data by specified columns.
Args:
filename: Name of the CSV file
columns: Column name or list of column names to sort by
ascending: Whether to sort in ascending order
limit: Optional limit on number of rows to return
Returns:
Dictionary with sorted data |
group_data | Group and aggregate CSV data.
Args:
filename: Name of the CSV file
group_by: Column name or list of column names to group by
aggregations: Dictionary mapping column names to aggregation functions
(sum, mean, count, min, max, std, etc.)
Returns:
Dictionary with grouped and aggregated data |
validate_data | Validate CSV data integrity and format.
Args:
filename: Name of the CSV file
Returns:
Dictionary with validation results, issues, and warnings |
delete_csv | Delete a CSV file (with backup if enabled).
Args:
filename: Name of the CSV file to delete
Returns:
Dictionary with deletion results |
list_csv_files | List all CSV files in the storage directory.
Returns:
Dictionary with list of CSV files and their metadata |
get_path_info | Get detailed information about a file path, supporting both relative and absolute paths.
Args:
filepath: The file path to analyze (can be relative or absolute)
Returns:
Dictionary with comprehensive path information including:
- Whether the path is absolute or relative
- Resolved path (following symlinks)
- Parent directory information
- File existence and accessibility
- Safety validation for absolute paths |
create_csv_at_path | Create a new CSV file at a specific path (absolute or relative).
Args:
filepath: Full path where the CSV file should be created
headers: List of column headers
data: Optional list of rows, where each row is a list of values
Returns:
Dictionary with creation results and file information |