Lightdash MCP Server

Instructions

Implementation Reference

• src/mcp.ts:127-147 (handler)

  Handler function that executes the lightdash_list_projects tool by calling the Lightdash API endpoint '/api/v1/org/projects' and returns the project list as JSON.

  case 'lightdash_list_projects': {
    const { data, error } = await lightdashClient.GET(
      '/api/v1/org/projects',
      {}
    );
    if (error) {
      throw new Error(
        `Lightdash API error: ${error.error.name}, ${
          error.error.message ?? 'no message'
        }`
      );
    }
    return {
      content: [
        {
          type: 'text',
          text: JSON.stringify(data.results, null, 2),
        },
      ],
    };
  }

• src/mcp.ts:49-53 (registration)

  Tool registration in the ListTools response, defining name, description, and input schema.

  {
    name: 'lightdash_list_projects',
    description: 'List all projects in the Lightdash organization',
    inputSchema: zodToJsonSchema(ListProjectsRequestSchema),
  },

• src/schemas.ts:3-4 (schema)

  Zod schema defining the input for lightdash_list_projects tool, which requires no parameters.

  export const ListProjectsRequestSchema = z.object({});