flyway-consolidate
Analyze and consolidate Flyway SQL migrations into clean, domain-grouped CREATE TABLE migrations for pre-production projects. Use when consolidating database migrations, refactoring Flyway schemas, simplifying migration history, grouping tables by domain, or when user mentions "consolidate migrations", "merge migrations", "clean up Flyway", "refactor schema", "baseline migrations".
database-selection
Database selection: PostgreSQL as default, Redis for ephemeral, NoSQL comparison, specialized databases, polyglot persistence. Use when choosing databases.
migration-strategies
Migration strategies: zero-downtime deployments, expand-contract schema changes, database migrations, framework migrations. Use when planning system migrations.
mysql-patterns
MySQL database patterns for query optimization, schema design, indexing, and security. Quick reference for common patterns.
postgres-patterns
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
role-databasereplication-ha
High availability and replication topologies across all database engines. Synchronous/asynchronous/semi-synchronous replication, primary-secondary, multi-primary, quorum-based. PostgreSQL streaming/logical replication, MySQL GTID/Group Replication, MongoDB replica sets, Redis Sentinel/Cluster, Cassandra multi-DC. Consensus protocols (Raft, Paxos, Gossip). Failover automation, split-brain prevention. Use when designing HA architectures, configuring replication, or troubleshooting failover.
database-optimizer
Use when investigating slow queries, analyzing execution plans, or optimizing database performance. Invoke for index design, query rewrites, configuration tuning, partitioning strategies, lock contention resolution.
databricks-lakebase-autoscale
Patterns and best practices for Lakebase Autoscaling (next-gen managed PostgreSQL). Use when creating or managing Lakebase Autoscaling projects, configuring autoscaling compute or scale-to-zero, working with database branching for dev/test workflows, implementing reverse ETL via synced tables, or connecting applications to Lakebase with OAuth credentials.
activerecord
This skill should be used when the user asks to "write a migration", "add a column", "add column to table", "create an index", "add a foreign key", "set up associations", "fix N+1 queries", "optimize queries", "add validations", "create callbacks", "use eager loading", or mentions ActiveRecord, belongs_to, has_many, has_one, :through associations, polymorphic associations, inverse_of, touch: true, counter_cache, dependent: destroy, where clauses, scopes, includes, preload, eager_load, joins, find_each, batch processing, counter caches, foreign key constraints, or database constraints. Should also be used when editing *_model.rb files, working in app/models/ directory, db/migrate/, discussing query performance, N+1 prevention, validation vs constraint decisions, or reviewing database schema design.
git-back-to-main
Discard local changes, switch to main, and pull latest
resend-setup
Configure Resend for transactional emails like password resets and email verification.
supabase-postgres
用于 Supabase 平台开发与 PostgreSQL 最佳实践，包含 RLS、Edge Functions 和实时订阅。来源：supabase 官方 52.5K installs。
relationship-query
Query relationships in SpiceDB/Kessel via the RBAC relations API
role-backendcaching-strategies
Implements caching solutions using Redis patterns (cache-aside, write-through, write-behind), Memcached, cache invalidation strategies, TTL design, cache stampede prevention, CDN configuration, and distributed caching. Use when optimizing read performance, reducing database load, designing cache layers, or configuring CDN rules.
surrealdb-python
Master SurrealDB 2.3.x with Python for multi-model database operations including CRUD, graph relationships, vector search, and real-time queries. Use when working with SurrealDB databases, implementing graph traversal, semantic search with embeddings, or building RAG applications.
mssql-tools
SQL Server (MSSQL) 数据库工具集，用于连接数据库实例、列出所有表、查看表结构、执行 SQL 查询等操作。当需要操作 SQL Server 数据库、查询数据、分析表结构时使用此技能。支持通过命令行参数指定 server、port、user、password、database 等连接信息，可代替 mssql mcp 服务使用。支持 Windows、macOS 和 Linux 平台。
