All categories
Databases
SQL, NoSQL, schema design, migrations, ORMs, and database operations
- 4,325
- 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 browserBrowse databases skills
Showing 1,153–1,176 of 4,325 skills
- Prisma Migrations> Manage database schema evolution with prisma migrate dev/deploy/reset and migration historyVotes: 0GitHub stars: 20
- Prisma Filtering Sorting> Filter and sort Prisma queries with where, AND/OR/NOT, orderBy, and cursor/offset paginationVotes: 0GitHub stars: 20
- Prisma Client Queries> Query data with Prisma Client findUnique/findMany, create/update/delete, upsert, select, includeVotes: 0GitHub stars: 20
- Perf Query Optimization> Master database query optimization — EXPLAIN and EXPLAIN ANALYZE for query plan analysis, identifying sequential scans and inefficient joins, rewriting queries for index utilization, understanding the query optimizer's cost model, and diagnosing slow queries in PostgreSQL and MySQL.Votes: 0GitHub stars: 20
- Perf N Plus One> Master N+1 query elimination — detecting N+1 patterns in ORMs and GraphQL resolvers, eager loading strategies, DataLoader batching, query count monitoring, and ORM-specific solutions for Prisma, Drizzle, Sequelize, and TypeORM.Votes: 0GitHub stars: 20
- Perf Index Strategies> Master database indexing — B-tree index mechanics and column ordering, composite indexes for multi-column queries, partial indexes for filtered subsets, covering indexes for index-only scans, GIN indexes for JSONB and full-text search, GiST for geometric and range data, and index maintenance strategies.Votes: 0GitHub stars: 20
- Perf Connection Pooling> Master database connection pooling — pool sizing formulas, connection lifecycle overhead, PgBouncer transaction-mode pooling, serverless connection management, pool monitoring and diagnostics, and configuration for PostgreSQL, MySQL, and managed database services.Votes: 0GitHub stars: 20
- Owasp Injection Prevention> Eliminate SQL, NoSQL, and command injection by never concatenating untrusted input into queries or commandsVotes: 0GitHub stars: 20
- Otel Tracing Pattern> Instrument distributed traces with OpenTelemetry spans to visualize request flow across servicesVotes: 0GitHub stars: 20
- Node Testing Patterns> Test Node.js APIs and modules using supertest, nock, and test containersVotes: 0GitHub stars: 20
- Node Environment Config> Manage environment configuration with process.env, dotenv, and validation for 12-factor appsVotes: 0GitHub stars: 20
- Microservices Outbox Pattern> Guarantee at-least-once event delivery using a transactional outbox and polling publisher.Votes: 0GitHub stars: 20
- Microservices Health Check> Implement /health and /ready endpoints for liveness and readiness probes in containers.Votes: 0GitHub stars: 20
- Harness State Management> Manage persistent state across agent sessions so that context, decisions, progress, and learnings survive context resets. Load state at session start, track position and decisions throughout, and save state for the next session.Votes: 0GitHub stars: 20
- Harness Sql Review> Adversarial review of SQL queries for performance anti-patterns, missing indexes, N+1 queries, and unsafe operations. Analyzes raw SQL, ORM-generated queries, and migration scripts to produce optimization recommendations with estimated impact.Votes: 0GitHub stars: 20
- Harness Soundness Review> Deep soundness analysis of specs and plans. Auto-fixes inferrable issues, surfaces design decisions to you. Runs automatically before sign-off.Votes: 0GitHub stars: 20
- Harness Pulse> Single-page time-windowed product pulse. **Phase 3 ships the first-run interview only**: it converts vague intent into a concrete `pulse:` block in `harness.config.json`, refuses read-write DB credentials, and seeds from `STRATEGY.md` when present. The actual `harness pulse run` (Phases 2-4 of the runtime) is deferred to spec Phase 4.Votes: 0GitHub stars: 20
- Harness Event Driven> Architectural guide for message queues, event sourcing, CQRS, and saga patterns. Maps event flows, designs topic topologies, validates delivery guarantees, and produces event catalog documentation.Votes: 0GitHub stars: 20
- Harness Database> Advisory guide for schema design, migrations, ORM patterns, and migration safety. Detects your ORM, analyzes schema health, produces safe migrations, and validates backward compatibility.Votes: 0GitHub stars: 20
- Harness Caching> Advisory guide for cache strategies, invalidation patterns, and distributed caching. Detects existing cache usage, analyzes access patterns, designs cache layers with proper invalidation, and validates consistency guarantees.Votes: 0GitHub stars: 20
- Events Outbox Pattern> Reliably publish domain events using the transactional outbox and CDC polling approach.Votes: 0GitHub stars: 20
- Drizzle With Nextjs> Integrate Drizzle with Next.js using Neon/Vercel Postgres, edge runtime, and connection poolingVotes: 0GitHub stars: 20
- Drizzle Transactions> Execute atomic Drizzle operations with db.transaction(), nested transactions, and rollback semanticsVotes: 0GitHub stars: 20
- Drizzle Schema Definition> Define Drizzle ORM schemas with pgTable/mysqlTable/sqliteTable, column types, indexes, and constraintsVotes: 0GitHub stars: 20