DBHub

By Cong Ty TNHH Thuong Mai Va Dich Vu MVDB

Get New App Alerts

Open in ChatGPT

Open in Claude

Overview

DBHub gives Claude read-only access to your dbhub data warehouse, which consolidates advertising and e-commerce data from sources such as Facebook Ads, TikTok Shop and Google Ads. What it does: - List the tables in your workspace, grouped by data source, with descriptions and date columns - Describe a table: columns, business meaning, summable metrics, derived metric formulas and aggregation rules - Look up business definitions (CTR, CPC, CPM, ROAS and more) so metrics are computed correctly - Run read-only PostgreSQL queries (SELECT only, up to 1000 rows, 30-second timeout) Common uses: analyze ad performance across channels, compare campaigns, and answer marketing and sales questions with real data. Security: all tools are read-only. No data can be modified. Sign-in via OAuth is required.

Tools

describe_table

ChatGPT

Shows one table's columns (type and business meaning), date range, last sync, and its semantics: summable metrics with their column, derived metric formulas (SQL), values that must not be summed, dimensions and aggregation rules such as grouping by currency. Ends with 3 sample rows.

get_business_glossary

ChatGPT

dbhub's business definitions: each metric concept (label, synonyms, unit, meaning), how derived metrics such as CTR, CPC, CPM or ROAS are computed (sum of numerator over sum of denominator), metrics that cannot be computed and why, and ambiguous terms. Without a module it returns a compact index of concepts and module codes; with a module code (FAD, GGA, TTA, GMV, TTS, MPI, GA4, GSC, YTC, POS, PAN, PAC, KVT, SHO, FBT) it returns full definitions.

list_tables

ChatGPT

Lists the tables in this dbhub DB Warehouse workspace, grouped by data source module (Facebook Ads, TikTok Shop, Google Ads, ...), with a business description, row grain and main date column when known.

run_query

ChatGPT

Runs one read-only PostgreSQL 16 query (SELECT or WITH ... SELECT) against this workspace's tables and returns at most 1000 rows. Queries time out after 30 seconds. SQL reference: https://www.postgresql.org/docs/16/sql-select.html