Can it help me fix slow database queries?

Yes, it provides specific strategies for performance tuning, including indexing strategies, EXPLAIN ANALYZE interpretation, and identifying N+1 query anti-patterns.

How does this skill help with database selection?

It evaluates your project's specific context, such as deployment environment and scale, to recommend the best fit between options like PostgreSQL, SQLite, Neon, or Turso.

Does it focus only on SQL patterns?

No, it focuses on the logic and decision-making behind data architecture, helping you think through normalization, data types, and storage strategies rather than just copying code.

Which ORMs does this skill support?

The skill provides guidance and implementation patterns for popular modern ORMs and query builders including Drizzle, Prisma, and Kysely.

Database Design & Architecture

Name: Database Design & Architecture
Author: claudiodearaujo

byclaudiodearaujo

0•

Database Management

Architects optimized database schemas and selects the ideal data stack based on specific project requirements and performance needs.

The Database Design skill empowers Claude to act as a senior data architect, moving beyond generic SQL patterns to provide strategic guidance on schema design, indexing, and technology selection. It helps developers navigate the complex landscape of modern data storage by evaluating trade-offs between traditional databases like PostgreSQL and serverless options like Neon or Turso. By focusing on core principles such as normalization, N+1 query prevention, and intelligent indexing, this skill ensures that data layers are scalable, performant, and perfectly matched to the deployment environment.

Key Features

01Context-aware database selection (PostgreSQL, Neon, Turso, SQLite)

02Performance tuning via indexing and query optimization

03Migration planning for serverless and traditional environments

040 GitHub stars

05Strategic ORM guidance for Drizzle, Prisma, and Kysely

06Advanced schema design and relationship normalization

Use Cases

01Designing a scalable relational schema for a new application from scratch

02Selecting the right ORM and database provider for a serverless deployment

03Optimizing existing database performance by identifying N+1 queries and missing indexes

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add claudiodearaujo/sistema-de-narra-o-de-livro-front database-design

For use in Claude.ai and ChatGPT

Download Skill