database-design
Database Design teaches schema fundamentals, ORM selection, and performance tuning through structured decision-making rather than rote patterns. It covers normalization, relationship design, indexing strategy, and query optimization across PostgreSQL, SQLite, and serverless databases.
Database Design helps you build normalized schemas by guiding ORM choice, indexing strategy, and query patterns for your specific context.
AI-generated summary based on this skill's SKILL.md
Decision gist · record as of 2026-07-26
Database Design helps you build normalized schemas by guiding ORM choice, indexing strategy, and query patterns for your specific context. Database Design teaches schema fundamentals, ORM selection, and performance tuning through structured decision-making rather than rote patterns. It covers normalization, relationship design, indexing strategy, and query optimization across PostgreSQL, SQLite, and serverless databases.
Use it when
- Database Design emphasizes normalization, proper relationship modeling, and thoughtful indexing.
- Database Design helps you evaluate databases by context.
Verify before relying
Read SKILL.md below before installing (8 files). Open directory: indexed for reading, not audited.
Install
vudovn/ag-kit/database-design · repository language: TypeScript
Open directory. Skills are indexed for reading, not audited. Review a skill's body before installing it.
Frequently asked questions
AI-generated answers based on this skill's SKILL.md and metadata
How do I design a database schema for my application?
Database Design covers schema fundamentals through structured decision-making. Start by identifying entities and their relationships, then apply normalization principles to eliminate redundancy. The skill guides you through designing relational schemas that balance query efficiency with data integrity, considering your specific application context and scale requirements.
What are database design best practices I should follow?
Database Design emphasizes normalization, proper relationship modeling, and thoughtful indexing. Key practices include: decomposing data to eliminate redundancy, choosing appropriate primary and foreign keys, designing for query patterns rather than just data structure, and planning migrations safely from the start. The skill teaches decision-making frameworks rather than rigid patterns.
How do I choose between PostgreSQL and SQLite?
Database Design helps you evaluate databases by context. PostgreSQL suits multi-user applications, complex queries, and production systems needing reliability. SQLite works well for embedded use, prototyping, and edge deployments. The skill also covers serverless options like Neon and Turso, helping you match database choice to your project's scale, concurrency needs, and infrastructure constraints.
What's the difference between Prisma and Drizzle ORM?
Database Design covers ORM selection as part of choosing the right tools for your project. Both ORMs handle schema definition and query building, but differ in philosophy and features. The skill teaches you to evaluate ORMs based on your application's needs, migration strategy, type safety requirements, and performance characteristics rather than recommending one universally.
How do I optimize database queries and avoid N+1 problems?
Database Design addresses query optimization through indexing strategy and relationship design. N+1 issues arise when fetching related data inefficiently. The skill teaches you to recognize these patterns, use eager loading and batch queries, design indexes for common access patterns, and analyze query performance with tools like EXPLAIN ANALYZE to identify bottlenecks.
How should I plan and execute safe database migrations?
Database Design emphasizes migration safety as a core design principle. Plan migrations by understanding your schema changes, testing in staging environments, and using reversible migration tools. The skill covers strategies for zero-downtime deployments, handling data transformations safely, and coordinating schema changes with application code to prevent production incidents.
SKILL.md
Rendered from the published skill. Quoted content, verbatim.
Database Design
> Learn to THINK, not copy SQL patterns.
🎯 Selective Reading Rule
Read ONLY files relevant to the request! Check the content map, find what you need.
| File | Description | When to Read |
|---|---|---|
database-selection.md |
PostgreSQL vs Neon vs Turso vs SQLite | Choosing database |
orm-selection.md |
Drizzle vs Prisma vs Kysely | Choosing ORM |
schema-design.md |
Normalization, PKs, relationships | Designing schema |
indexing.md |
Index types, composite indexes | Performance tuning |
optimization.md |
N+1, EXPLAIN ANALYZE | Query optimization |
migrations.md |
Safe migrations, serverless DBs | Schema changes |
⚠️ Core Principle
- ASK user for database preferences when unclear
-
Choose database/ORM based on CONTEXT
(truncated - see the full file via the links below)
File tree — 8 files
.agents/skills/database-design/SKILL.md
.agents/skills/database-design/database-selection.md
.agents/skills/database-design/indexing.md
.agents/skills/database-design/migrations.md
.agents/skills/database-design/optimization.md
.agents/skills/database-design/orm-selection.md
.agents/skills/database-design/schema-design.md
.agents/skills/database-design/scripts/schema_validator.py
Let your AI agent find skills like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 56,283 agent skills by what they can do, searchable in plain language.
wish › “Design a normalized database schema for my application”
Give your agent the search over MCP, or paste the wish link into any chat. No install? Search from any chat →
Related skills
Database Design teaches you to think through structural decisions rather than copy patterns. It covers schema normalization, relationship modeling, index strategies, and ORM selection across PostgreSQL, SQLite, and serverless options. Work through decision checklists and optimization techniques to build performant databases suited to your deployment context.
Build well-structured database schemas from requirements through deployment. This skill guides you through normalization, relationship design, index optimization, and reversible migrations—covering relational databases like PostgreSQL and MySQL, document stores like MongoDB, and ORMs including Prisma, Drizzle, and TypeORM.
This skill guides you through the complete lifecycle of database schema design, from conceptual modeling and logical design through physical optimization and safe migrations. It covers normalization principles, relationship patterns, indexing strategies, and query optimization techniques, with decision tables for choosing between SQL, document, and key-value storage engines. Includes zero-downtime migration patterns and backfill strategies to evolve schemas safely in production.
This skill guides you through principled decisions for Node.js development—from picking the right framework (Express, Fastify, NestJS, Hono) based on your deployment target and performance needs, to structuring layered architectures and handling errors consistently. It covers async patterns, validation strategies, security fundamentals, and testing priorities, emphasizing context-aware choices over one-size-fits-all solutions.
Database Design guides you through schema normalization, indexing strategies, and query optimization for both SQL and NoSQL systems. It covers normalization forms, denormalization trade-offs, index types, and migration patterns to help you build performant, maintainable databases. Use it when designing tables, fixing performance issues, or planning data migrations.
Architecture guides decision-making through requirements analysis, trade-off evaluation, and ADR documentation. It helps teams capture design rationale and choose patterns systematically, emphasizing simplicity and constraint-aware choices.
More skills drizzle (MIT) · drizzle-best-practices (MIT) · oma-db (MIT) · datamodellm (MIT) · server-management (MIT)