Database Management Habilidades de Claude

Railway Database Management

Deploys and configures official Railway database services including PostgreSQL, Redis, MySQL, and MongoDB with automated environment wiring.

Deployment Verification Agent

Generates executable Go/No-Go deployment checklists with SQL verification queries, rollback procedures, and monitoring plans for risky production changes.

Schema Drift Detector

Identifies and filters out unrelated database schema changes in Pull Requests to maintain clean version control history.

Data Integrity Guardian

Protects production databases by reviewing migrations, schema constraints, and transaction boundaries for safety and compliance.

Database Architect

Streamlines database schema design, query optimization, and migration management for robust data foundations.

Database Management

Manages database migrations, seeds, and direct Ruby script execution against specific event databases.

EF Core Hexagonal Data Layer

Implements high-performance, testable data persistence layers using Entity Framework Core and Hexagonal Architecture patterns.

Salesforce SOQL Expert

Generates, optimizes, and secures Salesforce Object Query Language (SOQL) queries using natural language and performance analysis.

GraphRAG System Design

Designs complete GraphRAG architectures by integrating graph databases, vector stores, and LLM reasoning for complex data retrieval.

Salesforce Visual AI & Diagrammer

Generates professional Salesforce ERD diagrams, LWC mockups, and architecture visuals using Gemini AI and Nano Banana Pro.

SQLite Knowledge Database

Builds and manages composable, relational knowledge databases using the native SQLite CLI.

PostgreSQL psql Expert

Manages and automates PostgreSQL databases using the psql interactive terminal and advanced command-line techniques.

Database Migration Generator

Automates the creation of safe database migrations with automatic framework detection and built-in rollback logic.

Nette Database & Explorer

Optimizes Claude's ability to write Nette Database queries, design typed entities, and manage schemas using MySQL 8.4+.

Identity Resolution & Account Matching

Normalizes and matches accounts, contacts, and opportunities across disparate data sources to maintain a unified source of truth.

Data Contract Framework

Establishes structured operating models for defining, enforcing, and auditing business intelligence data contracts.

PGVector Hybrid Search

Implements production-grade hybrid search by combining PGVector HNSW semantic retrieval with BM25 keyword matching using Reciprocal Rank Fusion.

Database Schema Designer

Designs and optimizes scalable SQL and NoSQL database schemas with a focus on normalization, performance, and robust migration patterns.

Vertica to dbt Snowflake Migration

Automates the conversion of Vertica DDL into production-ready dbt models optimized for Snowflake Data Cloud.

DB2 to Snowflake dbt Migrator

Converts IBM DB2 DDL and stored procedures into production-ready dbt models and schema configurations optimized for Snowflake.

EF Core DDD Persistence Layer

Implements a robust data persistence layer using Entity Framework Core within Hexagonal Architecture and Domain-Driven Design patterns.

Snowflake CLI

Manages Snowflake objects, executes SQL scripts, and deploys applications using the command-line interface for data orchestration and automation.

Snowflake Connections

Configures and manages Snowflake authentication for CLI tools, Streamlit applications, dbt projects, and Snowpark scripts.

dbt Modeling

Implements production-quality dbt models using standardized CTE patterns, medallion architecture layers, and SQL best practices.

dbt Commands & Operations

Executes dbt command-line operations, manages model selection syntax, and implements Jinja templating for data transformation workflows.

dbt Projects Snowflake Setup

Configures native dbt Projects on Snowflake with comprehensive guides for integrations, workspace management, and automated monitoring.

dbt Materializations

Provides expert guidance on selecting and implementing optimal data transformation strategies within dbt, including incremental models, snapshots, and Python-based ML workflows.

dbt Projects on Snowflake

Deploys, manages, and monitors dbt projects natively within Snowflake using PROJECT objects and OpenTelemetry-based event tables.

dbt Architecture

Guides the implementation of medallion architecture and production-grade project organization within dbt.

Snowflake Schema Management

Deploys and manages Snowflake database objects using a version-controlled, migration-based approach for seamless CI/CD integration.