skills.rest
keshavraj936
keshavraj936COMMUNITY
Explore all skills by this author →
Website𝕏@ksavrajshahGitHub

database-design

Guide database and ORM selection, schema design, indexing, and query optimization.

Updated Feb 27, 2026
Search Tags:#design#database#postgresql#optimization#schema#orm#prisma
One-click install
npx skills add https://github.com/keshavraj936/Pulse-AI --skill database-design-keshavraj936
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/keshavraj936/Pulse-AI/tree/main/Inceptrix/.agent/skills/database-design
Command: npx skills add https://github.com/keshavraj936/Pulse-AI --skill database-design-keshavraj936

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill helps you make informed decisions about database and ORM selection, schema design, indexing, and optimization, ensuring efficient and scalable data management.

Core Features & Use Cases

  • Database Selection: Guides you through choosing the right database (PostgreSQL, Neon, Turso, SQLite, etc.) based on project requirements.
  • ORM Selection: Assists in selecting the best ORM (Drizzle, Prisma, Kysely) for your development needs.
  • Schema Design: Provides principles for normalization, primary keys, timestamps, and relationships.
  • Indexing & Optimization: Offers strategies for effective indexing and query optimization, including avoiding N+1 problems.
  • Migrations: Details safe migration practices for zero-downtime changes.
  • Use Case: When starting a new project, use this Skill to determine whether PostgreSQL with Prisma or Turso with Drizzle is the most suitable stack, and then design an optimized schema.

Quick Start

Use the database-design skill to help choose between PostgreSQL and Neon for a new web application.

Frequently Asked Questions about database-design

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

FAQPage Schema
How do I choose between PostgreSQL and SQLite for my web application schema?▼

Database selection depends on your project requirements, with PostgreSQL suited for scalable web applications and SQLite for lightweight local needs. This guidance evaluates PostgreSQL, Neon, Turso, and SQLite to match your specific architecture.

What is the best way to avoid N+1 query problems when using an ORM?▼

Avoiding N+1 query problems requires proper relationship mapping and eager loading strategies in your ORM. This Skill provides query optimization techniques to prevent these anti-patterns when using ORMs like Prisma or Drizzle.

How do I design database indexes for query optimization without hurting write performance?▼

Database indexing strategies must balance read speed with write overhead based on your query patterns. This Skill offers comprehensive indexing guidance to optimize query performance across your selected database system.

Can I use Prisma with Turso, or should I use Drizzle for my database ORM?▼

Prisma and Drizzle support different database systems, with Prisma often paired with PostgreSQL and Drizzle offering broad compatibility. This Skill assists in selecting the best ORM for your chosen database stack.

How do I execute zero-downtime database migrations safely?▼

Safe database migrations require following zero-downtime practices to prevent data loss and service interruptions. This Skill details migration best practices to ensure secure schema changes during deployment.

Related Skills

Explore More Software Engineering Skills→
DaytimeBluesDaytimeBlues

database-design

Guide database selection, schema design, indexing, and ORM choices.

Community
Intermediate
PlazaCCPlazaCC
2

db-migrate

Generate and apply Drizzle ORM migration scripts for Supabase Postgres.

Official
Intermediate
EIS-ITSEIS-ITS

Backend Models

Define database models and ORM entities with relationships and constraints.

Official
Intermediate
SergeiGolosSergeiGolos
1

database-design

Guide database selection and schema design across PostgreSQL, Neon, Turso, and SQLite.

Community
Intermediate