Design database schemas, ERDs, and migration strategies for SQL and NoSQL databases.
npx skills add https://github.com/johangm90/spex --skill spex-db
Please help me install this Agent Skill. Skill: spex-db Source: https://github.com/johangm90/spex/tree/main/skills/spex-db Command: npx skills add https://github.com/johangm90/spex --skill spex-db
This Skill automates the complex and error-prone process of designing database schemas, ERDs, and safe migration strategies, ensuring data integrity and efficient development.
user_preferences table, define its columns (e.g., theme, notifications_enabled), specify data types, and generate a migration script that can be safely applied to production.Design the database schema for the new user profile feature, including tables for profiles, avatars, and settings.
High-intent search queries and answers about installing and using this skill.
Designing a database schema for PostgreSQL involves modeling entities, attributes, and constraints, followed by generating additive migration scripts with rollback plans to ensure zero-downtime deployments and transactional integrity.
The best way to generate an ERD is by modeling entities and their relationships based on project requirements, which produces a visual Entity-Relationship Diagram that clarifies data modeling and supports efficient development.
Yes, schema migration and design approaches support both SQL and NoSQL databases, specifically configuring schemas and migration strategies for PostgreSQL, MariaDB, MySQL, and MongoDB according to best practices.
To create zero-downtime migration scripts, you design additive and safe destructive migration strategies that include rollback plans, ensuring data integrity and preventing disruption during production deployments.
Yes, you can integrate ORM tools with the database schemas you design, as the schema design process includes specific guidance on ORM integration alongside indexing and transactional integrity best practices.
You need to define specific data types and constraints in MariaDB schema design when modeling entities and attributes for new features, ensuring data integrity and efficient queries through proper indexing and transactional rules.
rsmdtDesign database schemas from domain requirements with ER modeling and normalization.
ouakarDesign database schemas, indexes, and zero-downtime migration plans for multi-tenant systems.
jeremylongshoreGenerate ORM models and database schemas across multiple frameworks.
elsolalDesign relational database schemas with ERD, migrations, and performance-oriented indexes.