MCP-Server

UCLA-Trustworthy-AI-Lab/MCP-Server

3.1

If you are the rightful owner of MCP-Server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

This MCP server is designed for data analysis, focusing on reading Excel files, performing descriptive analysis, and generating various plots.

Tools

Functions exposed to the LLM to take actions

Fileslist_excel_files

Scans the desktop for .xlsx and .xls files and returns a list of filenames.

read_excel_file

Reads the specified Excel file from the desktop and returns basic info about rows, columns, a preview of the first 5 rows, and data types.

analyze_excel_data

Computes descriptive statistics for numeric, categorical, and date columns, and calculates a correlation matrix for numeric columns if applicable.

create_bar_chart

Generates a bar chart from an Excel file using specified columns.

create_pie_chart

Generates a pie chart from an Excel file using specified columns.

create_line_chart

Generates a line chart from an Excel file using specified columns.

create_scatter_plot

Generates a scatter plot from an Excel file using specified columns.

create_histogram

Generates a histogram from an Excel file using a specified column.

create_box_plot

Generates a box plot from an Excel file using specified columns.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources