SAS xpt MCP Server by CData

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.