MCP.so
Sign In
A

Amazon Athena MCP Server by CData

@CDataSoftware

Repository

About Amazon Athena MCP Server by CData

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free [CData MCP Server for Amazon Athena (beta)](https://www.cdata.com/download/download.aspx?sku=FKZK-V&type=beta).

#amazon-athena#mcp-server#cdata

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\amazon-athena.prp"
      ]
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Amazon Athena MCP Server by CData?

This read-only MCP server allows LLMs like Claude Desktop to query live Amazon Athena data using natural language, no SQL required. It wraps the CData JDBC Driver for Amazon Athena, exposing the data as relational SQL models through a simple MCP interface.

How to use Amazon Athena MCP Server by CData?

Clone the repository and build with mvn clean install. Download and license the CData JDBC Driver for Amazon Athena. Use the driver’s Connection String utility to generate a JDBC URL, then create a .prp file with properties like Prefix, ServerName, DriverPath, and JdbcUrl. Add the server to your claude_desktop_config.json using the generated jar and .prp file. Fully quit and reopen Claude Desktop for the server to appear.

Key features of Amazon Athena MCP Server by CData

  • Read-only MCP server for Amazon Athena data.
  • Uses stdio transport (client and server must run on same machine).
  • Exposes tools: get_tables, get_columns, and run_query (SQL SELECT).
  • Requires CData JDBC Driver for Amazon Athena (licensed separately).
  • Built with Java and Maven, outputs a single JAR file.
  • Licensed under MIT.

Use cases of Amazon Athena MCP Server by CData

  • Ask natural‑language questions about Amazon Athena data (e.g., “How many open tickets do I have?”).
  • Retrieve live table and column metadata from connected Athena sources.
  • Execute custom SQL SELECT queries through an LLM interface.
  • Integrate Amazon Athena insights directly into Claude Desktop conversations.

FAQ from Amazon Athena MCP Server by CData

What does this server do?

It allows LLMs to query Amazon Athena data in real time using natural language, without writing SQL. The server is read‑only; for full CRUD capabilities, use CData’s beta MCP Server for Amazon Athena.

What are the prerequisites?

Java (to run the JAR), Maven (to build), the CData JDBC Driver for Amazon Athena, and a valid license for that driver (a trial is available). The driver must be installed and licensed on the same machine as the MCP server.

How do I connect to Amazon Athena?

Use the driver’s Connection String utility to build a JDBC URL (e.g., jdbc:amazonathena:InitiateOAuth=GETANDREFRESH) and save it in a .prp file. Configure the server in Claude Desktop using the path to the JAR and that .prp file.

Why is the server not showing up in Claude Desktop?

Ensure you have fully quit Claude Desktop (use Task Manager on Windows, Activity Monitor on Mac) and reopened it. Also verify that the claude_desktop_config.json is in the correct directory and contains the proper paths.

Is data stored or cached?

No. The server queries Amazon Athena live via the JDBC driver each time a tool is invoked. No data is persisted by the server.

Frequently asked questions

What does this server do?

It allows LLMs to query Amazon Athena data in real time using natural language, without writing SQL. The server is read‑only; for full CRUD capabilities, use CData’s beta MCP Server for Amazon Athena.

What are the prerequisites?

Java (to run the JAR), Maven (to build), the CData JDBC Driver for Amazon Athena, and a valid license for that driver (a trial is available). The driver must be installed and licensed on the same machine as the MCP server.

How do I connect to Amazon Athena?

Use the driver’s Connection String utility to build a JDBC URL (e.g., `jdbc:amazonathena:InitiateOAuth=GETANDREFRESH`) and save it in a `.prp` file. Configure the server in Claude Desktop using the path to the JAR and that `.prp` file.

Why is the server not showing up in Claude Desktop?

Ensure you have fully quit Claude Desktop (use Task Manager on Windows, Activity Monitor on Mac) and reopened it. Also verify that the `claude_desktop_config.json` is in the correct directory and contains the proper paths.

Is data stored or cached?

No. The server queries Amazon Athena live via the JDBC driver each time a tool is invoked. No data is persisted by the server.

Comments

Basic information

Category

Cloud & Infrastructure

Transports

stdio

Author

CDataSoftware

Submitted by

Cameron Leblanc

More Cloud & Infrastructure MCP servers

Supabase MCP Server

supabase-community

Connect Supabase to your AI assistants

2.8K

AWS Model Context Protocol (MCP) Server

alexei-led

A lightweight service that enables AI assistants to execute AWS CLI commands (in safe containerized environment) through the Model Context Protocol (MCP). Bridges Claude, Cursor, and other MCP-aware AI tools with AWS CLI for enhanced cloud infrastructure management.

184

tfmcp: Terraform Model Context Protocol Tool

nwiizo

🌍 Terraform Model Context Protocol (MCP) Tool - An experimental CLI tool that enables AI assistants to manage and operate Terraform environments. Supports reading Terraform configurations, analyzing plans, applying configurations, and managing state with Claude Desktop integrati

370

Nippy

Nippy

Nippy is drag-and-drop hosting (nippy.host) with an MCP server: connect it and your assistant can publish HTML, folders of photos, or file downloads to a live *.nippy.site URL — and keep editing the site in place at the

Aws Kb Retrieval Server

modelcontextprotocol

Model Context Protocol Servers

88.2K