Invoke AWS services directly from Amazon RDS for SQL Server 2025

This article demonstrates how Amazon RDS for SQL Server 2025 can invoke AWS services and external HTTPS endpoints directly from T-SQL using the new sp_invoke_external_rest_endpoint stored procedure.

• Enable sp_invoke_external_rest_endpoint via custom DB parameter group to allow HTTPS calls from the database
• Score customer records in real-time against Amazon SageMaker ML models inline with database inserts
• Call private custom services on Amazon EC2 within VPC using database-scoped credentials for authentication
• Send transactional emails via Amazon SES directly from database triggers when critical events occur
• Route AWS service calls through authentication layer (API Gateway + Lambda) for SigV4 signing
• Use database-scoped credentials to securely store API keys without exposing secrets in query text
• Extend pattern to any HTTPS endpoint including internal microservices and third-party APIs

The capability eliminates middleware tiers by allowing databases to participate directly in service meshes, enabling real-time ML inference, custom business logic invocation, and event-driven notifications within database transactions.