Databases

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

skills in category: 4,708
pages available: 197

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,393–1,416 of 4,708 skills

Idempotency Key PatternsAImplementing the `Idempotency-Key` HTTP header pattern (Stripe-pioneered, IETF-standardizing) so retries don't double-charge or duplicate side effects — full Postgres schema with recovery-point state machine, fingerprint check, in-progress lock with 409 response, and 24h retention. Grounded in Stripe blog/docs, the IETF httpapi WG draft, and Brandur Leach's canonical implementation.databasesrustgoVotes: 0GitHub stars: 10
Graphql N Plus One DataloaderADiagnose and eliminate the GraphQL N+1 resolver explosion using Facebook DataLoader's per-request batching, plus the second-order defenses (persisted queries, depth limits, cost analysis). Use when a GraphQL query that returns N items in a list triggers N+1 database round trips, when designing nested resolvers that load associations, when a list query times out under load, or when you need to budget query cost before resolvers run. NOT for REST-style endpoint design (use api-versioning-strate...databasesgobashVotes: 0GitHub stars: 10
Drizzle MigrationsAManage 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.databasestypescriptgoVotes: 0GitHub stars: 10
Distributed Tracing W3c ContextAImplementing distributed tracing with W3C Trace Context — the byte-precise `traceparent` and `tracestate` header formats, OpenTelemetry's W3CTraceContextPropagator as the modern default (replacing X-B3-* and X-Datadog-*), head vs tail sampling, and HTTP→SQL trace propagation via sqlcommenter. Grounded in the W3C REC and OpenTelemetry specs.databasesgobashVotes: 0GitHub stars: 10
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