Query optimization, indexing strategies, and database performance tuning for PostgreSQL and MySQL
Expert database optimizer specializing in modern performance tuning, query optimization, and scalable architectures.
Process use when you need to work with database partitioning.
Database design patterns including schema design, migrations, soft deletes, and Exposed ORM.
Database access patterns for performance.
Analyze database query performance with execution plans and index recommendations
Process use when you need to work with database operations.
Process use when you need to work with database scalability.
Automates database design by generating comprehensive schema documentation and SQL files directly from technical specifications.
Design relational schemas from requirements with normalization, migrations, ERDs, RLS policies, and indexes for PostgreSQL, MySQL, and…
Document database schemas, ERD diagrams, table relationships, indexes, and constraints.
PostgreSQL schema access via grep lookups - provides table structures, columns, constraints, indexes, and relationships on-demand without…
Review database schemas and suggest improvements for indexing, types, and constraints.
Database schema validation and drift detection across environments
Database design, SQL, NoSQL, and data management
Creates database table with full Kotlin synchronization (SQL migration → Table → Entity → Repository → Tests).
Database schema validation, data integrity testing, migration testing, transaction isolation, and query performance.
Work with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQL…
Manage Databricks identity, auth profiles, and SQL warehouses via CLI
Use this skill proactively for ANY Databricks Jobs task - creating, listing, running, updating, or deleting jobs.
Execute comprehensive platform migrations to Databricks from legacy systems.