skills.rest
marablemarcel
marablemarcelCOMMUNITY
Explore all skills by this author →
GitHub

database-design

Identify and resolve database design issues across PostgreSQL, Neon, Turso, and SQLite.

Updated Jan 6, 2026
Search Tags:#design#indexing#database#schema#orm#prisma
One-click install
npx skills add https://github.com/marablemarcel/Living-Lytics --skill database-design-marablemarcel
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/marablemarcel/Living-Lytics/tree/main/living-lytics/.agent/skills/database-design
Command: npx skills add https://github.com/marablemarcel/Living-Lytics --skill database-design-marablemarcel

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Database design challenges often cause recurring performance and maintenance issues across schemas, indexes, and migrations.

Core Features & Use Cases

  • Guidance on schema design, normalization vs denormalization, and primary keys.
  • Strategies for indexing, query performance tuning, and ORM/DB choices across relational and serverless databases.
  • Use Case: design a scalable schema for a SaaS app with multi-tenant data and evolving access patterns.

Quick Start

Run the schema validator against your project to surface Prisma and Drizzle schema issues.

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 scalable database schema for a multi-tenant SaaS app?▼

Design a scalable database schema by resolving schema design issues and normalizing data for consistency. This improves performance and handles evolving access patterns for multi-tenant data across PostgreSQL, Neon, Turso, and SQLite.

What is the best way to choose indexing strategies for serverless database deployments?▼

Choose indexing strategies by identifying and resolving database design issues specific to your workload. This provides index suggestions and query performance tuning for serverless or edge deployments across supported databases.

How do I validate my Prisma or Drizzle schema for design issues?▼

Validate your Prisma or Drizzle schema by running the schema validator script against your project. This surfaces modeling issues, checks naming conventions, and ensures your primary keys and schema structure are durable.

Can I use this to get migration guidelines for PostgreSQL and SQLite?▼

Yes, you can get safe migration guidelines for PostgreSQL and SQLite. It identifies and resolves database design issues to improve performance and ensure consistency during schema migrations.

When should I normalize versus denormalize data in my database design?▼

Normalize data to ensure modeling consistency, or denormalize when resolving specific performance issues. This guidance applies to schema design decisions across relational and serverless databases like Turso and Neon.

Related Skills

Explore More Software Engineering Skills→
mjmmattoni98mjmmattoni98

database-design

Guide database selection and schema design for PostgreSQL, Neon, and Turso.

Community
Advanced
gajjalaashok75-UIgajjalaashok75-UI
2

database-atlas

Design database architecture, schema models, indexing strategies, and migration plans.

Community
Advanced
navraj007innavraj007in
2

generate-data-model

Convert architecture blueprint database schemas into Prisma, Drizzle, or TypeORM models, migrations, and seed data.

Community
Advanced
albertdobmeyeralbertdobmeyer
2

sql-toolkit

Manage SQL database tasks across SQLite, PostgreSQL, and MySQL.

Community
Intermediate