database-design

Guide database selection and schema design with indexing strategies.

1|Updated Jan 26, 2026

Search Tags:#indexing #schema design #database #optimization #sql #orm

Ready to run

npx skills add https://github.com/simoabid/ABID.Dev-Portfolio --skill database-design-simoabid

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/simoabid/ABID.Dev-Portfolio/tree/main/.agent/skills/database-design
Command: npx skills add https://github.com/simoabid/ABID.Dev-Portfolio --skill database-design-simoabid

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill helps you make informed decisions about database selection, schema design, indexing, and optimization, preventing common pitfalls and ensuring efficient data management.

Core Features & Use Cases

Database Selection: Guides you through choosing the right database (PostgreSQL, Neon, Turso, SQLite, etc.) based on project requirements.
Schema Design: Provides principles for normalization, primary key selection, and defining relationships.
Performance Tuning: Offers strategies for effective indexing and query optimization to avoid performance bottlenecks.
Use Case: Selecting the most appropriate database for a new web application, considering factors like scalability, latency, and feature requirements.

Quick Start

Guide me through selecting a database for a new project that requires edge deployment and low latency.

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 a new web application?▼

Choosing the right database involves evaluating project requirements like scalability, latency, and features. This Skill provides decision trees to compare PostgreSQL, Neon, Turso, and SQLite, ensuring you select an architecture that prevents data management bottlenecks.

What are the best practices for SQL schema design and normalization?▼

Effective SQL schema design relies on normalization principles, primary key selection, and defining relationships. This Skill provides actionable guidelines to structure your schema efficiently, avoiding common anti-patterns that degrade data integrity and query performance.

How do I optimize database performance with indexing strategies?▼

Optimizing database performance with indexing requires targeted strategies for query tuning. This Skill offers concrete indexing techniques to avoid performance bottlenecks and ensure efficient data retrieval across your selected database system.

Should I use Drizzle or Prisma ORM with my database?▼

Selecting between Drizzle and Prisma ORMs depends on your database choice and performance needs. This Skill facilitates informed ORM selection by outlining how each integrates with systems like PostgreSQL and SQLite to match your project requirements.

Which database supports edge deployment and low latency?▼

For edge deployment and low latency, you need databases designed for distributed environments. This Skill guides you through selecting appropriate systems like Turso or Neon based on your specific latency and scalability requirements.