flyway-migration
Database migration patterns using Flyway with versioned SQL scripts
drizzle-migrations
Manage database schema with Drizzle ORM and SQLite migrations. Use when adding tables, modifying columns, creating indexes, or running migrations. Activates for database schema changes, migration generation, and Drizzle query patterns.
clickhouse-query-optimization
20+ optimization rules for ClickHouse queries. Load when writing queries, debugging slow queries, fixing memory errors, or optimizing JOINs. Achieves 10-100x faster queries, 90% less memory usage.
database-review
PostgreSQL database specialist for query optimization, schema design, security, and performance. Use when writing SQL, creating migrations, or troubleshooting database performance.
postgres-patterns
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
postgres-patterns
基于Supabase最佳实践的PostgreSQL数据库模式，用于查询优化、架构设计、索引和安全。
supabase-postgres
PostgreSQL best practices for Supabase. Use when writing queries, designing schemas, or optimizing database performance.
data-design
Design data layer across PostgreSQL, MongoDB, Elasticsearch, and Typesense. Covers schema design, indexing, migrations, query patterns, consistency, and cross-store sync. Triggers: "data design", "database design", "schema design", "data model", "data architecture".
postgresql
PostgreSQL best practices: multi-tenancy with RLS, schema design, Alembic migrations, async SQLAlchemy, and query optimization. Use when designing multi-tenant tables with Row-Level Security, debugging tenant isolation, creating/changing Alembic migrations, or optimizing PostgreSQL queries. Keywords: PostgreSQL, RLS, Alembic, SQLAlchemy, multi-tenancy.
turso
Turso SQLite database. Covers encryption, sync, agent patterns. Use when working with Turso/libSQL embedded databases, configuring encryption-at-rest, setting up sync replication, or building agent-friendly database patterns. Keywords: Turso, libSQL, embedded, SQLite, encryption, sync.
database-operations-manager
AI-powered database optimization, query analysis, schema design validation, and connection management. Analyzes SQL/NoSQL queries, recommends indexes, validates schema design patterns, and optimizes database performance.
sql-expert
Write, optimize, and explain SQL queries and database design
sqlalchemy-postgres
Load when writing, reviewing, or debugging SQLAlchemy 2.x ORM code against PostgreSQL. Covers the patterns Claude consistently gets wrong: select() vs query(), async session usage, relationship loading, N+1 queries, transactions, and Alembic migration gotchas.
wrds-psql
Use this skill when the user needs to query WRDS data via PostgreSQL from the local machine. Covers psql connection using .pgpass credentials, query execution patterns, CSV/parquet export, and best practices for large extractions. Invoke when the user wants to pull data from WRDS (CRSP, OptionMetrics, Compustat) via SQL.
supabase-postgres-best-practices
PostgreSQL performance optimization guidelines from Supabase. Apply when writing SQL, designing schemas, configuring RLS, or optimizing database performance.
