lightdash_mcp
Verified Safeby poddubnyoleg
Overview
This server enables LLMs to programmatically interact with Lightdash for data discovery, query execution, chart creation, and dashboard management.
Installation
python server.pyEnvironment Variables
- LIGHTDASH_TOKEN
- LIGHTDASH_URL
- CF_ACCESS_CLIENT_ID
- CF_ACCESS_CLIENT_SECRET
- LIGHTDASH_PROJECT_UUID
Security Notes
The server uses environment variables for sensitive credentials (Lightdash API Token), which is a good practice. It acts as a wrapper around the Lightdash API, forwarding JSON payloads that can contain SQL fragments (e.g., in `metric_query` for custom dimensions or additional metrics). While this means the Lightdash backend itself must be robust against SQL injection, the MCP server doesn't directly execute arbitrary SQL on its host or introduce new direct code execution vulnerabilities. Error handling for API calls is present. No direct use of `eval` or `exec` on user input was found.
Similar Servers
powerbi-modeling-mcp
Automate Power BI semantic model development and management using AI agents via the MCP protocol.
logfire-mcp
Enables LLMs to retrieve and analyze application telemetry data (OpenTelemetry traces and metrics) from Pydantic Logfire using SQL queries.
powerbi-mcp
Enables AI assistants to interact with Power BI Desktop and Service for querying data, managing models, and performing safe bulk operations through natural language, ensuring enterprise-grade security and preserving report visual integrity during refactoring.
mcp-server-datahub
The DataHub MCP Server enables AI agents to discover, explore lineage, understand usage, and generate SQL queries for data assets within a DataHub ecosystem.