Database Management Agent Skills

Database Deadlock Detector

Identifies, analyzes, and resolves database deadlock issues to ensure optimal application performance and system stability.

Database Deadlock Detector

Identifies, analyzes, and resolves database lock contention and transaction deadlocks to maintain system stability.

ORM Code Generator

Automates the creation of database schemas and ORM models for multiple programming languages and frameworks.

Database Index Advisor

Analyzes database query patterns and workloads to provide actionable recommendations for index optimization and performance tuning.

Query Optimization & Database Performance

Optimizes SQL database performance through advanced indexing strategies, execution plan analysis, and query refactoring.

CakePHP Database Designer

Designs optimized database schemas, Phinx-based migrations, and multi-tenant architectures specifically for PHP CakePHP applications.

MartenDB Expert

Streamlines MartenDB development in .NET by providing specialized guidance on document storage, LINQ queries, and schema migrations.

Koan Performance Optimizer

Optimizes data-intensive applications through streaming, bulk operations, and high-speed count strategies for the Koan framework.

Nushell Data Storage & Formats

Manages data persistence, SQLite operations, and complex file format conversions within the Nushell environment.

Database Initializer

Automates the provisioning and schema initialization of database infrastructure across local and cloud environments.

PostgreSQL Patterns & Optimization

Optimizes PostgreSQL databases through expert schema design, indexing strategies, and security best practices based on Supabase standards.

PostgreSQL Patterns & Optimization

Implements high-performance PostgreSQL database designs using industry-standard indexing, schema patterns, and security best practices.

ClickHouse Analytics & Data Engineering

Provides high-performance ClickHouse database patterns, query optimizations, and data engineering best practices for OLAP workloads.

CRM File Downloader

Retrieves and saves files, documents, and attachments from a CRM PostgreSQL database directly to the local filesystem.

JPA & Hibernate Patterns

Implements best practices for Spring Boot data persistence, query optimization, and entity modeling.

Docker MCP Dynamic Tools

Enables on-demand discovery and integration of over 170 MCP servers for database access, cloud services, and specialized web APIs.

PHP Database Mastery

Optimizes PHP database interactions using advanced PDO patterns, ORM implementations, and high-performance query tuning.

FHIR Data Migration & Integration

Migrates patient and practitioner data to HAPI FHIR storage using a hybrid architecture for healthcare applications.

AgentDB Performance Optimization

Optimizes AgentDB vector databases through quantization, HNSW indexing, and advanced caching to drastically reduce memory usage and increase search speed.

SurrealDB Expert

Architects, implements, and optimizes secure multi-model database solutions using SurrealDB and SurrealQL.

SAP ABAP CDS Development

Streamlines the creation and optimization of SAP ABAP Core Data Services (CDS) views for advanced data modeling and semantic enrichment.

SAP Datasphere Expert

Accelerates SAP Datasphere development by providing expert guidance on data modeling, ETL orchestration, and BTP integration.

Database Query Optimizer

Analyzes and optimizes database queries for PostgreSQL, MySQL, and MongoDB using EXPLAIN plans and automated index recommendations.

SAP SQLScript Development

Streamlines SAP HANA database programming with expert SQLScript syntax patterns, performance optimization, and AMDP integration.

ClickHouse Best Practices & Optimization

Optimizes ClickHouse database performance by enforcing 28 specialized rules for schema design, query execution, and data ingestion.

NoSQL Database Engineering

Implements scalable NoSQL solutions and distributed data patterns using MongoDB, Redis, Cassandra, and DynamoDB.

Data Warehousing & Modeling

Architects and optimizes production-grade cloud data warehouses using dimensional modeling and modern performance patterns.

Data Engineering

Architects and implements robust ETL/ELT pipelines, production data platforms, and data quality frameworks.

xsql Cross-Database CLI

Queries MySQL and PostgreSQL databases safely with read-only protection and structured JSON output for AI agents.

PostgreSQL Row Level Security (RLS)

Enforces robust multi-tenant data isolation by auditing PostgreSQL Row Level Security policies and preventing common bypass vulnerabilities.