Snowflake, BigQuery, clustering, partitioning, and materialized views for warehouse performance.
Database MCP server integration for PostgreSQL, MySQL, MongoDB
PgBouncer, connection optimization, and pooling strategies for database performance.
Architects robust database systems by implementing multi-tenant isolation, transaction boundaries, and data consistency strategies.
Database architecture design, schema optimization, query performance tuning, and data migration.
Generate database ER diagrams from schema for documentation
Implements database layers using Prisma, Drizzle ORM, TypeORM, SQLAlchemy 2.0, GORM, Diesel, Entity Framework Core 8, Hibernate/Panache…
Designs and optimizes database indexing strategies using ESR principles and advanced access patterns for maximum query performance.
Comprehensive guide for database management patterns covering PostgreSQL and MongoDB including schema design, indexing, transactions…
Create database migration with schema changes and rollback.
Orchestrates safe, zero-downtime database schema changes and data migrations using industry-standard patterns like Expand/Contract.
Use for Drizzle migrations: schema/table/column changes, migration generation or regeneration, sequence conflicts after rebase, idempotent…
Design, review, stage, execute, and verify safe PostgreSQL schema and data migrations in production.
Database reconnaissance — full inventory of schema, migrations, data volume, backups, connection pooling, and query patterns.
Generate database seed scripts with realistic sample data.
Automatically discover database skills when working with SQL, PostgreSQL, MongoDB, Redis, database schema design, query optimization…
Databricks Agent Production Readiness skill
Build, scaffold, and extend Databricks Apps with the AppKit Node.js + React/TypeScript SDK (@databricks/appkit, @databricks/appkit-ui).
Manage Databricks compute resources and job execution via CLI
Databricks development guidance including Python SDK, Databricks Connect, CLI, and REST API.
Create and query Databricks Genie Spaces for natural language SQL exploration.