Mcpseverdbs

🚀 Database MCP Server Setup Guide

This guide explains how to set up a Model Context Protocol (MCP) server for various AWS database services to use with Amazon Bedrock models.

📦 Supported Databases

• Amazon RDS MySQL: SQL database service
• Amazon DocumentDB: MongoDB-compatible document database
• Amazon DynamoDB: NoSQL key-value and document database
• Amazon Redshift: Data warehousing service
• Amazon ElastiCache Redis: In-memory data store

🛠️ Prerequisites

Before setting up the MCP server, ensure the following:

1. You have access to AWS services with appropriate permissions.
2. The database instance is created and accessible.
3. Node.js and npm are installed.
4. Python 3 is installed.
5. Git is installed.
6. Docker is installed (optional, for containerizing the MCP server).

You can use the following command to check and install the prerequisites:

chmod +x check_prerequisites.sh
./check_prerequisites.sh

🚧 Setup Process

1. Configure Database Credentials

Create a credentials file containing database connection information:

cp db_credentials_template.sh set_db_credentials.sh

Edit set_db_credentials.sh and fill in the actual database credentials.

2. Validate Database Connection

Before setting up the MCP server, verify that the database connection is working properly:

chmod +x validate_db_connections.sh
source ./set_db_credentials.sh
./validate_db_connections.sh

This script will test the connections to all configured databases and report any issues.

3. Set Up the MCP Server

Run the security setup script to install and configure all database MCP servers:

chmod +x setup_db_mcp_servers_secure.sh
./setup_db_mcp_servers_secure.sh

This script will:

• Clone the required repositories.
• Build the necessary components.
• Update the MCP configuration.
• Restart the MCP service.

4. Test the MCP Server

After the setup is complete, test whether all MCP servers are running properly:

chmod +x test_mcp_servers.sh
./test_mcp_servers.sh

💻 Usage Examples

Once the MCP servers are set up, you can use them with Amazon Bedrock models through the MCP framework. Here are some example prompts:

MySQL

Show all tables in the MySQL database.
Run a query to select the first 10 rows from the customers table.
What are the column names and data types of the customer_orders table?

MongoDB/DocumentDB

List all collections in the MongoDB database.
Find documents in the users collection where the age is greater than 30.
Show the schema of the products collection.

DynamoDB

List all tables in DynamoDB.
Get the item from the orders table where the customer ID is 'CUST001'.
What are the primary key attributes of the products?

Redshift

Show all tables in the Redshift database.
Run a query to analyze sales data by region.
What is the schema of the customer_transactions table?

Redis

Get all keys in Redis.
What is the value of the key 'session:user123'?
Show all members of the set 'active_users'.

⚠️ Security Considerations

• Never commit credentials to version control.
• Consider using AWS Secrets Manager or Parameter Store for credential management.
• Use IAM roles instead of access keys whenever possible.
• Implement a least-privilege access policy to ensure appropriate access for database users.
• Ensure the secure configuration of the MCP service and related resources.

🐞 Troubleshooting

If you encounter issues, check the following:

1. Whether the database instance is running and accessible.
2. Whether the credentials are configured correctly.
3. Whether all necessary software has been installed according to the prerequisites.
4. Whether the script commands have been executed correctly.

For further assistance, refer to the AWS documentation or contact the support team.

📚 Additional Resources

• AWS Official Documentation
• MCP Project Homepage
• Amazon Bedrock Developer Guide

Thank you for using the MCP server setup guide! If you have any feedback or suggestions, please feel free to contact us.