Skip to main contentAWS Startups
Agent Icon

AWS DB Advisor

  • Databases

A Kiro CLI agent that helps startup developers pick and run the right AWS database - from initial selection through production operations.

Created on Jul 9, 2026 by Svetozar Miucin

By using these prompts, you agree to this disclaimer.

Agent Details

Choosing the right database on AWS is one of the most consequential early decisions a startup makes, and switching later is expensive. This agent eliminates the guesswork by mapping your application type, access patterns, and expected scale to the right AWS database from the start. It covers the full portfolio - Aurora, RDS, DynamoDB, ElastiCache/Valkey, OpenSearch, Neptune, MemoryDB, Timestream, DocumentDB, and DSQL - and knows when each one fits based on your specific workload. If you're building AI features, it guides you through vector database selection: pgvector for small workloads, OpenSearch for scale, S3 Vectors for massive corpora, with clear trade-offs at each tier. Once you've picked a database, it doesn't stop there. It advises on high availability and disaster recovery at every level, from free multi-AZ storage replication through multi-region active-active architectures, always with cost trade-offs so you're not over-engineering for your stage. For cost optimization, it walks through Savings Plans, Reserved Instances, I/O-Optimized storage decisions, and scale-to-zero configurations so you only pay for what you use. When you outgrow your current setup, it handles heterogeneous migrations - Oracle to RDS, MSSQL to Aurora PostgreSQL - with DMS patterns, major version upgrade planning, and failure recovery strategies. It also covers day-to-day operational concerns: connection pooling with RDS Proxy, Lambda cold-start patterns, PostgreSQL performance tuning, partitioning strategies, CDC/zero-ETL pipelines to analytics, and multi-tenant schema isolation. It uses the AWS Knowledge MCP server to look up live documentation, so answers reflect current service capabilities rather than stale training data.

Installation instructions

Prerequisites:

  • Kiro CLI installed (curl -fsSL https://cli.kiro.dev/install | bash)
  • Node.js 18+ (required for the AWS Knowledge MCP server)
  • jq (preinstalled on macOS; apt install jq on Debian/Ubuntu)

Setup:

  1. Clone the repository:

git clone https://github.com/aws-samples/sample-genai-startups.git
cd sample-genai-startups/agentic-coding-library/agents/aws-db-advisor

  1. Run the installer:

./install.sh

This installs the agent to ~/.kiro/agents/aws-db-advisor, copies context files, and configures the AWS Knowledge MCP server.

  1. Launch the agent:

kiro-cli chat --agent aws-db-advisor

Other install modes:

  • ./install.sh power - Install as a Kiro Power
  • ./install.sh claude - Install as a Claude Code Skill (invoke with /aws-db-advisor)
  • ./install.sh all - Install all three targets
  • ./install.sh agent --agent <name> - Integrate into an existing agent

Example prompts:

  • "I'm building a SaaS project management tool. What database should I use on AWS?"
  • "I'm running Aurora PostgreSQL Serverless v2 with a single writer. Is my database highly available?"
  • "I need my app to survive a complete AWS region failure. What's the cheapest way to do multi-region DR?"
  • "I'm building a RAG chatbot that needs to search through documents. What database should I use?"

Model requirements: Claude Sonnet 4.6 or higher. Lower models may fall back to training data and produce incorrect answers for recently changed service capabilities.

AWS DB Advisor | AWS Startups