Agent skill · vasilyu1983
software-database-design
Designs database schemas, migrations, and data models for PostgreSQL, MySQL, MongoDB, and Redis. Use when planning tables, relationships, indexes, or ORM-backed schema changes.
What it needs
About 12k tokens when loaded.
What this skill does
Database Design Schema design, data modeling, migration safety, and ORM patterns. This skill covers structural decisions — what tables exist, how they relate, how schemas evolve. For tuning queries on an existing schema, use data-sql-optimization. Quick Reference Task Default Picks Notes ------ --------------- ------- Relational database PostgreSQL 18 Transactions, complex queries, JSON support, native uuidv7(), async I/O Relational (MySQL family) MySQL 8.4 LTS 8.0 reached EOL (Apr 2026); 8.4 is the LTS migration target, 9.x is the quarterly innovation train Embedded / edge relational SQLite 3.5x Current release train moves fast (monthly point releases); pin a version, don't chase latest blindly Flexible schema MongoDB 8.x Rapid iteration, embedded relationships Caching / sessions Redis Ephemeral data, counters, pub/sub Graph traversals Neo4j Relationship-heavy queries (social, fraud) Time-series TimescaleDB, InfluxDB Metrics, IoT, event streams Managed app backend ../software-baas-platforms/SKILL.md Use when auth, realtime, storage, and functions are part of the platform choice Schema migrations expand-contract pattern Zero-downtime changes ORM Prisma, Drizzle, SQLAlchemy, EF Core Match stack; review generated SQL Vector similarity pgvector (co-located with PostgreSQL) HNSW is the default index for new work; see ai-vector-brain for implementation depth When to Use This Skill Design table/collection schemas and normalization strategies Model relationships (1:N, M:N, polymorphic associations) Plan zero-downtime migrations (expand-contract) Define indexing strategies based on access patterns Configure ORMs and avoid common anti-patterns Choose between relational, document, key-value, and graph databases When NOT to Use This Skill Problem Go here --------- --------- Query optimization on existing schemas data-sql-optimization Backend service implementation software-backend Managed app backend platform (Supabase, Convex, Firebase, Appwrite, PocketBase) software-baas-pla …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills vasilyu1983/software-database-design