This MCP server provides a read-only interface to Amazon Athena data via the MCP protocol. It wraps the CData JDBC Driver for Amazon Athena and exposes data sources as a set of MCP tools that can be invoked by an LLM or an MCP client. The built-in tools allow you to discover available tables, inspect columns, and run read-only SQL queries against your Athena data source. Typical usage involves configuring Claude Desktop (or another MCP client) to connect to the server, then asking natural language questions like: which tables exist, what are the important columns in a table, or retrieve specific records from a table using a SELECT query. The server exposes tools named in the pattern {servername}_get_tables, {servername}_get_columns, and {servername}_run_query (for example amazon_athena_get_tables, amazon_athena_get_columns, amazon_athena_run_query). The MCP server runs locally on the machine and uses standard input/output streams to communicate with clients, making it suitable for on-device experiments and private data processing.

Prerequisites:

• Java (JDK 8 or newer)
• Maven (for building the MCP server JAR)
• Access to the CData JDBC Driver for Amazon Athena and a valid license

Installation steps:

1. Clone the repository and build the MCP server: git clone https://github.com/cdatasoftware/amazon-athena-mcp-server-by-cdata.git cd amazon-athena-mcp-server-by-cdata mvn clean install

   This creates CDataMCP-jar-with-dependencies.jar in the target/ directory

2. Download and install the CData JDBC Driver for Amazon Athena from: https://www.cdata.com/drivers/athena/download/jdbc Follow the vendor instructions to license the driver (typically in the lib folder, run java -jar cdata.jdbc.amazonathena.jar --license).
3. Create a .prp file (e.g. amazon-athena.prp) with the JDBC connection details, including Prefix, ServerName, ServerVersion, DriverPath, DriverClass, JdbcUrl, and Tables. Example content is provided in the README: Prefix=amazonathena ServerName=CDataAmazonAthena ServerVersion=1.0 DriverPath=PATH\TO\cdata.jdbc.amazonathena.jar DriverClass=cdata.jdbc.amazonathena.AmazonAthenaDriver JdbcUrl=jdbc:amazonathena:InitiateOAuth=GETANDREFRESH; Tables=
4. Run the MCP server: java -jar CDataMCP-jar-with-dependencies.jar /PATH/TO/amazon-athena.prp Note: The server uses stdio and is intended to be run on the same machine as the MCP client.

Tips and notes:

• This repository provides a read-only MCP server. If you need full read/write/update/delete capabilities, use the full MCP server variant described in CData documentation.
• Ensure your JDBC connection string (JdbcUrl) is correctly configured and tested with the CData JDBC Driver Utility before wiring it into the MCP server.
• The server runs with stdio, so clients must run on the same machine or adapt to an appropriate IPC mechanism.
• If Claude Desktop or your MCP client cannot see the server, fully quit and re-launch the client after adding the new MCP server configuration.
• For security, avoid exposing the local MCP server to untrusted networks without proper access controls.