smartsheet-mcp-server-by-cdata

smartsheet-mcp-server-by-cdata

3.2

If you are the rightful owner of smartsheet-mcp-server-by-cdata 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.

CData's Model Context Protocol (MCP) Server for Smartsheet is a read-only server designed to allow LLMs to query live Smartsheet data using natural language.

The CData MCP Server for Smartsheet is a specialized server that facilitates the interaction between large language models (LLMs) and Smartsheet data. By leveraging the CData JDBC Driver for Smartsheet, this server exposes Smartsheet data as relational SQL models, enabling LLMs to access and query live data without the need for SQL knowledge. This server is particularly useful for applications like Claude Desktop, where users can ask natural language questions to retrieve real-time information from Smartsheet. The server is read-only, meaning it allows data retrieval but not modification. For full CRUD capabilities, users are encouraged to explore the CData MCP Server for Smartsheet (beta). The setup involves building the server, licensing the JDBC driver, and configuring the connection to Smartsheet, making it accessible through a simple MCP interface.

Features

  • Read-only access to Smartsheet data
  • Integration with CData JDBC Driver for Smartsheet
  • Natural language querying via LLMs
  • Simple MCP interface for data retrieval
  • Support for Claude Desktop integration

Tools

  1. smartsheet_get_tables

    Retrieves a list of tables available in the data source.

  2. smartsheet_get_columns

    Retrieves a list of columns for a specified table.

  3. smartsheet_run_query

    Executes a SQL SELECT query on the data source.