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.
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
2026
Build a data foundation for agentic AI on AWS: From lakehouse to MCP
Nov 2
2026
2026
Extending AWS DevOps Agent with Skills, Model Context Protocol (MCP) Servers, Custom Agents and Connectors
Apr 22
2026
2026
Automating Incident Investigation with AWS DevOps Agent and Salesforce MCP Server
Oct 7
2026
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.