skills.rest
Ab-aswini
Ab-aswiniCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-design

Guide database design, technology selection, and ORM choices for software development.

2|Updated Feb 15, 2026
Search Tags:#performance#schema design#database#postgresql#migrations#sql#orm
One-click install
npx skills add https://github.com/Ab-aswini/Agent-kit-P1 --skill database-design-ab-aswini
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/Ab-aswini/Agent-kit-P1/tree/main/.agent-os/skills/database-design
Command: npx skills add https://github.com/Ab-aswini/Agent-kit-P1 --skill database-design-ab-aswini

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides guidance and best practices for designing efficient, scalable, and maintainable database schemas and selecting appropriate database technologies and ORMs.

Core Features & Use Cases

  • Database Selection: Helps choose between PostgreSQL, Neon, Turso, SQLite, and others based on project needs.
  • ORM Selection: Guides the choice between Drizzle, Prisma, Kysely, and raw SQL.
  • Schema Design: Covers normalization, primary keys, timestamps, and relationship types.
  • Indexing Strategy: Provides principles for effective index creation.
  • Query Optimization: Addresses the N+1 problem and query analysis.
  • Migrations: Outlines safe migration strategies for zero-downtime changes.
  • Use Case: When starting a new web application, use this Skill to decide whether to use PostgreSQL with Prisma or Turso with Drizzle, and then design the initial user and product schemas.

Quick Start

Use the database-design skill to help select an ORM for a new project.

Frequently Asked Questions about database-design

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

FAQPage Schema
How do I design a database schema for a new web application?▼

To design a database schema, apply normalization principles, define primary keys and timestamps, and structure relationship types. This skill provides comprehensive guidance on schema design and technology selection for efficient, maintainable database architectures.

What is the best way to choose between PostgreSQL, Turso, and SQLite?▼

The best way to choose between PostgreSQL, Turso, and SQLite is by evaluating project requirements against database capabilities. This skill helps compare database systems to facilitate informed architecture and tooling decisions for software development.

How do I decide whether to use Prisma, Drizzle, Kysely, or raw SQL?▼

To decide between Prisma, Drizzle, Kysely, or raw SQL, evaluate your application's query complexity and abstraction needs. This skill guides ORM choices by comparing these tools to ensure appropriate integration with your selected database system.

How do I fix the N+1 query problem and optimize database performance?▼

To fix the N+1 query problem, implement query analysis techniques and proper indexing strategies. This skill provides query optimization guidance and indexing principles to resolve N+1 issues and enhance overall database performance.

What are safe database migration strategies for zero-downtime changes?▼

Safe database migration strategies for zero-downtime changes involve careful schema alteration practices. This skill outlines safe migration strategies to help you apply database changes without causing downtime or data loss.

When do I need database normalization and effective index creation?▼

Database normalization and effective index creation are needed when structuring scalable databases to minimize redundancy and accelerate query performance. This skill covers schema normalization principles and indexing strategies for robust database design.

Related Skills

Explore More Software Engineering Skills→
phuonghxphuonghx
1

database-design

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

Community
Advanced
darblexdarblex

sql-toolkit

Interact with SQLite, PostgreSQL, and MySQL databases via command-line operations.

Community
Advanced
mikkelkrogsholmmikkelkrogsholm
5

neon

Provide guidance on Neon serverless PostgreSQL features and integrations.

Community
Intermediate
tankpkgtankpkg
1

@tank/relational-db-mastery

Optimize PostgreSQL and MySQL query performance with indexing and tuning strategies.

Official
Advanced