database-design

Guide database selection, schema design, indexing, and migration decisions.

Updated Apr 4, 2026

Search Tags:#query optimization #indexing #schema design #database #migrations #orm

Ready to run

npx skills add https://github.com/capaas2/Site-teste --skill database-design-capaas2

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/capaas2/Site-teste/tree/main/.agent/skills/database-design
Command: npx skills add https://github.com/capaas2/Site-teste --skill database-design-capaas2

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill helps you choose the right database, model data structures, and avoid common schema and query performance mistakes when building applications.

Core Features & Use Cases

Database selection: Compare PostgreSQL, Neon, Turso, SQLite, and other options based on deployment and workload.
Schema design: Plan tables, primary keys, relationships, timestamps, and normalization decisions with practical guidance.
Performance and safety: Improve indexing, reduce N+1 queries, and apply safer migration strategies for production systems.
Use case: A developer building a new app can use this Skill to decide whether SQLite is enough, how to structure related tables, and what indexes to add before launch.

Quick Start

Ask the assistant to design a database schema for your app, including database choice, table structure, relationships, and indexes.

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 my application with the right tables and indexes?▼

To design a database schema, plan tables, primary keys, relationships, and timestamps with practical normalization guidance. Add appropriate indexes to reduce N+1 queries and improve performance before launching your application.

What is the best way to choose between PostgreSQL, SQLite, Turso, and Neon for my workload?▼

Choosing between PostgreSQL, SQLite, Turso, and Neon depends on your deployment target and workload. Compare these database options based on serverless requirements, relational modeling needs, and scaling constraints.

How do I apply zero-downtime database migrations safely in production?▼

Apply zero-downtime database migrations by using safer migration strategies that prevent production system locks. Plan schema changes carefully to maintain performance and safety during application development updates.

Does this database design guidance work with Drizzle and Prisma ORM setups?▼

Yes, database design guidance works with Drizzle and Prisma ORM setups. It provides context-aware recommendations for ORM choice, relational modeling, and query optimization tailored to these specific frameworks.

When should I not use SQLite for my application database?▼

You should not use SQLite when your workload requires heavy concurrent writes or serverless scaling limits are exceeded. Compare SQLite with PostgreSQL, Neon, or Turso to decide if it handles your deployment needs.