Hotdata MCP

list_data_sources

List data sources (connections) in the current workspace.

list_tables

List tables for a connection. connection_id is the connection's public_id.

describe_table

Get table description: column metadata (name, type, nullable, default).

get_tables_summary

List tables with optional row count and size (up to table_limit).

get_table_row_count

Get row count for a table. approximate=True uses estimate when available.

get_table_size

Get table size (bytes/GB). Dialect-dependent (e.g. Postgres).

list_datasets

List datasets in the current workspace.

list_schedules

List refresh schedules (frequency, status, next run).

create_schedule

Create a refresh schedule. frequency: 5m, 15m, 30m, 1h, 1d, 1w.

update_schedule

Update a schedule. status: active or paused.

delete_schedule

Delete a schedule.

get_schedule_run_history

Get history of runs for a schedule.

get_schedule_failure_summary

Get a summary of failed schedule runs in the workspace.

explain_workspace_metrics

Explain current workspace metrics (connections, queries, p50/p99 latency).

get_query_latency_trend

Get query latency trend for the last 24 hours.

get_query_storage

Get visibility into query result storage (object count, total bytes).

get_query_count

Get total query count for the workspace.

list_query_errors

List recent query errors in the workspace.

list_recent_queries

List recent queries (time, SQL preview, latency, execution time).

get_slow_queries

List slowest queries in the workspace by latency.

list_saved_queries

List saved (pinned) queries in the workspace.

🔌 Hotdata MCP