Skip to content

Skills suchen.../

Agent Skill Search Engine

Suche

Suche
Kategorien
Berufe

About

About
Privacy
Terms

© 2026 Skills Pool. Alle Rechte vorbehalten.

Design Postgres Entity | Skills Pool

Skill-Datei

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 Sterne28.03.2026

Beruf
Kategorien: SQL-Datenbanken

Skill-Inhalt

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,

Verwandte Skills

Schnellinstallation

Design Postgres Entity

npx skillvault add nickAnhel/nickanhel-nerdex-agents-skills-design-postgres-entity-skill-md

Skill herunterladen Repository öffnen

Autor: nickAnhel
Sterne: 0
Aktualisiert: 28.03.2026
Beruf

Auf dieser Seite

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

Datenbankarchitekten

SQL-Datenbanken

Postgres Patterns

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

SQL-Datenbanken

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.

SQL-Datenbanken

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.

SQL-Datenbanken

Postgres Patterns

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

Data Engineering

Postgres Patterns

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

SQL-Datenbanken

Jpa Patterns

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

Datenbankarchitekten