What is Rds Mcp

RDS MCP Server is a Model Context Protocol server designed for monitoring and analyzing Amazon RDS (MySQL, PostgreSQL) instances. It provides functionalities to retrieve instance information, metrics, and slow query logs.

Use cases

The server can be utilized for tracking the health and performance of RDS databases, analyzing slow queries to improve application efficiency, and generating insights based on various database metrics over customizable time ranges.

How to use

To use the RDS MCP Server, authenticate via IAM roles or AWS access keys, and run specific commands to access RDS instance details, database metrics, slow queries, and instance performance metrics, using appropriate function calls on your database instance.

Key features

Key features include support for multiple authentication methods (IAM roles, access keys), tools for obtaining RDS instance details, database metrics, slow query logs, and instance performance metrics.

Where to use

The RDS MCP Server is suitable for development environments, AWS infrastructure management (e.g., EC2, ECS), and any scenario requiring deep monitoring and analysis of Amazon RDS databases.

RDS MCP Server

A Model Context Protocol (MCP) server for monitoring and analyzing Amazon RDS(MySQL, PostgreSQL) instances information, metrics and slowquery logs.

Installation

Install directly from GitHub using pipx:

# Install
pipx install git+https://github.com/yourusername/rds-mcp.git

# Or run without installation
pipx run git+https://github.com/yourusername/rds-mcp.git

Quick Start

Authentication Options

The server supports multiple AWS authentication methods:

Option 1: IAM Roles (Recommended for EC2/ECS)

When running on AWS infrastructure with IAM roles attached, you can omit AWS credentials:

rds-mcp --openai-api-key "YOUR_OPENAI_API_KEY" --region "YOUR_AWS_REGION"

Option 2: AWS Access Keys

For local development or when IAM roles are not available:

rds-mcp --access-key "YOUR_AWS_ACCESS_KEY" --secret-access-key "YOUR_AWS_SECRET_KEY" --region "YOUR_AWS_REGION" --openai-api-key "YOUR_OPENAI_API_KEY"

Option 3: Environment Variables

You can also set AWS credentials via environment variables:

rds-mcp --access-key "YOUR_AWS_ACCESS_KEY" --secret-access-key "YOUR_AWS_SECRET_KEY" --region "YOUR_AWS_REGION" --openai_api_key "YOUR_OPENAI_API_KEY"

Note: When using IAM roles, the server will automatically use the default AWS credential chain, which includes IAM roles, environment variables, and AWS credentials file.

Available Tools

The server provides the following tools for RDS instance management and monitoring:

1. Get RDS instance details:

await get_db_info(
    database_name="your-db-instance",
    region="your-aws-region"
)

2. Get database metrics:

await get_database_metrics(
    database_name="your-db-instance",
    time_range_minutes=30
)

3. Get slow queries:

await get_database_queries(
    database_name="your-db-instance",
    time_range_minutes=30
)

4. Get instance performance metrics:

await get_instance_performance_metrics(
    database_name="your-db-instance",
    time_range_minutes=30
)

Development

For development setup:

git clone https://github.com/yourusername/rds-mcp.git
cd rds-mcp
python -m venv venv
source venv/bin/activate  # On Windows: venv\Scripts\activate
pip install -e ".[dev]"

License

MIT License - See LICENSE file for details