create_dataset
Create a virtual SQL-based dataset from a validated query to enable charting in Preset. Register the query with a database ID to make data available for visualization.
Instructions
Create a virtual (SQL-based) dataset for charting.
This is the main entry point from analytics into visualization. Take a validated SQL query (e.g. from igloo-mcp) and register it as a Preset dataset. Use list_databases to find database_id.
Write SQL (INSERT, DROP, etc.) is blocked — only SELECT-style queries are permitted as dataset definitions.
Args: name: Display name for the dataset sql: SQL query defining the dataset database_id: Database connection ID schema: Optional schema name dry_run: If True, validate inputs and return a preview without making any changes (default: False)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | ||
| sql | Yes | ||
| database_id | Yes | ||
| schema | No | ||
| dry_run | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |