skills.rest
involvex
involvexCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-design

Guide database selection, schema design, indexing, and migration strategies.

Updated Mar 7, 2026
Search Tags:#performance#database#schema#migration#sql#orm
One-click install
npx skills add https://github.com/involvex/llms-remote --skill database-design-involvex
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/involvex/llms-remote/tree/main/.agents/skills/database-design
Command: npx skills add https://github.com/involvex/llms-remote --skill database-design-involvex

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pypdf, pdfplumber, pdf2image, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides guidance on making informed decisions for database selection, schema design, indexing, ORM choice, and migration strategies, ensuring efficient and maintainable data storage solutions.

Core Features & Use Cases

  • Database Selection: Helps choose between PostgreSQL, Neon, Turso, SQLite, PlanetScale, etc., based on project requirements.
  • ORM Selection: Guides the choice between Drizzle, Prisma, Kysely, or raw SQL.
  • Schema Design: Covers normalization, primary keys, timestamps, and relationship types.
  • Indexing Strategy: Explains when and how to create effective indexes.
  • Migration Management: Outlines safe strategies for schema changes, especially for serverless databases.
  • Use Case: When starting a new web application, use this Skill to determine the most suitable database and ORM, design the initial schema, and plan for future migrations.

Quick Start

Use the database-design skill to help select an ORM 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, Turso, and SQLite for a new web application?▼

Schema design best practices include normalization, selecting appropriate primary keys, implementing timestamps, and defining relationship types. This guidance covers these foundational principles to ensure your database structure is robust, maintainable, and efficient.

What is the best way to choose an ORM like Drizzle, Prisma, or Kysely?▼

Migration management requires safe strategies for schema changes, especially in serverless database environments. This guidance outlines techniques to execute structural modifications without downtime or data loss during deployments.

How do I create effective indexing strategies for my database schema?▼

Effective indexing strategies dictate when and how to create indexes to optimize query performance. This guidance explains the decision-making process for implementing indexes that speed up data retrieval without degrading write performance.

Does this database design guidance support serverless environments?▼

Yes, this database design guidance explicitly supports serverless environments. It details selection criteria for serverless databases like Neon and Turso, and outlines safe migration techniques tailored for these specific deployment contexts.

Related Skills

Explore More Software Engineering Skills→
mohitmishra786mohitmishra786

architect

Design system architecture, select technology stacks, and define API contracts.

Community
Advanced
RyoOsakaRyoOsaka

migration

Generate and apply Drizzle ORM database migrations from TypeScript schema changes.

Community
Intermediate
sandros94sandros94
1

integrate-valibot

Integrate Valibot schemas with Standard Schema for interoperability and code generation.

Community
Intermediate
edulazaroedulazaro
12

lc:model-diagram

Generate Mermaid Entity-Relationship diagrams from Eloquent models and migrations.

Community
Intermediate