Qlik MCP Server

1[![MseeP.ai Security Assessment Badge](https://mseep.net/pr/jwaxman19-qlik-mcp-badge.png)](https://mseep.ai/app/jwaxman19-qlik-mcp)
2 
3# Qlik MCP Server
4 
5MCP Server for the Qlik Cloud API, enabling Claude to interact with Qlik applications and extract data from visualizations.
6 
7## Tools
8 
9### qlik_get_apps
10List all Qlik applications available in the workspace
11- Optional inputs:
12  - `limit` (number, default: 100): Maximum number of apps to return
13  - `offset` (string): Pagination offset for next page
14- Returns: List of applications with their IDs and information
15 
16### qlik_get_app_sheets
17Get all sheets in a Qlik application
18- Optional inputs:
19  - `app_id` (string): The ID of the Qlik application (defaults to QLIK_APP_ID env variable)
20- Returns: List of sheets with their IDs, titles, and metadata
21 
22### qlik_get_sheet_charts
23Get all charts in a specific sheet
24- Required inputs:
25  - `sheet_id` (string): The ID of the sheet to get charts from
26- Optional inputs:
27  - `app_id` (string): The ID of the Qlik application (defaults to QLIK_APP_ID env variable)
28- Returns: List of charts with their IDs, types, and positions
29 
30### qlik_get_chart_data
31Get data from a specific chart
32- Required inputs:
33  - `sheet_id` (string): The ID of the sheet containing the chart
34  - `chart_id` (string): The ID of the chart to get data from
35- Optional inputs:
36  - `app_id` (string): The ID of the Qlik application (defaults to QLIK_APP_ID env variable)
37  - `max_rows` (number, default: 10000): Maximum total rows to retrieve
38  - `page_size` (number, default: 1000): Number of rows per request
39  - `include_metadata` (boolean, default: true): Include chart metadata in response
40- Returns: Chart data with headers, rows, and optional metadata
41 
42## Setup
43 
44### Create a Qlik Cloud API Key:
451. Log in to your Qlik Cloud tenant
462. Navigate to Settings > API keys
473. Create a new API key with appropriate access
484. Save the API key securely
49 
50### Configure Environment:
51Create a `.env` file with your Qlik Cloud credentials (see `.env.example` for a template):
52```env
53QLIK_API_KEY=your_api_key_here
54QLIK_BASE_URL=your_tenant_url
55QLIK_APP_ID=your_default_app_id
56MAX_ROWS_PER_REQUEST=1000
57MAX_TOTAL_ROWS=10000
58REQUEST_DELAY_MS=100
59MAX_RETRIES=3
60RETRY_DELAY_MS=1000
61```
62 
63## Usage with Docker
64 
65You can also run this MCP server using Docker:
66 
67```bash
68# Build the Docker image
69docker build -t qlik-mcp .
70 
71# Run the container
72# Make sure to create a .env file first (copy from .env.example)
73docker run --env-file .env qlik-mcp
74```
75 
76## Usage with Claude Desktop
77 
78Add the following to your `claude_desktop_config.json`:
79 
80### Using Deno (Recommended)
81```json
82{
83  "mcpServers": {
84    "qlik": {
85      "command": "/path/to/deno",
86      "args": ["run", "--allow-all", "--env-file=.env", "src/index.ts"],
87      "cwd": "/path/to/qlik-mcp"
88    }
89  }
90}
91```
92 
93### Using Node.js
94```json
95{
96  "mcpServers": {
97    "qlik": {
98      "command": "npx",
99      "args": ["tsx", "src/index.ts"],
100      "env": {
101        "QLIK_API_KEY": "your_api_key_here",
102        "QLIK_BASE_URL": "your_tenant_url",
103        "QLIK_APP_ID": "your_default_app_id"
104      },
105      "cwd": "/path/to/qlik-mcp"
106    }
107  }
108}
109```
110 
111## Usage with Cursor
112 
1131. Open Cursor settings
1142. Navigate to the Claude configuration section
1153. Add a new MCP configuration:
116 
117```json
118{
119  "name": "Qlik Cloud",
120  "command": "/path/to/deno",
121  "args": ["run", "--allow-all", "--env-file=.env", "src/index.ts"],
122  "cwd": "/path/to/qlik-mcp"
123}
124```
125 
126Replace `/path/to/deno` with your Deno installation path (usually `~/.deno/bin/deno` on Unix systems) and `/path/to/qlik-mcp` with the absolute path to your cloned repository.
127 
128## Troubleshooting
129 
130If you encounter errors, verify that:
131- Your API key has the necessary permissions
132- The tenant URL is correct and accessible
133- The app ID exists and is accessible
134- Environment variables are properly set
135- Rate limiting settings are appropriate for your tenant
136 
137Common issues:
138- `401 Unauthorized`: Check your API key
139- `403 Forbidden`: Verify API key permissions
140- `429 Too Many Requests`: Adjust rate limiting settings
141- `404 Not Found`: Verify app and sheet IDs
142 
143## Development
144 
145### Prerequisites
146- [Deno](https://deno.land/#installation)
147- [Node.js](https://nodejs.org/) (optional, for IDE support)
148 
149### Local Setup
150```bash
151# Clone repository
152git clone https://github.com/jwaxman19/qlik-mcp.git
153cd qlik-mcp
154 
155# Install dependencies (for IDE support)
156npm install
157 
158# Run server
159deno task dev
160```
161 
162## License
163 
164This MCP server is licensed under the MIT License. This means you are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License. For more details, please see the LICENSE file in the project repository.
165 
166### 📊 <a name="data-platforms"></a>Data Platforms
167 
168Data Platforms for data integration, transformation and pipeline orchestration. 
169 
170- [JordiNei/mcp-databricks-server](https://github.com/JordiNeil/mcp-databricks-server) - Connect to Databricks API, allowing LLMs to run SQL queries, list jobs, and get job status.
171- [jwaxman19/qlik-mcp](https://github.com/jwaxman19/qlik-mcp) 📇 ☁️ - MCP Server for Qlik Cloud API that enables querying applications, sheets, and extracting data from visualizations with comprehensive authentication and rate limiting support.
172- [keboola/keboola-mcp-server](https://github.com/keboola/keboola-mcp-server) - interact with Keboola Connection Data Platform. This server provides tools for listing and accessing data from Keboola Storage API.