Skill ファイル

Sql Migration

Name: Sql Migration
Author: twlines

SQLite schema and migration patterns for Maslow

twlines0 スター2026/02/14

職業: データベースアーキテクト
カテゴリ: SQL データベース

スキル内容

SQLite Conventions

Schema Creation

CREATE TABLE IF NOT EXISTS my_table (
  id TEXT PRIMARY KEY,
  project_id TEXT NOT NULL,
  name TEXT NOT NULL,
  metadata TEXT,
  created_at INTEGER NOT NULL,
  updated_at INTEGER NOT NULL,
  FOREIGN KEY (project_id) REFERENCES projects(id) ON DELETE CASCADE
);
CREATE INDEX IF NOT EXISTS idx_my_table_project ON my_table(project_id);

Migrations (Adding Columns)

const cols = db.pragma("table_info(my_table)") as Array<{ name: string }>
if (!cols.some((c) => c.name === "new_column")) {
  db.exec(`ALTER TABLE my_table ADD COLUMN new_column TEXT`)
  db.exec(`CREATE INDEX IF NOT EXISTS idx_my_table_new ON my_table(new_column)`)
}

Prepared Statements

関連 Skill

Sql Migration | Skills Pool

const stmts = {
  getById: db.prepare(`SELECT * FROM my_table WHERE id = ?`),
  create: db.prepare(`INSERT INTO my_table (id, name, created_at) VALUES (?, ?, ?)`),
  update: db.prepare(`UPDATE my_table SET name = ?, updated_at = ? WHERE id = ?`),
}

Sql Migration

SQLite Conventions

Schema Creation

Migrations (Adding Columns)

Prepared Statements

Sql Migration

SQLite Conventions

Schema Creation

Migrations (Adding Columns)

Prepared Statements

Rules

Postgres Patterns

Postgres Patterns

Database Migrations

Postgres Patterns

Postgres Patterns

Jpa Patterns