MCP App Store
by KeenEthics
Revenue Analytics for HubSpot icon

Revenue Analytics for HubSpot MCP Server for Claude and ChatGPT

By DataLabs.store

Overview

Your HubSpot dashboards answer the questions you knew to ask. This connects Claude to every other one. Real problems teams solve with it: • Cohort Analysis - a blended metric can look healthy while hiding one segment expanding and another quietly churning. No HubSpot tier cohorts by acquisition segment and signup period. • Drift Correction - a custom field can quietly change what it measures mid-year, making a definition change look like a real cost shift. Teach Claude the correction once; every future query applies it. • Per-Rep Weighting - reps don't all use the same deal stage the same way, so one configured probability can misstate whose pipeline is solid. Weighting by each rep's real win rate can reorder who looks strongest. • Forecast calibration - configured win probabilities are rarely checked against actual history, letting dead-weight stages quietly inflate the forecast. • Email attribution - native reporting stops at opens/clicks; tracing engaged contacts through to an actual deal takes joins no single-object report can express. • Pipeline leaderboard - ranking reps by raw open pipeline rewards volume over quality; weighting by real odds and win rate can reorder who's strongest. Each needs joins, CTEs, HAVING, or window functions across multiple HubSpot objects at once - what HubSpot's standard reporting has no path for (single-object reports, a 2-object cap on cross-object dot notation, multi-object reporting gated to Enterprise Data Hub). Ask Claude in plain words and it writes and runs the SQL, then shows its work. Under the hood: mirrors your HubSpot portal (deals, pipeline, contacts, companies, engagements, email, workflows) into a real SQL Server database, with schema discovery, semantic metadata, and saved-query tools alongside read-only query execution. Requires a DataLabs.store account with HubSpot sync enabled; queries run through a read-only database role.

How to connect

  1. Claude: Open the Revenue Analytics for HubSpot listing in the Claude connectors directory and choose Connect. Claude listing Revenue Analytics for HubSpot exposes 13 tools here.
  2. ChatGPT: Open the Revenue Analytics for HubSpot listing in the ChatGPT app directory and choose Connect. ChatGPT listing Revenue Analytics for HubSpot exposes 13 tools here.

Tools

execute_query

ChatGPT
For HubSpot portal SQL database execute analytical SQL query with optional parameters. Tip: When using AVG() on decimal/money columns (e.g. amount), wrap with CAST to avoid arithmetic overflow: AVG(CAST(amount AS FLOAT)). Read-only: this tool connects using a read-only SQL Server role; INSERT/UPDATE/DELETE/DDL and any other write statement are rejected by the database itself, not just validated client-side.

execute_saved_query

ChatGPT
For HubSpot portal SQL database execute a query previously saved via save_query, by the tool name it was saved under (as returned by list_saved_queries)

fetch

ChatGPT
For HubSpot portal SQL database retrieve the full content of a table, business terminology entry, or saved query previously returned by search, by its id

get_data_statistics

ChatGPT
For HubSpot portal SQL database get record counts for table, date ranges when available, null percentages, cardinality of categorical fields and common value distributions when calculated

get_database_schema_subtree

ChatGPT
For HubSpot portal SQL database get tables related to the table requested, and the table itself. The requested table, and any related table small enough to add little size (few columns), get full business meaning descriptions, categories, and allowed values per column. A wide related table (pulled in only because it has a foreign key to/from the requested table) shows column names, data types, and foreign key links only, to keep the response size down - call this tool again with that table's own name to get its full column detail. Prefer the default MARKDOWN output_format over JSON - MARKDOWN is far more compact for the same data; only request JSON when you specifically need to parse the result programmatically. A wide, heavily-customized table (e.g. a HubSpot Contact object with hundreds of custom properties) can still return a large amount of content even as MARKDOWN; if you only need specific fields rather than the whole table, use search/fetch instead

get_full_database_schema

ChatGPT
For HubSpot portal SQL database. WARNING This method returns large content - every table in the database at once, each with full business meaning descriptions per column. Prefer get_database_schema_subtree for a specific table instead - it is far smaller. Use the default MARKDOWN output_format over JSON unless you specifically need to parse the result programmatically - MARKDOWN is far more compact for the same data. Get database tables and business meaning descriptions for each, column names with business meaning descriptions and data types for each, primary keys and foreign key relationships, sample values and allowed values for enum-like columns

get_object_relationships

ChatGPT
For HubSpot portal SQL database get table relations and cardinality

get_semantic_metadata

ChatGPT
For HubSpot portal SQL database get business terminology and common aggregation patterns, alongside with categorical fields allowed values and their meanings

get_tables_list

ChatGPT
For HubSpot portal SQL database get tables and business meaning descriptions for each, primary keys and foreign key relationships

list_saved_queries

ChatGPT
For HubSpot portal SQL database list your saved queries (pre-built selections and custom queries saved via save_query), with their descriptions, query names and parameters. Use execute_saved_query to run one by name

save_query

ChatGPT
For HubSpot portal SQL database save SQL query and its parameters into a new or existing saved query for future reuse. Each saved query can consist of several queries sharing parameters fully or partially. Retrieve saved queries with list_saved_queries, run them with execute_saved_query

set_semantic_metadata

ChatGPT
For HubSpot portal SQL database contribute to business terminology and common aggregation patterns, categorical fields allowed values and their meanings. Note: value_info is optional; when provided it must list ALL the allowed values for this element (a partial list replaces, not merges with, any previously saved list)

execute_query

Claude

execute_saved_query

Claude

fetch

Claude

get_data_statistics

Claude

get_database_schema_subtree

Claude

get_full_database_schema

Claude

get_object_relationships

Claude

get_semantic_metadata

Claude

get_tables_list

Claude

list_saved_queries

Claude

save_query

Claude

set_semantic_metadata

Claude

Similar Apps

Listed on MCP App Store

Listed on MCP App Store

Add this badge to your site or README. It links to this page.

HTML

<a href="https://mcp-app-store.keenethics-labs.com/app/revenue-analytics"><img src="https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg" alt="Listed on MCP App Store" width="220" height="44"></a>

Markdown

[![Listed on MCP App Store](https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg)](https://mcp-app-store.keenethics-labs.com/app/revenue-analytics)