All categories
Databases
SQL, NoSQL, schema design, migrations, ORMs, and database operations
- 4,708
- 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 browserBrowse databases skills
Showing 4,369–4,392 of 4,708 skills
- Data InsightsGenerate actionable insights from transaction data. Use when implementing insight generators, anomaly detection, or data analysis features for financial/tax tracking applications.Votes: 0GitHub stars: 666
- Data ImporterImport Synnovator platform data from .synnovator/*.md files into SQLite database via SQLAlchemy models. Use when need to populate test data, initialize database from file-based data, or migrate .synnovator content to relational database. Triggers include "import synnovator data", "populate database from .synnovator", "fill database with test data", or when user needs to test FastAPI endpoints with real data.Votes: 0GitHub stars: 666
- Data Import WorkflowManaging the lifecycle of weapon and mod data from external sources to the local databaseVotes: 0GitHub stars: 666
- Data DesignData modeling, schema design, and data architectureVotes: 0GitHub stars: 666
- Data ArchitectureData architecture - models, relationships. Use when designing data structures.Votes: 0GitHub stars: 666
- Data And SqlUse when writing SQL queries, optimizing database performance, or analyzing dataVotes: 0GitHub stars: 666
- Data Analyst Sql OptimizationApply SQL optimization patterns including index usage, query rewriting, JOIN optimization, and window functions. Use when improving query performance or analyzing slow queries. This skill provides comprehensive SQL optimization patterns and best practices: - N+1 query elimination - Index optimization strategies - JOIN vs subquery performance - Window functions for complex aggregations - Query execution plan analysis Triggers: "optimize SQL", "slow query", "improve performance", "SQL最適化", "ク...Votes: 0GitHub stars: 666
- Data Analysis SqlSQL for data analysis with exploratory analysis, advanced aggregations, statistical functions, outlier detection, and business insights. 50+ real-world analytics queries.Votes: 0GitHub stars: 666
- Tech Selection Explain将技术选型决策转换为业务语言解释，生成客户友好的技术说明。当ARCH中技术术语过多、需要向PM/客户解释时使用。Votes: 0GitHub stars: 5
- Client Arch Explain生成客户友好的架构说明（通俗语言解释架构层次、数据流、技术选型），适合演示和评审会议。当准备客户演示或用户验收前使用。Votes: 0GitHub stars: 5
- Crud ImplementationComplete workflow guide for implementing new CRUD entities. Use when adding a new resource, implementing full CRUD operations, or needing an overview of the database-to-API flow. Triggers: "new entity", "add resource", "implement CRUD", "create table and API". Orchestrates add-database-table, add-domain-entity, and add-api-endpoint skills.Votes: 0GitHub stars: 666
- Crud Development定义若依（RuoYi / RuoYi-Vue-Plus 生态）在数据持久层（Mapper）与业务层（Service）的 CRUD 开发规范。要求 Mapper 统一继承 `BaseMapperPlus<Entity,Vo>`、Service 统一实现 `IService<Entity>` 并采用标准实现基类；查询/更新条件强制使用 `LambdaQueryWrapper` / `LambdaUpdateWrapper` 构建类型安全条件；分页统一使用 `PageQuery` + `TableDataInfo<T>` 返回。严禁循环执行 SQL、严禁直接返回 Entity 给前端、严禁 `SELECT *`，写操作强制采用批量 API 与 VO/DTO 封装，提升代码一致性、可维护性与性能。Votes: 0GitHub stars: 666
- Cross Service IntegrationUse when designing or implementing cross-service communication, data synchronization, or service boundary patterns.Votes: 0GitHub stars: 666
- Cross Env Postgresql ExtensionsActivate when creating database migrations that enable or disable PostgreSQL extensions. Provides the DO block pattern for cross-environment compatibility between Nhost Cloud, CNPG (CloudNativePG), and other PostgreSQL environments.Votes: 0GitHub stars: 666
- Crm Rmx Sync IntegrationCreate or update CRM to RMX syncing integrations. Use when adding a new synced entity, mapping, EF Core model/migration, or CrmSyncingInboxService logic for CRM to RMX (and optional RMX to CRM live sync/outbox). Produces a repeatable step-by-step plan and implements the integration.Votes: 0GitHub stars: 666
- TaskmanagerManage tasks, state, and memories - parse PRDs into hierarchical tasks with dependencies and complexityVotes: 0GitHub stars: 35
- Taskmanager MemoryManage project memories - constraints, decisions, conventions with conflict detection and resolutionVotes: 0GitHub stars: 35
- Critical PeerProfessional skepticism with pattern enforcement. Verify before agreeing, challenge violations, propose instead of asking. Concise output, research before asking, answer questions literally.Votes: 0GitHub stars: 666
- Docker DocsReference Docker and Compose documentation for configuration patterns and best practicesVotes: 0GitHub stars: 35
- Docker DatabaseConfigure database containers with security, persistence, and health checksVotes: 0GitHub stars: 35
- Creating Gorm EntityCreates GORM entity structs for go-kratos microservices with BaseModel embedding, proper field tags, relationships (one-to-one, one-to-many), indexing strategies, and soft delete support. Use when defining database schema, creating new entities, setting up table relationships, or configuring database constraints.Votes: 0GitHub stars: 666
- Creating Elysia DomainsCreates new domain modules in the Nexus Elysia API with proper typing for Eden Treaty consumers (Dashboard, The Machine)Votes: 0GitHub stars: 666
- TestcontainersWrite integration tests using TestContainers for .NET with xUnit. Covers infrastructure testing with real databases, message queues, and caches in Docker containers instead of mocks.Votes: 0GitHub stars: 1,155
- Package ManagementManage NuGet packages using Central Package Management (CPM) and dotnet CLI commands. Never edit XML directly - use dotnet add/remove/list commands. Use shared version variables for related packages.Votes: 0GitHub stars: 1,155