Database Management Agent Skills

Oracle Database Expert

37

Accelerates Oracle database development through expert SQL generation, PL/SQL logic design, and performance tuning strategies.

Railway Database Management

35

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

Database Management

33

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

EF Core Hexagonal Data Layer

33

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

Salesforce SOQL Expert

32

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

Salesforce Visual AI & Diagrammer

32

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

PostgreSQL psql Expert

30

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

Data Contract Framework

29

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

Identity Resolution & Account Matching

29

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

PGVector Hybrid Search

29

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

Nette Database & Explorer

29

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

Database Schema Designer

29

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

Database Migration Generator

29

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

DB2 to Snowflake dbt Migrator

25

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

EF Core DDD Persistence Layer

24

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

dbt Commands & Operations

23

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

Snowflake Connections

23

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

dbt Projects on Snowflake

23

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

dbt Materializations

23

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

dbt Projects Snowflake Setup

23

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

dbt Modeling

23

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

dbt Performance Optimization

23

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

Snowflake Schema Management

23

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

dbt Architecture

23

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

dbt Core Development

23

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

Snowflake CLI

23

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

Zod Schema Designer

21

Designs and implements robust Zod schemas and TypeScript types using a Zod-first development approach for safe data modeling.

Doctrine Batch Processing

21

Optimizes large-scale Symfony data operations through memory-efficient Doctrine ORM patterns and bulk database strategies.

Neon & Vercel Serverless Postgres

21

Configures and manages Neon and Vercel Serverless Postgres databases optimized for edge and serverless environments.

Cloudflare D1 Database Manager

21

Manages Cloudflare D1 serverless SQLite databases with best practices for migrations, query optimization, and global read replication.