sql-databases
414
database-migrations-sql-migrations
SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, SQL Server
Dokhacgiakhoa
databases
sorting
stars
current ordering strategy
query
all entries
refine the visible subset
sql-databases
414
neon-postgres
Expert patterns for Neon serverless Postgres, branching, connection pooling, and Prisma/Drizzle integration Use when: neon database, serverless postgres, database branching, neon postgres, postgres serverless.
Dokhacgiakhoa
databases
sql-databases
414
postgres-best-practices
PostgreSQL and Supabase optimization guide.
Dokhacgiakhoa
databases
sql-databases
414
postgresql
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
Dokhacgiakhoa
databases
sql-databases
414
database-design
Database design principles and decision-making.
Dokhacgiakhoa
databases
sql-databases
414
sql-optimization-patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
Dokhacgiakhoa
databases
sql-databases
397
table-schema
Define evidence-first table schemas for a survey: what each table must answer, row unit, columns, and which evidence-pack fields are required to fill it. **Trigger**: table schema, schema-first tables, table design, 表格 schema, 先 schema 后填充. **Use when**: you want survey tables that are verifiable and fillable before LaTeX (typically Stage C4, after evidence packs exist). **Skip if**: `outline/table_schema.md` already exists and is refined (covers both index tables and Appendix tables; no placeholders; evidence mapping is explicit). **Network**: none. **Guardrail**: no invented facts; schema must be checkable and map each column to an evidence source.
WILLOSCAR
databases
sql-databases
394
clickhouse-best-practices
MUST USE when reviewing ClickHouse schemas, queries, or configurations. Contains 28 rules that MUST be checked before providing recommendations. Always read relevant rule files and cite specific rules in responses.
ClickHouse
databases
sql-databases
393
mysql
Plan and review MySQL/InnoDB schema, indexing, query tuning, transactions, and operations. Use when creating or modifying MySQL tables, indexes, or queries; diagnosing slow/locking behavior; planning migrations; or troubleshooting replication and connection issues. Load when using a MySQL database.
planetscale
databases
sql-databases
391
convex-schema-validator
Defining and validating database schemas with proper typing, index configuration, optional fields, unions, and migration strategies for schema changes
waynesutton
databases
sql-databases
389
database-postgresql
Enforce repository patterns, zero-downtime migrations, and indexing standards for PostgreSQL with TypeORM or Prisma. Use when defining entities, writing migrations, adding RLS policies, or optimizing query performance. (triggers: **/*.entity.ts, prisma/schema.prisma, **/migrations/*.sql, TypeOrmModule, PrismaService, PostgresModule)
HoangNguyen0403
databases
sql-databases
389
database-mongodb
Apply expert schema design, indexing, and performance rules for MongoDB. Use when designing MongoDB schemas, creating indexes, or optimizing NoSQL query performance. (triggers: **/*.ts, **/*.js, **/*.json, mongo, mongoose, objectid, schema, model)
HoangNguyen0403
databases
sql-databases
388
models-standards
Define database models with clear naming, appropriate data types, constraints, relationships, and validation at multiple layers. Use this skill when creating or modifying database model files, ORM classes, schema definitions, or data model relationships. Apply when working with model files (e.g., models.py, models/, ActiveRecord classes, Prisma schema, Sequelize models), defining table structures, setting up foreign keys and relationships, configuring cascade behaviors, implementing model validations, adding timestamps, or working with database constraints (NOT NULL, UNIQUE, foreign keys). Use for any task involving data integrity enforcement, relationship definitions, or model-level data validation.
maxritter
databases
sql-databases
388
write-sql-queries
Guide for writing SELECT, INSERT, UPDATE, DELETE queries with workers-qb
G4brym
databases
sql-databases
382
fantasia-sqlite-main
Designs SQLite usage in Fantasia Archive’s Electron main process: file locations under userData, native better-sqlite3 module constraints, and migrations. Use when editing electron-main database code, schema, or persistence paths.
vishiri
databases
sql-databases
376
postgres-patterns
PostgreSQL 数据库模式，用于查询优化、架构设计、索引和安全性。基于 Supabase 最佳实践。
xu-xiang
databases
sql-databases
376
postgres-patterns
PostgreSQL 数据库模式，涵盖查询优化、架构设计、索引和安全。基于 Supabase 最佳实践。
xu-xiang
databases
sql-databases
376
database-migrations
跨 PostgreSQL、MySQL 及常用 ORM（Prisma、Drizzle、Django、TypeORM、golang-migrate）的模式变更（schema changes）、数据迁移、回滚及零停机部署（zero-downtime deployments）的数据库迁移最佳实践。
xu-xiang
databases
