{
  "listing": {
    "skills": [
      {
        "path": "plugins/databases-on-aws/skills/dsql/SKILL.md",
        "name": "dsql",
        "description": "Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, diagnose cluster performance, load data, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL and PostgreSQL-to-DSQL schema conversion, foreign key constraints, OCC retry patterns, ORM migration (Django/EF Core/Hibernate/Rails/SQLAlchemy), DDL operations, query plan explainability, system diagnostics via CloudWatch AAS, SQL compatibility validation, and bulk data loading. Load before answering DSQL limit or error-code questions; it has limits docs omit. Triggers on phrases like: DSQL, Aurora DSQL, distributed SQL database, serverless PostgreSQL-compatible database, migrate to DSQL, DSQL query plan, DSQL EXPLAIN ANALYZE, DSQL ENUM, DSQL foreign key, DSQL OCC retry, DSQL multi-region, DSQL JSONB, DSQL GIN index, load into DSQL, load CSV into DSQL, bulk load DSQL, aurora-dsql-loader, DSQL slow, DSQL performance, DSQL wait events, DSQL AAS.",
        "files": {
          "plugins/databases-on-aws/skills/dsql/SKILL.md": "7a53b87c24452fec3d818e64737cadab6f65799f3bb89ff5bb31975a05979b7a",
          "plugins/databases-on-aws/skills/dsql/mcp/mcp-setup.md": "7b855431ed0ea24ee12104f5a84fa8c101f5dabf73fe394ec8bc4c7de4e54a13",
          "plugins/databases-on-aws/skills/dsql/mcp/mcp-tools.md": "6fadbf5c4a8f310ad0e4b4b865de8364db528659712a741487dcc3fcfaa96737",
          "plugins/databases-on-aws/skills/dsql/mcp/platforms/claude-code.md": "00d80f363183eaf841eb778f3e518cfac9fd351a8a5de5fac9212ac60ab60769",
          "plugins/databases-on-aws/skills/dsql/mcp/platforms/codex.md": "7753e3181f980ed0dbe8008302e7ac8b991ab665be9c8957b3819deb0e7fbd5e",
          "plugins/databases-on-aws/skills/dsql/mcp/platforms/gemini.md": "08b2697d96fe811c64336930841727be7f37de7ac48724c8b36523187d7941da",
          "plugins/databases-on-aws/skills/dsql/mcp/platforms/kiro.md": "38fa9a45ee7323dc9df3fa2f327536dc167829ec1c15a45d43cf667586e793c3",
          "plugins/databases-on-aws/skills/dsql/mcp/tools/database-tools.md": "e1521d2001dff6929cd235dd2bbc29e9ba2054ee9832540f796c052a0c2a669f",
          "plugins/databases-on-aws/skills/dsql/mcp/tools/documentation-tools.md": "0b79a75497a2ffed7256f2f32baafca836ce1bbfc479fc76c766b56279f88e7d",
          "plugins/databases-on-aws/skills/dsql/mcp/tools/input-validation.md": "55b478deb29572f8a56a8e6f41dcea7f7b776d3d668ea085d8e8cb09b231e190",
          "plugins/databases-on-aws/skills/dsql/mcp/tools/safe_query.py": "f8ec7b0388386f79275a795f93c85f0988a3ba3c39c7aca1f44cb4d9ef0b42bb",
          "plugins/databases-on-aws/skills/dsql/mcp/tools/workflow-patterns.md": "d65042620e7430f3c2d0de9608d0f9af63d6f55099b8a7344522797f1a146263",
          "plugins/databases-on-aws/skills/dsql/references/access-control.md": "820a167c7a1204577eb967c4ed1bdeb9ccbffca94e46c59b8f458b0548aeda22",
          "plugins/databases-on-aws/skills/dsql/references/auth/authentication-guide.md": "54cd722aeab832339fac6c1d587941e3103b4685ffbd79559ece149084982b9e",
          "plugins/databases-on-aws/skills/dsql/references/auth/connectivity-tools.md": "a2d3375158cdc7b2460fe57d79c57af350bcb4c4333e1a08e8787bb3f3ad9db8",
          "plugins/databases-on-aws/skills/dsql/references/auth/scaling-guide.md": "5c4034475bf801879e57a1760ec1e43bf6400fdd1e209c1e2fdfff461bf2482f",
          "plugins/databases-on-aws/skills/dsql/references/data-loading.md": "cb5aaf75c90cb3495ab538746b2d988a2fbf7819dcb105d75fd8dc196afd7859",
          "plugins/databases-on-aws/skills/dsql/references/ddl-migrations/batched-migration.md": "67cdb45ffd3bf7fe8d3f9aefce837e0b692ac5b676d84aa6b884795539dd0dcc",
          "plugins/databases-on-aws/skills/dsql/references/ddl-migrations/column-operations.md": "c6406e2d5c59f5ae04790c31790d31a0feaf024f0b07e1e083119c4c2af66418",
          "plugins/databases-on-aws/skills/dsql/references/ddl-migrations/constraint-operations.md": "a18e85333e46afe1d9f8b25ab829e494e9041ac0e912c829edda89b1f9b1e479",
          "plugins/databases-on-aws/skills/dsql/references/ddl-migrations/overview.md": "0b1a1ab7d0fbc48b0d57dcb580098df46939703fe7887b52d4c6a185c176d6ad",
          "plugins/databases-on-aws/skills/dsql/references/development-guide.md": "83c90221124ed3c57e5d4e3ebf3efcda7b01ac00355b94ff5a860fcd06b62205",
          "plugins/databases-on-aws/skills/dsql/references/dsql-examples.md": "8cf1944b0a90ac18df5020e0bc08aa3cf4b272d2aa09f8ffaf2bc27ee519b7d3",
          "plugins/databases-on-aws/skills/dsql/references/dsql-lint.md": "ff1c439cddbd9175500d39acaf9c15733df286c7f349e171667d95b9f3682995",
          "plugins/databases-on-aws/skills/dsql/references/examples/connection.md": "201953c379f089040621001d324d4d8c7b15f008217bdf6c83569a56933735ca",
          "plugins/databases-on-aws/skills/dsql/references/examples/data-operations.md": "744ed9dfcf8226492530f3c7037e55c0cd2ff218bccf5eba792cc300683a8de0",
          "plugins/databases-on-aws/skills/dsql/references/examples/migrations.md": "c099cf0b935cd9fa55e9d7e4e44916e0ea921649544c2c9a48ce1ef9d100427c",
          "plugins/databases-on-aws/skills/dsql/references/examples/patterns.md": "5e022e0de02f809eb781523dc16257ea3f1dc8329c6438cf384c37c0cfe98cb8",
          "plugins/databases-on-aws/skills/dsql/references/examples/schema.md": "d16d0fdbbc67ab5848adfc0277ff1cf6487d2d310b0dc6d0753aaa9b77032f09",
          "plugins/databases-on-aws/skills/dsql/references/foreign-keys.md": "535f25ee6c1313bc4c19b0e8569c6f250ef12edcb5e6bb9c6b1fd1389ddbf977",
          "plugins/databases-on-aws/skills/dsql/references/language.md": "7cefaf5959f15a12b66a5e784c553a9b7cec7f6acf0b5619a4c58fbab2aed1c1",
          "plugins/databases-on-aws/skills/dsql/references/limits-and-error-codes.md": "a0a89787354b5ab2721b938ad29bd51166f496f741c138a42feea5ccd69cffe1",
          "plugins/databases-on-aws/skills/dsql/references/mysql-migrations/ddl-auto-increment.md": "20bf31a6f1c5105caa2069d7fb475dcc6cdf0fb0e4ad239ed14b830897b7ce95",
          "plugins/databases-on-aws/skills/dsql/references/mysql-migrations/ddl-batching.md": "f986ca49a4a1bb7c5f0748fc54e9d4e6034c1d745c8448f6844f35039f56ef0c",
          "plugins/databases-on-aws/skills/dsql/references/mysql-migrations/ddl-column-changes.md": "a921f975dc3f45c08baa3ea819dc6e47c19afab64ae6fa59cf3e9caffe0ecbfd",
          "plugins/databases-on-aws/skills/dsql/references/mysql-migrations/ddl-constraints.md": "531a357a9311e5ab09456b05380ff71fd26ed845397ef65ff213699700c29368",
          "plugins/databases-on-aws/skills/dsql/references/mysql-migrations/ddl-operations.md": "a54ae4d5cb344e3ed14af1da289db7d88ecb709bd2188e87c5864f52a8300647",
          "plugins/databases-on-aws/skills/dsql/references/mysql-migrations/ddl-structural.md": "d3d32b4af67e892b16e96b9410e548c6206fa5a1f4af74d325328d2614f3c591",
          "plugins/databases-on-aws/skills/dsql/references/mysql-migrations/ddl-type-alternatives.md": "77740b0fb8cb70a2277100ca6c62c66d214dfcc1f8b88c2ef440769db2d022db",
          "plugins/databases-on-aws/skills/dsql/references/mysql-migrations/full-example.md": "13ac4e4a10346fc8a44324d3159571ded738b8de80ccd4971416953647fe50f1",
          "plugins/databases-on-aws/skills/dsql/references/mysql-migrations/type-mapping.md": "730f9760260aeb4ab06be8b741e4366cb858f8fa32bc69c7f5b2a724504b6460",
          "plugins/databases-on-aws/skills/dsql/references/occ-retry-patterns.md": "82f0a6d4b078b80da8d366692f0f7db91276df239cf0d939e576e6f758d21680",
          "plugins/databases-on-aws/skills/dsql/references/onboarding.md": "4cd37ea1609a30fb19152f28908eebe3487db7e70b128c78f2ba7323a1a96a56",
          "plugins/databases-on-aws/skills/dsql/references/orm-guides/overview.md": "140da44b6e8e1ffaa898af7b31d69154a3fd68079d82d242d483dc7ba899d000",
          "plugins/databases-on-aws/skills/dsql/references/pg-migrations/index-conversion.md": "8c75c1b9228bc2a9558ce0d5dbc368046ae19d61b8a33f738bd4ae7cedd548e8",
          "plugins/databases-on-aws/skills/dsql/references/pg-migrations/multi-region.md": "ebfcf9a86f1b433d6195fd89e2283106c3719276ea04d450fbdb0037b2688ec0",
          "plugins/databases-on-aws/skills/dsql/references/pg-migrations/schema-objects.md": "e692c6718fc98b35e744906389e34cc5c1d385e8929f3278b318416b8e2f10a4",
          "plugins/databases-on-aws/skills/dsql/references/pg-migrations/type-mapping.md": "25605cc33ac2a55c0ecafe98ef973c03cc705a84e7fb9298c091ce8ea5bfc942",
          "plugins/databases-on-aws/skills/dsql/references/query-plan/catalog-queries.md": "adfe0aa5657b653977778528ed51210c0e17cd0380d2fa00ef307cf970c1c16b",
          "plugins/databases-on-aws/skills/dsql/references/query-plan/guc-experiments.md": "7c56a9386a12b4ba90fdc283e46b01b608f88a5df15e2154d02da030e7866104",
          "plugins/databases-on-aws/skills/dsql/references/query-plan/plan-interpretation.md": "de4155ac2bf5d13adff3bf5445ac4c60b382b34bfb25fa0ed5368600a04bc241",
          "plugins/databases-on-aws/skills/dsql/references/query-plan/query-rewrites/cte-late-materialization.md": "9ad0daf044db89c3678db2a5f167e155dec80caaebd66d5d1da48744e03f94bf",
          "plugins/databases-on-aws/skills/dsql/references/query-plan/query-rewrites/flatten-union-all.md": "61efe7ab89a5297e8660e39a7d99b0a0feed333592b155ef66e0ea4d45e9f56d",
          "plugins/databases-on-aws/skills/dsql/references/query-plan/query-rewrites/left-join-to-inner.md": "b699ddb528320c9eb9d5a576233250817010c01245fbd8f06cd80f02be8967a0",
          "plugins/databases-on-aws/skills/dsql/references/query-plan/query-rewrites/not-in-to-not-exists.md": "e4383e19ea4ff72efecf3a3e05f28ea1aa39de653c5d46a1a51261b38d332013",
          "plugins/databases-on-aws/skills/dsql/references/query-plan/query-rewrites/or-to-in.md": "7b39c40d7b3e4db4dfbf8658b10684d76ae48cff689e15b3a4dc93dafb1e4ac0",
          "plugins/databases-on-aws/skills/dsql/references/query-plan/query-rewrites/propagate-filter.md": "3a359c14bfdad065ad78441996031effab1899e361677f1912243a18e220ed67",
          "plugins/databases-on-aws/skills/dsql/references/query-plan/query-rewrites/push-computation-to-constant.md": "f1c7a8c03ab85640b39b1dfcbe3d8189bb8c6da24d59493567d00a72b60b3ccc",
          "plugins/databases-on-aws/skills/dsql/references/query-plan/query-rewrites/push-group-by-into-subquery.md": "aec24ff9759050ca6756a16cd0fc5c979b7e9888e984acf28b667b2547366c15",
          "plugins/databases-on-aws/skills/dsql/references/query-plan/query-rewrites/reltuples-estimate.md": "f12dec472f1bfd2b81af9078e89d7181349fc942c8208e57bc268e295641ea8d",
          "plugins/databases-on-aws/skills/dsql/references/query-plan/query-rewrites/split-large-joins.md": "e0ce11938173b3ef9010faf6781b2c5c71de52d0095c863807379aa858b385e1",
          "plugins/databases-on-aws/skills/dsql/references/query-plan/query-rewrites/subquery-unnesting-correlated.md": "6621fd4068001620d5ad97f3cbaffae1d4e49c4387ddf1919edc615b4532bede",
          "plugins/databases-on-aws/skills/dsql/references/query-plan/query-rewrites/subquery-unnesting-scalar.md": "084e2a6a3ed7e307e3020a53bb99f77898c52646cf8534f193307d0f1f191c08",
          "plugins/databases-on-aws/skills/dsql/references/query-plan/query-rewrites/subquery-unnesting-uncorrelated.md": "8b33947c9d4575ac737efc95bdfc974f23522aac561e105bbb583227bb0357c4",
          "plugins/databases-on-aws/skills/dsql/references/query-plan/query-rewrites-dsql-specific.md": "715a425f8af05c101344f387a04b5d8fbc01e8f4c4029a8181d6528d9c6aa3d5",
          "plugins/databases-on-aws/skills/dsql/references/query-plan/query-rewrites-generic.md": "21217cea5891b431ce776ac9e9efd9e711b92bb5a6a02063e029b3633211ea0c",
          "plugins/databases-on-aws/skills/dsql/references/query-plan/report-format.md": "a4dd65e1a582882aa4410335b043ffba91bacd78d6793c8eec5c638417d1be20",
          "plugins/databases-on-aws/skills/dsql/references/query-plan/workflow.md": "f20a8e9e85a50c699a2f1bddb5e202c1bdb30c2e63846942842ae14478e4b234",
          "plugins/databases-on-aws/skills/dsql/references/system-diagnostics/promql-patterns.md": "1e68e59b253554c8f131ec071063af2b141b5d936eae7cb3a1245318920bddf3",
          "plugins/databases-on-aws/skills/dsql/references/system-diagnostics/wait-events.md": "011b10146bd91d3546d80e02dd842ac4c5df791f36f38244d73b5b139838308c",
          "plugins/databases-on-aws/skills/dsql/references/system-diagnostics/workflow.md": "87c02dd984483e0acf1a2a202c7a46756e123a1dafb90f9adb239cb0680b3abc",
          "plugins/databases-on-aws/skills/dsql/references/troubleshooting.md": "c5cf871d8ff2e6f9c9b66335524f9abb0d7475890a78910bbcc7642c9a206955"
        }
      }
    ],
    "hooks": [
      {
        "path": "plugins/databases-on-aws/hooks/hooks.json",
        "sha256": "5a0a8e710282dd8d2f2f54633d1c35156755417959604a5321104879b2d35ef4",
        "event": "PostToolUse",
        "matcher": "mcp__aurora-dsql.*__transact",
        "declaration": {
          "type": "prompt",
          "prompt": "A DSQL transact operation completed. Verify the result: if it was a DDL change, confirm the schema looks correct using get_schema. If it was a DML change, confirm the affected row count is expected. If it was an EXPLAIN operation, follow up on Query Plan Explainability within the DSQL skill"
        },
        "executed": false
      }
    ],
    "executions": []
  }
}