Mode Analytics MCP server Let your AI agent refresh your Mode reports.

ToolWhat it doesAccess

• list_collections Lists the Collections of a Workspace that your account can open. read

  Returns each Collection with its name, whether it is your personal Collection and how many reports it holds. Collections you cannot open are not listed. Pass a name to list_reports to look inside one.

  MCP callmode_analytics_read → list_collections

  REST endpointGET https://cotlet.dev/api/v1/mode-analytics/collections

  Parameters

  Parameters: list_collections

  Name	Type	Description
  workspace string required	string	Workspace username, the first part of the URL (app.mode.com/{workspace}).

  Example input

  {
    "workspace": "workspace"
  }

  Example response

  {
    "collections": [
      {
        "name": "Growth",
        "token": "c4f1a9b2d7e3",
        "personal": false,
        "reports": 14
      },
      {
        "name": "Finance",
        "token": "8d2b6e0a51c9",
        "personal": false,
        "reports": 9
      },
      {
        "name": "Maya Chen",
        "token": "f3a7c1e8b406",
        "personal": true,
        "reports": 3
      }
    ]
  }

• list_reports Lists the reports in a Collection or finds reports by words in the title. read

  Returns each report with its token, title, description, Collection, last edited date and the state of its latest run. Without collection or query it lists the reports you can open in the Workspace. Pass next_cursor back as cursor until it is empty.

  MCP callmode_analytics_read → list_reports

  REST endpointGET https://cotlet.dev/api/v1/mode-analytics/reports

  Parameters

  Parameters: list_reports

  Name	Type	Description
  workspace string required	string	Workspace username, the first part of the URL.
  collection string	string	Collection name or token from list_collections.
  query string	string	Words to search for in report titles.
  archived boolean	boolean	true lists archived reports instead of active ones.
  cursor string	string	Next page cursor from the previous call.

  Example input

  {
    "workspace": "workspace"
  }

  Example response

  {
    "reports": [
      {
        "token": "a1b2c3d4e5f6",
        "title": "Weekly signups by channel",
        "description": "Signups per channel, last 8 weeks",
        "collection": "Growth",
        "last_edited": "2026-11-03",
        "latest_run": "succeeded"
      },
      {
        "token": "b7c8d9e0f1a2",
        "title": "Trial to paid conversion",
        "description": "",
        "collection": "Growth",
        "last_edited": "2026-09-18",
        "latest_run": "succeeded"
      }
    ],
    "next_cursor": null
  }

• get_report Reads one report: title, description, Collection, creator and its queries. read

  Returns the report details with the name and token of each query and the data source it runs on. It also returns who created the report, when it was last edited and whether it is archived. Use get_query for the SQL.

  MCP callmode_analytics_read → get_report

  REST endpointGET https://cotlet.dev/api/v1/mode-analytics/report

  Parameters

  Parameters: get_report

  Name	Type	Description
  report string required	string	Report token, the last part of the report URL (app.mode.com/{workspace}/reports/{token}). list_reports returns it.

  Example input

  {
    "report": "report"
  }

  Example response

  {
    "token": "a1b2c3d4e5f6",
    "title": "Weekly signups by channel",
    "description": "Signups per channel, last 8 weeks",
    "collection": "Growth",
    "created_by": "Maya Chen",
    "last_edited": "2026-11-03",
    "archived": false,
    "queries": [
      {
        "name": "Signups by channel",
        "token": "q9z8y7x6w5v4",
        "data_source": "Production warehouse"
      }
    ]
  }

• get_query Reads the SQL of one query in a report. read

  Returns the query name, its SQL as written in the query editor and its data source. With no query it returns all queries of the report in the order the report lists them.

  MCP callmode_analytics_read → get_query

  REST endpointGET https://cotlet.dev/api/v1/mode-analytics/query

  Parameters

  Parameters: get_query

  Name	Type	Description
  report string required	string	Report token, the last part of the report URL (app.mode.com/{workspace}/reports/{token}). list_reports returns it.
  query string	string	Query name or token from get_report. Leave out to read every query in the report.

  Example input

  {
    "report": "report"
  }

  Example response

  {
    "queries": [
      {
        "name": "Signups by channel",
        "token": "q9z8y7x6w5v4",
        "data_source": "Production warehouse",
        "sql": "SELECT channel, COUNT(*) AS signups FROM signups WHERE created_at >= CURRENT_DATE - 56 GROUP BY channel"
      }
    ]
  }

• update_report Changes the title or the description of a report. write

  Saves the new title or description and returns the old ones. It reaches no one and one more call undoes it, so it needs no confirmation.

  MCP callmode_analytics_write → update_report

  REST endpointPATCH https://cotlet.dev/api/v1/mode-analytics/report

  Parameters

  Parameters: update_report

  Name	Type	Description
  report string required	string	Report token, the last part of the report URL (app.mode.com/{workspace}/reports/{token}). list_reports returns it.
  title string	string	New report title.
  description string	string	New report description.

  Example input

  {
    "report": "report"
  }

  Example response

  {
    "token": "b7c8d9e0f1a2",
    "title": "Trial to paid conversion",
    "description": "Share of trials that become paid, by signup week",
    "previous_description": ""
  }

• archive_report Archives a report so it leaves its Collection. write

  Archives the report. It reaches no one and unarchive_report puts it back, so it needs no confirmation. Archived reports can still be found with list_reports and archived set to true.

  MCP callmode_analytics_write → archive_report

  REST endpointPOST https://cotlet.dev/api/v1/mode-analytics/report/archive

  Parameters

  Parameters: archive_report

  Name	Type	Description
  report string required	string	Report token, the last part of the report URL (app.mode.com/{workspace}/reports/{token}). list_reports returns it.

  Example input

  {
    "report": "report"
  }

  Example response

  {
    "token": "c2d3e4f5a6b7",
    "title": "Pricing test, Q1",
    "archived": true
  }

• unarchive_report Brings an archived report back. write

  Unarchives the report so it shows in its Collection again. It reaches no one, so it needs no confirmation.

  MCP callmode_analytics_write → unarchive_report

  REST endpointPOST https://cotlet.dev/api/v1/mode-analytics/report/unarchive

  Parameters

  Parameters: unarchive_report

  Name	Type	Description
  report string required	string	Report token, the last part of the report URL (app.mode.com/{workspace}/reports/{token}). list_reports returns it.

  Example input

  {
    "report": "report"
  }

  Example response

  {
    "token": "c2d3e4f5a6b7",
    "title": "Pricing test, Q1",
    "archived": false
  }

ToolWhat it doesAccess

• list_report_runs Lists the runs of a report, with the state of each. read

  Returns the run history as the View Details page shows it: run token, started time, finished time and state. A failed run carries the error text from the run. Use it to see whether the last scheduled run worked.

  MCP callmode_analytics_read → list_report_runs

  REST endpointGET https://cotlet.dev/api/v1/mode-analytics/report-runs

  Parameters

  Parameters: list_report_runs

  Name	Type	Description
  report string required	string	Report token, the last part of the report URL (app.mode.com/{workspace}/reports/{token}). list_reports returns it.
  cursor string	string	Next page cursor from the previous call.

  Example input

  {
    "report": "report"
  }

  Example response

  {
    "runs": [
      {
        "token": "r5t6y7u8i9o0",
        "started": "2026-11-05T07:00:12Z",
        "finished": "2026-11-05T07:00:41Z",
        "state": "succeeded"
      },
      {
        "token": "r1q2w3e4r5t6",
        "started": "2026-11-04T07:00:10Z",
        "finished": "2026-11-04T07:00:19Z",
        "state": "failed",
        "error": "column \"channel\" does not exist"
      }
    ],
    "next_cursor": null
  }

• get_run_results Reads the result table of one query in a report run. read

  Returns the column names, the rows and the total row count of the run, with the time the run finished. It reads a run that already exists and starts nothing; use run_report for fresh data.

  MCP callmode_analytics_read → get_run_results

  REST endpointGET https://cotlet.dev/api/v1/mode-analytics/run-results

  Parameters

  Parameters: get_run_results

  Name	Type	Description
  report string required	string	Report token, the last part of the report URL (app.mode.com/{workspace}/reports/{token}). list_reports returns it.
  query string required	string	Query name or token from get_report.
  run string	string	Run token from list_report_runs. Defaults to the latest successful run.
  limit integer	integer	Most rows to return. The result says when it was cut.

  Example input

  {
    "report": "report",
    "query": "query"
  }

  Example response

  {
    "run": "r5t6y7u8i9o0",
    "finished": "2026-11-05T07:00:41Z",
    "columns": [
      "channel",
      "signups"
    ],
    "rows": [
      [
        "Organic",
        412
      ],
      [
        "Paid",
        268
      ],
      [
        "Referral",
        96
      ]
    ],
    "total_rows": 3,
    "truncated": false
  }

• run_report Starts a new run of a report and waits for it to finish. writeasks first

  Returns the run token and its final state, succeeded or failed, with the error text when it failed. The run sends the report queries to your data source, so it uses your warehouse. It does not email or post anywhere. By default you confirm each call; you can switch that off for this tool.

  MCP callmode_analytics_write → run_report

  REST endpointPOST https://cotlet.dev/api/v1/mode-analytics/report/run

  Parameters

  Parameters: run_report

  Name	Type	Description
  report string required	string	Report token, the last part of the report URL (app.mode.com/{workspace}/reports/{token}). list_reports returns it.
  parameters object	object	Parameter values as name and value, for reports that have parameters.

  Example input

  {
    "report": "a1b2c3d4e5f6",
    "parameters": {
      "weeks": 8
    }
  }

  Example response

  {
    "run": "r9p8o7i6u5y4",
    "state": "succeeded",
    "started": "2026-11-05T09:12:03Z",
    "finished": "2026-11-05T09:12:31Z"
  }

• update_query Changes the name or the SQL of one query in a report. writeasks first

  Saves the change in the query editor and returns the SQL as it was before, so one more call puts it back. The change reaches everyone who opens the report and every later scheduled run. It does not run the query; call run_report for that. By default you confirm each call; you can switch that off for this tool.

  MCP callmode_analytics_write → update_query

  REST endpointPATCH https://cotlet.dev/api/v1/mode-analytics/query

  Parameters

  Parameters: update_query

  Name	Type	Description
  report string required	string	Report token, the last part of the report URL (app.mode.com/{workspace}/reports/{token}). list_reports returns it.
  query string required	string	Query name or token from get_report.
  name string	string	New query name.
  sql string	string	New SQL for the query.

  Example input

  {
    "report": "report",
    "query": "query"
  }

  Example response

  {
    "query": "q9z8y7x6w5v4",
    "name": "Signups by channel",
    "previous_sql": "SELECT channel, COUNT(*) AS signups FROM signups GROUP BY channel",
    "saved": true
  }

ToolWhat it doesAccess

• list_schedules Lists the schedules of a report with their delivery settings. read

  Returns each schedule with its name, refresh frequency, parameter values and where it delivers: email subscribers and Slack channels. A report can have several schedules for different groups.

  MCP callmode_analytics_read → list_schedules

  REST endpointGET https://cotlet.dev/api/v1/mode-analytics/schedules

  Parameters

  Parameters: list_schedules

  Name	Type	Description
  report string required	string	Report token, the last part of the report URL (app.mode.com/{workspace}/reports/{token}). list_reports returns it.

  Example input

  {
    "report": "report"
  }

  Example response

  {
    "schedules": [
      {
        "name": "Monday digest",
        "frequency": "Every Monday at 08:00",
        "parameters": {},
        "delivers_to": {
          "slack": [
            "#growth"
          ],
          "email": 2
        },
        "created_by": "Maya Chen"
      }
    ]
  }

• create_schedule Adds a schedule to a report that runs it and delivers the results. writeasks first

  Creates the schedule from the report header, Schedule then New Schedule, and returns its name and where it delivers. The schedule keeps running until the report or the schedule is deleted. Recipients must be Workspace members or in a claimed domain unless external sharing is on. By default you confirm each call; you can switch that off for this tool.

  MCP callmode_analytics_write → create_schedule

  REST endpointPOST https://cotlet.dev/api/v1/mode-analytics/schedules

  Parameters

  Parameters: create_schedule

  Name	Type	Description
  report string required	string	Report token, the last part of the report URL (app.mode.com/{workspace}/reports/{token}). list_reports returns it.
  name string required	string	Schedule name that describes its purpose.
  frequency string required	string	Refresh frequency in words, for example "every Monday at 8:00". The tool picks the matching choice in the Schedule form and fails if there is none.
  parameters object	object	Parameter values for the scheduled runs.
  slack_channel string	string	Slack channel to post the report to. A private channel needs the @Mode bot added.
  subscribers array	array	Email addresses to subscribe. They always get an email that says they were subscribed.

  Example input

  {
    "report": "report",
    "name": "Jane Doe",
    "frequency": "frequency"
  }

  Example response

  {
    "report": "a1b2c3d4e5f6",
    "name": "Monday digest",
    "frequency": "Every Monday at 08:00",
    "delivers_to": {
      "slack": [
        "#growth"
      ],
      "email": 1
    },
    "created": true
  }

• share_report Sends a report once to a Slack channel or to email addresses. writeasks first

  Uses the Share button of the report. The post or email goes out immediately and includes your name, the report title and a link, and a preview image in Slack unless an admin turned previews off. Everyone in the channel sees the message, but only people with Mode access can open the link. By default you confirm each call; you can switch that off for this tool.

  MCP callmode_analytics_write → share_report

  REST endpointPOST https://cotlet.dev/api/v1/mode-analytics/report/share

  Parameters

  Parameters: share_report

  Name	Type	Description
  report string required	string	Report token, the last part of the report URL (app.mode.com/{workspace}/reports/{token}). list_reports returns it.
  slack_channel string	string	Slack channel name. Needs Mode connected to your Slack. A private channel needs the @Mode bot added.
  emails array	array	Email addresses. Recipients must be Workspace members or in a claimed domain unless external sharing is on.
  message string	string	Short message to add.
  include_links boolean	boolean	false leaves the report links out. Default true.

  Example input

  {
    "report": "report"
  }

  Example response

  {
    "report": "a1b2c3d4e5f6",
    "sent_to": {
      "slack": "#growth",
      "email": []
    },
    "sent": true
  }