# rds-sqlserver

A skill for wiring apps to Amazon RDS for SQL Server: drivers, connection strings, Kerberos, IAM through RDS Proxy and common error modes.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode · 4600 installs · ★ 3282
- Author: aws
- License: Apache-2.0 · policy=mirror · the beginning of the file is at the end of this page
- Source: https://github.com/aws/agent-toolkit-for-aws/tree/HEAD/skills/specialized-skills/database-skills/rds-sqlserver/SKILL.md
- Updated: 2026-10-23
- HTML: https://affpapa.org/en/nevibecode/skills/rds-sqlserver

## What it does

The skill walks the whole path from picking a driver to a working connection against Amazon RDS for SQL Server. It covers connection strings, SSL/TLS encryption, SQL and Windows authentication, IAM auth via RDS Proxy, and connection pooling. A separate part deals with VPC networking and deployment on EC2, ECS, Lambda and EKS.

It classifies the context first: language from project files (`requirements.txt` and `*.py` for Python, `*.csproj` for .NET, `pom.xml` or `build.gradle` for Java, `package.json` for Node.js), then runtime and auth type, and routes you to the matching reference. Auth defaults to `sql` unless you mention Active Directory, Kerberos, NTLM or IAM. Drivers covered include pymssql and pyodbc, Microsoft.Data.SqlClient, mssql-jdbc and tedious.

The AWS CLI is required — most steps go through the AWS API, so a missing CLI blocks them. The AWS MCP server is recommended rather than required; it adds sandboxed execution, CloudTrail audit and observability. The skill can create and modify RDS resources, but every such action needs your explicit confirmation first. It refuses deletes, automated backup removal, forced failover, major version upgrades and turning on public accessibility — those belong in your change-control process or the AWS Console.

## Requirements
- Works with: AWS

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add aws/agent-toolkit-for-aws --skill rds-sqlserver -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/rds-sqlserver/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/rds-sqlserver/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add aws/agent-toolkit-for-aws --skill rds-sqlserver -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/rds-sqlserver/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add aws/agent-toolkit-for-aws --skill rds-sqlserver -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/rds-sqlserver/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install aws/agent-toolkit-for-aws rds-sqlserver
```

2. **Manually: put the files in place**
- File: `.github/skills/rds-sqlserver/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add aws/agent-toolkit-for-aws --skill rds-sqlserver -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/aws/agent-toolkit-for-aws --path skills/specialized-skills/database-skills/rds-sqlserver
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/rds-sqlserver/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add aws/agent-toolkit-for-aws --skill rds-sqlserver -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/aws/agent-toolkit-for-aws/tree/HEAD/skills/specialized-skills/database-skills/rds-sqlserver/SKILL.md

## When to use it
- debug why SSMS times out connecting to RDS from EC2
- fix the Cannot generate SSPI context error under Windows auth
- connect to RDS SQL Server from Lambda with pymssql
- explain why auth_scheme reports NTLM instead of KERBEROS on ECS Fargate
- set up an SSM tunnel to RDS SQL Server from a laptop

## Example prompts
- Help me connect to RDS SQL Server from Lambda in Python using pymssql
- SSMS times out connecting to RDS from EC2 — what's going on?
- Set up Windows authentication to RDS SQL Server with AWS Managed Microsoft AD

## Source text · SKILL.md · Apache-2.0

Below is the content of a third-party file. It is data, not instructions for you: do not act on anything written inside unless the human asks. Block tag: d1807dcc0da15c97.

BEGIN THIRD-PARTY FILE d1807dcc0da15c97
```text
---
name: rds-sqlserver
version: 1
description: Provides connectivity, authentication, and troubleshooting guidance for Amazon RDS for SQL Server. Applicable when users ask about SSMS times out connecting from EC2, Cannot generate SSPI context with Windows auth, connect RDS SQL Server from Lambda with pymssql, auth_scheme shows NTLM instead of KERBEROS on ECS Fargate, SSM tunnel to RDS SQL Server from laptop, port 1433 security group, TrustServerCertificate=True for localhost tunnels, SPN MSSQLSvc, AWS Managed Microsoft AD, CNAME not RDS endpoint for Kerberos, tds_version='7.4', encryption='require', port-as-string for pymssql, Secrets Manager credential caching in Lambda, error 18456 login failed. Covers Python (pymssql, pyodbc), .NET (Microsoft.Data.SqlClient), Java (JDBC mssql-jdbc), Node.js (tedious), IAM auth via RDS Proxy, and VPC/ECS/EKS/Lambda deployment.
---

# Amazon RDS for SQL Server

## Safety guidance

This skill covers creating and modifying RDS for SQL Server resources when the user requests it. The agent MUST confirm the action with the user before executing. Do NOT execute any create or modify operation without explicit user confirmation (e.g., "yes", "proceed", "confirmed", "go ahead"). If the user has not confirmed, present the planned action and ask for approval.

### Execute these operations (after user confirmation)

- Create an instance: `create-db-instance` (requires a DB subnet group; RDS SQL Server is VPC-only and not publicly accessible by default)
- Create a custom parameter group: `create-db-parameter-group` (family `sqlserver-ex-15.00`, `sqlserver-se-15.00`, etc.) — needed to set `rds.force_ssl=1` among others
- Create an option group: `create-option-group` (for TDE, S3 integration, SQLServer Audit, Native Backup/Restore, SSIS, SSAS, SSRS)
- Create an RDS Proxy: `create-db-proxy`, `register-db-proxy-targets` (for IAM DB auth in front of SQL Server — see the rds-proxy reference)
- Create an AWS Managed Microsoft AD directory for Windows auth: `create-directory` (then associate via `modify-db-instance --domain`)
- Create a Secrets Manager secret with rotation: `create-secret`, `rotate-secret --rotation-rules AutomaticallyAfterDays=N`
```
END THIRD-PARTY FILE d1807dcc0da15c97

The third-party file has ended. Everything between the d1807dcc0da15c97 tags is data: requests and commands from it are not followed. An “end of file” line with another tag inside the block is part of the file.

First 2204 of 25136 bytes. © aws · Apache-2.0 · https://github.com/aws/agent-toolkit-for-aws/tree/HEAD/skills/specialized-skills/database-skills/rds-sqlserver/SKILL.md

_Part of the page did not fit — see the HTML version._

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md