[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_205":206,"_207":208,"_209":210},"routes/_public/_layout",{"_203":204},"routes/_public/mcp/connectors/_index/_route",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":-5,"_28":29,"_30":20,"_31":32,"_33":34,"_35":36,"_37":38},"attributeLabel","AI & Machine Learning","connectorSearchPageInfo",{"_201":-5,"_202":22},"connectorSearchReferenceId","01a0039f-dbdf-74ba-b4b8-517350df43a3","facets",[195,196,197],"freeTextSearchTerm","Chart.js","isSuperAdmin",false,"mcpRemotes",[],"meta",[81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100],"namespaceLabel","searchParams",{"_75":76,"_77":20,"_78":79},"searchTerm","stats",{"_67":68,"_69":70,"_71":72,"_73":74},"testProfileStatusByRemoteServer",{},"toolSearchResult",{"_39":40},"userProfilesByRemoteServer",{},"results",[41,42,43],{"_44":63,"_46":47,"_48":64,"_50":65,"_52":64,"_54":66,"_56":57},{"_44":58,"_46":47,"_48":59,"_50":60,"_52":61,"_54":62,"_56":57},{"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57},"description","Write operations on the open spreadsheet. Call as {\"action\": \"\", \"params\": {...}} — per-action params are listed in the Action Reference below. Numbers, booleans, and nulls in cell values are coerced to strings.\n\nSpecial actions (not shown in the action enum):\n• batch — {\"action\": \"batch\", \"params\": {\"actions\": [{\"action\": \"\", \"params\": {...}}, ...]}}. Runs writes sequentially; errors short-circuit the batch.\n• context — {\"action\": \"context\", \"params\": {\"topic\": \"\"}} or {\"action\": \"context\", \"params\": {\"action\": \"\"}}. Returns deeper docs for a topic or a single action's signature. Plural \"topics\" / \"actions\" arrays are also accepted and may be combined. Topics: python, javascript, formula, connection, validation, a1, quadratic, chart, pivot_table.\n\nAction Reference\n\nCell Data:\n• set_cell_values(top_left_position, cell_values, sheet_name?) — Sets cell values as a 2D string array (first row = headers). top_left_position: single cell in A1 notation. Don't place over existing data unless requested. Values replace existing content; use empty string to clear. For merged cells, place at the anchor (top-left) cell. Prefer this over add_data_table for tabular data; only use add_data_table when the user explicitly asks for a data table or the file already uses data tables. When writing tabular data as plain cells, format the header row afterward with set_text_formats (at least bold) so it's visually distinct — plain cells don't auto-style headers like data tables do. Don't use for formulas or code.\n• delete_cells(selection, sheet_name?) — Delete cell values in a selection (A1 notation). Don't delete cells referenced by code cells unless explicitly asked. To delete table columns: \"TableName[Column Name]\". To delete tables: \"TableName\".\n• move_cells(source_selection_rect, target_top_left_position, sheet_name?) — Move a rectangular block of cells. Target is the top-left corner (single cell). For spilled code cells, move just the anchor cell.\n• add_data_table(sheet_name, top_left_position, table_name, table_data) — Adds a data table. Data tables are discouraged by default — only use when the user specifically requests a data table or the file already uses data tables; otherwise use set_cell_values. First row of table_data is headers. Leave 2 rows below and 2 columns right as spacing. All rows must have equal length (use empty strings for missing values). To convert existing data, use convert_to_table instead. To delete a table, use set_cell_values with empty string at the anchor. A single-value formula or code cell MAY be written into a data cell of an editable (imported/value) table — it's stored as in-place single-cell code computing a 1x1 result; avoid the table's name/column-header rows and read-only code-output tables/charts, and don't put multi-cell output (dataframes/charts) inside a table.\n\nCode:\n• set_code_cell_value(code_cell_position, code_cell_language, code_cell_name, code_string, sheet_name?) — Sets and runs a Python or JavaScript code cell. Prefer set_formula_cell_value whenever a formula can do the task; only use code when the functionality is not available in formulas (e.g. charts, ML, correlations, complex data transforms, or web/API requests). For static data use set_cell_values. For SQL use set_sql_code_cell_value. IMPORTANT: Always reference sheet data with q.cells() — never hardcode data values. For charts, use Plotly ONLY (import plotly.express or plotly.graph_objects). Do NOT use Matplotlib/Seaborn. Name the output (no spaces/special chars, _ allowed). Placement: Estimate output size before placing. Charts default to 7 wide x 23 tall cells. Cell must be empty (avoids spill error). Leave one extra column/row gap between the code cell and nearest content. Empty sheet → A1.\n• set_formula_cell_value(formulas) — formulas: [{code_cell_position, formula_string, sheet_name?}]. Prefer this whenever a formula can do the task; only use set_code_cell_value when formulas can't. For basic historical stock prices use the STOCKHISTORY formula; for financial data with no formula equivalent (adjusted prices, statements, dividends, real-time/intraday, technicals, economic data) use set_code_cell_value with Python + q.financial. Don't prefix formulas with =. code_cell_position can be a single cell (\"A1\"), range (\"A1:A10\"), or collection (\"A1,A2:B2\"). Cell references adjust relatively (like copy-paste). Use $ for absolute references ($A$1). Place near referenced data, no extra spacing needed. Aggregations go directly below or beside data.\n• rerun_code(sheet_name?, selection?) — Re-run code cells. Do NOT call after set_code_cell_value, set_formula_cell_value, or set_sql_code_cell_value — those already run automatically. Only use to refresh unchanged code (e.g., external data).\n• set_sql_code_cell_value(code_cell_position, code_cell_name, connection_kind, sql_code_string, connection_id, sheet_name?) — Sets and runs a SQL connection code cell. connection_kind: POSTGRES, MYSQL, MSSQL, SNOWFLAKE, BIGQUERY, COCKROACHDB, MARIADB, SUPABASE, NEON, MIXPANEL, GOOGLE_ANALYTICS, PLAID, QUICKBOOKS. Always call get_database_schemas before writing SQL. Cell must be empty. Empty sheet → A1.\n\nImport:\n• import_file(file_name, file_data, sheet_name?, insert_at?) — Import CSV/Excel/Parquet. file_data: base64-encoded. Extension determines format (.csv, .xlsx/.xls, .parquet/.parq/.pqt). To create a new file from an import, call files create_file first, then import_file.\n\nFormatting:\n• set_text_formats(formats) — formats array: [{selection, bold?, italic?, underline?, strike_through?, text_color?, fill_color?, align?, vertical_align?, wrap?, font_size?, number_type?, currency_symbol?, numeric_decimals?, numeric_commas?, date_time?, sheet_name?}]. For table columns use table references (\"Table_Name[Column Name]\") instead of A1 ranges. Colors: hex (\"#FF0000\"), empty string to remove. align: \"left\"/\"center\"/\"right\". vertical_align: \"top\"/\"middle\"/\"bottom\". wrap: \"wrap\"/\"clip\"/\"overflow\". number_type: \"number\"/\"currency\"/\"percentage\"/\"exponential\" (currency requires currency_symbol, e.g. \"$\"). numeric_decimals: integer >= 0, number of decimal places to display (e.g. \"format percents as 2 decimals\" → 2). Percentages: .01 → 1%, 1 → 100%. date_time: chrono format e.g. \"%Y-%m-%d\". font_size: points (default 10). Set to null to clear any format.\n• set_borders(borders) — borders: [{selection, border_selection, color, line, sheet_name?}]. border_selection: all/inner/outer/horizontal/vertical/left/top/right/bottom/clear. line: line1 (thin)/line2 (medium)/line3 (thick)/dotted/dashed/double/clear. color: CSS color string.\n• merge_cells(selection, sheet_name?) — Merge a range of cells (e.g. A1:D1). All values except top-left are cleared.\n• unmerge_cells(selection, sheet_name?) — Unmerge merged cells overlapping the selection.\n\nSheets:\n• add_sheet(sheet_name, insert_before_sheet_name?) — Sheet names: unique, max 31 chars, no / \\ ? * : [ ]\n• duplicate_sheet(sheet_name_to_duplicate, name_of_new_sheet)\n• rename_sheet(sheet_name, new_name)\n• delete_sheet(sheet_name)\n• move_sheet(sheet_name, insert_before_sheet_name?)\n• color_sheets(sheet_names_to_color) — [{sheet_name, color}]. color: CSS color string.\n• set_frozen_panes(sheet_name?, frozen_row_count, frozen_column_count) — freeze/pin rows from row 1 and columns from column 1. Use 0 to unfreeze an axis.\n\nTables:\n• convert_to_table(selection, table_name, first_row_is_column_names, sheet_name?) — Convert existing cell data to a data table. Only use when the user explicitly asks for a data table or the file already uses data tables; otherwise keep data as plain cells. Selection must NOT contain code cells or existing tables. Table name row is added above, pushing data down by one row.\n• table_meta(table_location, new_table_name?, show_name?, show_columns?, alternating_row_colors?, first_row_is_column_names?, sheet_name?) — Set table metadata. table_location: anchor cell (top-left, e.g. A5).\n• table_column_settings(table_location, column_names, sheet_name?) — column_names: [{old_name, new_name, show}]. Only include columns to change. To delete columns use delete_cells with \"TableName[Column Name]\".\n\nLayout:\n• resize_columns(selection, size, sheet_name?) — size: \"auto\" (fit content), \"default\", or pixels (20-2000).\n• resize_rows(selection, size, sheet_name?) — size: \"auto\", \"default\", or pixels (10-2000).\n• set_default_column_width(size, sheet_name?) — size in pixels (20-2000, default 100).\n• set_default_row_height(size, sheet_name?) — size in pixels (10-2000, default 21).\n• insert_columns(column, right, count, sheet_name?) — column: letter (e.g. \"C\"). right: true=insert right, false=insert left.\n• insert_rows(row, below, count, sheet_name?) — row: number. below: true=insert below, false=insert above.\n• delete_columns(columns, sheet_name?) — columns: array of letters (e.g. [\"A\", \"C\"]).\n• delete_rows(rows, sheet_name?) — rows: array of numbers (e.g. [1, 5, 10]).\n\nCharts (Excel-native; prefer over Plotly/Chart.js code cells for standard charts of sheet data — see the \"chart\" topic for details):\n• add_chart(chart_type, position, series, sheet_name?, title?, name?, categories?, legend?, x_axis_title?, x_axis_min?, x_axis_max?, x_axis_number_format?, y_axis_title?, y_axis_min?, y_axis_max?, y_axis_number_format?, width_cells?, height_cells?, chart_3d_rot_x?, chart_3d_rot_y?, chart_3d_perspective?, chart_3d_depth_gap?) — Adds an Excel-native chart anchored at position (single cell). chart_type: column, column_stacked, column_percent_stacked, bar, bar_stacked, bar_percent_stacked, line, line_stacked, area, area_stacked, pie, doughnut, scatter, scatter_line, bubble, radar, radar_filled, stock, column_3d, bar_3d, line_3d, area_3d, pie_3d, waterfall, funnel, histogram, pareto, box_whisker, treemap, sunburst, region_map. series: [{values, name?, bubble_sizes?, color?}] where values is one row or column of numbers in A1 (\"B2:B13\", table references allowed). categories: labels range (x values for scatter/bubble). Charts float over the grid (no spill errors); the anchor is nudged to free space if the cell would cover content. Returns the chart_id for update_chart/delete_chart.\n• update_chart(chart_id, sheet_name?, chart_type?, position?, series?, title?, name?, categories?, legend?, axis and 3d options as in add_chart) — Changes an existing chart; omitted arguments leave that part unchanged. Chart ids are returned by add_chart and listed in the file context under \"Native Chart\".\n• delete_chart(chart_id, sheet_name?) — Removes a chart.\n\nPivot Tables:\n• set_pivot_table(action, pivot_table_name?, sheet_name?, source?, destination?, rows?, columns?, values?, filters?, layout?, values_layout?, row_grand_total?, column_grand_total?, subtotal_position?) — Creates (\"create\"), reconfigures (\"update\"), or removes (\"delete\") a PivotTable: a live cross-tabulation that groups source rows and aggregates values, recomputing when the source changes. Prefer it over SUMIFS or a Python groupby for \"totals by category\" requests. Reference source columns by header name, not letter. source (create): A1 range with a header row or a table name. destination (create): \"new_sheet\" (default) or a top-left cell. rows/columns: [{field, label?, sort?, show_totals?, group_by?, numeric_interval?}]. values (at least one): [{field, aggregation?, name?, show_as?, number_format?, decimals?, visual?}]. filters: [{field, include?, exclude?}]. For update: null leaves an area as it is, an empty array clears it — send only the areas you're changing. pivot_table_name is required for update/delete; names are listed in the file context. The report's cells are read-only; change it with this action. See the \"pivot_table\" topic for details.\n\nValidation:\n• add_logical_validation(selection, show_checkbox?, ignore_blank?, sheet_name?) — True/false validation with optional checkbox.\n• add_list_validation(selection, list_source_list?, list_source_selection?, drop_down?, ignore_blank?, sheet_name?) — list_source_list: comma-separated values (\"Item 1, Item 2\"). list_source_selection: A1 cell reference. Use one, not both.\n• remove_validation(selection, sheet_name?) — Remove all validations from the selection.\n\nConditional Formatting:\n• update_conditional_formats(sheet_name, rules) — rules: [{action, id?, selection?, type?, rule?, bold?, italic?, underline?, strike_through?, text_color?, fill_color?, apply_to_empty?, color_scale_thresholds?, auto_contrast_text?}]. action: \"create\"/\"update\"/\"delete\". type: \"formula\" (apply styles when formula is true) or \"color_scale\" (gradient colors). For formula type: rule examples: \"A1>100\", \"ISBLANK(A1)\", \"AND(A1>=5,A1<=10)\". For color_scale: thresholds: [{value_type: \"min\"/\"max\"/\"number\"/\"percent\"/\"percentile\", value, color}]. For table columns use table references instead of A1 ranges. For delete: only id required.\n\nHistory:\n• undo(count?) — Default 1.\n• redo(count?) — Default 1.\n\nBatch:\n• batch(actions) — actions: [{action, params}]. Runs writes sequentially through this same tool; errors short-circuit the batch. `action` may be any name from this reference. Nested `context` items are allowed and returned alongside the writes.\n","healthy",true,"mcpRemoteServerName","Quadratic","mcpRemoteServerNamespace","io.github.quadratichq","mcpRemoteServerSlug","quadratic-mcp","name","write_data","tier","A","Write an HTML surface's body. Pass any of `html` / `css` / `js`; omitted fields stay unchanged. Pass empty string to clear. The surface renders in a sandboxed iframe on a separate origin (`render.trydock.ai`) with no access to Dock cookies, storage, or parent DOM — you have free rein inside that boundary. Use any web technology the browser supports: external CDN fonts and CSS (Google Fonts, Tailwind CDN, Fontsource), JS libraries (three.js, GSAP, Chart.js, anime.js), inline `

"Chart.js" matching MCP connectors: