AWS Athena
Integrates with AWS SDK to execute SQL queries against Athena databases, enabling large-scale data a...
Prepare an S3 Bucket for Athena Results
- Log in to your AWS Management Console.
- Open the S3 service at https://console.aws.amazon.com/s3/.
- Create a new bucket (or use an existing one) to store Athena query results.
- Take note of the bucket name. Example:
your-bucket.
Obtain AWS Access Keys
- Open the AWS Management Console.
- Go to "IAM" (Identity and Access Management) at https://console.aws.amazon.com/iam/.
- In the left sidebar, click "Users" and select your user.
- Go to the "Security credentials" tab.
- Under "Access keys," click "Create access key."
- Copy and save the
AWS_ACCESS_KEY_IDandAWS_SECRET_ACCESS_KEY. (You will only see the secret once!)
Optional: AWS Session Token (if using temporary credentials)
- If your credentials are temporary (such as when using MFA or a federated login), obtain the
AWS_SESSION_TOKENfrom your authentication process.
- If your credentials are temporary (such as when using MFA or a federated login), obtain the
Get Your AWS Region
- Identify the region where your Athena and S3 resources are located (e.g.,
us-east-1).
- Identify the region where your Athena and S3 resources are located (e.g.,
Get Your Athena Workgroup (Optional)
- If you use a specific Athena workgroup, find its name in the Athena console at https://console.aws.amazon.com/athena/.
Fill In the FastMCP Connection Interface
- Click the “Install Now” button for @lishenxydlgzs/aws-athena-mcp in FastMCP.
- In the connection interface, fill out the following values:
OUTPUT_S3_PATH: The URL of your bucket, e.g.,s3://your-bucket/athena-results/AWS_REGION(optional): The region code, e.g.,us-east-1.AWS_PROFILE(optional): Leave blank unless using a named AWS CLI profile.AWS_ACCESS_KEY_ID: Your AWS access key ID.AWS_SECRET_ACCESS_KEY: Your AWS secret access key.AWS_SESSION_TOKEN(optional): Only if your credentials require it.ATHENA_WORKGROUP(optional): The name of your Athena workgroup.- Leave other optional fields at their default values if you are unsure.
Save and Test
- Save the configuration and, if prompted, test the connection to ensure the credentials and permissions are working correctly.
Quick Start
Choose Connection Type for
Authentication Required
Please sign in to use FastMCP hosted connections
Configure Environment Variables for
Please provide values for the following environment variables:
started!
The MCP server should open in . If it doesn't open automatically, please check that you have the application installed.
Copy and run this command in your terminal:
Make sure Gemini CLI is installed:
Visit Gemini CLI documentation for installation instructions.
Make sure Claude Code is installed:
Visit Claude Code documentation for installation instructions.
Installation Steps:
Configuration
Installation Failed
More for Database
View All →Supabase MCP Server
Connect Supabase projects directly with AI assistants using the Model Context Protocol (MCP). This server standardizes communication between Large Language Models and Supabase, enabling AI to manage tables, query data, and interact with project features like edge functions, storage, and branching. Customize access with read-only or project-scoped modes and select specific tool groups to fit your needs. Integrated tools cover account management, documentation search, database operations, debugging, and more, empowering AI to assist with development, monitoring, and deployment tasks in your Supabase environment efficiently and securely.
ClickHouse
Unlock powerful analytics with the ClickHouse MCP Server—seamlessly run, explore, and manage SQL queries across ClickHouse clusters or with chDB’s embedded OLAP engine. This server offers easy database and table listing, safe query execution, and flexible access to data from files, URLs, or databases. Built-in health checks ensure reliability, while support for both ClickHouse and chDB enables robust data workflows for any project.
Postgres MCP Pro
Boost your Postgres database performance with Postgres MCP Pro, an AI-driven MCP server offering advanced index tuning, detailed explain plans, and comprehensive health checks. It combines proven optimization algorithms with schema intelligence for safe, context-aware SQL execution. Whether analyzing slow queries or recommending optimal indexes, Postgres MCP Pro empowers developers to improve efficiency and maintain database integrity. Designed for both development and production, it supports flexible transport options and robust access controls, making database management smarter, safer, and easier. Experience deterministic performance insights alongside AI assistance to keep your Postgres running at its best.
More for Cloud Platforms
View All →Salesforce
Unlock powerful Salesforce org management with the Salesforce DX MCP Server, designed for seamless interaction between large language models and Salesforce environments. This developer preview offers secure, direct access to Salesforce resources without exposing secrets, using TypeScript libraries and granular org allowlisting. Its modular toolsets cover org administration, data queries, user permissions, metadata deployment, and testing. Easily extendable and compatible with various clients like VS Code, Cursor, and more, it empowers developers to perform complex tasks with natural language commands while maintaining robust security. The MCP Server streamlines Salesforce DX workflows through an efficient, secure, and flexible protocol.
Netlify
Control your Netlify projects effortlessly using natural language through AI agents with Netlify MCP Server. This server follows the Model Context Protocol to enable code agents to create, deploy, and manage sites, configure access controls, handle environment variables, and more—all via simple prompts. It acts as a bridge between AI clients and Netlify’s API and CLI, empowering seamless automation and resource management. Whether retrieving team data or managing forms and extensions, Netlify MCP Server streamlines your workflow by integrating powerful AI-driven project control in an accessible, standardized way.
Azure All
Supercharge AI agents with seamless access to Azure services using Azure MCP Server. This project enables powerful automation and management of Azure resources with tools for databases, storage, monitoring, security, and best practices. Easily interact with services like Cosmos DB, SQL, Key Vault, Service Bus, and more—all within compatible AI platforms. Azure MCP Server is in Public Preview and rapidly evolving, making it a versatile solution for both developers and enterprise environments looking to integrate Azure functionality.
Tencent EdgeOne Pages
Remote
Effortlessly publish HTML, folders, or zip files with instant public URLs using EdgeOne Pages MCP. This service streamlines rapid deployment of your static content via EdgeOne Pages, leveraging serverless edge functions and key-value storage for fast, reliable delivery. Users can quickly deploy content and receive shareable links, making it ideal for web developers and teams needing easy, scalable web hosting.
