Skill UI

Specializes in generating production-grade SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, and SQL Server. Provides comprehensive plans covering data integrity, detailed rollback procedures, performance optimization, and validation checks for critical schema changes.

Automates database schema design guidance for backend projects, activating whenever you ask about schema patterns, best practices, or implementation in node.js, Python, Go, microservices, caching, or messaging contexts.

Automates database schema visualization tasks by guiding diagram creation, recommending best practices, producing ready-to-use code, and validating visual documentation for systems that need clear relational overviews.

Designs normalized database schemas by analyzing requirements, mapping relationships, generating ERD diagrams, and producing SQL CREATE statements so you can build well-structured relational databases and follow best practices.

This skill details best practices for handling and structuring Evernote data. It covers designing local database schemas (SQL), advanced ENML content processing (to Markdown/HTML), managing attachments, and implementing reliable incremental synchronization using Update Sequence Numbers (USN). Ideal for developers building robust applications requiring deep, local data access and integrity checks for Evernote content.

This comprehensive workflow guides the entire lifecycle of building a complex full-stack feature, from initial architectural design to final integration testing. It enforces an API-first approach, ensuring that the database schema, backend services, and frontend components are developed cohesively, promoting scalability, testability, and adherence to modern industry best practices.

Automatically generate thorough database documentation using database-documentation-gen, covering ERD diagrams, relationships, columns, indexes, triggers, procedures, and interactive HTML reports whenever you need schema insight for onboarding, reviews, or governance.

Generates realistic database seed data and scripts for development or testing, leveraging Faker libraries to respect schema constraints, maintain relationships, and allow configurable volumes for quick population of demo or test environments.

Generates ORM models and database schemas for frameworks like TypeORM, Prisma, Sequelize, SQLAlchemy, Django ORM, Entity Framework, and Hibernate, translating user requests into ready-to-use model code or schema definitions to accelerate backend development.

Generate complete, production-ready REST API implementations from existing OpenAPI specifications or database schemas. This skill scaffolds all necessary CRUD endpoints (GET, POST, PUT, DELETE) across multiple frameworks (Express, FastAPI, Spring Boot, etc.), automatically incorporating features like pagination, filtering, validation, and robust authentication middleware. Ideal for rapidly bootstrapping complex backend services from defined data models.

Generates realistic users, products, orders, or schema-driven data via the test-data-generator plugin for populating test databases, simulating user behavior, and creating fixtures for automated or API testing.

Automates choosing and configuring database audit logging strategies, offering trigger/application/CDC/log-based options, schema templates, and guidance for compliance or debugging workflows.