clicdata-mcp

ClicData MCP Server enables AI assistants (Claude, Mistral, ChatGPT, etc.) to connect directly to your ClicData account and access your data warehouse in real…

CommunityOnlineNo sign-inGlobalFreeRead-only

What it can do

  • List Dashboards: Lists dashboards accessible to the user (owned, shared, or via team). Light-weight summary by default — pass "fields" for more, or use GetDashboard(id) for full detail.
  • Describe Schedule Fields: Selectable "fields" paths for ListSchedules/GetSchedule.
  • Describe Query Data Parameters: Selectable/usable "columns", "groupByColumns", "filters" and "aggregations" parameters for QueryData, plus the paging metadata always present on its result — call this

What data it sees

Do you need an account

No: the server works without sign-in

ClicData MCP Server enables AI assistants (Claude, Mistral, ChatGPT, etc.) to connect directly to your ClicData account and access your data warehouse in real time. Query tables, list dashboards, retrieve schedules, validate datasets, debug refreshes, and manage workflows all through natural language prompts.

Secure OAuth 2 authentication ensures users can only access data they're already authorized to see.

How to connect

How to connect clicdata-mcp to Claude

The server address to paste into Claude settings:

https://clicdata-mcp--clicdata.run.tools

  1. Open Claude (claude.ai or the desktop app).
  2. Go to Settings → Connectors.
  3. Click Add custom connector.
  4. Paste the server address copied below into Remote MCP server URL and click Add.
  5. In a chat, click + → Connectors and switch the new connector on.

Custom connectors are available on Free, Pro, Max, Team and Enterprise plans (Free is limited to one). On Team and Enterprise an organization Owner adds the connector first under Organization settings → Connectors.

Authorization

After you click Add, a sign-in window for the service opens. Sign in with your own account and approve access. Claude never sees your password.

How to connect clicdata-mcp to ChatGPT

The server address to paste into ChatGPT settings:

https://clicdata-mcp--clicdata.run.tools

  1. Open ChatGPT in a browser (chatgpt.com). A Plus, Pro, Business, Enterprise or Edu plan is required.
  2. Turn on developer mode once: Settings → Apps → Advanced settings → Developer mode.
  3. Open Settings → Connectors and click Create.
  4. Fill in the form: Name (anything), Description (one line about what the service does), MCP server URL (copy it below).
  5. Under Authentication choose OAuth if the service requires sign-in, otherwise None. Click Create.
  6. In a new chat open + → Apps/Connectors and enable the connector.

OpenAI has renamed this section before (Connectors → Apps/Plugins). If the label differs, search settings for "developer mode". On Business/Enterprise workspaces an admin must allow custom connectors first.

Authorization

On first use ChatGPT opens the service's sign-in window. Sign in and approve access.

How to connect clicdata-mcp to Cursor

The server address to paste into Cursor settings:

https://clicdata-mcp--clicdata.run.tools

Fastest: click Open in Cursor below and confirm the prompt.

Manually:

  1. In Cursor open Settings → Cursor Settings → MCP and click Add new global MCP server.
  2. Paste the JSON copied below into ~/.cursor/mcp.json (per project: .cursor/mcp.json in the repo root).
  3. Save the file. The server appears in the MCP list; authorize it there if asked.

Authorization

If the service needs sign-in, an authorize button appears next to the server in the MCP list.

Server tool list (14)

Raw names from tools/list. Only developers need these.

list_dashboardsLists dashboards accessible to the user (owned, shared, or via team). Light-weight summary by default — pass "fields" for more, or use GetDashboard(id) for full detail.
describe_schedule_fieldsSelectable "fields" paths for ListSchedules/GetSchedule.
describe_query_data_parametersSelectable/usable "columns", "groupByColumns", "filters" and "aggregations" parameters for QueryData, plus the paging metadata always present on its result — call this once per tableId (columns come from GetTableSchema) before building non-trivial QueryData calls.
describe_dashboard_fieldsSelectable "fields" paths for GetDashboard/ListDashboards.
list_tablesLists tables accessible to the user (owned, shared, or via team). Light-weight summary by default — pass "fields" for more, or use GetTable(id) for full detail.
get_table_schemaReturns the table's column schema wrapped with tableId/columnCount metadata. Throws if not found/accessible.
list_schedulesLists schedules accessible to the user (owned, shared, or via team). Light-weight summary by default — pass "fields" for more, or use GetSchedule(id) for full detail.
get_meReturns profile information about the currently authenticated user.
describe_user_fieldsSelectable "fields" paths for GetMe.
query_dataPaged rows from a table (column names from GetTableSchema). Recipes: 1) rows: columns=[...] only. 2) distinct values: columns=groupByColumns=[...]. 3) totals per group: columns=groupByColumns=[...] + aggregations=[{Column,Function}]. 4) overall total: columns=[], aggregations=[{Column,Function}], no groupByColumns. Rule: when groupByColumns is set, columns must contain exactly the same columns as groupByColumns (same set, order-independent) — every group-by column must be selected so grouped rows stay distinguishable; must be empty if aggregations is used without groupByColumns. Throws if the table doesn't exist or isn't accessible. Use filters to restrict rows before grouping/aggregation (WHERE-only — filtering on aggregated results/HAVING is not supported) instead of pulling the whole table. Filters combine as AND by default; give filters the same Group id to OR them together instead (different groups, and ungrouped filters, are still ANDed — e.g. Status=A/Group:1 + Status=B/Group:1 + Region=X gives (Status=A OR Status=B) AND Region=X). Comparator keywords (contains/startswith/endswith/equals/...) are case-insensitive, but the string values they compare against row data are case-sensitive; between/notbetween are inclusive of both bounds. pageSize is clamped to a maximum (currently 1000).
get_dashboardReturns full detail of a dashboard: configuration, live link, usage stats, widgets. Throws if not found/accessible.
describe_table_fieldsSelectable "fields" paths for ListTables/GetTable/GetTableSchema.
get_tableReturns full detail of a table. Throws if not found/accessible.
get_scheduleReturns full detail of a schedule. Throws if not found/accessible.