MCP tools

These are the tools your AI agent can call through the Holistics MCP Server, grouped by what they let it do.

Tool	Description	Reporting	Development
Explore datasets
`list_datasets`	List available datasets (unames, labels, descriptions, tags).	✓	✓
`fetch_dataset`	Fetch full details of a dataset: dimensions, measures, models, relationships, and analytics contexts.	✓	✓
`explore_dataset`	Explore a dataset interactively.	✓	✓
`fetch_sample_data`	Fetch sample values of a model dimension to understand its data shape.	✓	✓
`lookup_values`	Look up exact values of a model dimension for use in AQL filters.	✓	✓
Write and run queries
`generate_aql`	Generate an AQL query for a dataset from a natural language question. Your agent can also write this itself. See Choose who writes AQL and visualizations.	✓	✓
`validate_aql`	Validate an AQL query and return any syntax or semantic errors.	✓	✓
`execute_aql`	Execute an AQL query and return the result data.	✓	✓
`explain_result`	Explain or surface insights from a query result.	✓	✓
Build visualizations
`generate_viz`	Generate an AML Viz definition from a natural language description. Your agent can also write this itself. See Choose who writes AQL and visualizations.	✓	✓
`execute_viz`	Execute an AML Viz and return the visualized result.	✓	✓
Reuse dashboards and viz blocks
`search_dashboards`	Search dashboards by query (returns unames, titles, descriptions, tags).	✓	—
`search_viz_blocks`	Search viz blocks by query (returns label, description, tags, AML Viz, AQL).	✓	—
`execute_viz_block`	Execute a viz block.	✓	✓
Inspect your data warehouse
`list_data_sources`	List all data sources with their name and database type.	✓	✓
`list_data_source_schemas`	List all schema names in a data source.	✓	✓
`read_data_source_schema`	List all tables within a schema.	✓	✓
`read_data_source_table_schema`	Read a table's columns, types, and constraints (PKs, FKs, unique).	✓	✓
Use docs, skills, and organization context
`search_docs`	Search Holistics documentation (AML, AQL, datasets, visualizations, etc.).	✓	✓
`list_skills`	List available automatic skills with their IDs and descriptions.	✓	✓
`load_skill`	Load the full content of a skill by ID.	✓	✓
`fetch_org_context`	Fetch AI context and instructions set by your organization.	✓	✓
`fetch_context`	Fetch a specific context chunk by ID.	✓	✓