database

Schema design involves creating tables with UUID primary keys, VARCHAR columns, and foreign key constraints to establish relationships. Use this Skill to define table structures with indexes and integrity constraints, then generate the SQL DDL statements for PostgreSQL, MySQL, or SQLite databases.

Optimized SQL queries combine JOINs, window functions, and proper indexing to retrieve data efficiently. This Skill helps you construct complex queries—including JSON operations on JSONB columns—and tune them for performance across PostgreSQL, MySQL, and SQLite.

Database migrations track incremental schema changes over time using an ORM like SQLAlchemy. This Skill supports robust migration workflows, including adding columns, indexes, and constraints, while maintaining data consistency and enabling rollback if needed.

Soft deletes via deleted_at columns and auditing timestamps preserve data history without physical deletion. This Skill implements these patterns alongside UUID primary keys and GIN indexes on JSONB columns for comprehensive PostgreSQL, MySQL, and SQLite schemas.

Index tuning improves query performance by reducing full-table scans. This Skill applies index strategies including GIN indexes for JSONB data and composite indexes for foreign key joins, ensuring efficient retrieval across PostgreSQL, MySQL, and SQLite.