sota-databases

What problem does it solve?

This Skill provides expert-level rules for designing, building, and auditing data layers, addressing issues like schema modeling, migrations, query optimization, transaction management, and security. It's ideal for engineers working with databases and seeking to implement best practices.

Core Features & Use Cases

• Schema Modeling: Guidelines for designing efficient and scalable database schemas.
• Migration Management: Best practices for writing and reviewing database migrations.
• Query Optimization: Techniques for crafting efficient queries and indexes.
• Transaction Management: Guidance on handling transactions and concurrency.
• Security and Compliance: Recommendations for securing data and ensuring compliance with standards.
• Use Case: A database engineer can use this Skill to review an existing database for correctness, performance, and security, or to design a new data layer following best practices.

Quick Start

Run the 'sota-databases' skill to perform an audit on the current database schema.