skills.rest
ofelixdev
ofelixdevCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-design

Analyzes database design, schema normalization, indexing, and query optimization.

Updated Feb 24, 2026
Search Tags:#performance#indexing#schema design#database#sql#orm
One-click install
npx skills add https://github.com/ofelixdev/cc-kit --skill database-design-ofelixdev
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/ofelixdev/cc-kit/tree/main/template/skills/database-design
Command: npx skills add https://github.com/ofelixdev/cc-kit --skill database-design-ofelixdev

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill helps developers make informed decisions about database selection, schema design, indexing strategies, and ORM choices to build efficient and maintainable data layers.

Core Features & Use Cases

  • Database Selection: Guides users through choosing the right database (PostgreSQL, Neon, Turso, SQLite) based on project requirements.
  • ORM Selection: Assists in selecting appropriate ORMs like Drizzle, Prisma, or Kysely.
  • Schema Design: Provides principles for normalization, primary keys, 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 web application and wants to understand the best practices for designing their initial schema and indexing strategy.

Quick Start

Use the database-design skill to help choose between Drizzle and Prisma for a new project.

Frequently Asked Questions about database-design

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I choose the right database for my web application?▼

Choosing the right database depends on your project requirements. You can evaluate PostgreSQL, Neon, Turso, and SQLite based on specific use cases like serverless deployments and edge computing to ensure an efficient data layer.

What's the best way to design a database schema with normalization?▼

The best way to design a database schema involves applying normalization principles, defining primary keys, and structuring relationships. This ensures your data layer remains efficient, maintainable, and robust against anomalies.

How do I optimize SQL query performance using indexing and EXPLAIN ANALYZE?▼

To optimize SQL query performance, you should implement targeted indexing strategies and analyze queries using EXPLAIN ANALYZE. This process identifies bottlenecks and guides structural adjustments for faster data retrieval.

How do I choose between Drizzle, Prisma, and Kysely for my ORM?▼

Choosing between Drizzle, Prisma, and Kysely requires evaluating your project constraints and database selection. This guidance assists in selecting an ORM that aligns with your schema design and performance tuning goals.

Can I perform zero-downtime database migrations safely?▼

Yes, you can perform zero-downtime database migrations safely. By following safe migration practices, you can update your schema and indexing strategies without disrupting active deployments or user access.

Related Skills

Explore More Software Engineering Skills→
mohitmishra786mohitmishra786

architect

Design system architecture, select technology stacks, and define API contracts.

Community
Advanced
gabi-agentgabi-agent

database-operations

Optimize PostgreSQL schema design, migrations, and query performance.

Community
Advanced
lehuuhau1231lehuuhau1231

database-design

Guide database design decisions covering schema, indexing, and ORM selection.

Community
Advanced
HouseGarofaloHouseGarofalo
3

database-architect-agent

Guide database architecture, data modeling, schema optimization, and query performance tuning.

Official
Advanced