{"_id":"@yahia_mmr/aws-athena-mcp-gdr","name":"@yahia_mmr/aws-athena-mcp-gdr","dist-tags":{"latest":"1.0.0"},"versions":{"1.0.0":{"name":"@yahia_mmr/aws-athena-mcp-gdr","version":"1.0.0","description":"Model Context Protocol (MCP) server for running AWS Athena queries","type":"module","main":"build/index.js","types":"build/index.d.ts","bin":{"aws-athena-mcp-GDR":"build/index.js"},"scripts":{"build":"tsc","start":"node build/index.js","dev":"tsc -w","prepublishOnly":"npm run build"},"keywords":["mcp","aws","athena","modelcontextprotocol","llm","ai"],"author":{"name":"Shen Li"},"license":"MIT","repository":{"type":"git","url":"git+https://github.com/M00191_BPI/aws-athena-mcp-GDR.git"},"engines":{"node":">=16"},"dependencies":{"@aws-sdk/client-athena":"^3.826.0","@aws-sdk/credential-provider-node":"^3.826.0","@modelcontextprotocol/sdk":"^1.6.0"},"devDependencies":{"@types/node":"^20.19.0","typescript":"^5.0.0"},"bugs":{"url":"https://github.com/M00191_BPI/aws-athena-mcp-GDR/issues"},"homepage":"https://github.com/M00191_BPI/aws-athena-mcp-GDR#readme","_id":"@yahia_mmr/aws-athena-mcp-gdr@1.0.0","gitHead":"c2a69f7c28328629269ef79e61f83285f0182fd4","_nodeVersion":"22.14.0","_npmVersion":"10.9.2","dist":{"integrity":"sha512-PrAXGfU4HqGCBxxL8Ha2IGkrkSuXpzrf2s1+A31ZGbwzqaJory51iHWPktfScTfXEGIziztRM2+eeUVcelYEfg==","shasum":"000611bc7646a1d9f902d51034edb4145d76fa69","tarball":"https://registry.npmjs.org/@yahia_mmr/aws-athena-mcp-gdr/-/aws-athena-mcp-gdr-1.0.0.tgz","fileCount":9,"unpackedSize":28731,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIAgF86T3OGysiI2Al4E6Wv1DP4kJT/tjQVgfTgURjAbgAiEA4Ls5k0KBODQk/fTALZyrQsDaHjPz3zrcsw8jAnSrcLM="}]},"_npmUser":{"name":"yahia_mmr","email":"yahia.conseil@gmail.com"},"directories":{},"maintainers":[{"name":"yahia_mmr","email":"yahia.conseil@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/aws-athena-mcp-gdr_1.0.0_1749310510812_0.30630753089124596"},"_hasShrinkwrap":false}},"time":{"created":"2025-06-07T15:35:10.745Z","1.0.0":"2025-06-07T15:35:11.005Z","modified":"2025-06-07T15:35:11.288Z"},"maintainers":[{"name":"yahia_mmr","email":"yahia.conseil@gmail.com"}],"description":"Model Context Protocol (MCP) server for running AWS Athena queries","homepage":"https://github.com/M00191_BPI/aws-athena-mcp-GDR#readme","keywords":["mcp","aws","athena","modelcontextprotocol","llm","ai"],"repository":{"type":"git","url":"git+https://github.com/M00191_BPI/aws-athena-mcp-GDR.git"},"author":{"name":"Shen Li"},"bugs":{"url":"https://github.com/M00191_BPI/aws-athena-mcp-GDR/issues"},"license":"MIT","readme":"# aws-athena-mcp-rcg\r\n\r\nA Model Context Protocol (MCP) server for running AWS Athena queries. This server enables AI assistants to execute SQL queries against your AWS Athena databases and retrieve results.\r\n\r\n3. The server provides the following tools:\r\n\r\n- `run_query`: Execute a SQL query using AWS Athena\r\n  - Parameters:\r\n    - database: The Athena database to query\r\n    - query: SQL query to execute\r\n    - maxRows: Maximum number of rows to return (default: 1000, max: 10000)\r\n  - Returns:\r\n    - If query completes within timeout: Full query results\r\n    - If timeout reached: Only the queryExecutionId for later retrieval\r\n\r\n- `get_status`: Check the status of a query execution\r\n  - Parameters:\r\n    - queryExecutionId: The ID returned from run_query\r\n  - Returns:\r\n    - state: Query state (QUEUED, RUNNING, SUCCEEDED, FAILED, or CANCELLED)\r\n    - stateChangeReason: Reason for state change (if any)\r\n    - submissionDateTime: When the query was submitted\r\n    - completionDateTime: When the query completed (if finished)\r\n    - statistics: Query execution statistics (if available)\r\n\r\n- `get_result`: Retrieve results for a completed query\r\n  - Parameters:\r\n    - queryExecutionId: The ID returned from run_query\r\n    - maxRows: Maximum number of rows to return (default: 1000, max: 10000)\r\n  - Returns:\r\n    - Full query results if the query has completed successfully\r\n    - Error if query failed or is still running\r\n\r\n- `list_saved_queries`: List all saved (named) queries in Athena.\r\n\r\n- Returns:\r\n  - An array of saved queries with `id`, `name`, and optional `description`\r\n  - Queries are returned from the configured `ATHENA_WORKGROUP` and `AWS_REGION`\r\n\r\n- run_saved_query: Run a previously saved query by its ID.\r\n- Parameters:\r\n  - `namedQueryId`: ID of the saved query\r\n  - `databaseOverride`: Optional override of the saved query's default database\r\n  - `maxRows`: Maximum number of rows to return (default: 1000)\r\n  - `timeoutMs`: Timeout in milliseconds (default: 60000)\r\n- Returns:\r\n  - Same behavior as `run_query`: full results or execution ID\r\n\r\n---\r\n\r\n## Usage Examples\r\n\r\n### Show All Databases\r\nMessage to AI Assistant:\r\n```List all databases in Athena```\r\n\r\nMCP parameter:\r\n```json\r\n{\r\n  \"database\": \"default\",\r\n  \"query\": \"SHOW DATABASES\"\r\n}\r\n```\r\n\r\n### List Tables in a Database\r\nMessage to AI Assistant:\r\n```Show me all tables in the default database```\r\n\r\nMCP parameter:\r\n```json\r\n{\r\n  \"database\": \"default\",\r\n  \"query\": \"SHOW TABLES\"\r\n}\r\n```\r\n\r\n### Get Table Schema\r\nMessage to AI Assistant:\r\n```What's the schema of the asin_sitebestimg table?```\r\n\r\nMCP parameter:\r\n```json\r\n{\r\n  \"database\": \"default\",\r\n  \"query\": \"DESCRIBE default.asin_sitebestimg\"\r\n}\r\n```\r\n\r\n### Table Rows Preview\r\nMessage to AI Assistant:\r\n```Show some rows from my_database.mytable```\r\n\r\nMCP parameter:\r\n```json\r\n{\r\n  \"database\": \"my_database\",\r\n  \"query\": \"SELECT * FROM my_table LIMIT 10\",\r\n  \"maxRows\": 10\r\n}\r\n```\r\n\r\n### Advanced Query with Filtering and Aggregation\r\nMessage to AI Assistant:\r\n```Find the average price by category for in-stock products```\r\n\r\nMCP parameter:\r\n```json\r\n{\r\n  \"database\": \"my_database\",\r\n  \"query\": \"SELECT category, COUNT(*) as count, AVG(price) as avg_price FROM products WHERE in_stock = true GROUP BY category ORDER BY count DESC\",\r\n  \"maxRows\": 100\r\n}\r\n```\r\n\r\n### Checking Query Status\r\n```json\r\n{\r\n  \"queryExecutionId\": \"12345-67890-abcdef\"\r\n}\r\n```\r\n\r\n### Getting Results for a Completed Query\r\n```json\r\n{\r\n  \"queryExecutionId\": \"12345-67890-abcdef\",\r\n  \"maxRows\": 10\r\n}\r\n```\r\n\r\n### Listing Saved Queries\r\n```json\r\n{\r\n  \"name\": \"list_saved_queries\",\r\n  \"arguments\": {}\r\n}\r\n```\r\n\r\n### Running a Saved Query\r\n```json\r\n{\r\n  \"name\": \"run_saved_query\",\r\n  \"arguments\": {\r\n    \"namedQueryId\": \"abcd-1234-efgh-5678\",\r\n    \"maxRows\": 100\r\n  }\r\n}\r\n```\r\n\r\n---\r\n\r\n## Requirements\r\n\r\n- Node.js >= 16\r\n- AWS credentials with appropriate Athena and S3 permissions\r\n- S3 bucket for query results\r\n- Named queries (optional) must exist in the specified `ATHENA_WORKGROUP` and `AWS_REGION`\r\n\r\n---","readmeFilename":"README.md","_rev":"1-4f25b197870cbd4b4e9a2d0067cbf229"}