skills.rest
aarushlohit
aarushlohitCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

db-sculptor

Automates PostgreSQL schema design, index optimization, and migration strategies.

Updated Apr 1, 2026
Search Tags:#database design#query optimization#indexing#migration#PostgreSQL
One-click install
npx skills add https://github.com/aarushlohit/TheRocketProject --skill db-sculptor-aarushlohit
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-sculptor
Source: https://github.com/aarushlohit/TheRocketProject/tree/main/rocket/external/shokunin/.pack/skills/db-sculptor
Command: npx skills add https://github.com/aarushlohit/TheRocketProject --skill db-sculptor-aarushlohit

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires prisma, drizzle-orm, postgresql, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines database schema design, indexing, query optimization, and migration strategies, ensuring efficient and scalable database performance.

Core Features & Use Cases

  • Schema Design: Design database schemas based on access patterns and data volume, utilizing best practices for normalization, indexing, and partitioning.
  • Index Optimization: Analyze query performance and recommend or create indexes to optimize PostgreSQL databases.
  • Query Optimization: Diagnose and fix slow queries using EXPLAIN ANALYZE, focusing on execution plan improvements.
  • Migration Safety: Create safe, zero-downtime migrations for schema changes and feature additions.
  • Use Case: A developer uses this Skill to design a new database schema for an e-commerce platform, optimizing it for fast read/write access and secure transactions.

Quick Start

Design a schema for the 'e-commerce' database based on the access patterns and data volume estimates provided.

Frequently Asked Questions about db-sculptor

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a PostgreSQL schema for high-volume e-commerce access patterns?▼

PostgreSQL schema design for high-volume e-commerce requires structuring tables around specific access patterns and data volumes, applying normalization, indexing, and partitioning best practices to ensure scalable read and write performance.

How do I optimize slow PostgreSQL queries using EXPLAIN ANALYZE?▼

PostgreSQL query optimization with EXPLAIN ANALYZE diagnoses slow queries by inspecting execution plans, allowing you to restructure queries and apply appropriate indexing strategies to improve data retrieval speed.

Can I create zero-downtime PostgreSQL migrations with Prisma and Drizzle?▼

Zero-downtime PostgreSQL migrations with Prisma and Drizzle are possible by generating safe schema change strategies that prevent locking and maintain application availability during feature additions.

What's the best way to analyze and create indexes for PostgreSQL performance tuning?▼

PostgreSQL index optimization analyzes query performance against access patterns to recommend and create targeted indexes, significantly improving execution speed for data-intensive financial and e-commerce applications.

Does this approach support partitioning for data-intensive financial applications?▼

Partitioning for data-intensive financial applications is fully supported, utilizing PostgreSQL features to divide large tables into smaller, manageable pieces based on data volume estimates and access patterns.

Related Skills

Explore More Software Engineering Skills→
Chenm4Chenm4

drizzle

Design PostgreSQL schemas and migrations with Drizzle ORM for Node.js.

Community
Intermediate
jtucker9jtucker9

migration-planner

Generate ordered migration scripts and rollback plans from schema diffs.

Community
Advanced
gil00pitagil00pita

prisma

Generate a type-safe Prisma Client from declarative schemas for Node.js and TypeScript.

Community
Advanced
paopp2paopp2

postgresql-psql

Orchestrate PostgreSQL database interactions through the psql command-line client.

Community
Intermediate