ssas-mcp-server-by-cdata
If you are the rightful owner of ssas-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 SQL Server Analysis Services is a read-only server that allows LLMs to query live data from SQL Server Analysis Services using natural language.
The CData MCP Server for SQL Server Analysis Services is designed to facilitate the interaction between large language models (LLMs) and SQL Server Analysis Services. By leveraging the CData JDBC Driver, this server exposes SQL Server Analysis Services data as relational SQL models, enabling LLMs to access and query live data without requiring SQL knowledge. This server is particularly useful for applications like Claude Desktop, where users can ask natural language questions to retrieve data insights. The server is read-only, but a full-featured version with read, write, update, and delete capabilities is available in beta. The setup involves cloning the repository, building the server, and configuring the connection using a JDBC driver.
Features
- Read-only access to SQL Server Analysis Services data.
- Integration with LLMs for natural language querying.
- Utilizes CData JDBC Driver for data exposure.
- Simple MCP interface for data retrieval.
- Supports a wide range of data sources.
Tools
{servername}_get_tables
Get a list of available tables in the data source
{servername}_get_columns
Get the column list of specified tables
{servername}_run_query
Execute SQL SELECT query
