SAS xpt MCP Server by CData

Name: SAS xpt MCP Server by CData
Author: CDataSoftware

@CDataSoftware

SAS xpt 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 SAS xpt (beta): https://www.cdata.com/download/download.aspx?sku=JXZK-V&type=beta

#sas-xpt #mcp-server #cdata

基本情報

カテゴリ

その他

トランスポート

stdio

公開者

CDataSoftware

投稿者

Cameron Leblanc

設定

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

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

ツール

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

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is SAS xpt MCP Server by CData?

This read-only MCP server enables LLMs such as Claude Desktop to query live data from SAS xpt files using natural language. It wraps the CData JDBC Driver for SAS xpt, which exposes SAS xpt data as relational SQL tables, and makes that data available through a simple MCP interface.

How to use SAS xpt MCP Server by CData?

Clone the repository and build the JAR with mvn clean install. Next, download and install the CData JDBC Driver for SAS xpt, license it, and configure a connection string via the driver's utility. Create a .prp file with the JDBC connection properties (prefix, server details, driver path, class, and JDBC URL). Finally, add the server to your Claude Desktop configuration (claude_desktop_config.json) using the Java command, then restart the client.

Key features of SAS xpt MCP Server by CData

Read-only access to SAS xpt data via MCP tools
Exposes get_tables, get_columns, and run_query tools
No SQL required – works with natural language prompts
Built on the CData JDBC Driver for SAS xpt
Uses stdio transport for local clients

Use cases of SAS xpt MCP Server by CData

Let LLMs answer questions about SAS xpt data without writing queries
Combine SAS xpt data with other sources through an AI client
Explore table schemas and run ad‑hoc SELECT queries from a chat interface

FAQ from SAS xpt MCP Server by CData

Is this server read‑only?

Yes. The project explicitly builds a read‑only MCP server. For full read, write, update, delete, and action capabilities, CData offers a separate beta MCP server.

What are the runtime dependencies?

You need Java to run the built JAR, the CData JDBC Driver for SAS xpt (downloaded separately), and a client like Claude Desktop that supports MCP over stdio.

How is data accessed and where does it live?

The server connects to SAS xpt files on the same machine using the JDBC driver. All queries run locally; data is not sent to external services beyond the LLM client.

What transport does the server use?

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

How do I authenticate to SAS xpt?

Authentication is handled by the CData JDBC Driver. If the data source uses OAuth, you will be prompted to authenticate in your browser when configuring the connection string.