Validate Prisma schemas and guide database schema design and indexing.
npx skills add https://github.com/achmf/KostaHub --skill database-design-achmf
Please help me install this Agent Skill. Skill: database-design Source: https://github.com/achmf/KostaHub/tree/main/.agent/skills/database-design Command: npx skills add https://github.com/achmf/KostaHub --skill database-design-achmf
This skill addresses the complexity of database architecture by providing a structured framework for schema design, indexing strategies, and technology selection, preventing common performance bottlenecks and maintenance issues.
Use the database-design skill to validate the current project schema and suggest indexing improvements.
High-intent search queries and answers about installing and using this skill.
You can validate a Prisma schema by running automated validation scripts that check for missing primary keys, naming convention inconsistencies, and index optimization opportunities. This identifies schema inconsistencies and performance anti-patterns.
Evaluating database engines involves analyzing specific project requirements like edge deployment or vector search needs. Architectural guidance supports decision-making by comparing PostgreSQL, Neon, Turso, SQLite, and PlanetScale based on these constraints.
Resolving N+1 query problems requires implementing effective indexing strategies and using EXPLAIN ANALYZE methodologies. This provides architectural guidance for query optimization and helps identify performance bottlenecks.
Schema validation prevents performance bottlenecks by providing a structured framework for schema design and indexing strategies. Automated scripts detect anti-patterns, missing primary keys, and suboptimal indexes before they cause maintenance issues.
Automated validation scripts facilitate migration planning across various database engines by identifying schema inconsistencies. They validate Prisma schemas and provide architectural guidance for technology selection and optimization.
nholder88Identify MongoDB drivers and ODMs, then catalog schemas and indexes.
patricio0312revAnalyze SQL EXPLAIN plans and propose indexes and rewrites to optimize slow queries.
keshavraj936Guide database and ORM selection, schema design, indexing, and query optimization.
moveonhaDetect PostgreSQL SQL anti-patterns and generate EXPLAIN ANALYZE-based optimization recommendations.
