skills.rest
ntuan2502
ntuan2502COMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-design

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

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides guidance and best practices for designing and selecting appropriate databases and ORMs, ensuring efficient and scalable data management.

Core Features & Use Cases

  • Database Selection: Helps choose between PostgreSQL, Neon, Turso, SQLite, and others based on project needs.
  • ORM Selection: Guides the choice of ORMs like Drizzle, Prisma, or Kysely.
  • Schema Design: Offers principles for normalization, primary keys, and relationships.
  • Optimization: Covers indexing strategies and query optimization techniques.
  • Migrations: Provides a strategy for safe, zero-downtime database migrations.
  • Use Case: A developer needs to build a new web application and is unsure whether to use PostgreSQL with Prisma or Turso with Drizzle. This Skill helps them evaluate the trade-offs and make an informed decision.

Quick Start

Guide me through selecting the best database for a new serverless application with edge deployment needs.

Frequently Asked Questions about database-design

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

FAQPage Schema
How do I choose the best database for a serverless application with edge deployment needs?▼

Choosing the best database for serverless edge deployments requires evaluating SQLite-based options like Turso against traditional PostgreSQL. This Skill guides you through evaluating performance requirements and deployment context to select the right technology.

What is the best way to design a database schema using Prisma or Drizzle?▼

Designing a database schema with ORMs like Prisma or Drizzle involves applying normalization principles, defining primary keys, and structuring relationships. This Skill provides comprehensive schema design guidance for robust data management.

How do I execute zero-downtime database migrations?▼

Executing zero-downtime database migrations requires a safe strategy to update schema without disrupting active users. This Skill provides migration strategies to ensure safe and seamless database transitions during software development.

Should I use PostgreSQL with Prisma or Turso with Drizzle for my web application?▼

Choosing between PostgreSQL with Prisma and Turso with Drizzle depends on your project context, scale, and deployment environment. This Skill helps evaluate trade-offs between these stacks to make an informed technology decision.

What indexing strategies should I use for database query optimization?▼

Indexing strategies for database query optimization involve selecting appropriate indexes based on query patterns and performance requirements. This Skill covers indexing techniques and optimization methods to ensure efficient data retrieval.

Related Skills

Explore More Software Engineering Skills→
HechaoYannetHechaoYannet

create-architecture

Generate a master architecture document from GDDs, ADRs, and governance constraints.

Community
Advanced
pacphipacphi
6

database-testing

Validate database schemas, data integrity, migrations, and ACID properties.

Community
Intermediate
desafindesafin

moai-platform-deployment

Deploy applications to Vercel, Railway, and Convex platforms.

Community
Advanced
ai-enhanced-engineerai-enhanced-engineer
3

gcp-cicd-patterns

Automate CI/CD pipeline design on Google Cloud Platform with Cloud Build and Cloud Deploy.

Official
Advanced