Design relational database schemas and optimize queries across PostgreSQL, Prisma, SQLAlchemy, GORM, and Drizzle.
npx skills add https://github.com/dotBeeps/hoard --skill database-dotbeeps
Please help me install this Agent Skill. Skill: database Source: https://github.com/dotBeeps/hoard/tree/main/morsels/skills/database Command: npx skills add https://github.com/dotBeeps/hoard --skill database-dotbeeps
Provides practical patterns and guardrails for designing relational schemas, writing safe migrations, optimizing queries, and using ORMs to avoid common runtime and performance issues.
Ask the database skill to review a schema and recommend safe, stepwise migrations and indexing changes to add a non-null field without downtime.
High-intent search queries and answers about installing and using this skill.
To add a non-null column without downtime, use multi-step forward-only migrations to deploy schema changes incrementally, backfill rows, and create indexes concurrently before enforcing constraints.
Avoiding N+1 queries in ORMs like Prisma and SQLAlchemy requires applying ORM-specific patterns such as eager loading relations, managing transactions effectively, and utilizing raw SQL when necessary to optimize complex data fetching.
You need composite or partial indexes for query optimization when filtering on multiple columns or specific subsets of data. Analyzing EXPLAIN plans helps identify slow queries, guiding the creation of covering indexes and efficient pagination strategies.
Yes, this database skill provides migration guidance for Drizzle, GORM, Prisma, Alembic, Knex, and Goose. It offers forward-only migration workflows, safe schema change patterns, and ORM-specific practices to avoid common runtime and performance pitfalls.
Recommended schema design conventions include standardized table and column naming, appropriate primary key strategies, and adding audit columns. It also provides guidance on determining when to denormalize for performance or resilience.
Forward-only migrations ensure auditability and safer production deployments by preventing data loss from destructive rollback scripts. This approach enforces multi-step deployment strategies and concurrent index creation to maintain high availability during schema evolution.
xmark168Generate Prisma schema models with relations and indexes for PostgreSQL.
jtucker9Generate ordered migration scripts and rollback plans from schema diffs.
pascallammersGuide Neon Serverless Postgres usage for branching, pooling, optimization, and CI/CD.
himanshu231204Optimize ClickHouse MergeTree schemas, queries, and bulk data ingestion.
