tdc-database
Manage MySQL database for The Dreamer's Cave. Use for schema, migrations, queries, backup/restore.
Manage MySQL database for The Dreamer's Cave. Use for schema, migrations, queries, backup/restore.
This skill should be used when the user asks about "migrations", "database schema", "create_table", "add_column", "remove_column", "add_index", "foreign keys", "db:migrate", "db:rollback", "schema.rb", "change_column", "reversible", "references", "timestamps", or needs guidance on modifying database structure in Rails applications.
Guide through safe database schema modification and migration generation for Drizzle ORM with D1 database. Use when modifying server/database/schema.ts or managing database changes.
Implementing and optimizing database connection pools for high-performance applications.
WHEN: Database migration review, backwards compatibility, rollback safety, data integrity WHAT: Migration safety + Rollback validation + Downtime analysis + Data preservation + Lock prevention WHEN NOT: Query optimization → sql-optimizer, Schema design → schema-reviewer
Apply SQL migration files to JusticeHub Supabase database with verification and error handling.
PostgreSQL expert for .sql migration files, CREATE TABLE, ALTER TABLE, indexes, constraints, foreign keys, schema changes, docker/postgres/migrations/, init.sql, idempotent SQL, transactions, BEGIN/COMMIT, psql, database testing, schema_migrations
Execute SQL queries, migrations, and RLS policies on Supabase database using MCP tools
Advanced Database Reliability Engineering, Performance, and Safe Migrations
Sequelize migration patterns and best practices for PostgreSQL schema changes. Use when creating migrations, modifying tables, managing indexes, or handling data migrations safely.
Write secure, optimized database queries using parameterized statements, eager loading, and proper indexing to prevent SQL injection and N+1 query problems. Use this skill when writing database queries, using ORM query methods, implementing data fetching logic, or optimizing database performance. When working with SQL queries, ORM query builders, repository patterns, or data access layers. When implementing joins, eager loading, query optimization, transactions, or query caching. When selecting data, filtering records, or fetching related associations in service files, repository files, or controller methods.
Create and manage Supabase database migrations using MCP tools. Use when creating tables, modifying schemas, adding RLS policies, or working with database structure.
Safe database migration creation and management for Supabase PostgreSQL
Review Drizzle ORM migrations for MySQL. Checks for potential data loss, performance issues, missing indexes, and schema alignment. Use when reviewing changes in the drizzle/ directory or schema.ts files.
MongoDB database development - queries, aggregations, schema analysis using MCP tools
Manage LibSQL/Turso database schemas with Zod validation, create migrations, and ensure type-safe database operations.
Use this when changing the database schema, generating/applying Drizzle migrations for Cloudflare D1 (SQLite), or working with Better Auth schema generation.
Add, manage, and execute SQL scripts in self-hosted Metabase via REST API. Supports creating cards/questions, running queries, and managing collections. Use when: Creating Metabase dashboards programmatically, automating report generation, managing SQL questions/cards via API, or integrating Metabase with the casino platform.
Use before implementing pgdbm patterns to avoid common mistakes - provides rationalization table and red flags that prevent pool multiplication, schema errors, and template syntax violations
Write effective, type-safe Kysely queries for PostgreSQL. This skill should be used when working in Node.js/TypeScript backends with Kysely installed, covering query patterns, migrations, type generation, and common pitfalls to avoid.
Use when working with SQLiteData library (@Table, @FetchAll, @FetchOne macros) for SQLite persistence, queries, writes, migrations, or CloudKit private database sync.
PostgreSQL MCPでスキーマ確認とread-only分析を行う。集計・意思決定資料が必要な時に使う。