Amazon Q

Provides a MySQL MCP server to query AWS RDS MySQL databases via natural language with Amazon Q CLI.

python

GitHub Stars

python

Language

4 months ago

First Indexed

3 weeks ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "dcs5star-aws-rds-mysql-mcp-server-amazonq-cli": {
      "command": "/absolute/path/to/your/venv-mcp/bin/python3",
      "args": [
        "/absolute/path/to/your/fastmcp_server.py"
      ],
      "env": {
        "RDS_DB": "your-database-name",
        "RDS_HOST": "your-mysql-host.amazonaws.com",
        "RDS_PASS": "your-password",
        "RDS_PORT": "3306",
        "RDS_USER": "your-username",
        "AWS_REGION": "us-east-1",
        "BEDROCK_MODEL_ID": "anthropic.claude-3-haiku-20240307-v1:0"
      }
    }
  }
}

You set up a MySQL MCP server that you can control from the Amazon Q CLI, enabling natural language interactions with your AWS RDS MySQL database. This MCP server runs a local FastMCP service that translates conversational queries into safe, structured SQL operations, so you can manage data without writing raw SQL language.

How to use

You interact with the MCP server through the Amazon Q CLI. Start a chat session and issue natural language requests like asking to show all users, describe a table, insert new records, or update existing data. The MCP layer handles query translation, enforces security features such as input validation, and applies operation restrictions to prevent dangerous actions. Use it to perform typical data access patterns, schema inspection, and data manipulation via conversational prompts.

Practical usage patterns you can accomplish include:

How to install

Prerequisites you need before installation:

Python 3.8 or higher
Amazon Q CLI installed and configured
AWS CLI configured with appropriate permissions
An AWS RDS MySQL instance or local MySQL server

Step-by-step setup commands you will run:

Additional sections

Configuration overview: You create a global MCP configuration to enable system-wide access to the MySQL MCP server. The MCP server is defined with a stdio entry, which specifies the local Python interpreter within your virtual environment and the script that runs the server.

Security considerations include input validation to block SQL injection attempts, operation restrictions that prevent destructive commands (such as DROP or TRUNCATE), a 120-second connection timeout, secure credential handling through environment files, and graceful error handling that avoids leaking sensitive information.

Usage examples show natural language interactions for common database tasks, including selecting, inserting, updating, deleting, creating tables, and describing table structures.

Troubleshooting tips cover common problems like MCP server not found, database connection failures, and permission issues. Use direct commands to test the MCP server, verify environment variables, and inspect MCP configuration with the CLI.

Configuration notes

Global MCP setup lets you run commands from any directory while keeping a persistent configuration. You place the MCP configuration file at a standard path, and the CLI reads it to locate and launch the local server process.

Notes on maintenance and future improvements

You can extend functionality by adding more tools or supporting multiple databases, enhance security with role-based access control, and set up monitoring and automated deployment processes for team environments.

Built by

VeilStrat

AI signals for GTM teams