db-sculptor

What problem does it solve?

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.

Core Features & Use Cases

• Schema design from access patterns: prioritizes reads/writes, latency budgets, and query shapes to choose normalization vs selective denormalization.
• Index and query optimization for PostgreSQL: recommends B-tree, composite, partial, covering (INCLUDE), GIN, GiST, BRIN, and Hash indexes using EXPLAIN ANALYZE-driven diagnosis.
• Zero-downtime migration planning: produces expand/contract migration sequences (e.g., nullable-backfill-not-null, CREATE INDEX CONCURRENTLY) and guardrails to avoid locking and breaking changes.
• Use case: You need to add a new search feature and your current queries are timing out; design the schema changes, add the proper GIN index (e.g., FTS with GIN), and produce an expand/contract migration plan that won’t block production traffic.

Quick Start

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.