Skip to main content
Glama

CSV MCP Server

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
CSV_STORAGE_PATHNoBase path for CSV file storagecurrent directory
CSV_MAX_FILE_SIZENoMaximum file size in MB50
CSV_BACKUP_ENABLEDNoEnable automatic backupstrue
CSV_SUPPORT_ABSOLUTE_PATHSNoEnable absolute path supporttrue

Schema

Prompts

Interactive templates invoked by user choice

NameDescription
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

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription
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

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/NovaAI-innovation/csv-mcp-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server