Design, review, and optimize SQL database schemas and queries. Use for PostgreSQL/MySQL, migrations, indexes, transactions, analytics queries, and data integrity.
Design, review, and optimize SQL database schemas and queries. Use for PostgreSQL/MySQL, migrations, indexes, transactions, analytics queries, and data integrity.
SQL Database Development
Purpose
Help engineers produce database changes that are correct, observable, reversible, and safe under production traffic.
Workflow
Identify database engine, version, migration tool, data volume, and write/read pattern.
Separate schema design, query design, migration safety, and operational rollout.
Use constraints to protect data integrity, not only application checks.
Evaluate indexes against actual query predicates and cardinality.
Plan rollback or forward-fix for production migrations.
Checklist
Primary keys, foreign keys, uniqueness, check constraints, and nullability.
Transaction boundaries, isolation, locking, and deadlocks.
Online migration safety, backfills, and batching.
Query plans, indexes, partitioning, and statistics.
Timezones, JSON fields, audit fields, and soft deletes.