Skip to main content

HG Catalog

Discover available tables, columns, data types, and row counts in the HG Insights data warehouse. Use this tool before writing queries with hg_data_query.

Parameters​

NameTypeRequiredDefaultDescription
table_namestringNo-Filter to a single table by name. Must match ^[a-z_][a-z0-9_]{0,63}$.

Required Integrations​

  • hginsights_v2

Credit Cost​

Free — this tool does not consume any credits.

MCP Resource​

This tool is also available as an MCP resource at hg://catalog, which returns the same schema information.

Use Cases​

  • Schema discovery: Understand available tables and columns before writing SQL queries
  • Query planning: Identify join keys (url_id connects most tables to company_locations)
  • Column lookup: Find exact column names and data types for use in queries
  • Data exploration: See approximate row counts to understand table sizes

Example Usage​

List all tables​

{
  "tool": "hg_catalog",
  "parameters": {}
}

Get schema for a specific table​

{
  "tool": "hg_catalog",
  "parameters": {
    "table_name": "company_locations"
  }
}

Response Format​

{
  "tables": [
    {
      "name": "company_locations",
      "description": "Company lookup and firmographics",
      "approximate_row_count": 30000000,
      "columns": [
        {
          "name": "url_id",
          "type": "bigint",
          "description": "Unique company identifier"
        },
        {
          "name": "company_name",
          "type": "varchar",
          "description": "Company name"
        }
      ]
    }
  ]
}
  • tables: Array of table definitions
    • name: Table name
    • description: Human-readable description
    • approximate_row_count: Estimated number of rows
    • columns: Array of column definitions with name, type, and description

Error Handling​

Common errors:

  • Table not found: Requested table_name does not exist in the catalog
  • Invalid table name: Name does not match the required pattern
  • Authentication: HG Insights API key not configured or invalid

Next Steps​