DataSelf MCP+ for Analytics & Data Warehousing

Connect AI to curated business data for trusted KPIs, reports, and analytics.

Intro

Learn about the business value here: MCP Server for BI and Analytics.

DataSelf MCP+ for Analytics & Data Warehousing (or simply DataSelf MCP+) exposes your curated DataSelf data warehouse to AI tools such as Claude, ChatGPT, Copilot, and other MCP-compatible clients through a secure, tokenized connection. Once connected, users can query data, generate reports, explore KPIs, and analyze business information using plain natural language — no SQL required.

In data warehousing (DW) environments, MCP provides a standardized framework for AI systems to access, understand, and interact with warehouse data in a controlled and intelligent manner.

Modern DataSelf data warehouses consolidate business-critical information from multiple systems into curated, business-friendly models. While traditional BI and SQL tools often require technical expertise to retrieve and analyze data, MCP introduces a conversational, AI-driven approach that makes trusted analytics accessible to both business and technical users.

Setup Guide for Claude

This is a guide to connect Claude to your SQL Server data warehouse. 

Prerequisites:

• DataSelf Cloud data warehouse: contact us.

• DataSelf private-cloud or on-premise data warehouse: WIP - contact us.

Step 1 — Add a Custom MCP Connector in Claude

Open http://Claude.ai in your browser. Click on Customize in the left sidebar and select Connectors.

In Connectors, click the Add (+) … Add custom connector.

Fill in the connector form with the following values:

Click Add to confirm.

Step 2 — Enable All Actions

After adding the connector, Claude will ask how much access to grant. To allow full query capability, you need to enable all actions.

Find the newly added Dataself MCP+ - Data warehouse connector in your integrations list. Click it to open its settings and look for the Permissions or Actions section. 

Select Always allow (or the equivalent option that grants full tool access). This allows Claude to list tables, run queries, and return results from your SQL Server.

Step 3 — Start Asking Questions

Open a new chat in Claude. The Dataself MCP+ - Data warehouse connector is now active. You can start with broad exploration questions and then go deeper from there.

Example prompts to get started:

• "What tables are available in the database?"

• "Show me total sales by month for the last 12 months"

• "How many active customers do we have by region?"

• "What is the current inventory level by warehouse?"

• "Compare sales performance this year versus last year by product category"

Claude may ask for your permission the first time it runs a query tool in a new session. Click Allow to proceed. You can also click the tool call to expand and inspect the exact query that was executed.