CData SSAS MCP Server

Example Use Cases

• 1

  Query live SQL Server Analysis Services data using natural language.

• 2

  Retrieve metadata such as tables and columns from SSAS data sources.

• 3

  A read-only interface to SSAS data integrated with AI clients like Claude Desktop.

Description

This MCP server wraps the CData JDBC Driver for SQL Server Analysis Services to expose data through a simple Model Context Protocol interface. It allows large language models (LLMs) like Claude Desktop to query live SSAS data using natural language without requiring SQL knowledge. The server supports retrieving metadata and running SQL SELECT queries in a read-only mode, facilitating easy integration with AI clients.