Enables Redshift system-table (SYS_*) log publishing to S3 Tables in Apache Iceberg format for both Provisioned clusters and Serverless namespaces, verifies publishing status, and queries the published logs via any Iceberg-compatible engine including Redshift and Athena. Covers system tables such as sys_query_history, sys_query_text, sys_connection_log, sys_query_detail, and sys_session_history.
Install
npx skills add aws/agent-toolkit-for-aws --skill querying-aws-redshiftnpx skills add aws/agent-toolkit-for-aws --skill querying-aws-redshift -a claude-code -gnpx skills add aws/agent-toolkit-for-aws --skill querying-aws-redshift -a codex -ggemini skills install https://github.com/aws/agent-toolkit-for-aws.git --path skills/specialized-skills/system-table-skills/querying-aws-redshiftgh skill install aws/agent-toolkit-for-aws querying-aws-redshiftgit clone --depth 1 https://github.com/aws/agent-toolkit-for-aws /tmp/aws__agent-toolkit-for-aws
mkdir -p ~/.claude/skills ~/.agents/skills
cp -R /tmp/aws__agent-toolkit-for-aws/skills/specialized-skills/system-table-skills/querying-aws-redshift ~/.claude/skills/querying-aws-redshift # Claude Code
cp -R /tmp/aws__agent-toolkit-for-aws/skills/specialized-skills/system-table-skills/querying-aws-redshift ~/.agents/skills/querying-aws-redshift # Codex, Cursor, Gemini CLI, Copilot, OpenCode