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

Ready to run

npx skills add https://github.com/nguyenphp/antigravity-marketing --skill database-design-nguyenphp

💬 Prompt for ChatGPT / Claude Chat▼

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.