Home icon

AI-driven database investigation using MCP, Agent Skills, and AWS DevOps Agent

Database Blog



This article demonstrates how to automate database investigations for Amazon RDS for SQL Server using AWS DevOps Agent, Amazon Bedrock AgentCore Gateway, and custom MCP tools.

  • AgentCore Gateway provides a managed MCP endpoint with SigV4 authentication, fine-grained access policies, and observability for tool calls
  • AWS DevOps Agent reads CloudWatch metrics and Database Insights, then calls custom MCP tools through the Gateway for session-level and plan-level diagnostics
  • AWS DevOps Agent Skills define investigation procedures in Markdown, including triage, diagnosis, drill-down, correlation, and recommendation steps
  • 13 custom tools expose SQL Server diagnostics: blocking sessions, slow queries, Query Store data, execution plans, and missing index suggestions
  • Database credentials stay in Secrets Manager; the agent never accesses them directly, maintaining security across three layers
  • Demonstrated investigation found a blocking chain caused by a client-side transaction holding a lock for 5 minutes, identified root cause, and recommended fixes

The solution enables autonomous incident response for database performance issues without requiring agents to manage credentials or database connectivity directly.



Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Nov 11
2026
Build a data foundation for agentic AI on AWS: From lakehouse to MCP
Nov 2
2026
Extending AWS DevOps Agent with Skills, Model Context Protocol (MCP) Servers, Custom Agents and Connectors
Apr 22
2026
Automating Incident Investigation with AWS DevOps Agent and Salesforce MCP Server
Oct 7
2026
Automate remediation post AWS DevOps Agent investigation

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.