Databases

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

skills in category: 4,314
pages available: 180

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 433–456 of 4,314 skills

Db MigrationsAUse when running, planning, or discussing database migrations, schema changes, or data transformations against any environmentdatabasesrustgoVotes: 0GitHub stars: 22
Convex Performance AuditADiagnose and fix performance problems in Convex applications, one problem class at a time.databasesgoreactVotes: 0GitHub stars: 22
Convex Migration HelperASafely migrate Convex schemas and data when making breaking changes.databasestypescriptapiVotes: 0GitHub stars: 22
Smith Architecture DecisionsAUse this skill when a build requires a technical call that will be expensive to reverse later. Storage choice. Sync vs. async. Library swap. Monolith vs. service split. Schema shape for a domain object the rest of the system will lean on. Auth boundary. The test: if you'd be embarrassed to discoverdatabasesgoVotes: 0GitHub stars: 10
Database Migration SkillADatabase schema evolution with Prisma, Alembic, Django — workflows, rollback, zero-downtime, seed data, migration testing.databasestypescriptpythonVotes: 0GitHub stars: 6
Typeorm MigrationsACreating TypeORM database migrations. Use when schema changes are needed (new columns, tables, indexes, constraints).databasestypescriptgoVotes: 0GitHub stars: 33
Persistence Query ReviewADesign and review Ayunis Core database access for avoidable round trips, check-then-act races, N+1 queries, and stale writes. Use when modifying or reviewing repositories, finders, QueryBuilder code, or application code that issues database calls in loops.databasessqldatabaseVotes: 0GitHub stars: 33
38 Architecture DeepenerAEncontra oportunidades de "deepening" no codebase — refactors que transformam modulos shallow (interface complexa, implementacao simples) em deep (interface simples, implementacao rica). Foco em testabilidade e AI-navigability. Use quando usuario quiser melhorar arquitetura, encontrar oportunidades de refactor, consolidar modulos acoplados, ou preparar codebase para trabalho de agente. Trigger em: "deepening", "deep module", "shallow module", "refactor architecture", "improve architecture", "...databasesgobashVotes: 0GitHub stars: 23
03 Backend ApiASkill do Backend Developer para definição de APIs, banco de dados, e lógica de servidor. Use quando precisar definir schemas de banco, endpoints REST/GraphQL, validação server-side, autenticação, migrations, ou qualquer lógica de backend. Trigger em: "API", "endpoint", "banco de dados", "schema", "migration", "backend", "servidor", "autenticação", "JWT", "middleware", "ORM", "Prisma", "PostgreSQL", "Node.js", "Express", "NestJS", "validação server-side".databasestypescriptgoVotes: 0GitHub stars: 23
Complete IssueAImplement a change end-to-end from a freeform prompt - settle the requirements, design the engineering approach and get it approved, implement with TDD, run the format/compile/credo/coveralls gates without shortcuts, self-review the diff like a senior engineer, QA the finished change in the running app, record a demo video when it is visible there, then commit and open the PR. Use when the user wants to "complete an issue", "work the ticket", or hands over a description of something to build.databasesgoshellVotes: 0GitHub stars: 17
Sqlite OptimizerAUse this agent when you need expert SQLite database optimization, schema design review, or performance analysis for SQLite-backed applications. This agent should be invoked when reviewing DDL, designing indexing strategies, evaluating WAL/journal configuration, diagnosing write contention, analyzing query plans with EXPLAIN QUERY PLAN, or optimizing ent/GORM ORM usage against SQLite. Covers SQLite-specific constraints that differ materially from PostgreSQL (single-writer, type affinity, limit...databasesgosqlVotes: 0GitHub stars: 8
Postgres OptimizerAUse this agent when you need expert PostgreSQL database optimization,databasesgosqlVotes: 0GitHub stars: 8
Golang DatabaseAComprehensive guide for Go database access — parameterized queries, struct scanning, NULLable columns, transactions, isolation levels, SELECT FOR UPDATE, connection pool, batch processing, context propagation, and migration tooling. Use when writing, reviewing, or debugging Golang code that interacts with PostgreSQL, MariaDB, MySQL, or SQLite; for database testing; or for questions about database/sql, sqlx, or pgx. Does NOT generate database schemas or migration SQL.databasesgobashVotes: 0GitHub stars: 8
ReviewAComprehensive PostgreSQL schema analysis to identify optimization opportunitiesdatabasesbashsqlVotes: 0GitHub stars: 8
AntipatternsAScan PostgreSQL codebase and schema for anti-patterns using postgres-optimizer agentdatabasesrustgoVotes: 0GitHub stars: 8
Backend DevelopmentAWorking on the RomM Python backend (backend/), a FastAPI app with SQLAlchemy 2.1, Alembic, RQ/Redis, and Socket.IO. Use when adding or changing API endpoints, handlers, ORM models, response schemas, metadata-provider adapters, background tasks, database migrations, or backend tests. Covers the layered architecture, conventions, auth/scopes, the OpenAPI→frontend type pipeline, and the uv/pytest/alembic/trunk workflow. Trigger on any work under backend/.databasestypescriptpythonVotes: 0GitHub stars: 13,244
Guru Reactivate TaskAReactivate one normally finished archived task while preserving its identity and routing the fresh work.databasesreactgitVotes: 0GitHub stars: 8
Guru Merge Task DeliveryAMerge one reviewed active-task Delivery PR through a semantic live gate, exact merge-commit trailers, and terminal recovery.databasesbashgitVotes: 0GitHub stars: 8
Guru Finish TaskAPersist Completion and Closure into one reviewed task archive and terminal bookkeeping result.databasesreactgitVotes: 0GitHub stars: 8
Guru Complete Task ClosureAApply the exact source Issue disposition after Completion approval and return a recoverable closure result.databasesVotes: 0GitHub stars: 8
Guru Cleanup Task ResourcesAClean sealed Guru-owned resources or explicitly selected manual and machine-handoff targets.databasesgitVotes: 0GitHub stars: 8
Explain LptsAComprehensive reference for the LPTS pipeline — LogicalPlan to AST to CTE List to SQL string. Covers AST node hierarchy, CTE node hierarchy, column binding maps, expression resolution, and operator-specific conversion logic. Auto-loaded when discussing the pipeline, AST nodes, CTE generation, or operator handling.databasessqlnodeVotes: 0GitHub stars: 10
Explain Lpts DdlAReference for LPTS DDL syntax — PRAGMA lpts, lpts_query, the lpts_check round-trip setting, lpts_normalize_query, dialect settings, and print_ast. Auto-loaded when discussing LPTS usage, pragmas, table functions, round-trip checks, or dialect configuration.databasessqlexpressVotes: 0GitHub stars: 10
Server Function ValidationAA server function checks every argument against a valibot schema from src/server/validate.ts before it acts, because the parameter types are gone by the time a call arrives. Applies whenever adding a 'use server' function or giving an existing one something new to read.databasesgosecurityVotes: 0GitHub stars: 5