[アップデート] Amazon Redshift が Agent Toolkit for AWS と統合され AI エージェントから管理できるようになったので試してみました

/plugin install aws-data-analytics@claude-plugins-official
/reload-plugins

% aws configure agent-toolkit  --region us-east-1

Detecting installed AI coding agents...
  ✓ Claude Code — ~/.claude/skills
  ✗ Cline — ~/.cline/skills (not found)
  ✓ Codex — ~/.agents/skills/
  ✓ Cursor — ~/.cursor/skills
  ✓ Gemini CLI — ~/.agents/skills/
  ✓ Kiro — ~/.kiro/skills
  ✗ OpenClaw — ~/.openclaw/skills (not found)
  ✗ OpenCode — ~/.agents/skills (not found)
  ✗ Pi — ~/.pi/agent/skills (not found)
  ✗ Windsurf — ~/.agents/skills (not found)

Select agents to configure (space to toggle, up/down arrows to navigate, enter t
o confirm):
  [x] Claude Code — ~/.claude/skills
  [x] Codex — ~/.agents/skills/
  [x] Cursor — ~/.cursor/skills
  [x] Gemini CLI — ~/.agents/skills/
  [x] Kiro — ~/.kiro/skills

% aws agent-toolkit search-skills --search-query "redshift SQL" --region us-east-1
{
    "skills": [
        {
            "name": "redshift-guide",
            "description": "Amazon Redshift is NOT PostgreSQL — corrects PostgreSQL-derived LLM mistakes; covers Redshift-specific SQL, DDL, COPY/UNLOAD, system views, metadata discovery, and operational patterns. Applies ONLY when the task is about Redshift itself (cluster, Serverless workgroup, or Redshift SQL). Pushes back on: CREATE INDEX, string_agg, pg_catalog, text type, SERIAL, stl_query, LATERAL, RETURNING. Triggers on: Redshift SQL, Redshift CREATE TABLE, Redshift COPY/UNLOAD, slow Redshift query, Redshift permission denied, Redshift disk full, Redshift system views, QUALIFY, PIVOT, MERGE, Redshift Data API, Redshift WLM, concurrency scaling, Redshift resize, Redshift Spectrum external tables. Does NOT apply to (defer to that service's own skill): Amazon S3 storage/bucket policies, Athena or Glue queries/catalogs, data-lake or Iceberg work outside Redshift, Aurora, RDS, or DynamoDB — but S3/Glue ARE in scope for Redshift COPY, UNLOAD, or data-lake queries (external schemas/tables on S3).",
            "skillVersion": "v1",
            "categories": []
        },
      :
      :
      :
        {
            "name": "querying-aws-sagemaker-catalog",
            "description": "Runs SQL analytics on SageMaker Catalog asset metadata tables exported as Apache Iceberg in S3 Tables. Covers governance queries, asset growth tracking, ownership audits, time-travel over catalog state, and metadata quality analysis. Applies when querying catalog inventory, finding assets without descriptions, comparing catalog snapshots, or auditing data ownership. Trigger phrases: catalog inventory SQL, how many assets, assets without descriptions, asset growth over time, who owns this data, catalog governance, data quality audit, catalog analytics.",
            "skillVersion": "v1",
            "categories": []
        }
    ]
}

% aws agent-toolkit get-skill-metadata --skill-name redshift-guide --region us-east-1
{
    "name": "redshift-guide",
    "skillVersion": "v1",
    "description": "Amazon Redshift is NOT PostgreSQL — corrects PostgreSQL-derived LLM mistakes; covers Redshift-specific SQL, DDL, COPY/UNLOAD, system views, metadata discovery, and operational patterns. Applies ONLY when the task is about Redshift itself (cluster, Serverless workgroup, or Redshift SQL). Pushes back on: CREATE INDEX, string_agg, pg_catalog, text type, SERIAL, stl_query, LATERAL, RETURNING. Triggers on: Redshift SQL, Redshift CREATE TABLE, Redshift COPY/UNLOAD, slow Redshift query, Redshift permission denied, Redshift disk full, Redshift system views, QUALIFY, PIVOT, MERGE, Redshift Data API, Redshift WLM, concurrency scaling, Redshift resize, Redshift Spectrum external tables. Does NOT apply to (defer to that service's own skill): Amazon S3 storage/bucket policies, Athena or Glue queries/catalogs, data-lake or Iceberg work outside Redshift, Aurora, RDS, or DynamoDB — but S3/Glue ARE in scope for Redshift COPY, UNLOAD, or data-lake queries (external schemas/tables on S3).",
    "categories": [],
    "files": [
        {
            "path": "SKILL.md"
        },
        {
            "path": "references/redshift-sql-ddl-copy.md"
        },
        {
            "path": "references/redshift-sql-extensions-semantics.md"
        },
        {
            "path": "references/redshift-sql-functions-types.md"
        },
        {
            "path": "references/redshift-sql-materialized-views.md"
        },
        {
            "path": "references/redshift-sql-metadata.md"
        },
        {
            "path": "references/redshift-sql-recipes-load-api.md"
        },
        {
            "path": "references/redshift-sql-syntax.md"
        }
    ]
}

SELECT version();

PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.416217

SELECT string_agg(v, ',') FROM (SELECT 'a' AS v UNION ALL SELECT 'b') t;

ERROR: function string_agg(character varying, "unknown") does not exist
Hint: No function matches the given name and argument types. You may need to add explicit type casts.

SELECT LISTAGG(v, ',') WITHIN GROUP (ORDER BY v) AS joined
FROM (SELECT 'a' AS v UNION ALL SELECT 'b') t;

joined
a,b

SELECT * FROM stl_query LIMIT 1;

ERROR: permission denied for relation stl_query

SELECT query_id, status FROM sys_query_history ORDER BY start_time DESC LIMIT 3;

query_id   status
1412360    running
1412359    success
1412358    success

SELECT v FROM (SELECT 'a' AS v UNION ALL SELECT 'b' UNION ALL SELECT 'c') t
QUALIFY ROW_NUMBER() OVER (ORDER BY v DESC) = 1;

v
c

SELECT SUBSTR(v,1,1) FROM (SELECT 'abc' AS v UNION ALL SELECT 'def') t;

substr
a
d

SELECT SUBSTR(status,1,3) AS s FROM sys_query_history LIMIT 1;

ERROR: SUBSTR() function is not supported (Hint: use SUBSTRING instead)
code: 8001

SELECT SUBSTRING(status,1,3) AS s FROM sys_query_history LIMIT 1;

s
suc

SELECT ('abc   ' = 'abc') AS literal_eq;

literal_eq
False