MCP MCP Server

MCP server to query your data warehouse (BigQuery, Snowflake, Redshift, Azure Synapse) with natural language. Connect Claude, ChatGPT, Copilot or

Local serverstdio

What is the MCP MCP server?

Connect MCP to Claude, Cursor or any other MCP client and it stops being a tab you switch to. 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. The mcp mcp server is what makes that connection.

What the server does

  • 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

Available tools

The toolset is worth reading before you wire it up, because it tells you what the integration is really for:

  • 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

Installation

Setup follows the usual MCP pattern — install or clone the server, register it in your client's configuration file, restart the client.

Credentials and setup notes

  • 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)

Where it fits

Among the database access options, the useful question is rarely "what can it do" but "what does it cost you to run" — permissions, credentials, and how much of your context its toolset consumes. MCP's toolset — list_projects, get_project_context, get_schema_context and 8 more — is a fair guide to whether it matches your workflow. It is maintained by quantiio; worth a glance at recent repository activity before you build anything load-bearing on it.

SyncDev reviews every entry in this directory against the project's own documentation before publishing, and revisits them as servers change.

Worth knowing first

  • It runs with your machine's permissions. That is convenient and also the reason to think about what you point it at before you approve a tool call.
  • With 11 tools registered it takes up a noticeable share of the context window; turn it off in projects that never touch MCP.
  • Keep per-call confirmation enabled while you learn its behaviour; it is the cheapest safeguard you have.

Available tools

ToolWhat it does
list_projectsList your accessible Quanti projects
get_project_contextGet project context (connectors, datasets, date ranges)
get_schema_contextBuild schema context for your question using RAG
execute_queryExecute read-only SQL queries on your data warehouse
get_use_casesSearch for relevant use case templates
list_my_use_casesList your personal saved analyses
list_project_use_casesList team shared analyses
create_use_caseSave an analysis for reuse
update_use_caseUpdate an existing use case
delete_use_caseDelete a use case
collect_feedbackProvide feedback on query results

Configuration

  • 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)

Example prompts to try

  • Use MCP to list projects.
  • Use MCP to get project context.
  • Use MCP to get schema context.

Frequently asked questions

It connects MCP to MCP-compatible AI assistants such as Claude and Cursor, exposing 11 tools (list_projects, get_project_context, get_schema_context, and more) that the assistant can call on your behalf. Instead of copying data back and forth by hand, the assistant works with MCP directly.