Database Management Claudeスキル

Schema Drift Detector

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

Deployment Verification Agent

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

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.

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.

Salesforce SOQL Expert

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

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.

Nette Database & Explorer

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

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.

Identity Resolution & Account Matching

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

Database Migration Generator

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

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.

Docker Database Configuration

Configures secure, production-ready database containers for PostgreSQL, MySQL, MongoDB, and Redis with persistence and health monitoring.

dbt Architecture

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

dbt Core Development

Manages the local installation, configuration, and optimization of dbt-core environments for Snowflake data engineering.

Snowflake Schema Management

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

dbt Performance Optimization

Optimizes dbt and Snowflake performance through expert guidance on materialization strategies, warehouse sizing, and advanced query patterns.

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 Projects Snowflake Setup

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

dbt Commands & Operations

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

dbt Materializations

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