Database Management Agent Skills

Oracle Database Expert

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

Database Schema Design

Designs normalized relational database schemas with optimized indices, integrity constraints, and comprehensive documentation.

Navicat Database Expert

Streamlines database administration, SQL execution, and data management using the Navicat ecosystem.

MyBatis-Plus Code Generator

Generates comprehensive MyBatis-Plus boilerplate and domain objects including Entity, Mapper, Service, and Controller from database schemas.

Redis Database Expert

Provides comprehensive implementation guidance for Redis data structures, caching patterns, and high-performance backend optimization.

PostgreSQL Database Expert

Optimizes PostgreSQL workflows by providing expert guidance on SQL syntax, performance tuning, and advanced data features.

Spring Data JPA Expert

Simplifies Java persistence by providing expert guidance on Spring Data JPA repositories, entity mapping, and complex query implementation.

Elasticsearch Management & Search

Streamlines Elasticsearch development by providing expert guidance on indexing, complex query DSL, and cluster optimization.

Azure SQL Management

Streamlines Azure SQL Database workflows by providing expert guidance on creation, security configuration, and cloud resource management.

MySQL Database Expert

Provides comprehensive guidance for MySQL database architecture, query optimization, and schema management.

Spring Data JPA Repository Creator

Generates production-grade Spring Data JPA repositories with optimized queries and auditing configurations.

PostgreSQL Read-Only Query Assistant

Executes safe, read-only SQL queries and explores schemas across multiple PostgreSQL databases with built-in security protections.

Railway Database Management

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

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 Visual AI & Diagrammer

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

GraphRAG System Design

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

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.

Data Contract Framework

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

Database Schema Designer

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

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.

Database Migration Generator

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

PGVector Hybrid Search

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

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.