List all QuickSight datasets with their names, IDs, and import mode.

Returns every dataset in the account with:

• name: Human-readable dataset name

• id: Dataset ID (use this for other dataset operations)

• import_mode: SPICE (cached) or DIRECT_QUERY (live)

Results are cached for 5 minutes. Use this to discover datasets before calling get_dataset_sql or update_dataset_sql.

Search QuickSight datasets by name (case-insensitive partial match).

Get full metadata for a QuickSight dataset.

Get the SQL query powering a QuickSight dataset.

Update the SQL query for a QuickSight dataset.

WARNING: This modifies the dataset in place. A backup is created by default.

Trigger a SPICE refresh (data reload) for a dataset.

Use this after updating dataset SQL to reload data into SPICE cache. Has no effect on DIRECT_QUERY datasets.

Check the status of a SPICE dataset refresh.

List recent SPICE refresh history for a dataset.

Create a new QuickSight dataset from a SQL query.

Update full dataset definition from JSON.

WARNING: This replaces the entire dataset definition. A backup is created automatically before the update.

Cancel a running SPICE dataset refresh.

Use this to stop a SPICE ingestion that is stuck in QUEUED or RUNNING state. Useful when old ingestions block new ones.

Find and replace text in a dataset's SQL query.

Convenience tool that reads the current SQL, applies a string replacement, and updates the dataset. A backup is created automatically.

List all QuickSight analyses with their names, IDs, and status.

Returns every analysis in the account. Results are cached for 5 minutes. Use this to discover analyses before inspecting them.

Each entry includes:

• name: Human-readable analysis name

• id: Analysis ID (use this for other analysis operations)

• status: CREATION_SUCCESSFUL, UPDATE_SUCCESSFUL, etc.

Search QuickSight analyses by name (case-insensitive partial match).

Get a structured summary of a QuickSight analysis.

Returns an overview of the analysis structure without the full raw definition -- ideal for understanding what an analysis contains before making changes.

List all visuals in a QuickSight analysis with type and location info.

List all calculated fields in a QuickSight analysis.

Get a frequency map of columns used across an analysis.

List all parameters defined in a QuickSight analysis.

Get the complete raw analysis definition for inspection.

Returns the full Definition dict exactly as stored by AWS. This is useful for debugging, manual inspection, or extracting complex structures (visual definitions, filter groups, etc.) that can be passed to other tools.

WARNING: The output can be very large for complex analyses.

List all filter groups defined in a QuickSight analysis.

Run a comprehensive health check on a QuickSight analysis.

Use this AFTER any write operation to verify the analysis is healthy. This is the "reviewer" that ensures changes actually took effect and nothing was silently broken.

Checks performed:

• Analysis status is SUCCESSFUL (not FAILED or IN_PROGRESS)

• Sheet count is within QuickSight limits (<=20)

• All visuals have corresponding layout elements

• All calculated fields reference valid dataset identifiers

Take a snapshot of the current analysis state for QA comparison.

Use this BEFORE making changes. After changes, use diff_analysis to compare and verify exactly what changed.

Compare current analysis state against a previous snapshot.

Use AFTER making changes to see what was added, removed, or modified. This is the QA reviewer -- ensures changes had the intended effect and nothing unexpected broke.

Get details of a specific calculated field in an analysis.

Add a new calculated field to a QuickSight analysis.

WARNING: This modifies the analysis definition. A backup is automatically created before making changes.

Update the expression of an existing calculated field.

WARNING: This modifies the analysis definition. A backup is automatically created before making changes. Visuals using this field will reflect the new expression immediately.

Delete a calculated field from a QuickSight analysis.

WARNING: This is destructive. If the field is used by any visuals or other calculated fields, those references will break. Check get_columns_used first to understand the impact.

A backup is automatically created before deletion.

List all QuickSight dashboards with their names, IDs, and publish status.

Returns every dashboard in the account. Results are cached for 5 minutes. Dashboards are the published, viewer-facing version of analyses.

Each entry includes:

• name: Dashboard display name

• id: Dashboard ID (use this for other dashboard operations)

• published_version: Current published version number

Search QuickSight dashboards by name (case-insensitive partial match).

List the version history of a QuickSight dashboard.

Publish a QuickSight analysis to an existing dashboard.

WARNING: This is a DESTRUCTIVE operation that replaces the current dashboard content with the analysis content. All viewers will immediately see the new version. Make sure you have tested the analysis thoroughly before publishing.

Best practice:

1. Clone the analysis first (clone_analysis) and test

2. Back up the dashboard (backup_analysis on the source)

3. Publish with a descriptive version_description

4. If something goes wrong, use rollback_dashboard

Rollback a QuickSight dashboard to a previous version.

WARNING: This is a DESTRUCTIVE operation. The current dashboard content will be replaced with the specified previous version. All viewers will immediately see the rolled-back version.

Use get_dashboard_versions first to find the version number you want to restore.

Save a full backup of a QuickSight analysis definition to disk.

Creates a timestamped JSON file containing the complete analysis definition (sheets, visuals, calculated fields, parameters, filters, etc.). Use restore_analysis to restore from a backup.

Backups are saved to ~/.quicksight-mcp/backups/.

Save a full backup of a QuickSight dataset configuration to disk.

Creates a timestamped JSON file containing the dataset definition (SQL, columns, physical/logical table maps, etc.).

Backups are saved to ~/.quicksight-mcp/backups/.

Restore a QuickSight analysis from a JSON backup file.

WARNING: This overwrites the analysis definition with the backup contents. The current state of the analysis will be replaced.

Clone a QuickSight analysis for safe experimentation.

Creates a full copy of the analysis with a new name and ID. The clone includes all sheets, visuals, calculated fields, parameters, and filters. Use this to test changes without affecting the original.

Best practice workflow:

1. clone_analysis to create a test copy

2. Make and test changes on the clone

3. When satisfied, publish_dashboard from the clone

4. Delete the clone when done

Show what the server has learned from your QuickSight usage patterns.

This server tracks every tool call -- what you use most, what fails, what takes longest -- and surfaces actionable insights.

Returns:

• most_used_tools: Tools you call most frequently

• slowest_tools: Tools with highest average latency

• error_rate: Per-tool failure percentages

• recommendations: Suggestions based on your usage patterns (e.g., "You search datasets often -- consider using list_datasets with caching instead")

The more you use the server, the better the insights become.

Show common QuickSight errors and their known fixes.

Analyzes your error history to identify recurring failure patterns and provides specific remediation steps. This is especially useful for diagnosing SPICE refresh failures, permission issues, and API throttling.

Returns:

• patterns: Grouped error types with frequency and last occurrence

• known_fixes: Documented fixes for each error pattern

• recent_errors: The most recent errors with context

Call this when something goes wrong to see if it is a known issue with a known fix.

Add a new sheet to a QuickSight analysis.

WARNING: This modifies the analysis definition. A backup is automatically created before making changes.

Delete a sheet from a QuickSight analysis.

WARNING: This is destructive. All visuals on the sheet will be removed. A backup is automatically created before deletion.

Rename an existing sheet in a QuickSight analysis.

WARNING: This modifies the analysis definition. A backup is automatically created before making changes.

List all visuals in a specific sheet of a QuickSight analysis.

Copy all visuals from one sheet to a new sheet in the same analysis.

This is the recommended way to duplicate a sheet. It copies all visuals with their layouts in a single API call, which is much more reliable than adding visuals one at a time.

Visual IDs are automatically prefixed with 'rc_' to avoid conflicts.

WARNING: This modifies the analysis definition. A backup is automatically created before making changes.

Delete all empty sheets (0 visuals) from an analysis.

Use this to clean up orphan sheets left by failed operations. Automatically removes filter groups scoped to deleted sheets.

WARNING: This is destructive. A backup is automatically created.

Get the full raw definition of a specific visual.

Use this to inspect a visual's complete configuration including field mappings, aggregations, formatting, and chart configuration. The returned definition can be modified and passed to add_visual to create a copy.

Add a visual to a sheet in a QuickSight analysis.

WARNING: This modifies the analysis definition. A backup is automatically created before making changes.

Delete a visual from a QuickSight analysis.

WARNING: This is destructive. The visual and its layout element will be removed. A backup is automatically created before deletion.

Set or update the title of a visual.

WARNING: This modifies the analysis definition. A backup is automatically created before making changes.

Set the position and size of a visual in the grid layout.

QuickSight uses a 36-column grid. Common patterns:

• Full width: column_index=0, column_span=36

• Half width: column_span=18

• Third width: column_span=12

• Row height: typically 8-16 rows per visual

WARNING: This modifies the analysis definition. A backup is automatically created before making changes.

Create a KPI visual from simple parameters.

Create a bar chart from simple parameters.

Create a line chart from simple parameters.

Create a pivot table from simple parameters.

Create a flat table visual from simple parameters.

Create a combo chart (bars + line on same chart) from simple parameters.

A combo chart overlays bar values and line values sharing a category axis. For example, count bars with a percentage line overlay.

Create a pie chart from simple parameters.

Add a parameter to a QuickSight analysis.

WARNING: This modifies the analysis definition. A backup is automatically created before making changes.

Delete a parameter from a QuickSight analysis.

WARNING: This is destructive. If the parameter is used by filters, calculated fields, or controls, those references will break. Check get_parameters first to understand dependencies.

A backup is automatically created before deletion.

Add a filter group to a QuickSight analysis.

WARNING: This modifies the analysis definition. A backup is automatically created before making changes.

Delete a filter group from a QuickSight analysis.

WARNING: This is destructive. Removing a filter group may change what data is displayed in affected visuals. A backup is automatically created before deletion.