Database MCP Servers Setup Guide

Database MCP Servers Setup Guide

This guide explains how to set up Model Context Protocol (MCP) servers 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 warehouse service
• Amazon ElastiCache Redis: In-memory data store

Prerequisites

Before setting up the MCP servers, ensure you have:

1. Access to AWS services and appropriate permissions
2. Database instances already created and accessible
3. Node.js and npm installed
4. Python 3 installed
5. Git installed
6. Docker installed (optional, for containerized MCP servers)

You can check and install prerequisites using:

chmod +x check_prerequisites.sh
./check_prerequisites.sh

Setup Process

1. Configure Database Credentials

Create a credentials file with your database connection information:

cp db_credentials_template.sh set_db_credentials.sh

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

2. Validate Database Connections

Before setting up the MCP servers, validate that your database connections work:

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

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

3. Set Up MCP Servers

Run the secure 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 necessary repositories
• Build required components
• Update the MCP configuration
• Restart the MCP services

4. Test MCP Servers

After setup, test that all MCP servers are working correctly:

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 me 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 in the orders table?

MongoDB/DocumentDB

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

DynamoDB

List all tables in DynamoDB.
Get items from the Orders table where CustomerId equals 'CUST001'.
What are the primary key attributes for the Products table?

Redshift

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

Redis

Get all keys in Redis.
What is the value of the key 'session:user123'?
Show me 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 when possible
• Implement least privilege access for database users
• Set appropriate read/write permissions in MCP server configurations

Troubleshooting

If you encounter issues:

1. Check the logs in the logs directory
2. Verify database connectivity using the validation script
3. Ensure all required environment variables are set
4. Check that the MCP service is running (http://127.0.0.1:7002)
5. Verify that the Chatbot UI is accessible (http://localhost:8502)

Additional Resources

• MCP Protocol Documentation
• Amazon Bedrock Documentation
• AWS Database Services