HubSpot Data Model
The CData MCP Server for HubSpot models HubSpot data as an easy-to-use SQL database. There are three parts to the data model: tables, views, and stored procedures.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your HubSpot account.
Common tables include:
| Table | Description |
| Contacts | Handles HubSpot contact records, enabling full create, read, update, delete (CRUD) operations on contact data. |
| Companies | Manages company records in HubSpot, allowing creation, updating, and deletion of company data similar to contact management. |
| Deals | Manages HubSpot deals used for recording sales opportunities, with capabilities for retrieval and modification. |
| Tickets | Retrieves all ticket records from a HubSpot portal, used for customer support and issue tracking. |
| Engagements | Represents various types of interactions in HubSpot, including calls, emails, and tasks, useful for tracking customer engagement activities. |
| ContactLists | Manages contact lists used to group and target contacts based on shared attributes or behavior. |
| ContactProperties | Accesses both standard and custom properties assigned to contacts, critical for personalized marketing and sales strategies. |
| CompanyProperties | Provides access to standard and custom fields associated with companies in HubSpot, aiding in data enrichment. |
| DealProperties | Provides access to deal property fields, both standard and custom, supporting deal tracking and analysis. |
| TicketProperties | Lists all properties related to tickets, both default and custom, used for managing customer support cases. |
| LineItems | Retrieves all line items in HubSpot, commonly used in association with deals and transactions. |
| Products | Retrieves product records configured in HubSpot, useful for inventory, pricing, and catalog management. |
| Workflows | Manages and retrieves workflows configured in HubSpot to automate marketing, sales, and service processes. |
| CrmAssociations | Queries customer relationship management (CRM) object associations within HubSpot, essential for understanding relationships between CRM entities. |
| ContactFormSubmissions | Lists form submissions made by contacts, useful for analyzing contact engagement through forms. |
| Forms | Enables creation, management, and retrieval of HubSpot forms used for lead capture and contact data collection. |
| MarketingEmails | Enables creation, management, and retrieval of marketing emails in HubSpot for email campaign management. |
| EmailSubscriptions | Lists subscription types linked to a specific email address, allowing management of subscription preferences. |
| AnalyticsSessions | Breaks down analytics data by user sessions, providing visibility into visitor behavior across sessions. |
| AnalyticsViews | Lists configured analytics views within the HubSpot portal, providing information on available analytics perspectives. |
API limitations and requirements are documented in each table.
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including creating schemas and managing OAuth tokens.