Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| GEMINI_API_KEY | No | Your Gemini API key for AI-powered features | |
| OPENAI_API_KEY | No | Your OpenAI API key for AI-powered features | |
| DEEPSEEK_API_KEY | No | Your DeepSeek API key for AI-powered features | |
| ANTHROPIC_API_KEY | No | Your Anthropic API key for AI-powered features |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| read_file | Read an entire CSV or Excel file with optional chunking for large files |
| get_cell | Get the value of a specific cell using A1 notation |
| get_range | Get values from a range of cells |
| get_headers | Get the column headers (first row) of a file |
| search | Search for cells containing a specific value |
| filter_rows | Filter rows based on column values |
| aggregate | Perform aggregation operations on a column |
| read_file_chunked | Read large files in manageable chunks to avoid token limits |
| get_file_info | Analyze file size and get chunking recommendations |
| statistical_analysis | Perform comprehensive statistical analysis on a column |
| correlation_analysis | Calculate correlation between two numeric columns |
| data_profile | Generate comprehensive data profiling report for all columns |
| pivot_table | Create pivot table with grouping and aggregation |
| dcf_analysis | Perform Discounted Cash Flow (DCF) valuation analysis for investment evaluation |
| budget_variance_analysis | Analyze budget vs actual performance with variance calculations |
| ratio_analysis | Perform comprehensive financial ratio analysis with industry benchmarks |
| scenario_modeling | Perform what-if scenario analysis with multiple assumptions |
| trend_analysis | Analyze time series trends, growth rates, seasonality, and forecasting for sales and performance data |
| write_file | Write data to a new CSV or Excel file (supports multiple sheets for Excel) |
| add_sheet | Add a new sheet to an existing Excel file |
| write_multi_sheet | Create a complex Excel file with multiple sheets, formulas, and inter-sheet references |
| export_analysis | Export analysis results (pivot tables, statistics, etc.) to a new file |
| format_cells | Apply formatting to Excel cells (fonts, colors, borders, alignment) |
| auto_fit_columns | Automatically adjust column widths to fit content in Excel files |
| evaluate_formula | Evaluate an Excel formula with given context |
| parse_natural_language | Convert natural language to Excel formula or command |
| explain_formula | Explain what an Excel formula does in plain English |
| ai_provider_status | Check status of available AI providers |
| smart_data_analysis | AI-powered analysis suggestions for your data |
| validate_data_consistency | Cross-validate data integrity across related files |
| bulk_aggregate_multi_files | Aggregate same column across multiple files in parallel |
| bulk_filter_multi_files | Filter data across multiple files with optional export |
| find_duplicates | Find and manage duplicate rows in Excel/CSV files with multiple strategies |
| data_cleaner | Batch data cleaning operations with intelligent detection of common data quality issues |
| vlookup_helper | Intelligent VLOOKUP setup and execution with error handling and fuzzy matching |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |