MCP Server for Business Intelligence
Add database querying and dataset management to your AI applications with a semantic layer API
Create a new dataset for sales analytics with Orders, Customers, and Products tables.
Dataset "Sales Analytics" created. You can now add columns or define joins.
What are the top 5 products by total sales?
Here are the top 5 products by total sales:
| Product Name | Total Sales | Units Sold |
|---|---|---|
| Widget Pro | $12,500 | 250 |
| Gadget Max | $9,800 | 196 |
| Service Plus | $7,200 | 120 |
Platform Capabilities
Comprehensive BI Controls
Configure roles, manage sharing, and adjust dataset structure and permissions directly in the chat interface. Supports collaborative workflows and governance for business data.
Multi-Step Conversational Actions
Perform several related actions in a single conversation, such as creating datasets, updating columns, and setting access, without switching context.
Integration with Existing Systems
Connects with enterprise data sources and business applications. Designed to fit into established IT environments and analytics processes.
Security and Access Management
Provides authentication, access control, and secure credential handling to help meet organizational requirements for data protection.
API Endpoints
GET /toolsDiscover available MCP tools
POST /queryExecute database queries
GET /datasetsManage semantic datasets
POST /instructionsGet context-aware guidance
Supports PostgreSQL, MySQL, SQL Server, and Snowflake