Databases

SQL, NoSQL, schema design, migrations, ORMs, and database operations

skills in category: 4,325
pages available: 181

Security grades appear on each card once the skill has been scanned. Newly imported skills may briefly show without a grade until the backfill job runs.

Open in full browser

Browse databases skills

Showing 1,009–1,032 of 4,325 skills

Dimensional ModelerAStar schema, snowflake schema, SCD types, and Kimball methodology for analytical data modeling. Activate on: dimensional model, star schema, snowflake schema, SCD, fact table, dimension table, Kimball, grain, surrogate key. NOT for: dbt implementation (use dbt-analytics-engineer), warehouse tuning (use data-warehouse-optimizer).databasespythongoVotes: 0GitHub stars: 10
Designing Data Intensive Applications The Big Ideas BehindA### 1. The Fault/Error/Failure Hierarchy NOT for unrelated tasks outside this domain.databasesgosqlVotes: 0GitHub stars: 10
Database Migration PlannerAPlan database migrations before executing them: risk assessment, dependency mapping, multi-service sequencing, rollback budgets, and stakeholder communication plans. Use when deciding HOW to migrate, not when writing the actual DDL. NOT for: writing migration SQL (use database-migration-manager), data ETL pipelines (use data-migration-specialist), query optimization, or ORM configuration.databasesgosqlVotes: 0GitHub stars: 10
Database Migration ManagerASafe database migration manager for zero-downtime DDL changes and rollback plans. Activate on: database migration, schema change, DDL, rollback plan, zero-downtime migration, Prisma migrate, Drizzle kit, Flyway, column rename, table alter. NOT for: query optimization (use database-optimizer), ORM modeling (use data-pipeline-engineer), backup/restore (use devops-automator).databasesgobashVotes: 0GitHub stars: 10
Database Design PatternsASchema design, normalization decisions, indexing strategies, and migration safety for relational databases. Use when designing tables, choosing between normalize vs denormalize, selecting index types, planning zero-downtime migrations, or setting up connection pooling. Activate on "schema design", "normalization", "denormalization", "foreign key", "index strategy", "migration", "connection pooling", "composite key", "surrogate key", "soft delete", "polymorphic association". NOT for PostgreSQL...databasesgosqlVotes: 0GitHub stars: 10
Database Connection Pool ManagerAPgBouncer, connection optimization, and pooling strategies for database performance. Activate on: connection pool, PgBouncer, database connections, pool size, connection limit, Prisma pool, Drizzle pool. NOT for: query optimization (use data-warehouse-optimizer), database schema design (use dimensional-modeler).databasestypescriptgoVotes: 0GitHub stars: 10
D1 And Supabase MigrationsAUse when applying Cloudflare D1 migrations, fighting Supabase migration history vs SQL execution, choosing direct psql over CLI, designing idempotent migrations, debugging schema drift between local and remote, or recovering after a half-applied migration. Triggers: supabase migration repair instructions appearing, table missing after "applied" status, "Tenant or user not found" when running psql, --remote vs --local D1 confusion, NOT NULL on a populated column, foreign key constraint failure...databasesrustgoVotes: 0GitHub stars: 10
Cqrs Event Sourcing ArchitectACQRS pattern, event stores, projections, eventual consistency. Activate on: CQRS, event sourcing, event store, read model, projection, aggregate, domain event, command handler. NOT for: message broker setup (use event-driven-architecture-expert), database optimization (use data-warehouse-optimizer).databasestypescriptgoVotes: 0GitHub stars: 10
SupabaseAComplete Supabase skill — platform layer (Auth, RLS policies, Client SDK JS/Dart/Swift, Storage, Realtime, Edge Functions, CLI migrations) + Postgres SQL layer (query optimization, indexing, connection pooling, schema design, locking, monitoring). Use when integrating Supabase into an app, writing RLS policies, calling supabase-js, handling storage, subscribing to realtime, deploying Edge Functions, or optimizing Postgres queries and schema.databasesjavascriptgoVotes: 0GitHub stars: 3
DatabasesBPostgreSQL database guide — SQL queries, JOINs, CTEs, window functions, indexing, EXPLAIN/ANALYZE, user management, backups, replication, psql CLI. Use when writing SQL queries, designing schemas, optimizing performance, or administering PostgreSQL databases. For Supabase-specific RLS, SDK, and Postgres tuning see the `supabase` skill.databasesbashsqlVotes: 0GitHub stars: 3
Seo DriftASEO drift monitoring — baseline a page's SEO-critical elements (title, meta, canonical, robots, headings, schema, OG tags, Core Web Vitals), diff the current state against that baseline, and classify every change CRITICAL/WARNING/INFO. Git for your SEO — catches the regression a redesign or CMS change introduced, before rankings visibly drop.databasespythongoVotes: 0GitHub stars: 3
Tenant ModelerADefine the tenant model for a SaaS product — what a tenant IS (organization, workspace, account), the hierarchy between those concepts, user-to-tenant membership (roles attached to membership, invitations, users in multiple tenants), ownership semantics, and the full tenant lifecycle from provisioning through suspension to offboarding and purge. Produces a tenant model definition, a lifecycle state machine with per-state access/billing/data posture, and a membership + invitation model. Use wh...databasesrustgoVotes: 0GitHub stars: 4
Data Partitioning Sharding StrategistADesign OLTP partitioning and sharding for WRITE/size scale in a multi-tenant SaaS — shard-key selection (tenant-as-shard-key and its hot-tenant limit), range/hash/list partitioning of large tables, resharding/rebalancing a hot tenant, and the cross-shard query/transaction costs you inherit — all gated behind the DON''T-SHARD-PREMATURELY rule: a well-indexed primary plus read replicas can serve a large SaaS while measured write, size, and maintenance limits permit, so shard ONLY on evidence of...databasesgonodeVotes: 0GitHub stars: 4
Command Gateway ArchitectADesign a single server-side-mediated write path — a command bus — for protected mutations in a multi-tenant SaaS: a command registry plus a per-command pipeline (validate payload → authenticate the actor from the token, never from client-supplied identity → derive trusted target tenant/resource scope → authorize that resolved target against policy → idempotency → execute → emit audit + domain events → safe error envelope), plus the no-direct-client-writes invariant for protected actions. Prod...databasesrustgoVotes: 0GitHub stars: 4
Typeorm ExpertAUse when implementing typeorm functionality with production-grade patterns and safeguards.databasessqlreactVotes: 0GitHub stars: 3
Sqlite ExpertAUse when implementing sqlite functionality with production-grade patterns and safeguards.databasessqltestingVotes: 0GitHub stars: 3
Sql ExpertAUse when implementing SQL functionality with production-grade patterns and safeguards.databasessqlrefactoringVotes: 0GitHub stars: 3
Sequelize ExpertAUse when implementing sequelize functionality with production-grade patterns and safeguards.databasessqldatabaseVotes: 0GitHub stars: 3
ScoutAUse for rapid read-only discovery of files, APIs, and relevant implementation areas.databasesgoexpressVotes: 0GitHub stars: 3
Root ScoutAYou are the scout. You answer questions about the codebase quickly and accurately. You never modify files.databasesgoexpressVotes: 0GitHub stars: 3
Root MigratorAYou are the migrator. You change database schemas and transform data without losing anything or taking the service down.databasessqldatabaseVotes: 0GitHub stars: 3
Root Data PipelineAYou are the data pipeline agent. You build ETL that is observable, resumable, and never silently loses data.databasesgoapiVotes: 0GitHub stars: 3
Rails Activerecord ExpertAUse when implementing rails activerecord functionality with production-grade patterns and safeguards.databasesgorubyVotes: 0GitHub stars: 3
Prisma ExpertAUse when implementing prisma functionality with production-grade patterns and safeguards.databasestypescriptsqlVotes: 0GitHub stars: 3