Design PostgreSQL schemas, indexes, and zero-downtime migrations with Prisma or Drizzle.
npx skills add https://github.com/EliasOulkadi/shokunin --skill db-sculptor
Please help me install this Agent Skill. Skill: db-sculptor Source: https://github.com/EliasOulkadi/shokunin/tree/main/.pack/skills/db-sculptor Command: npx skills add https://github.com/EliasOulkadi/shokunin --skill db-sculptor
It helps you design and evolve relational database schemas without slow queries or unsafe migrations by selecting the right keys, indexes, and migration strategy for PostgreSQL with Prisma or Drizzle.
Ask the AI to design your PostgreSQL schema for the access patterns you describe, propose the minimum index set, and generate a safe Prisma/Drizzle migration plan to implement it with zero downtime.
High-intent search queries and answers about installing and using this skill.
To optimize slow PostgreSQL queries using EXPLAIN ANALYZE, you diagnose execution plans and apply targeted index strategies like B-tree, GIN, GiST, BRIN, or partial/covering indexes to reduce latency and eliminate timeouts.
An expand/contract zero-downtime migration is a sequence that safely evolves PostgreSQL schemas by adding nullable fields or using CREATE INDEX CONCURRENTLY, then backfilling data and cleaning up, avoiding blocking locks and breaking changes in production.
To design a PostgreSQL schema from access patterns with Prisma or Drizzle, you prioritize reads, writes, and latency budgets to choose between normalization and selective denormalization, generating the corresponding ORM definitions.
You need a GIN index instead of a B-tree index in PostgreSQL when implementing full-text search or querying array elements, as GIN indexes support these complex data types better than standard B-tree structures.
To add a full-text search feature to PostgreSQL without blocking production traffic, you design schema changes, add a GIN index concurrently, and execute an expand/contract migration plan to avoid locking.
To avoid locking when creating indexes in PostgreSQL, you use CREATE INDEX CONCURRENTLY within an expand/contract migration sequence, ensuring concurrent query execution without blocking production traffic.
GeneralJerelAudit performance budgets for Core Web Vitals, bundle size, and API latency.
iCesofTOptimize PostgreSQL and MySQL queries with EXPLAIN ANALYZE and index tuning.
1154761334Create and migrate database schemas using TypeScript definitions with Drizzle ORM.
jralphDesign relational schemas with normalization, indexing, and migration strategies.
