--- title: Invoke AWS services directly from Amazon RDS for SQL... description: SQL Server 2025 on Amazon RDS introduces the sp_invoke_external_rest_endpoint stored procedure, enabling T-SQL code to call HTTPS endpoints synchronously.... canonical: https://daily.dev/posts/invoke-aws-services-directly-from-amazon-rds-for-sql-server-2025-svjqn5j6g twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Invoke AWS services directly from Amazon RDS for SQL Server 2025 | daily.dev og:description: SQL Server 2025 on Amazon RDS introduces the sp_invoke_external_rest_endpoint stored procedure, enabling T-SQL code to call HTTPS endpoints synchronously.... og:url: https://daily.dev/posts/invoke-aws-services-directly-from-amazon-rds-for-sql-server-2025-svjqn5j6g og:image: https://api.daily.dev/og/posts/svjQn5J6g.png og:image:alt: Invoke AWS services directly from Amazon RDS for SQL Server 2025 og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Invoke AWS services directly from Amazon RDS for SQL Server 2025 **[AWS Database Blog](https://daily.dev/sources/aws-database-blog)** · 15 min read · 0 upvotes · 0 comments ## Summary SQL Server 2025 on Amazon RDS introduces the sp_invoke_external_rest_endpoint stored procedure, enabling T-SQL code to call HTTPS endpoints synchronously. Three practical examples are covered: invoking an Amazon SageMaker real-time inference endpoint for churn scoring via a database trigger, calling a private Python credit-scoring service on EC2 using DATABASE SCOPED CREDENTIAL for API key management, and sending transactional emails through Amazon SES. AWS services requiring SigV4 signing are routed through an API Gateway and Lambda authentication layer, while token-based services use database-scoped credentials. Key considerations include transaction rollback on transport failures, SageMaker payload limits, SES sending quotas, and the need for HTTPS with trusted TLS certificates. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How do I call an AWS service like SageMaker or SES directly from T-SQL in SQL Server 2025 on Amazon RDS? Use the built-in sp_invoke_external_rest_endpoint stored procedure, which sends a synchronous HTTPS request and returns the response code, headers, and body. Because AWS services require SigV4 signing that the procedure does not perform itself, route calls through an authentication layer such as an API Gateway endpoint backed by a Lambda function that signs the request using its IAM role's temporary credentials. _daily.dev surfaces practical patterns like this for developers wiring databases into AWS-native workflows._ ### Is sp_invoke_external_rest_endpoint enabled by default on Amazon RDS for SQL Server 2025? No, it is disabled by default. Enable it by creating a custom DB parameter group, setting the external rest endpoint enabled parameter to 1, and attaching that parameter group to the DB instance; after it reaches the in-sync state, verify by checking that value_in_use equals 1 in sys.configurations. It requires engine version 17.0.4015.4 or later on Standard or Enterprise edition. _Track configuration steps like this on daily.dev when rolling out new RDS SQL Server capabilities._ ### What are the limits of the sp_invoke_external_rest_endpoint stored procedure in SQL Server 2025? The @url and @headers parameters are each limited to 4,000 characters, and the maximum @timeout value is 230 seconds. It sends a default Content-Type of application/json; charset=utf-8, so target endpoints must accept that charset directive. These limits are identical to those on a self-managed SQL Server 2025 installation. _Developers designing database-to-service integrations can keep tabs on limits like these via daily.dev._ ## Similar posts on daily.dev - [Building agentic AI patterns with Amazon Bedrock and SQL Server 2025 on Amazon RDS](https://daily.dev/posts/building-agentic-ai-patterns-with-amazon-bedrock-and-sql-server-2025-on-amazon-rds-gu2migzkd) · AWS Database Blog · 1 upvotes · 0 comments - [AWS Transform announces full-stack Windows modernization capabilities](https://daily.dev/posts/aws-transform-announces-full-stack-windows-modernization-capabilities-bgkonrsgd) · AWS · 0 upvotes · 0 comments --- Tags: [#aws](https://daily.dev/tags/aws), [#rest-api](https://daily.dev/tags/rest-api), [#aws-lambda](https://daily.dev/tags/aws-lambda), [#microsoft-sql-server](https://daily.dev/tags/microsoft-sql-server) [View this post on daily.dev](https://daily.dev/posts/invoke-aws-services-directly-from-amazon-rds-for-sql-server-2025-svjqn5j6g) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Invoke AWS services directly from Amazon RDS for SQL Server 2025","url":"https://daily.dev/posts/invoke-aws-services-directly-from-amazon-rds-for-sql-server-2025-svjqn5j6g","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/invoke-aws-services-directly-from-amazon-rds-for-sql-server-2025-svjqn5j6g"},"datePublished":"2026-07-20T23:02:40.796Z","dateModified":"2026-09-14T06:50:11.254Z","description":"SQL Server 2025 on Amazon RDS introduces the sp_invoke_external_rest_endpoint stored procedure, enabling T-SQL code to call HTTPS endpoints synchronously....","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/69f86238e059bdfdb9a6114ed889607d?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/69f86238e059bdfdb9a6114ed889607d?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"AWS Database Blog","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"AWS Database Blog","logo":"https://media.daily.dev/image/upload/s--En-avd2a--/f_auto,q_auto/v1780213446/logos/aws-database-blog?_a=BAMAMiWQ0","url":"https://daily.dev/sources/aws-database-blog"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/invoke-aws-services-directly-from-amazon-rds-for-sql-server-2025-svjqn5j6g","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"aws,rest-api,aws-lambda,microsoft-sql-server","timeRequired":"PT15M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"AWS Database Blog","item":"https://daily.dev/sources/aws-database-blog"},{"@type":"ListItem","position":3,"name":"Invoke AWS services directly from Amazon RDS for SQL Server 2025"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/invoke-aws-services-directly-from-amazon-rds-for-sql-server-2025-svjqn5j6g#faq","mainEntity":[{"@type":"Question","name":"How do I call an AWS service like SageMaker or SES directly from T-SQL in SQL Server 2025 on Amazon RDS?","acceptedAnswer":{"@type":"Answer","text":"Use the built-in sp_invoke_external_rest_endpoint stored procedure, which sends a synchronous HTTPS request and returns the response code, headers, and body. Because AWS services require SigV4 signing that the procedure does not perform itself, route calls through an authentication layer such as an API Gateway endpoint backed by a Lambda function that signs the request using its IAM role's temporary credentials. daily.dev surfaces practical patterns like this for developers wiring databases into AWS-native workflows."}},{"@type":"Question","name":"Is sp_invoke_external_rest_endpoint enabled by default on Amazon RDS for SQL Server 2025?","acceptedAnswer":{"@type":"Answer","text":"No, it is disabled by default. Enable it by creating a custom DB parameter group, setting the external rest endpoint enabled parameter to 1, and attaching that parameter group to the DB instance; after it reaches the in-sync state, verify by checking that value_in_use equals 1 in sys.configurations. It requires engine version 17.0.4015.4 or later on Standard or Enterprise edition. Track configuration steps like this on daily.dev when rolling out new RDS SQL Server capabilities."}},{"@type":"Question","name":"What are the limits of the sp_invoke_external_rest_endpoint stored procedure in SQL Server 2025?","acceptedAnswer":{"@type":"Answer","text":"The @url and @headers parameters are each limited to 4,000 characters, and the maximum @timeout value is 230 seconds. It sends a default Content-Type of application/json; charset=utf-8, so target endpoints must accept that charset directive. These limits are identical to those on a self-managed SQL Server 2025 installation. Developers designing database-to-service integrations can keep tabs on limits like these via daily.dev."}}]} ```