zSQLAgent: An AWS Bedrock-Based Intelligent Database Assistant + re:Invent recap
Details
New year, new opportunity!
Join us as we do a quick recap and discussion on re:Invent announcements, then hear from Monty on a cool solution he developed!
6:30 - 7 : Welcome, socialization, yummy Zotec food
7-7:20 : re:Invent recap - panel
7:20 - 8++ : Monty - zSQLAgent - a Bedrock-powered AI assistant
The zSQLAgent is a Bedrock-powered AI assistant developed by Zotec’s Database Engineering team to streamline SQL development and analysis. Built with AWS Bedrock, Lambda, OpenSearch, and S3, it integrates directly with Slack to interpret natural language, generate and optimize T-SQL, and validate queries against real database schemas. Using retrieval-augmented generation (RAG) with Bedrock knowledge bases, the agent ensures schema-aware accuracy and enforces join logic for safe query execution. It routes user intents through a multi-node Bedrock flow, leverages Claude 4 Sonnet and Nova Pro for SQL reasoning, and alerts engineers when queries require review. This session details the system’s architecture, flow design, and integration approach—demonstrating how AWS Bedrock can power scalable, production-grade AI agents for database engineering.
AI summary
By Meetup
zSQLAgent is a Bedrock-based AI assistant for database engineers to generate, validate, and optimize T-SQL against real schemas.
AI summary
By Meetup
zSQLAgent is a Bedrock-based AI assistant for database engineers to generate, validate, and optimize T-SQL against real schemas.
