Database Management Habilidades de Claude

Event Sourcing Projection Patterns

Implements high-performance read models and projections for event-sourced systems and CQRS architectures.

Kysely PostgreSQL Query Builder

Generates type-safe Kysely queries and PostgreSQL migrations for Node.js and TypeScript backends.

Event Sourcing Projection Patterns

Builds optimized read models and materialized views from event streams to enhance query performance in event-sourced architectures.

MongoDB Query & Explorer

Enables read-only exploration and querying of MongoDB databases through an integrated MCP server.

PowerSync Local-First Development

Builds offline-capable, local-first TypeScript applications by synchronizing SQLite with backend databases like Postgres and MongoDB.

Symfony Entity Relation Manager

Automates the creation and configuration of Doctrine entity relationships within Symfony projects.

Stripe Sync Query

Provides optimized SQL patterns and ORM configurations for querying Stripe data synced to PostgreSQL.

Database Schema & Query Expert

Manages and optimizes MongoDB and PostgreSQL databases through expert schema design, query generation, and administration patterns.

SQL Engineering

Writes, optimizes, and structures high-performance SQL queries and database schemas tailored to specific dialects like PostgreSQL and BigQuery.

Database Migration & Schema Evolution

Executes seamless database schema and data migrations across multiple ORMs with robust rollback and zero-downtime deployment strategies.

Data Warehouse & dbt Modeling

Designs and builds maintainable data warehouses using dbt and Kimball-style dimensional modeling principles.

Database Schema Architect

Analyzes database schemas and migration files to visualize data models, map table relationships, and accelerate developer onboarding.

Supabase Database & Security Manager

Manages Supabase database instances, enforces PostgreSQL security best practices, and streamlines migration workflows for the Dashboard project.

SQL Optimization Patterns

Optimizes database performance through advanced indexing, query plan analysis, and efficient query architectural patterns.

Database Migration

Manage database schema and data migrations across ORMs with zero-downtime strategies and rollback procedures.

Pinecone Vector Database Integration

Streamlines the implementation and optimization of Pinecone vector databases for production-grade RAG and semantic search applications.

Database Management & Design

Manages, designs, and optimizes MongoDB and PostgreSQL databases through schema modeling, query generation, and performance tuning.

Supabase Database

Streamlines Supabase database management including complex queries, CRUD actions, and Row Level Security implementation.

WordPress SQL Database Manager

Executes SQL queries against WordPress development databases running in Docker MariaDB environments.

Unified Database Management

Streamlines schema design, query optimization, and administrative workflows for MongoDB and PostgreSQL database systems.

WordPress Database SQL Manager

Executes SQL queries against WordPress development databases via Docker containers to inspect data and debug issues.

SQL Optimization Patterns

Optimizes database performance through advanced indexing strategies, EXPLAIN plan analysis, and query restructuring patterns.

Database Architect & Manager

Streamlines the design, management, and optimization of MongoDB and PostgreSQL databases through schema modeling, complex querying, and performance tuning.

DBT Transformation Patterns

Implements production-ready dbt patterns for scalable data transformation, model organization, and analytics engineering best practices.

Data Quality Frameworks

Implements comprehensive data validation using Great Expectations, dbt tests, and data contracts to ensure reliable data pipelines.

Solomon Database Consultant

Performs expert-level database schema analysis, query optimization assessments, and architectural reviews to ensure data integrity and performance.

Database Design & Optimization

Designs high-performance database schemas and manages migrations for PostgreSQL, MySQL, and NoSQL systems.

Projection Patterns for Event Sourcing

Build efficient read models and materialized views from event streams to optimize query performance and implement CQRS architectures.

SQLite & Drizzle Database Management

Implements type-safe SQLite database workflows using LibSQL and Drizzle ORM for local, Turso, and Cloudflare D1 environments.

Database Migration

Facilitates seamless database schema and data migrations across multiple ORMs with zero-downtime strategies and robust rollback procedures.