Search skills.../

Design Postgres Entity | Skills Pool

Skill File

Design Postgres Entity

Design or change PostgreSQL-backed entities, relations, constraints, indexes, and migrations for Nerdex. Use when introducing schema for content, comments, reactions, tags, chats, media metadata, or any query-sensitive data model that must be driven by write and read paths, ownership, visibility, and future extensibility.

nickAnhel0 starsMar 28, 2026

Occupation
Categories: SQL Databases

Skill Content

Design a PostgreSQL Entity for Nerdex

Используй этот skill, когда задача вводит или меняет PostgreSQL-backed entity, relation или query-sensitive schema.

Goal

Спроектировать schema, которая корректна для реального product behavior, а не просто syntactically complete.

Process

Identify the domain object and its lifecycle.
Identify write paths.
Identify read paths.
Determine ownership and visibility rules.
Choose table boundaries.
Add constraints and indexes based on actual queries.
Plan migration and backfill impact.

Required thinking

Всегда рассуждай про:

primary key strategy,
foreign keys и delete behavior,
uniqueness constraints,
enum usage,
timestamp semantics,
pagination / sorting / filtering queries,

Related Skills

Quick Install

Design Postgres Entity

npx skills add nickAnhel/Nerdex

Download Skill Open repository

Author: nickAnhel
stars: 0
Updated: Mar 28, 2026
Occupation

On this page

01Design a PostgreSQL Entity for Nerdex

counters и denormalized fields,

moderation / deletion / archive states, если релевантно.

Content-specific rule

Если entity связана с posts / articles / videos / courses / comments / reactions / tags / feed behavior, сначала реши, находится ли concern в shared content или в type-specific detail table.

Deliverable format

При предложении schema changes включай:

table purpose,
key columns,
constraints,
indexes,
expected query patterns,
migration notes,
trade-offs.

Anti-patterns

Не делай:

design только от UI labels,
отсутствие indexes для очевидных list/feed/profile access paths,
попытку держать core integrity только в Python, если SQL может enforce это лучше,
premature denormalization без реального read bottleneck.

02

Goal

04Required thinking

05Content-specific rule

06Deliverable format

07Anti-patterns

Database Architects

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 모범 사례 기반.

Data Engineering

Postgres Patterns

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

Jpa Patterns

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

Database Architects