- Home
- /
- Categories
- /
- Database
Database
Database management and queries
sql
by miles990
SQL patterns for database querying and design
e-commerce
by miles990
E-commerce platforms, payment processing, and shopping cart patterns
planning
by srstomp
Use when analyzing PRD documents, concept briefs, or feature specs to create implementation plans, breaking work into epics/stories/tasks with dependencies and estimates, or generating PROJECT.md and kanban tracking.
architecture-review
by srstomp
Use when auditing project structure, planning refactors, improving code organization, analyzing dependencies and module boundaries, or identifying structural issues. TypeScript/JavaScript-primary with language-agnostic patterns.
migration-planning
by Blazity
Use when the user asks to plan a Next.js migration, create a migration roadmap, decide migration order, schedule migration phases, or asks "what order should I migrate routes?" Analyzes routes via AST and generates a phased migration plan (.migration/plan.md). Requires migration-assessment first.
component-migration
by Blazity
Use when adding 'use client' directives, splitting mixed components into server + client parts, or fixing RSC boundary errors like "useState only works in a Client Component." Also for migrating interactive UI (forms, modals, event handlers) to App Router.
database-design
by srstomp
Use when designing database schemas, reviewing data models, planning migrations, optimizing slow queries, or establishing database patterns. Covers relational (PostgreSQL, MySQL, SQLite), document (MongoDB), and ORM-integrated (Prisma, Drizzle, TypeORM) projects.
java-dev
by story-has-you
"Comprehensive Java development skill based on Alibaba Java Coding Guidelines (Songshan Edition). Use when writing, reviewing, or refactoring Java code to ensure compliance with industry best practices. Triggers on: (1) Writing new Java code (.java files), (2) Reviewing existing Java code, (3) Refactoring Java projects, (4) Database design with MySQL, (5) API design and implementation, (6) Unit testing, (7) Concurrent programming, (8) Security implementation, or any Java development tasks requiring adherence to coding standards."
prisma-orm-v7-skills
by gocallum
Key facts and breaking changes for upgrading to Prisma ORM 7. Consider version 7 changes before generation or troubleshooting
cloud-platforms
by Logos-Liber
AWS, Azure, and GCP cloud services and best practices
data-engineering
by Logos-Liber
Data pipeline patterns, ETL/ELT best practices, data storage options, and data quality techniques
agentic-mcp
by cablate
Agentic MCP - Three-layer progressive disclosure for MCP servers with Socket daemon. Use when the user needs to interact with MCP servers, query available tools, call MCP tools, or manage the MCP daemon process. Provides socket-based communication for efficient server interaction with three-layer progressive disclosure API.
oracle-dba
by acedergren
Use when managing Oracle Autonomous Database on OCI, troubleshooting performance issues, optimizing costs, or implementing HA/DR. Covers ADB-specific gotchas, cost traps, SQL_ID debugging workflows, auto-scaling behavior, and version differences (19c/21c/23ai/26ai).
backend-data-model
by parhumm
Generate data model docs with tables, constraints, indexes, retention, and migration notes. Use when designing database schemas from entities.
finops-cost-optimization
by acedergren
Use when optimizing OCI costs, investigating unexpected bills, planning budgets, or identifying waste. Covers hidden cost traps (boot volumes, reserved IPs, egress), Universal Credits gotchas, shape migration savings, free tier maximization, and cost allocation challenges.
backend-service-implement
by parhumm
Generate service implementations with business logic from specs and scaffold stubs. Use when implementing backend services.
social-trends
by cklxx
社交媒体热点趋势分析(抖音、微博、小红书等)。
search-strategy
by hvkshetry
Query decomposition and multi-source search orchestration. Breaks natural language questions into targeted searches per source, translates queries into source-specific syntax, ranks results by relevance, and handles ambiguity and fallback strategies.
calendar-management
by cklxx
日历事件的创建、查询、修改、删除管理。
best-practices
by acedergren
Use when architecting OCI solutions, migrating from AWS/Azure, designing multi-AD deployments, or avoiding common OCI anti-patterns. Covers VCN sizing mistakes, Cloud Guard gotchas, free tier specifics, OCI terminology confusion, and multi-AD patterns.
database-migration
by dkyazzentwatwa
Create database migration with schema changes and rollback. Auto-invoke when user says "create migration", "add table", "modify schema", or "change database".
mysql-tools
by huangzt
"MySQL 数据库工具集,用于连接数据库实例、列出所有表、查看表结构、执行 SQL 查询等操作。当需要操作 MySQL 数据库、查询数据、分析表结构时使用此技能。支持通过命令行参数指定 host、port、user、password、database 等连接信息,可代替 mysql mcp 服务使用。支持 Windows、macOS 和 Linux 平台。"
dm8-tools
by huangzt
"达梦数据库(DM8)工具集,用于连接数据库实例、列出所有表、查看表结构、执行 SQL 查询等操作。当需要操作达梦数据库、查询数据、分析表结构时使用此技能。支持通过命令行参数指定 host、port、user、password、database、schema 等连接信息,可代替 dm8 mcp 服务使用。支持 Windows、macOS 和 Linux 平台。"
json-typed-attributes
by RoleModel
Define typed attributes backed by JSON fields in Rails models. Use when models need flexible data storage with type casting, validations, and form integration. Supports integer, decimal, string, text, boolean, date, and array types.