mcp_powerdrill_get_dataset_overview
Retrieve key details and summary insights for a specified dataset on the Powerdrill MCP Server, enabling efficient data analysis and informed decision-making.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| datasetId | Yes | The ID of the dataset to get overview information for |
Implementation Reference
- src/index.ts:133-184 (registration)Registration of the MCP tool 'mcp_powerdrill_get_dataset_overview', including inline Zod schema and the main handler function that uses PowerdrillClient to fetch and format the dataset overview.server.tool( 'mcp_powerdrill_get_dataset_overview', { datasetId: z.string().describe('The ID of the dataset to get overview information for') }, async (args, extra) => { try { const { datasetId } = args; // Initialize Powerdrill client const client = new (await import('./utils/powerdrillClient.js')).PowerdrillClient(); // Fetch dataset overview const response = await client.getDatasetOverview(datasetId); // Check if response is valid if (response.code !== 0 || !response.data) { throw new Error(`Invalid API response: ${JSON.stringify(response)}`); } // Format the response as MCP content return { content: [ { type: "text", text: JSON.stringify({ id: response.data.id, name: response.data.name, description: response.data.description, summary: response.data.summary, exploration_questions: response.data.exploration_questions, keywords: response.data.keywords }) } ] }; } catch (error: any) { console.error(`Error getting dataset overview: ${error.message}`); // Return error response return { content: [ { type: "text", text: `Error getting dataset overview: ${error.message}` } ], isError: true }; } } );
- src/index.ts:138-183 (handler)The inline handler function for the tool, which extracts datasetId, initializes the client, calls getDatasetOverview, validates response, and returns formatted MCP content or error.async (args, extra) => { try { const { datasetId } = args; // Initialize Powerdrill client const client = new (await import('./utils/powerdrillClient.js')).PowerdrillClient(); // Fetch dataset overview const response = await client.getDatasetOverview(datasetId); // Check if response is valid if (response.code !== 0 || !response.data) { throw new Error(`Invalid API response: ${JSON.stringify(response)}`); } // Format the response as MCP content return { content: [ { type: "text", text: JSON.stringify({ id: response.data.id, name: response.data.name, description: response.data.description, summary: response.data.summary, exploration_questions: response.data.exploration_questions, keywords: response.data.keywords }) } ] }; } catch (error: any) { console.error(`Error getting dataset overview: ${error.message}`); // Return error response return { content: [ { type: "text", text: `Error getting dataset overview: ${error.message}` } ], isError: true }; } }
- src/index.ts:135-137 (schema)Zod input schema defining the required 'datasetId' parameter.{ datasetId: z.string().describe('The ID of the dataset to get overview information for') },
- Helper method in PowerdrillClient class that makes the API GET request to retrieve dataset overview data.async getDatasetOverview(datasetId: string) { try { const response = await this.client.get(`/datasets/${datasetId}/overview?user_id=${this.config.userId}`); return response.data; } catch (error: any) { console.error(`Error retrieving dataset overview for ${datasetId}:`, error.message); throw error; } }