MCP.so
ログイン
S

Smartsheet MCP Server by CData

@CDataSoftware

リポジトリ

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

基本情報

カテゴリ

その他

トランスポート

stdio

公開者

CDataSoftware

投稿者

Cameron Leblanc

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

ツール

ツールは検出されませんでした

ツールは 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

FAQ from Smartsheet MCP Server by CData

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.

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.

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.

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.

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

browsermcp

Browser MCP is a Model Context Provider (MCP) server that allows AI applications to control your browser

6.8K

AutoBrowser MCP

autobrowser-ai

Browser MCP is a Model Context Provider (MCP) server that allows AI applications to control your browser

6.8K

Unity MCP ✨

justinpbarnett

Unity MCP acts as a bridge between AI assistants and your Unity Editor. Give your LLM tools to manage assets, control scenes, edit scripts, and automate tasks within Unity.

12.2K

MCP Go 🚀

mark3labs

A Go implementation of the Model Context Protocol (MCP), enabling seamless integration between LLM applications and external data sources and tools.

8.9K

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K