Database Management Agent Skills

Ecto Query Patterns

Constructs efficient, composable, and type-safe database queries using Elixir's Ecto Query DSL.

C# LINQ Mastery

Facilitates advanced data manipulation and querying in C# using Language Integrated Query (LINQ) patterns and performance optimizations.

Python Data Modeling & Dataclasses

Streamlines Python data modeling using dataclasses, attrs, and Pydantic for clean, type-safe structures with robust validation.

Microsoft Data API Builder Setup

Configures Microsoft Data API Builder to expose SQL Server databases as production-ready MCP servers with granular access control.

Microsoft SQL Server MCP Manager

Manages and maintains Model Context Protocol (MCP) servers for seamless Microsoft SQL Server integration.

Data Pipeline Architect

Designs comprehensive data pipeline architectures and technology stacks based on natural language requirements.

C# Mock Data Migrator

Automatically generates realistic C# mock data classes from Drizzle, Prisma, and TypeORM schemas.

DBeaver Guide & Database Management

Optimizes database administration and SQL workflows using the DBeaver universal database tool.

PostgreSQL Read-Only Query Assistant

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

MongoDB Database Assistant

Optimizes MongoDB database interactions through expert guidance on queries, indexing, and schema design.

Spring Data JPA Expert

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

Oracle Database Expert

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

Huawei Cloud RDS Manager

Manages Huawei Cloud Relational Database Service (RDS) instances, including provisioning, configuration, and maintenance.

Navicat Database Expert

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

Azure SQL Management

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

PostgreSQL Database Expert

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

MySQL Database Expert

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

Redis Database Expert

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

Elasticsearch Management & Search

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

MyBatis-Plus Code Generator

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

Spring Data JPA Repository Creator

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

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.