list_saved_queries
Retrieve all saved Athena queries from your AWS account to access and manage previously created SQL queries for data analysis.
Instructions
List all saved (named) Athena queries available in your AWS account.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Implementation Reference
- src/athena.ts:201-223 (handler)Core implementation of list_saved_queries tool: lists Athena named queries using AWS SDK's ListNamedQueriesCommand and BatchGetNamedQueryCommand.async listNamedQueries(): Promise<{ namedQueries: { id: string; name: string; description?: string }[] }> { const listResponse = await this.client.send( new ListNamedQueriesCommand({ ...(this.workGroup && { WorkGroup: this.workGroup }) }) ); if (!listResponse.NamedQueryIds || listResponse.NamedQueryIds.length === 0) { return { namedQueries: [] }; } const batchResponse = await this.client.send( new BatchGetNamedQueryCommand({ NamedQueryIds: listResponse.NamedQueryIds }) ); const namedQueries = (batchResponse.NamedQueries || []).map((query) => ({ id: query.NamedQueryId || "", name: query.Name || "", description: query.Description, })); return { namedQueries }; }
- src/index.ts:252-263 (handler)MCP CallToolRequest handler case for 'list_saved_queries' that invokes AthenaService.listNamedQueries() and returns JSON-formatted response.case "list_saved_queries": { const result = await this.athenaService.listNamedQueries(); return { content: [ { type: "text", text: JSON.stringify(result, null, 2), }, ], }; }
- src/index.ts:136-143 (registration)Tool registration in ListToolsRequestHandler, including name, description, and empty input schema.{ name: "list_saved_queries", description: "List all saved (named) Athena queries available in your AWS account.", inputSchema: { type: "object", properties: {}, }, },