sas-xpt-mcp-server-by-cdata

sas-xpt-mcp-server-by-cdata

3.2

If you are the rightful owner of sas-xpt-mcp-server-by-cdata and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

CData's Model Context Protocol (MCP) Server for SAS xpt is a read-only server designed to allow LLMs to query live SAS xpt data using natural language.

CData's Model Context Protocol (MCP) Server for SAS xpt is a specialized server that facilitates the interaction between large language models (LLMs) and SAS xpt data. By leveraging the CData JDBC Driver for SAS xpt, this server exposes SAS xpt data as relational SQL models, enabling LLMs to access and query live data without the need for SQL knowledge. The server is designed to be read-only, providing a streamlined interface for retrieving information. It is particularly useful for applications like Claude Desktop, where users can ask natural language questions to obtain data insights. The server is built using Java and requires the CData JDBC Driver to be installed and licensed. Configuration involves setting up a connection string and creating a property file to define server parameters. Once configured, the server can be integrated with AI clients to enhance data accessibility and usability.

Features

  • Read-only access to SAS xpt data through a simple MCP interface.
  • Integration with CData JDBC Driver for SAS xpt to expose data as relational SQL models.
  • Natural language querying capability for LLMs, eliminating the need for SQL knowledge.
  • Configurable connection settings for tailored data access.
  • Support for integration with AI clients like Claude Desktop.

Tools

  1. {servername}_get_tables

    Retrieves a list of tables available in the data source.

  2. {servername}_get_columns

    Retrieves a list of columns for a specified table.

  3. {servername}_run_query

    Executes a SQL SELECT query.