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 337–360 of 4,314 skills

Prisma PatternsAPrisma ORM patterns for TypeScript backends — schema design, query optimization, transactions, pagination, and critical traps like updateMany returning count not records, $transaction timeouts, migrate dev resetting the DB, @updatedAt skipped on bulk writes, and serverless connection exhaustion.databasestypescriptgoVotes: 0GitHub stars: 17
Mysql PatternsAMySQL and MariaDB schema, query, indexing, transaction, replication, and connection-pool patterns for production backends.databasesjavascriptpythonVotes: 0GitHub stars: 17
Shucheng Budget Data ModelA提供预算系统数据模型的完整定义，包括所有表名、字段名、数据类型等。当用户需要查询预算相关数据模型结构、编写数据查询脚本、或需要了解特定表的字段信息时使用此技能。databasessqlVotes: 0GitHub stars: 12
Ai Intelligent Asset ManagementAIT 资产管理，硬件/软件全生命周期。databasespythonbashVotes: 0GitHub stars: 12
Database DesignerAUse when the user asks to design database schemas, plan data migrations, optimize queries, choose between SQL and NoSQL, or model data relationships.databasesgosqlVotes: 0GitHub stars: 12
Quality Gates PostgresAQuality gates determinísticos para PostgreSQL. Use quando o usuário pedir "quality gate PostgreSQL", "quality gate Postgres", migrations ou schema drift PostgreSQL, constraints ou índices PostgreSQL, EXPLAIN, plano de consulta ou baseline para PostgreSQL.databasesgosqlVotes: 0GitHub stars: 3
Dknet IdempotencyACovers DKNet.AspCore.Idempotency (the RequiredIdempotentKey endpoint filter on RouteHandlerBuilder/RouteGroupBuilder, AddIdempotentKey, IdempotencyOptions, IdempotentConflictHandling, key scope resolution) plus its store packages DKNet.AspCore.Idempotency.Relational (internal EF Core base, never referenced by apps), DKNet.AspCore.Idempotency.MsSqlStore (AddIdempotencyWithMsSqlStore), DKNet.AspCore.Idempotency.NpgsqlStore (AddIdempotencyWithNpgsqlStore), and DKNet.AspCore.Idempotency.RedisStor...databasesrustgoVotes: 0GitHub stars: 6
Dknet Efcore Save PipelineACovers DKNet.EfCore.Hooks, DKNet.EfCore.Events, and DKNet.EfCore.AuditLogs: the three SaveChangesAsync interceptors that stamp, dispatch, and audit around one EF Core write. APIs: AddDbContextWithHook, IBeforeSaveHookAsync/IAfterSaveHookAsync/IHookAsync/HookAsync, AddHook, DisableHooks, SnapshotContext (before/after SaveChanges hook, IHook wiring); AddEventPublisher, IEventPublisher, DefaultEventPublisher, AddEvent/AddEvent<TEvent>(), [RaisesEvent], EventOperations, EventException (domain eve...databasesgosqlVotes: 0GitHub stars: 6
Dknet Efcore Domain ModelACovers DKNet.EfCore.Abstractions, DKNet.EfCore.Extensions and DKNet.EfCore.Relational.Helpers: Entity<TKey>/Entity/AuditedEntity base classes, IConcurrencyEntity/ISoftDeletableEntity, GUID v7 keys, and the [RaisesEvent] declaration, [Sequence]/[SqlSequence], [AuditLog]/[SensitiveData] attributes; UseAutoConfigModel, IEntityTypeConfiguration discovery via DefaultEntityTypeConfiguration, global query filter (GlobalQueryFilter), data seeding, SQL sequences (NextSeqValue), SnapshotContext, SaveCh...databasesrustgoVotes: 0GitHub stars: 6
Create Auth SkillAScaffold and implement authentication in TypeScript/JavaScript apps using Better Auth. Detect frameworks, configure database adapters, set up route handlers, add OAuth providers, and create auth UI pages. Use when users want to add login, sign-up, or authentication to a new or existing project with Better Auth.databasesjavascripttypescriptVotes: 0GitHub stars: 2
Better Auth Best PracticesAConfigure Better Auth server and client, set up database adapters, manage sessions, add plugins, and handle environment variables. Use when users mention Better Auth, betterauth, auth.ts, or need to set up TypeScript authentication with email/password, OAuth, or plugin configuration.databasestypescriptrustVotes: 0GitHub stars: 2
Edward Arinin Web Dev Dexe OtcARun a DeXe OTC token sale end-to-end — open a multi-tier TokenSaleProposal, vote+execute it, then buyers check status / buy / claim. Covers the five dexe_otc_* composites plus the PRECISION-1e25 rate, native-BNB sentinel, and claim-timing gotchas. Use when the user mentions "OTC", "token sale", "sell DAO tokens", "buy from a tier", "claim vested tokens".databasesgoawsVotes: 0GitHub stars: 76
Cyanheads Api WorkersACloudflare Workers deployment using `createWorkerHandler` from `@cyanheads/mcp-ts-core/worker`. Covers the full handler signature, binding types, CloudflareBindings extensibility, runtime compatibility guards, and wrangler.toml requirements.databasessqlnodeVotes: 0GitHub stars: 76
Cyanheads Api MirrorAStand up a persistent, self-refreshing local mirror of a bulk upstream dataset with the MirrorService (@cyanheads/mcp-ts-core/mirror). Use when a server wraps a large or slow API and should query a synced local index (embedded SQLite + FTS5) instead of paginating the live API per request.databasessqlnodeVotes: 0GitHub stars: 76
Ashrafiucse Dependency VulnsBChecks project dependencies for known vulnerabilities (CVEs, GHSAs, PYSA, RUSTSEC, etc.) against the OSV.dev database. Finds lockfiles/manifests across npm, pip, Poetry, Bundler, Cargo, Composer, Go modules, Maven, NuGet, and Pub, queries live advisories for the exact installed versions, and also flags absent lockfiles, deprecated packages, and unpinned installs. Use when auditing dependencies or investigating a specific package's vulnerabilities.databasespythonrustVotes: 0GitHub stars: 76
Laravel PatternsALaravel架构模式、路由/控制器、Eloquent ORM、服务层、队列、事件、缓存以及用于生产应用的API资源。databasesphpapiVotes: 0GitHub stars: 3
Jason ChenAJason Chen 的 PHP/Laravel 开发经验技能，基于多年实战经验总结的最佳实践、问题解决方案和开发智慧。涵盖 PHP 基础、Laravel 框架、数据库优化、前端技术、DevOps、架构设计、性能优化和安全实践等方面。databasesphpshellVotes: 0GitHub stars: 3
Database DesignA数据库设计规范，涵盖迁移文件命名、表结构、字段类型、索引策略、外键约束与性能优化。用于创建或修改迁移文件、设计数据表结构、评审数据库设计。databasesgophpVotes: 0GitHub stars: 3
Db QueryAUse this skill to run SQL queries against the jishono database. Trigger for requests like "query the database", "run a SQL query", "check the data", "look up rows", "count entries", or any task that requires reading from or writing to the PostgreSQL database. Supports both the local dev database (via Docker) and the prod database (on localhost:5433).databasesbashsqlVotes: 0GitHub stars: 3
Db MigrateAUse this skill whenever the user wants to run, apply, or check database migrations in the jishono-backend repo. Trigger for requests like "run migrations", "apply pending migrations", "create a new migration", "roll back migration", "check migration status", "what migrations are pending", or "migrate the database". Also trigger when a new feature requires schema changes and the user wants help creating a migration file.databasesbashsqlVotes: 0GitHub stars: 3
BrainstormingAGenerate and explore ideas effectively. Use when starting new projects, solving problems, or exploring solutions. Covers ideation techniques and divergent thinking.databasessqlVotes: 0GitHub stars: 34
Data ManagementADesign and manage data storage effectively. Use when working with databases, schemas, or data migrations. Covers schema design, migrations, and data integrity.databasesjavabashVotes: 0GitHub stars: 34
Writing AdrsADocument architectural decisions. Use when making significant technical decisions that should be recorded. Covers ADR format and decision documentation.databasessqlapiVotes: 0GitHub stars: 34
Excalidraw CLI — Agent SkillACreate hand-drawn diagrams from JSON using `excalidraw-cli`. Outputs `.excalidraw` files and shareable URLs.databasesgobashVotes: 0GitHub stars: 97