skills.rest
nguyenphp
nguyenphpCOMMUNITY
Explore all skills by this author →
GitHub

database-design

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

41|12|Updated Jan 16, 2026
Search Tags:#design#performance#database#schema#sql#orm
One-click install
npx skills add https://github.com/nguyenphp/antigravity-marketing --skill database-design-nguyenphp
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/nguyenphp/antigravity-marketing/tree/main/templates/.agent/skills/database-design
Command: npx skills add https://github.com/nguyenphp/antigravity-marketing --skill database-design-nguyenphp

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill helps users make informed decisions about database selection, schema design, indexing strategies, and ORM choices, preventing common pitfalls and optimizing for performance and maintainability.

Core Features & Use Cases

  • Database Selection: Guides users 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 development workflow and deployment needs.
  • Schema Design: Provides principles for normalization, primary keys, timestamps, and relationships.
  • Performance Tuning: Offers guidance on indexing strategies and query optimization.
  • Use Case: A developer needs to choose between PostgreSQL and Turso for a new edge application and wants to understand the trade-offs for schema design and indexing.

Quick Start

Guide me through selecting a database and 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, Neon, and Turso for my application database?▼

When selecting an ORM like Drizzle, Prisma, or Kysely, you balance schema type safety, migration workflows, and query control. Drizzle offers SQL-like control, Prisma provides schema-first abstraction, and Kysely focuses on type-safe raw SQL.

What are the best practices for SQL schema normalization and primary key strategies?▼

Best practices for SQL schema normalization involve reducing data redundancy through normal forms, selecting robust primary key strategies, and implementing proper timestamps. This ensures data integrity and query performance for modern applications.

How do I optimize database performance with indexing techniques?▼

Database performance optimization relies on applying indexing techniques to frequently queried columns and avoiding common anti-patterns. Proper indexing accelerates data retrieval and maintains application responsiveness under load.

Can I use SQLite for a modern web application schema?▼

Yes, you can use SQLite for modern web application schemas, particularly when leveraging serverless platforms like Turso. It provides a lightweight, relational structure suitable for edge deployments and local development workflows.

Related Skills

Explore More Software Engineering Skills→
TorbenMerraldTorbenMerrald
1

Backend Models

Define and enforce database models and entity schemas across ORM and migration scripts.

Community
Advanced
rodmena-limitedrodmena-limited
3

moai-domain-database

Provide database schema design, query optimization, and indexing strategies.

Official
Advanced
felvieirafelvieira
22

backend-api

Define API contracts and data models for Node.js backend applications.

Community
Advanced
DauQuangThanhDauQuangThanh
14

database-design

Design relational and NoSQL database schemas from business requirements.

Community
Advanced