搵技能.../

Database Design | Skills Pool

技能檔案

Database Design

Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.

Topi1430 星標2026年4月5日

職業
分類: SQL 數據庫

技能內容

Overview

This skill provides practical guidance for Database Design.

When to Use

Use this skill when the request matches: Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.

Instructions

Selective Reading Rule: Perform this phase systematically and record evidence.
Core Principle: Perform this phase systematically and record evidence.
Decision Checklist: Perform this phase systematically and record evidence.
Anti-Patterns: Perform this phase systematically and record evidence.
Verification: Confirm final output quality, correctness, and regression safety.

Best Practices

Keep changes minimal, clear, and aligned with existing architecture.
Validate assumptions with reproducible evidence before editing code.
Add or update tests for behavior changes and regression prevention.

相關技能

快速安裝

Database Design

npx skills add Topi143/iSchedWise-AWS

下載 Skill 打開源碼倉庫

作者: Topi143
星標: 0
更新時間: 2026年4月5日
職業

本頁內容

Document trade-offs when multiple implementation approaches exist.

Examples

Use the database-design skill to handle this task end-to-end.
Apply database-design to diagnose and fix the current issue.
Use database-design to propose a safe implementation plan and execute it.

When to Use

04Best Practices

資料庫架構師

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Quick reference for common patterns, index types, data types, and anti-pattern detection. Based on Supabase best practices.

Database Migrations

Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate). Use when planning or implementing database schema changes.

Postgres Patterns

쿼리 최적화, 스키마 설계, 인덱싱, 보안을 위한 PostgreSQL 데이터베이스 패턴. Supabase 모범 사례 기반.

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Jpa Patterns

Spring Boot中的JPA/Hibernate模式，用于实体设计、关系处理、查询优化、事务管理、审计、索引、分页和连接池。

資料庫架構師