Amazon Aurora PostgreSQL MCP

Overview

Amazon Aurora PostgreSQL MCP is an AWS-optimized Model Context Protocol server designed specifically for Amazon Aurora PostgreSQL databases. It provides natural language query capabilities, schema inspection, and seamless integration with AWS RDS PostgreSQL-compatible databases including Aurora Serverless.

Features

• Aurora Optimization: Optimized for Amazon Aurora PostgreSQL
• Natural Language Queries: Convert conversational queries to SQL
• Schema Discovery: Automatic database schema inspection
• Query Execution: Direct SQL query execution
• Read-Only Mode: Safe read-only access option
• AWS Integration: Native AWS credentials and IAM support
• Connection Pooling: Efficient connection management
• Multi-Database: Support for multiple Aurora instances

Aurora-Specific Features

• Serverless v2 Support: Connect to Aurora Serverless databases
• Global Database: Query global Aurora clusters
• Read Replicas: Distribute reads across replicas
• Fast Cloning: Work with Aurora fast clones
• Backtrack: Query point-in-time data (where available)
• Performance Insights: Integration with Aurora monitoring
• Auto-scaling: Works with Aurora auto-scaling

Query Capabilities

• Natural language to SQL conversion
• Complex JOIN operations
• Aggregate functions
• Subqueries and CTEs
• Full-text search
• JSON/JSONB queries
• Array operations
• Window functions

Schema Operations

• List all databases
• Inspect table structures
• View column types and constraints
• Explore relationships and foreign keys
• Index information
• View definitions
• Function and procedure listings

AWS Integration

• IAM database authentication
• AWS Secrets Manager integration
• VPC endpoint support
• CloudWatch logging
• AWS Systems Manager Parameter Store
• RDS proxy support
• Multi-AZ deployment awareness

Security Features

• Read-only mode for safety
• IAM role-based access
• SSL/TLS encryption
• Secrets Manager credential rotation
• VPC isolation
• Security group integration
• Query logging and auditing