list_projectsLABSCO SUMMARY
Schema context first, then the SQL.
The failure mode of natural-language SQL is a model guessing at table and column names, which is what get_schema_context exists to prevent — it retrieves the schema that matches your question before anything is written. Saved use cases turn the good queries into ones the team can re-run rather than re-derive.
What it is
A hosted MCP server at https://ai.quanti.io/mcp that puts your Quanti projects and their warehouse schema in front of an assistant. It builds schema context with RAG, then your assistant writes the SQL and the server executes it read-only.
What you get
- list_projects — the Quanti projects you can reach
- get_project_context — connectors, datasets and date ranges for a project
- get_schema_context — schema context built for your specific question via RAG
- execute_query — run a read-only SQL query against the warehouse
- get_use_cases — search the library of use case templates
- list_my_use_cases / list_project_use_cases — your saved analyses and the team's shared ones
- create_use_case / update_use_case / delete_use_case — save an analysis for reuse and maintain it
- collect_feedback — send feedback on a query result
Requirements
A Quanti account with access to at least one project, a warehouse with an indexed schema (BigQuery, Snowflake, Redshift or Azure Synapse), and a client that supports MCP. Authentication is OAuth 2.0 with dynamic discovery; transport is HTTP with SSE. Setup guides ship for ChatGPT, Claude Desktop, Gemini, Le Chat and Copilot. Queries are read-only and access is controlled per project.
Setup effort
Add the hosted endpoint — paste it into your client
USE CASES
Answering a campaign question without writing SQL
Ask in plain language; the schema context is built first and the query runs read-only.
Getting oriented in a project you did not set up
Read its connectors, datasets and available date ranges before querying anything.
Reusing an analysis instead of rebuilding it
Search the template library, then save your own version for the team.
11 tools
Listed in project docs. Your client may show a different list.
get_project_contextget_schema_contextexecute_queryget_use_caseslist_my_use_caseslist_project_use_casescreate_use_caseupdate_use_casedelete_use_casecollect_feedbackBEFORE YOU INSTALL
What to know first
Tools you get
11 tools named in the project's documentation. Queries are read-only, and access is controlled per project.
INSTALLATION
Connect your client
Server setup
https://ai.quanti.io/mcpAdd this hosted endpoint to your MCP client.