database-design

Name: database-design
Availability: InStock
Author: marablemarcel

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

Updated Jan 6, 2026

Search Tags:#design #indexing #database #schema #orm #prisma

Ready to run

npx skills add https://github.com/marablemarcel/Living-Lytics --skill database-design-marablemarcel

💬 Prompt for ChatGPT / Claude Chat▼

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.