Guide database design, technology selection, and ORM choices for modern applications.
npx skills add https://github.com/dgkngk/super-kit --skill database-design-dgkngk
Please help me install this Agent Skill. Skill: database-design Source: https://github.com/dgkngk/super-kit/tree/main/skills/tech/database-design Command: npx skills add https://github.com/dgkngk/super-kit --skill database-design-dgkngk
This Skill provides guidance and best practices for designing efficient, scalable, and maintainable database schemas and selecting appropriate database technologies and ORMs.
Guide me through selecting the best database for a new serverless web application with a focus on edge deployment.
High-intent search queries and answers about installing and using this skill.
Choosing a database for serverless or edge applications requires evaluating PostgreSQL, Neon, Turso, and SQLite based on specific project needs like latency, scaling, and regional distribution to ensure efficient data access.
Proper database schema design requires applying normalization principles, defining appropriate primary keys and timestamps, and structuring relationship types correctly to create a maintainable and highly performant data model.
Safe database migrations with zero downtime require following specific best practices for altering tables and applying indexing strategies incrementally, ensuring changes do not lock the database or interrupt active application traffic.
Choosing between Drizzle, Prisma, and Kysely depends on your application's query optimization needs and developer experience preferences, as each ORM offers distinct approaches to database interaction and schema management.
Indexing strategies directly impact query optimization by determining how quickly the database engine can locate specific rows, making proper index selection crucial for maintaining high performance as your dataset grows.
Database normalization is needed during schema design to reduce data redundancy and improve data integrity, ensuring that your relational database structure remains efficient and maintainable as application complexity increases.
X-School-AcademyDesign system architecture with components, data flow, infrastructure, database schema, and API design.
4lermanGenerate SQL queries, introspect schemas, optimize performance, and create migration scripts.
gajjalaashok75-UIDesign and evaluate database schemas, indexes, ORMs, and migration plans.
Fancu1Design and optimize relational and NoSQL database schemas with migration patterns.
