704-technologies-sql

SQL schema design best practices involve consistent table and column naming, proper relational key configuration, and structured timestamps. This framework-agnostic skill reviews your database schema to ensure optimal relational integrity, readability, and performance.

To optimize SQL query performance, review execution plans, use CTEs for readability, apply proper joins, and utilize bind parameters. This skill analyzes your queries to enhance both operational performance and code maintainability.

Designing indexes for foreign keys and sort paths requires evaluating filter conditions and join operations to reduce scanning overhead. This skill helps you manage and structure indexes specifically for your database querying patterns and sorting needs.

Yes, this skill provides framework-agnostic database guidance, meaning it applies equally well outside of Spring Boot, Quarkus, or Micronaut. It focuses purely on SQL best practices, transaction management, and security without framework bias.

Reviewing database migration scripts and security practices involves checking transaction safety, testing procedures, and operational integrity for production databases. This skill evaluates your migration scripts to ensure secure and reliable database operations.