广告合作
MCP.so
登录
S

Smartsheet MCP Server by CData

@CDataSoftware

代码仓库

基本信息

分类

其他

传输方式

stdio

作者

CDataSoftware

提交者

Cameron Leblanc

关于 Smartsheet MCP Server by CData

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free CData MCP Server for Smartsheet (beta): https://www.cdata.com/download/download.aspx?sku=BSZK-V&type=beta

#smartsheet#mcp-server#data-integration

Smartsheet MCP Server by CData 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\smartsheet.prp"
      ]
    }
  }
}

Smartsheet MCP Server by CData 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Smartsheet MCP Server by CData?

Smartsheet MCP Server by CData is a read-only Model Context Protocol (MCP) server that allows LLMs (such as Claude Desktop) to query live Smartsheet data using natural language. It wraps the CData JDBC Driver for Smartsheet and exposes Smartsheet data as relational SQL tables through a simple MCP interface, requiring no SQL from the user.

How to use Smartsheet MCP Server by CData?

Clone the repository, build the JAR with mvn clean install, download and install the CData JDBC Driver for Smartsheet, license the driver, create a connection string using the driver’s utility, then create a .prp file with connection properties. Finally, configure Claude Desktop by adding the server entry in claude_desktop_config.json with the path to Java and the JAR and .prp files. The server uses stdio transport and must run on the same machine as the client.

Key features of Smartsheet MCP Server by CData

  • Read-only access to live Smartsheet data
  • Natural language querying via LLMs (e.g., Claude Desktop)
  • Exposes Smartsheet tables and columns as relational SQL models
  • Built-in tools: get_tables, get_columns, run_query
  • Uses CData JDBC Driver for Smartsheet for connectivity
  • MIT licensed and open source

Use cases of Smartsheet MCP Server by CData

  • Query live Smartsheet data from an LLM without writing SQL
  • Ask business questions about project status, account correlations, or ticket counts
  • Integrate Smartsheet data into AI-powered chatbots or assistants
  • Read Smartsheet data for reporting or analysis within a conversation

常见问题

1

Is Smartsheet MCP Server by CData read-only?

Yes, this project builds a read-only MCP server. For full CRUD and action capabilities, CData offers a separate beta MCP Server for Smartsheet.

2

What are the runtime requirements?

You need Java installed (to run the JAR) and the CData JDBC Driver for Smartsheet installed and licensed on the same machine.

3

How does the server connect to Smartsheet?

It uses a JDBC connection string configured in a `.prp` file, which can be generated using the CData JDBC Driver’s Connection String utility. OAuth authentication may require a browser login.

4

What transport does the server use?

The server uses `stdio` transport, so it can only be used with clients that run on the same machine as the server.

5

Can I use this server with other MCP clients besides Claude Desktop?

The README focuses on Claude Desktop, but the MCP interface is generic. Configuration for other clients is not described.

评论

其他 分类下的更多 MCP 服务器

YOUB

Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.0K
广告合作