技能檔案

Github Monolith Migrations

Name: Github Monolith Migrations
Author: luanzeba

Guide for creating database migrations in the GitHub monolith (github/github). Use when creating new tables, adding columns, modifying indexes, or working with database schema changes. Covers required configuration files (tableowners.yaml, database_structure.rb, schema-domains.yml), migration-specific rubocop rules, database clusters, and testing patterns.

luanzeba0 星標2026年2月5日

職業
分類: 數據庫工具

技能內容

Pre-Flight Checklist

When creating migrations, multiple configuration files may need updating:

File	New Table	Add Column	Purpose
`db/migrate/*.rb`	Yes	Yes	The migration itself
`db/tableowners.yaml`	Yes	No	Assign table ownership to a team
`lib/github/database_structure.rb`	Yes	No	Register table in database cluster constant
`db/schema-domains.yml`	Yes	No	Assign table to a schema domain
`sorbet/rbi/dsl/*.rbi`	Yes	Yes	Regenerate with `bin/tapioca dsl`

Generating Migrations

Always use the Rails generator to create migration files:

相關技能

Github Monolith Migrations | Skills Pool

# Create a new table
bin/rails g migration CreateCopilotPolicies

# Add column to existing table
bin/rails g migration AddPolicyStudioAssignmentsToCopilotConfigurations

# Search for existing table definitions
grep -r "your_related_table" lib/github/database_structure.rb

class CreateCopilotPolicies < ActiveRecord::Migration[8.2]
  self.use_connection_class(ApplicationRecord::Copilot)

  def change
    # ...
  end
end

# Find insertion point (alphabetical by table name)
grep -n "copilot_" db/tableowners.yaml | head -10

copilot_policies: github/copilot-policies

# Find the cluster constant
grep -n "COPILOT_TABLES" lib/github/database_structure.rb

COPILOT_TABLES = %w[
  # ... existing tables ...
  copilot_policies
  # ... more tables ...
]

# Find the domain section
grep -n "^copilot:" db/schema-domains.yml

Github Monolith Migrations

Pre-Flight Checklist

Generating Migrations

Github Monolith Migrations

Pre-Flight Checklist

Generating Migrations

Database Clusters

Configuration Files

1. Table Owners (`db/tableowners.yaml`)

2. Database Structure (`lib/github/database_structure.rb`)

3. Schema Domains (`db/schema-domains.yml`)

Database Migrations

Database Migrations

Postgres Patterns

Frontend Query & Mutation

Db Migrations

Drizzle

Github Monolith Migrations

Pre-Flight Checklist

Generating Migrations

Github Monolith Migrations

Pre-Flight Checklist

Generating Migrations

Database Clusters

Configuration Files

1. Table Owners (db/tableowners.yaml)

2. Database Structure (lib/github/database_structure.rb)

3. Schema Domains (db/schema-domains.yml)

Database Migrations

Database Migrations

Postgres Patterns

Frontend Query & Mutation

Db Migrations

Drizzle

1. Table Owners (`db/tableowners.yaml`)

2. Database Structure (`lib/github/database_structure.rb`)

3. Schema Domains (`db/schema-domains.yml`)