MCP.so
Sign In
S

SAS Data Sets MCP Server by CData

@CDataSoftware

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

Basic information

Category

Data & Analytics

Transports

stdio

Publisher

CDataSoftware

Submitted by

Cameron Leblanc

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-data-sets.prp"
      ]
    }
  }
}

Tools

No tools detected

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

Overview

What is SAS Data Sets MCP Server by CData?

A read-only MCP server that lets LLMs (e.g., Claude Desktop) query live SAS Data Sets using natural language. It wraps the CData JDBC Driver for SAS Data Sets, which exposes SAS Data Sets as relational SQL models.

How to use SAS Data Sets MCP Server by CData?

Clone the repository, build the JAR with mvn clean install, install and license the CData JDBC Driver for SAS Data Sets, configure a .prp file with your connection details, then add the server to your Claude Desktop claude_desktop_config.json using the java -jar command. Start your client and ask questions in natural language.

Key features of SAS Data Sets MCP Server by CData

  • Read-only access to live SAS Data Sets
  • Natural language querying – no SQL required
  • Exposes tables, columns, and SELECT query tools
  • Uses stdio transport for local client integration
  • Built on the CData JDBC Driver for SAS Data Sets

Use cases of SAS Data Sets MCP Server by CData

  • Query SAS Data Sets from within an AI assistant using everyday language
  • Explore table schemas and column metadata in SAS Data Sets
  • Run live SQL SELECT queries against SAS Data Sets from an LLM client

FAQ from SAS Data Sets MCP Server by CData

Is this server read-only?

Yes, this MCP server only supports read operations. For full create, read, update, delete, and action capabilities, use the free CData MCP Server for SAS Data Sets (beta).

What dependencies are required?

You need Java, Maven (to build), and the CData JDBC Driver for SAS Data Sets (separate download, requires a license key or a trial).

How does the server communicate with the client?

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

Where does the data live?

The data lives in SAS Data Sets on your local system or network; the JDBC driver connects to the location you specify in the connection string.

How do I troubleshoot connection issues?

Use the Connection String utility to test your JDBC connection, ensure the .prp file is configured correctly, and fully quit and restart the client (e.g., Claude Desktop) for changes to take effect.

Comments

More Data & Analytics MCP servers