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

#sas #data-sets #mcp-server

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.

Frequently asked questions

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

Basic information

More Data & Analytics MCP servers

Linkly Link Shortener

Linkly

Linkly is an URL shortener with geo redirects, click & conversion tracking, link rotators, mobile deep links and an URL shortening API.

ScrapeCheck

FieldmodeLLC

Verify scraped data against the live source page. Signed verdicts, $0.01 via x402.

BidSkim - UK Tenders & Contract Renewals

BidSkim

UK procurement intelligence for AI assistants: search live UK government tenders, find contract renewals with expiry dates and incumbent suppliers, and profile public-sector buyers and suppliers. Covers Find a Tender, Co

Hologrow

Hologrow Inc

Hologrow is the e-commerce data layer for any AI

SiteGuru

Your site's real SEO data in your AI assistant. SiteGuru crawls your website and connects to Google Search Console and Google Analytics. This server exposes that data to your assistant, so you can ask what's broken, wha