sql-migrations

Name: sql-migrations
Author: supernoi

SQL Migration Rules - All migrations must be reversible. Always provide a .down.sql file. - Use IF NOT EXISTS / IF EXISTS for idempotency. - Tables singular snake_case (user, trip, vehicle). - Primary

by supernoi(0) 0 installs

Free

Free account. Installing gives you the manifest plus copy-paste snippets.

See reviews

About

Instruction file imported from supernoi/relback (.github/instructions/sql-migrations.instructions.md). Copyright stays with the author.

SQL Migration Rules

All migrations must be reversible. Always provide a .down.sql file.
Use IF NOT EXISTS / IF EXISTS for idempotency.
Tables singular snake_case (user, trip, vehicle).
Primary keys: {table}_id (user_id, trip_id).
Timestamps: TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP.
Index all foreign keys.
Include EXPLAIN ANALYZE output in PR comments for migrations on large tables.

Use it

Copy one of these into your project. Installing also returns the manifest and these snippets.

yaml

targets:
  - https://api.opensmartroute.ai/api/v1/registry/supernoi-relback-sql-migrations-instructions/manifest   # or paste the manifest below

supernoi-relback-sql-migrations-instructions.ocm.jsonjson

{
  "ocm": "1",
  "id": "supernoi-relback-sql-migrations-instructions",
  "kind": "skill",
  "name": "sql-migrations",
  "description": "SQL Migration Rules - All migrations must be reversible. Always provide a .down.sql file. - Use IF NOT EXISTS / IF EXISTS for idempotency. - Tables singular snake_case (user, trip, vehicle). - Primary keys: {table}_id (user_id, trip_id). - Timestamps: TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP. - Index all foreign keys. - Include EXPLAIN ANALYZE output in PR comments for migrations on large tables.",
  "publisher": "supernoi",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "data_analysis",
      "coding"
    ],
    "tags": [
      "skill-md",
      "github-instructions"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "SQL Migration Rules - All migrations must be reversible. Always provide a .down.sql file. - Use IF NOT EXISTS / IF EXISTS for idempotency. - Tables singular snake_case (user, trip, vehicle). - Primary keys: {table}_id (user_id, trip_id). - Timestamps: TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP. - Index all foreign keys. - Include EXPLAIN ANALYZE output in PR comments for migrations on large tables."
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "github-instructions",
      "repository": "https://github.com/supernoi/relback",
      "path": ".github/instructions/sql-migrations.instructions.md",
      "ref": "17ae41a238706386e5cc00c65a7d6abdbcdad2e0",
      "url": "https://github.com/supernoi/relback/blob/17ae41a238706386e5cc00c65a7d6abdbcdad2e0/.github/instructions/sql-migrations.instructions.md",
      "key": "supernoi/relback/.github/instructions/sql-migrations.instructions.md"
    },
    "applies_to": "migrations/**/*.sql"
  },
  "instructions": "## SQL Migration Rules\n- All migrations must be reversible. Always provide a .down.sql file.\n- Use IF NOT EXISTS / IF EXISTS for idempotency.\n- Tables singular snake_case (user, trip, vehicle).\n- Primary keys: {table}_id (user_id, trip_id).\n- Timestamps: TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP.\n- Index all foreign keys.\n- Include EXPLAIN ANALYZE output in PR comments for migrations on large tables.",
  "cost": {
    "context_tokens": 102
  }
}

Fetch it by URL: GET /api/v1/registry/supernoi-relback-sql-migrations-instructions/manifest?version=1.0.0

sql-migrations

About

SQL Migration Rules

Use it

Manifest

Reviews