Warehouse
Database schema design, migrations, query optimization, and ORM patterns.
Deep expertise in Azure SQL Database and Azure Cosmos DB — provision and manage relational and NoSQL databases, write and optimize T-SQL…
bkend.ai database — CRUD, column types, filtering, sorting, relations, indexing.
Build a data pipeline — ETL/ELT with extraction, transformation, loading, error handling, and scheduling.
Guides building on Qdrant Edge, the embedded in-process shard.
CatColab Schemas - database schema modeling distinguishing entities (tables) from attributes (columns).
Implements Change Data Capture patterns for real-time data integration
Firebase: Firestore database, Authentication, Realtime Database, Cloud Functions, Firebase Storage, and security rules — for web and…
MUST USE when reviewing ClickHouse schemas, queries, or configurations.
Compositional algorithm and data analysis via algebraic databases
CQRS and Event Sourcing patterns for scalable, auditable systems with separated read/write models.
Streamlines the end-to-end database lifecycle from schema modeling and indexing to secure production migrations.
Database sharding for PostgreSQL/MySQL with hash/range/directory strategies.
Automatically discover database skills when working with SQL, PostgreSQL, MongoDB, Redis, database schema design, query optimization…
Database specialist for SQL, NoSQL, and vector database modeling, schema design, normalization, indexing, transactions, integrity…
Create and manage Doctrine migrations (lib 4.x) for schema versioning; handle dependencies, rollbacks, and production deployment
Define Doctrine entity relationships (OneToMany, ManyToMany, ManyToOne); configure cascade, orphan removal, multiple entity managers…
Architecture guardrails for Engram across local store, cloud sync, dashboard, and plugins.
Generate Django database migrations for Sentry.
Use when migrating a dbt project from one data platform or data warehouse to another (e.g., Snowflake to Databricks, Databricks to…