database-design
FeaturedDatabase schema design, optimization, and migration patterns for PostgreSQL, MySQL, and NoSQL databases. Use for designing schemas, writing migrations, or optimizing queries.
Install
Quality Score: 94/100
Skill Content
Details
- Author
- MoizIbnYousaf
- Repository
- MoizIbnYousaf/Ai-Agent-Skills
- Created
- 11 months ago
- Last Updated
- 1 months ago
- Language
- JavaScript
- License
- MIT
Integrates with
Similar Skills
Semantically similar based on skill content — not just same category
database-design
Designs PostgreSQL and SQLite schemas and keeps queries fast and migrations safe: normalization and column types, primary and foreign keys, B-tree, partial, covering and GIN indexes, reading EXPLAIN ANALYZE, N+1 and unbounded queries, zero-downtime migrations, transactions, isolation levels and deadlocks, connection pooling, and ORM usage (Prisma, Drizzle, SQLAlchemy, GORM). Use when designing or changing a table, writing or reviewing a migration, a query is slow, choosing indexes, setting up pooling, or chasing N+1 queries, lock waits or deadlocks. Not for REST or GraphQL contracts (api-design), app-level caching (performance-optimization) or MySQL-specific tuning.
database-patterns
DB schema design and query tuning: normalization, indexing, N+1, transactions, EXPLAIN. Triggers: schema, index, slow query, N+1, PostgreSQL, MySQL, EXPLAIN, deadlock, query plan.
database-schema-and-migrations
Design a database schema, write or run a migration, add an index, or diagnose a slow query. Covers normalization/denormalization, indexing strategy, reading EXPLAIN output, zero-downtime expand-contract migrations, N+1 detection, and connection pooling. Triggers on schema design, migration, index, slow query, EXPLAIN, N+1, Postgres.