Advertise
MCP.so
Sign In
S

SAS xpt MCP Server by CData

@CDataSoftware

Repository

Basic information

Category

Other

Transports

stdio

Author

CDataSoftware

Submitted by

Cameron Leblanc

About 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

SAS xpt MCP Server by CData config

Add this server to your MCP-compatible client using the configuration below.

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

SAS xpt MCP Server by CData tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

Frequently asked questions

1

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.

2

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.

3

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.

4

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.

5

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.

Comments

More Other MCP servers

FastMCP v2 🚀

jlowin

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

26.0K

Awesome Mlops

visenger

A curated list of references for MLOps

14.0K

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

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

ICSS

chokcoco

不止于 CSS

20.7K
Advertise