rds-mcp

neoai-agent/rds-mcp

3.4

If you are the rightful owner of rds-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

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

The RDS MCP Server is a specialized tool designed to facilitate the monitoring and analysis of Amazon RDS instances, specifically for MySQL and PostgreSQL databases. It provides a seamless way to gather and interpret data from RDS instances, offering insights into performance metrics, slow query logs, and other critical information. The server supports multiple authentication methods, including IAM roles for AWS infrastructure and AWS access keys for local development, ensuring flexibility and security. By leveraging the power of the Model Context Protocol, the RDS MCP Server enables users to efficiently manage their database environments, optimize performance, and troubleshoot issues with ease. Its integration with OpenAI's API further enhances its capabilities, allowing for advanced data analysis and interpretation.

Features

  • Supports multiple AWS authentication methods, including IAM roles and access keys.
  • Provides tools for retrieving RDS instance details and performance metrics.
  • Enables analysis of slow query logs for MySQL and PostgreSQL databases.
  • Integrates with OpenAI's API for enhanced data analysis.
  • Offers a flexible setup for both AWS infrastructure and local development environments.

Tools

  1. get_db_info

    Retrieve RDS instance details.

  2. get_database_metrics

    Fetch database metrics for a specified time range.

  3. get_database_queries

    Retrieve slow queries from the database.

  4. get_instance_performance_metrics

    Get performance metrics for the RDS instance.