skills.rest
VoTruongDanh
VoTruongDanhCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-design

Guide database selection, schema normalization, and indexing for PostgreSQL, Neon, Turso, SQLite, Drizzle, and Prisma.

Updated Jan 8, 2026
Search Tags:#indexing#schema design#database#optimization#sql#orm
One-click install
npx skills add https://github.com/VoTruongDanh/AI_Cafe --skill database-design-votruongdanh
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/VoTruongDanh/AI_Cafe/tree/main/ai-service/.agent/skills/database-design
Command: npx skills add https://github.com/VoTruongDanh/AI_Cafe --skill database-design-votruongdanh

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 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) based on project needs.
  • ORM Selection: Assists in picking the best ORM (Drizzle, Prisma, Kysely) for your development workflow.
  • Schema Design: Provides principles for normalization, primary keys, and relationships.
  • Performance Tuning: Offers strategies for indexing and query optimization.
  • Use Case: You're starting a new web application and need to decide between PostgreSQL and Turso, and then design an efficient schema for user data.

Quick Start

Guide me through selecting a database for a new serverless 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 my application database?▼

Choosing a database like PostgreSQL, Turso, or SQLite depends on your project needs and deployment environment. This Skill guides you through evaluating these options to ensure efficient and scalable data management for your specific architecture.

What is the best way to design a database schema with proper normalization and primary keys?▼

Proper database schema design requires applying normalization principles, selecting appropriate primary keys, and accurately modeling relationships. This Skill provides comprehensive guidance on these core principles to help you structure efficient and scalable relational data models.

How do I select the right ORM like Drizzle, Prisma, or Kysely for my development workflow?▼

Selecting the right ORM like Drizzle, Prisma, or Kysely depends on your specific development workflow and query preferences. This Skill assists in evaluating these ORMs to match your database choice and optimize your application's data interactions.

How do I optimize SQL queries and implement effective indexing strategies?▼

Optimizing SQL queries and implementing effective indexing strategies are crucial for performance tuning. This Skill offers targeted strategies for indexing and query optimization to improve your database's read and write efficiency.

Can I use this database design guidance for a new serverless application?▼

Yes, this database design guidance is suitable for a new serverless application. The Skill helps you decide between serverless-friendly databases like Neon and Turso, and assists in designing an efficient schema tailored for serverless environments.

What are safe migration practices when updating my database schema?▼

Safe migration practices when updating your database schema involve careful planning to prevent data loss and downtime. This Skill offers strategies for safe migration practices to ensure smooth and reliable schema evolution during application growth.

Related Skills

Explore More Software Engineering Skills→
Avi977Avi977

using-git-worktrees

Create isolated Git worktrees with priority-based directory selection and safety checks.

Community
Advanced
sigmadigitalzasigmadigitalza
1

database-review

Review database schemas, migration files, and query performance.

Official
Advanced
bcastelinobcastelino
2

database-design

Guide database schema design, system selection, and indexing optimization.

Community
Intermediate
devCharuzudevCharuzu

database-designer

Design database schemas with normalization checks and ERD generation.

Community
Advanced