Quanti MCP Server

MCP server to query your data warehouse (BigQuery, Snowflake, Redshift, Azure Synapse) with natural language. Connect Claude, ChatGPT, Copilot or Gemini to your marketing data and get instant SQL insights.

Features

• Natural Language to SQL: Ask questions in plain language, get SQL queries executed on your data warehouse
• Multi-platform Support: Works with BigQuery, Snowflake, Redshift, and Azure Synapse
• AI Assistant Compatible: Connect to Claude, ChatGPT, Gemini, Le Chat, or Copilot
• Schema Discovery: Automatic schema detection and context building via RAG
• Use Case Library: Save and reuse your favorite analyses
• Secure: OAuth 2.0 authentication, read-only queries, per-project access control

Quick Start

Server URL

https://ai.quanti.io/mcp

Setup Guides

• ChatGPT Setup
• Claude Desktop Setup
• Google Gemini Setup
• Mistral Le Chat Setup
• Microsoft Copilot Setup

Available Tools

Tool	Description
list_projects	List your accessible Quanti projects
get_project_context	Get project context (connectors, datasets, date ranges)
get_schema_context	Build schema context for your question using RAG
execute_query	Execute read-only SQL queries on your data warehouse
get_use_cases	Search for relevant use case templates
list_my_use_cases	List your personal saved analyses
list_project_use_cases	List team shared analyses
create_use_case	Save an analysis for reuse
update_use_case	Update an existing use case
delete_use_case	Delete a use case
collect_feedback	Provide feedback on query results

How It Works

1. Connect your AI assistant to the Quanti MCP server
2. Authenticate with your Quanti account via OAuth 2.0
3. Ask questions in natural language about your marketing data
4. The server builds context from your data warehouse schema
5. Your AI assistant generates and executes SQL queries
6. Get insights with formatted results

Example Queries

What are my top 10 campaigns by conversions this month?

Show me the daily spend trend for Google Ads over the last 30 days

Compare performance between Meta and Google Ads campaigns

Supported Data Sources

Quanti connects to 50+ marketing data sources including:

• Advertising: Google Ads, Meta Ads, LinkedIn Ads, TikTok Ads, Microsoft Ads
• Analytics: Google Analytics 4, Adobe Analytics
• CRM: Salesforce, HubSpot
• E-commerce: Shopify, WooCommerce
• And many more...

Requirements

• Quanti account with access to at least one project
• Data warehouse with indexed schema (BigQuery, Snowflake, Redshift, or Azure Synapse)
• AI assistant with MCP support (ChatGPT, Claude, Gemini, Le Chat, Copilot)

MCP Protocol

This server implements the Model Context Protocol (MCP) specification:

• Protocol Version: 2024-11-05
• Transport: HTTP with SSE (Server-Sent Events)
• Authentication: OAuth 2.0 with dynamic discovery

Support

• Documentation: docs.quanti.io
• Email: support@quanti.io
• Website: quanti.io

License

MIT License - see LICENSE for details.

---

Made with ❤️ by Quanti